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
-
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… -
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…
-
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…
-
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…
-
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…
-
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 …
-
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…
-
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…
-
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…
-
How to link GL journals to external cash transactionHi Team, I would like to create a custom BIP report to link GL journals to external cash transaction. How can I trace back from GL journal to external cash transaction? …
-
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 …
-
Adding BIP report to OTBI dashboardSummary: I am adding BIP report to OTBI dashboard. The BIP report runs fine individually, but when I add it to a dashboard and preview the dashboard. Nothing shows up. P…
-
Missing Data Repsonse using soap UIcould you please check this payload--> csv …
-
BICC: Extract is failing with Error while fetching rows from serverWhen we run the following PVO in full extract it's failing due to huge data as row counts are 208,699,447. FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalD…
-
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …
-
Requisition Report data not match with fusion job requisition data(attached screenshot)Summary: Requisition Report not match with fusion job requisition Content (please ensure you mask any confidential information): In the below SQL code for requisition co…
-
line managers are unable to view any data from my team - team skills centerSummary: line managers are unable to view any data from my team - team skills center although one of his directs has skills data be he is even unable to view his directs…
-
Unable to run reports or view it's dataDears, we have a custom role called profile specialist to handle all the transactions of profile management and it's copied from human resources specialist seeded role t…
-
Is there any table available where we can get status of email sent via burstingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is the number of rows retrieved from OTBI analysis is increased from 75K?Summary: OTBI analysis can retrieve maximum rows of 75K. But users are now able to retrieve around 160K records from the analysis. Is there any update/change happened in…
-
Help on Defining the LOV in BIP Excel TemplateHi Team, We have requirement to define a Person Name List of value in BIP excel template . Report will be run by Manager. Based on manager scope list of person Name need… -
How to determine the correct PVO to use for data augmentationSummary: Attempting to create a data augmentation for the Fusion Data Intelligence package to include an Accounting date from the Fusion ERP environment. We are needing …
-
Storing Oracle Fusion report outputs in document management systemSummary: We have a requirement for storing the output of various kinds of daily/weekly/monthly reports (BIP/OTBI/FRS) generated from Fusion ERP Cloud for audit purposes …
-
Report on user activities in Oracle Fusion ApplicationsSummary: Report on user activities in Oracle Fusion Applications Content (please ensure you mask any confidential information): Our management is asking for a report tha…
-
BICC: Last Extract Date for PVOs aren't set if Extract Schedule is failedI've JOB which contains 57 PVOs... Noticed the following behaviour when one of the PVOs is failed. The Last Extract Date for PVOs aren't set. It's set only if the Extrac…
-
Mapping Tables Not giving us accurate dataSummary: Mapping Tables Not giving us accurate data Content (please ensure you mask any confidential information): We are replacing our old system of EBS with ADW. When …
-
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 save an OTBI report into Reports and Analystics Favorites of Job Managers role in ERPI have developed some OTBI and BIP reports and I would like to centrally save this report in the Reports and Analystics Favorites for list of users / role. (Instead of e…
-
bursting is not workingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…