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
-
PO PDF Template Conditional Regions by Purchasing CategorySummary: We are trying to update the PO PDF template so that if 3 specific purchasing categories are used on the Purchase Order it renders some different text on the tem… -
OTBI report looks different when opening from ERPOTBI report looks different when opening from ERP than when opening it from OTBI. I want it to look like in ERP, but I do not understand why it will not do this. The fie…
-
Unable to add a new field to oracle seeded report "Payable Trial Balance Report"Summary: We have a requirement to add a new field "Vendor_name_alt" to seeded report (Payable Trial Balance Report), after added new field and ran ess job it is throwing…
-
Do we have any seeded audit report for setup changes required for SOX 7.2Summary: Audit report for setup changes Content (please ensure you mask any confidential information): This is in reference to SOX 7.2, and I would appreciate your assis…
-
Is it possible to see when a text field has been updated in Reports and analyticsThe usecase is to be able to make a filter on a text field where only items that have updated that specific field for the last 4 weeks are shown in the results.
-
deeplink for receiptsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…
-
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… -
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …
-
Join between xla_distribution_links and po_distributions_allHi, Can anyone tell me how to join from xla_distribution_links to the purchase order tables (po_distributions_all)? For example, for the receipt accounting accrual. In x…
-
Audit Trail in Procurement and Self Service ProcurementSummary: Currently in Procurement its possible to see only Supplier Audit History. Requisiton and Purchase Orders don't have any detailed history data available. Content… -
Financial Reporting Center reports not showing in searchHello, We are having an issue with reports showing in FRC. When a user searches for a report in FRC they return no results, but if the user navigates to the BI Catalog r… -
How to get the gl account segment 'description' from BICC PVO extracts?Summary How do we get the gl account segment 'description' from BICC PVO extracts?Content How do we get the gl account segment 'description' from BICC PVO extracts? We a…
-
what is the previlege for Workflow Transactions ListingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Timezone - BIP Report schedule defaultSummary Timezone - BIP Report schedule defaultContent Hello All, When we schedule any BIP report, in Output tab we noticed that below is the default timezone for all use… -
Can we have a multiple bursting in one reportSummary Can we have a multiple bursting in one reportContent Hello, Can we have multiple bursting in one report, I can create multiple burstings within the data model an… -
Schedule job list wanted by name of schedule time interval by schedule process by status waitSummary: I need the Report that can show me all schedule process running on interval and because we have many schedule process running. We have no track of those schedul…
-
Hi All, Can you help me with SQL Query for BIP Report Status and report name?Hi All, Do we have any SQL query for BIP Report Status ,report name and report history and the status of the Report?
-
Can I edit the template of FYI notification myself?Summary: Would you please let me know whether I can edit the templates of FYI notification myself? If yes, where can I find these templates? Thanks. 1, the FYI notificat…
-
Ability to load data into custom objects in file based using API similar to FBDISummary: We have a requirement to upload data into custom objects created using application composer file based, similar to FBDI approach. Has oracle exposed any service…
-
supplier bank accounts fusion querySummary: I am trying to retrive the supplier bank accounts loaded in fusion at supplier header level. I have loaded bank accounts with only BANK_ACCOUNT_NUM. I did not i…
-
How to join fnd_bpm_task_comment to fnd_bpm_task_history_b table?Summary: I am trying to get data from fnd_bpm_task_comment table and joining with fnd_bpm_task_history_b table with Task_id but i am dropping the data which doesn't have…
-
Changing Fonts in PDF Forms within FinancialReportsWe are creating forms in FinancialReports and outputting them as PDFs. We wish to change the font used in these forms. We have confirmed that fonts can be changed on a c…
-
Can we customise notifications to users only if there is any data generated after an ESS job runs.Summary: We have a requirement for which we want the notifications/Emails to be sent to users after an ESS job runs every week and if it does not have any data we don't …
-
Bug 28478515 : AUTOPOST JOURNALS PROCESS FOR MULTIPLE DATA ACCESS SETSummary Unable to perform batch posting by "Batch ID" due to data access set designContent Is there is update or ETA for fixing of this bug? Bug 28478515 : AUTOPOST JOUR… -
Which table/column store "Update unpaid invoices" of supplier bank accountSummary: Which table/column store "Update unpaid invoices" of supplier bank account Content (please ensure you mask any confidential information): Version (include the v…
-
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…
-
BI Cloud Connector (BICC) New featuresHi Does anyone know of any changes coming to BI Cloud connector with Fusion Application 22A upgrade. And can anyone help provide the link to the the New Features documen… -
What table store approval rules configuration in FusionSummary: We are looking tables name for approval rule configuration. Navigation: Tools>Transaction Console>Approval Rules Content (please ensure you mask any confidentia…
-
How to add account flex field as parameter for custom BIP reportSummary How to add account flex field as parameter for custom BIP reportContent Hi All - I have requirement to create custom BIP report which has to developed around GL …