To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv… -
Not receiving emails from bursting querySummary: We are trying to develop a bursting query to send email notifications, but are not receiving any emails though the report job shows to be successful. Content (p…
-
Report or table details for Chart of account listing values for natural account in General LedgerSummary: Hi Team, I have to create BIP report for COA listing values for Natural Account in General Ledger as per attachment. I am looking for table details or query to …
-
Sheets renaming in BIP report excelSummary: Sheets renaming in BIP report excel Content (please ensure you mask any confidential information): Hello experts, I'm developing a BIP report with excel output …
-
OTBI - can we apply case condition on columns from different subject areas ?Summary: CASE WHEN SA1.COl1 = 'Y' THEN SA1.COL2. ELSE SA2.COL1 END ; The above is not working as expected. Does OTBI supports CASE condition on multiple subject areas or…
-
How to migrate the custom defined ess job reports to the another instanceSummary How to migrate the custom defined ess job reports to the another instanceContent we have created the custom bip reports and those reports we registered as a ess … -
Oracle SaaS metric-descriptions-fusion-offeringsSummary: Hello Team, We are in a need of support to get information on following points. Scenario: We are in a need of adding these 2 privileges in our custom role ‘View…
-
How to create dependent Parameters in OTBI (Oracle Fusion ERP)?Summary: How to create dependent Parameters in OTBI (Oracle Fusion ERP)?
-
Unable to see and run "Input Tax Gain and Loss Report for Singapore"As per suggestion given on "https://docs.oracle.com/en/cloud/saas/financials/25b/ocuar/input-and-output-tax-gain-loss-reports-for-singapore.html#Frequently-Asked-Questio… -
Best Practices for OTBI Reports Handling Large Data VolumesSummary: Hi everyone, I’m looking for recommendations and best practices for developing OTBI reports that need to handle large amounts of data. Is there a recommended st… -
How to remove the privileges that are caught up in the ERP license count from the job roleHello, We tested and found the follows when trying to assign roles for OTBI report access. For the OTBI reports that spans business areas, there are some that cannot be …
-
Is it possible to change the output language of the log of scheduled process?I logged into the ERP with the default language set to "Spanish." However, when I download the log file from the "Scheduled Processes" UI, the output shows information i… -
BIP report only bursting to default printerHi Team, I have bursting logic in my BIP report to burst the output to different printers based on a lookup. If the selected printer is set as default printer in Adminin…
-
Request for Guidance on Data Export Prior to Tenant ExpirationOur Oracle tenant is set to expire next month, and we would like to ensure a smooth and complete export of all relevant data prior to that date. We have reviewed the ref…
-
Data Roles and Security Profiles - Unable to find 'STATUS' column for BI reportsHello, I’m currently working on a report related to Data Roles, and I was wondering if anyone here has worked on something similar or knows which table/column stores the…
-
MOT_REF_ENTITIES custom object table not pulling dataSummary: There is a OTBI report built using custom object subject area whose dimension and fact tables are populated with data thorugh some integration reports through s…
-
BI Fields used at Header in RTF template do not show input parameters value when there is no data.Summary: Hi All, In custom report, BI Fields are used at Header level in RTF template to display selected input parameters values. User use PDF extract and it works fine…
-
How to split a single row into multiple rows in oracle fusionDear All, I got an requirement like need to split single row into multiple rows dynamically, but here that single row is having value like 99 so i need to split 99 rows …
-
SQL Statement for AR invoice including attachment line informationSummary Receivables Transactions ExtractContent Hello I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have…
-
How can I get the image of products in report OTBI Query?I want to get the images uploaded in the Product Information Management module for a report using a query, I have the following query, but I have not been able to get th…
-
What does the FND_GRANT report data mean?We have a report in Oracle ERP Reports and Analytics that pulls data from FND_GRANTS that were modified during a specific time frame. Usually this report is empty but du…
-
script to show item numberDear all, I would like to get the records of procurement with detail item number and description for each PO Line. i try with script, but the item number not shown can a…
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to get the Individual COA Segment Values based on the security rules defined for the Role…
-
OTBI reporting errors after 25B release - Error generating view. Error getting cursor in GenerateSummary: After the 25B release on May 17th 2025, many of our reports are now failing to run, and presents error below. Reports which are run return a mixture of differen…
-
Email notification for the Aging ReportEmail Delivery (notification) to the user we have certain requirements related to the notification of Aging to the set of customers. Auto weekly reminder email (every Mo…
-
How to hide custom Report from BIP page and ESS job from Scheduled Process ?Hi Team, I have a requirement to hide Custom Report and Respective ESS job (BI catalog page and Scheduled process) From User's view. Tool → Scheduled Process →ESS job. T…
-
Identity Correct PO and PR approval email & notification reportsSummary: How can we identify and modify the correct Oracle Analytics reports to update email and approval notification formats for Purchase Requisitions (PR) and Purchas…
-
Not able to create a PO adding Header level DFF and line level DFF in that single payloadAble to create a PO in a single payload having headers, lines, schedules and distributions. However not able to create a PO adding Header level DFF and line level DFF in…
-
Can we customize Print Receivables Transactions report Bursting query from emai To FTP/SFTP ?Summary: Client requirement is to receive AR transaction PDF to FTP location rather sending it via email so want to customize Print Receivables Transactions Bursting que…
-
BICC: GL journal approval workflow dataHello All, I didn't find any PVOs for GL journal approval workflow data…. I am aware of writing BIP report, but this option is very least preference. Wondering is there …