Category 129
Discussion List
-
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…
-
Why Fusion and OTBI report gives different Validation StatusIn OTBI I use the MATCH_STATUS_FLAG from AP_INVOICE_DISTRIBUTIONS_ALL to get the validation status. A - Validated Null - Never / Not Validated T - Needs Revalidation Is …Alvin 16 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
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 …
-
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…
-
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…Ray727 391 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
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…RupaliGahalot 324 views 16 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for ERP
-
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 …
-
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…
-
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…
-
customize standard reportSummary: Hello everyone, Can you tell me how I can find out which standard report is associated with this view in the purchasing module > purchase requisitions? I've tri… -
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…Nariman.Moussa-Oracle 17 views 2 comments 0 points Most recent by Nariman.Moussa-Oracle Reporting and Analytics for ERP
-
Description need to pass for Purchase order using Oracle standard SOAP servicePassing Description in Oracle Standard API for uploading Attachments - We need to pass a description while uploading attachments via Oracle’s standard SOAP Service for P…
-
using procurement data for commitment reportingSummary: Looking for a way to report commitment data using procurement data Content (please ensure you mask any confidential information): We currently report purchase c…
-
How to dynamic format currency amounts in an RTF template (ref. Doc ID 1588933.1)?Summary: Hello, I have the following challenge that we need to format certain currency fields in an RTF (invoice) template regarding certain conditions WITHIN the templa…Frank.Steinjan 72 views 6 comments 1 point Most recent by Frank.Steinjan Reporting and Analytics for ERP
-
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…Aditi Agrawal2650 33 views 5 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
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…
-
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…
-
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…JoanB 32 views 5 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP
-
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… -
AD_APPLIED_Patches Patch TypeSummary: The AD_APPLIED_Patches "Patch Type" column has three different types - 'Maintenance-Pack', 'Patch-Set', and 'Snowball'. What are the differences between these t…
-
Custom BIP report for Accounts payable trial balanceSummary: I am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to p…