BI Publisher
Discussion List
-
ORA-00920: invalid relational operator at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.jaSummary: Hello Team, we have an sql report with multiple parameters and each parameter is a multi selelct pick list. we are trying following SQL for this and it is faili…Sudheer V SB 9 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…AvinashP 247 views 16 comments 0 points Most recent by Archana Prasad Reporting and Analytics for HCM -
Course/Offering Status Code Change Impacting BIP Report Output Across EnvironmentsSummary: We created a BIP report in DEV2 using the status codes ORA_COU_ACTIVE (Course Status) and ORA_CLS_ACTIVE (Offering Status). The report had been working correctl…
-
Balance Sheet SQL query requirement in BIPHi everyone, I need to build a custom balance sheet report in Oracle Fusion Cloud Financials using BI Publisher**,** and I’m completely stuck at the starting point. I ha…Pravesh Koonjal 7 views 1 comment 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
What all roles has BI Consumer Privilege?Summary: We have created a copy of the Employee role and removed the analytics permissions from it. However, we would now like to grant analytics access to only a few se…
-
We are not getting qstn_answer_id value in the HRQ_QSTN_RESPONSES tableSummary: We have some set of questions in the questionnaire for the performance document and when the user provides the response a row is getting generated in the HRQ_QS…
-
when scheduling a BIP report by selecting multi select parameters at Trigger job is skippingSummary: when a scheduled a report by selecting multi select parameters in general Tab and at Trigger in schedule Tab job is getting is skipped even when data exists. Ex…Mallikarjun Sheshagani 14 views 1 comment 0 points Most recent by John Lyndon Amemita Reporting and Analytics for ERP
-
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…
-
Apply Format Currency in RTF within a calculation TagSummary: Hello, Is there a way to apply a format currency () for this tag in an RTF template: Thanks Content (please ensure you mask any confidential information): Vers…Guillaume SAVALL 96 views 1 comment 0 points Most recent by User_8M22K Reporting and Analytics for ERP
-
Standard Purchase Order Report sub template logicSummary: Hi Team, Theres a subtemplate being called in PO template rest of contents in rtf template has english content with fields no language specfic condition. but w…
-
Unable to establish secure FTP connection with carriers, The Firewall is blocking port 10022Summary: While creating secure FTP connection with carriers, The Firewall is blocking port 10022, How to whitelist this port ? Content (please ensure you mask any confid…
-
BI Publisher Preview Options not enabledSummary: BI Publisher Preview Options are not enabled. Content (please ensure you mask any confidential information): We are trying to update our RTF template and the Pr… -
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 48 views 3 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
can not see all records in AP_IDR_INVOICE_TRACE_DYD tableSummary: Table - AP_IDR_INVOICE_TRACE_DYD, this table is used in standard invoice document recognition tracking report. But when we have queried the table, we can not se…Rama Krishna T 55 views 3 comments 0 points Most recent by Sridhar_Rejeti_1423 Payables, Payments & Cash Management
-
Report SQL parameter filter in DataModel dont show in Dashboard PageReport SQL parameter filter in Data Model dont show in Dashboard Page Dont show in Dashboard Page In Report showFERNANDA SANTOS 14 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
SQL to get the list of all tax codes definedSummary: Hi, Can anyone please share the SQL to get the list of all tax codes defined. Or are you aware if there is any standard reports which is available that can prov…
-
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are…Sudha KOVURU 407 views 6 comments 0 points Most recent by Raunak Kumar Singh Reporting and Analytics for ERP -
Requirement for HR users to modify copies of reports for their useSummary: We have a client requirement for HR users with certain roles to be able to copy existing reports and then modify them for their own use cases. Content (please e…Alona Aronov-Oracle 16 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Getting Blank Data When Combining Multiple Subject Areas in ReportSummary: Hi everyone, I’m trying to create a report by combining fields from three or more subject areas. However, whenever I add columns from different subject areas in…Vaibhav Shingare 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Can a ESS job have 2 different BIP report layout which will execute 2 different queriesSummary: We have a requirement wherein client is expecting one ESS job will execute different queries based on parmater and both quries are having different report layou…essdee 6 views 1 comment 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
Need Table details for Subledger Journal Batch Description in 25DSummary: Subledger journal batch description is showing in UI (review subledger journals page) as 'Payments'. We have checked xla_ae_headers, lines, events and transacti…AbdulBasith 29 views 0 comments 0 points Started by AbdulBasith Subledger Accounting & Accounting Hub
-
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
Extract the UCM content server attachments through BI ReportsSummary Extract the UCM content server attachments through BI ReportsContent Hi, PDC attachments(File formats like PDF,Excel,JPG etc) currently placed in UCM content ser…
-
BI Publisher prompt on date to refresh other parametersHello, I built a BI Publisher report with a prompt on 'as of date' which I want to reflect on other prompts so they refresh the available values. I read that it's not ye…Alice Gouzy 29 views 2 comments 1 point Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Why would a report not reflect the updated data model?We had an issue wherein the report did not reflect the updated data model. The fix was then to duplicate the report itself without any changes. The duplicated report the…Hazelle 38 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Procedures in AP_INVOICES_PKGSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Consultant2025 7 views 1 comment 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management
-
Generating Record 0150 (Participants/Suppliers) in SPED Fiscal (Bloco K) via LACLS_SpedInvBlocoKHi everyone, I have a question regarding the Brazilian Localization for EFD ICMS/IPI, specifically concerning the generation of Bloco K (Inventory and Production Control… -
AR Transaction Approval QuerySummary: Hi Team, Please help to get table that stores AR transaction approval History.User_S5U61 10 views 1 comment 0 points Most recent by Vighnesh Khade Reporting and Analytics for ERP
-
Print Receivables Transactions completes with errorSummary: When attempting to run the "Print Receivables Transactions" process for a single invoice, we are getting below error: The bill-to customer email address for tra…