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
-
Custom ESS jobs error outSummary: We have 7 custom reports where created a related ESS job definitions and created custom role (with appropriate Privileges) to run those custom ESS jobs. Job is … -
Which table will hold the information of period of an Asset BookSummary: Which table will hold the information of period of an Asset Book Content (required): Which table will hold the information of period of an Asset Book Version (i…
-
Project Budget Data (EPBCS) with Project Actual (ERP/Project Costing)Summary: Project Budget Data (EPBCS) with Project Actual (ERP/Project Costing) Content (required): How are oracle customers that use EPM/EPBCS for project planning, appr… -
Finally Closed Lines are shown as Cancelled in PO Archive LinesSummary: Some of the finally Closed lines on Change Orders are coming as cancelled in the Po archive lines Content (required): Version (include the version you are using… -
Finally Closed Lines are shown as Cancelled in PO Archive LinesSummary: Some of the finally Closed lines on Change Orders are coming as cancelled in the Po archive lines Content (required): Version (include the version you are using…
-
I need a query to obtain Chart of accounts Values on ERPSummary: We are trying to create a report using BI Publisher and We require a SQL query to obtain the chart of account value set values (Value and Description shown on s…
-
OTBI Report for Payables Distribution SetsSummary: Trying to create OTBI Report of the Distribution Sets along with the details on the account numbers assigned Content (required): Create OTBI Report of Distribut…
-
How to get the ribbon to appear that's above the row with the file location using Firefox?Summary: Ribbon that contains catalog home/favorites/dashboards/new/etc is missing after choosing Browse Catalog in Reports & Analytics. It's like it's hidden, but can't…
-
Logo in BI Publisher RTFIs there any way of embedding a logo dynamically in BI Publisher RTF ? We wish to show different logos based on different legal entities.
-
ERP event – Principles of Oracle Fusion Cloud Applications Security, Nov 17th, 9am PTIf you have any questions for this event please post them here and we will try to address them during the live session.Maria Centeno-Cloud ERP-Oracle 51 views 0 comments 0 points Started by Maria Centeno-Cloud ERP-Oracle
-
BI Publisher - How to pivot to display questions horizontally using answers instead of measuresSummary: BIP - How to pivot to display questions horizontally as the heading using answers instead of measures, displaying respondents as the first column Content (requi… -
Is supplier audit report available in fusion?Summary: We are looking for standard report to track old value and new value when supplier name, supplier bank number, etc is changed. Please let us know is there any st…
-
21D known issues - Just a thread to note down any issues ppl with this release have facedSummary: Opening this thread to note down issues with 21D. Currently we have this release in our lower environment and are testing - so I thought to have a thread that c… -
Permission Error When Trying to Migration BIP Reports between DEV and SAT environmentsSummary: We've setup a pipeline in VBS and are using a job to migrate data models and bip reports from one region to another and running into a permissions error on our …
-
How to convert xml data to columns in BI Publisher report Using ExtractValue?Summary: How to convert xml data to columns in BI Publisher report Using ExtractValue? Content (required): Version (include the version you are using, if applicable): Co…
-
Using BICC PVO in data model for BI publisher reportingSummary: is there way to configure data model to use BICC PVO? we need some custom reporting built and would like to leverage BICC PVO in data model Content (required): … -
In REST API Metadata what does updatable= FALSE means?Summary: In REST API Metadata what does updatable= FALSE means? Content (required): We can get any REST API Metadata by using "Rest URL/Describe" example - https://hostn…
-
Report on OTBI Agents Scheduled / StatusesSummary: Report on OTBI Agents Scheduled / Statuses Content (required): Is there any way to Report on OTBI Agents Scheduled / Statuses, either via SQL in BI Publisher or…
-
Will MS Office 64-bit work for Fusion Smart View reporting?Summary: Our company is planning to migrate to EPM Financial Consolidation (FC), can we upgrade to MS Office 64-bit for both Fusion & EPM Smart View reporting? Content (…User_2025-01-25-04-50-08-084 11 views 2 comments 0 points Most recent by User_2025-01-25-04-50-08-084
-
Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you… -
Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you…
-
Analysis Report Prompt is not appearing when running from the InvoicesSummary: Prompt added to the analysis report is not appearing when running it using invoice window. Content (required): Hi, I have created a OTBI analysis report (Not fo…
-
Analysis Report Prompt is not appearing when running from the InvoicesSummary: Prompt added to the analysis report is not appearing when running it using invoice window. Content (required): Hi, I have created a OTBI analysis report (Not fo…
-
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…
-
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
Is there an Archive and purge Strategy for Cloud ERP?Summary: Is there any document or reference guide for Archive and Purge strategy for Cloud ERP and EPM? Content (required): For EBS, we had excellent resources in form o… -
How to customize Subledger Period Close Exception ReportSummary: How to customize Sub-ledger Period Close Exception Report Content (required): Ledger Set Parameter to be added to the report. when i'm trying to edit datamodel,…
-
Where can we see warnings after FBDI import of customersSummary: Where can we see warnings after FBDI import of customers Content (required): Where can we see warnings after FBDI import of customers. I cannot find them in the… -
Can I create a button to print or cancel, when executing a report in BI?Summary: Can I create a button to print or cancel, when executing a report in BI? If possible, what would be the next steps? Content (required): Version (include the ver…
-
Table which holds notification modeSummary: We need table name which holds notification mode Content (required): table to print notification mode Version (include the version you are using, if applicable)…