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
-
BICC - ability to product a single CSV output merging data from many data stores/VO'sSummary: Does BICC support selecting columns from different data stores/PVO's and apply query filter? Content (required): We have a business requirement to extract large… -
Invoices on Hold with Matching DetailsSummary: I cannot find a good screen that will show you the pricing or quantity details that are behind a matching hold, so I created this set of reports that I hope you… -
Is there any Supplier Statement Report?Summary: Is there any Suppliers Statement Summary Report? including Opening and closing balance paid and unpaid invoices. Content (required): Supplier transactions Versi… -
Calling BICC Rest API Service in ODISummary: Calling BICC Rest API Service in ODI 12c Content (required): Need help to know the step by step configuration for calling BICC Rest API services from ODI . How …
-
Is there a REST API to get the submission and completion time details of an ESS Job ?Summary: Is there a REST API to get the submission and completion time details of an ESS Job ? Please provide pointers if available. Dhruv -
Unauthorized Access: Either you do not have the privilege, or you have not signed inAfter latest upgrade from Oracle fusion to version 22A and 22B - OTBI users are experiencing this error - intermittently. Everytime they refresh it connects back - but i…
-
How to Purge the Interface tables with Load_Request_Id as -1 and request_id is null?Summary: We need to run Purge Interface tables job for Import Payables Invoices. We have a few invoices with status null that have Load_Request_Id as -1 and Request_Id a…
-
Fusion Role Required for Approval & ReportsContent This sounds like a basic question, however we did not get a convincing answer via My Oracle Support. We are a Finance & SCM customer, and we would like to know (… -
Oracle Fusion Financials - custom version of standard BI Publisher reportSummary Oracle Fusion Financials - custom version of standard BI Publisher reportContent I am following this guide; - https://docs.oracle.com/en/cloud/saas/financials/21… -
Scheduling/Automation software available to support Oracle Fusion.Summary Scheduling/Automation software available to support Oracle Fusion.Content Hi Experts, We have a requirement to automate and schedule process in oracle cloud. Exa…User_2025-03-10-23-59-44-230 48 views 4 comments 2 points Most recent by User_2025-03-10-23-59-44-230
-
Roles given to External Auditors during AuditContent External Auditors will need to view Journal Entries, Invoices, etc and the supporting documentation. What roles have you provided them? We are trying to avoid cr… -
Need to identify tables that contain BPM configurations - Application PreferencesContent Looking to identify the table(s) that contain Application Preferences for BPM Worklist. See screen shot below. -
How to display data of a column horizontally in RTF?Content Hi all, I have a requirement where I need to display some data that comes from a column horizontally on RTF.Hereby, I'm attaching a screenshot of the RTF and wha… -
Vendor name not available at source lines for assets in FAContent Hi all, I face an issue where I don't get the vendor name for the table FA_ASSET_INVOICES where I take invoice no, PO no for source lines of an asset. When I add…
-
Field in form - how to find the corresponding attribute and tableContent Hi experts :) I have been working in many different ERP systems. Oracle Cloud is new to me. In some ERP systems it is possible in a form to access information ab…
-
Query to check if an invoice have a prepayment included or notContent Hi all, I want a query that can provide me with a flag whether an invoice has an applied prepayment or not. I checked if a flag is available in the invoice table…
-
Oracle cloud ERP Log monitoringContent Hi, Our organization wants to setup ERP Log Monitoring by ingesting the ERP System logs into Log Analyzers/aggregator. We do not have license for OCI. How else c… -
Why there is a delay in data loading for BI reports in fusion?Content Hi all,I found that some of the customs made BI reports in the fusion by me, has a delay in displaying data when a transaction or any change is done in the syste…
-
EBS Data Extraction SQLContent Hi, I am in the process of migration data from EBS to Fusion can someone help me to get the EBS data extraction queries for Finance (AP, AR, GL) and SCM modules … -
Mapping Oracle eBS (12.2.8) tot Oracle CloudContent We are currently investigating moving from Oracle eBS on premise (12.2.8) to Oracle cloud. We have quite some customizations and reports build on the old datamod… -
Recap of Ideas related to Audit Policies and audit logging abilitiesContent Following is a list of over 40 Ideas related to Audit Policies that we and others have logged. Most of these are essential to have complete audit logs; what we w…
-
Unable to find PVOs in BICCContent Hello, We need PVOs of following tables in BICC but we couldn't find these in Lineage Sheet. If anyone has any idea on how to get those or any workaround would r… -
LedgerSummary All transaction detailContent Hi experts, I need a report of all single detail of all transactions. Is there any report at "Scheduled Process"? Muhammad Amir Ver… -
Required-Oracle Fusion financials workshop PPT documentsSummary Required-Oracle Fusion financials workshop PPT documentsContent Required-Oracle Fusion financials workshop PPT documents -
How to give an access to specific users to custom ess jobSummary How to give an access to specific users to custom ess jobContent Hello All, We have one custom report and we have created a ess job to it and now wats to give an… -
What Role/Privilege grants access to edit Scheduled Agent "RUN AS" in OTBI?Content Does anyone know what Role/Privilege allows access to update the "Run As" field in a Scheduled Agent for an Analysis in OTBI? I've assigned the following to a te… -
BIP Schedule Skip or Resume after Oracle DowntimeSummary BIP Schedule Skip or Resume after Oracle DowntimeContent Hello, Whenever Oracle SaaS is down due to patching or release upgrades, does it pause all the BIP Sched…
-
Fixed value in Value set querySummary Fixed value in Value set queryContent we have defined the value set and validation type is Table we have written condition to pick email ID from PER_EMAIL_ADDRES…
-
How to import data model in fusion biContent Dear , We have data model but cant find to import data model into fusion. Could you please guide how to import data model into fusion. step by step We have admin… -
BI Publisher report in Oracle fusion not completing after 21B upgradeSummary BI Publisher report in Oracle fusion not completing after 21B upgradeContent Hello Peers- Posting our experience with one of the BI Publisher reports after upgra…