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
-
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 2.8K views 77 comments 9 points Most recent by Malleswara_Rao_P -
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra… -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available … -
Sample OTBI dashboard and reports for Joint Venture Management TransactionsSummary An OTBI dashboard with a detailed and summary report for Joint Venture Management Transactions. Content You can import the attached catalog file into a Cloud ERP… -
Editing of transactions within Transaction ConsoleSummary: We have enabled the editing function within the Transaction Console. Users can now adjust the transactions to make corrections while not yet approved. Is there …
-
Why are some users receiving error:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P ?Summary: Some users are receiving Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P when attempting to access a OTBI Dashboard. However, other …
-
help with if/then formula in EPM ReportI need help with a formula in a report. As soon as I add the subtraction part to the final part of the statement i get an error. This works: IF(IsMissing([G]), 0, [F]) T… -
FRS Reports erroring out intermittentlySummary: erroring out intermittently Content (please ensure you mask any confidential information): These are the errors received trying to run the Fin reports Error exe… -
Query to fetch the CARRIER_NAME, DELETE_SOURCES and DELETE_EXCLUSION for Sourcing RulesHi Everyone, Can you please help me with the SQL Query or the Fusion tables/columns required to fetch the following fields for Sourcing Rules( Supply Chain Planning → Ma…
-
XDO_TEMPLATES_BSummary: I am not able to query XDO_TEMPLATES_B. Getting ORA-00942: table or view does not existhttps://docs.oracle.com/error-help/db/ora-0 Content (please ensure you ma…
-
Query to get PPR pending approver nameI need to extract data for Payment Process Request ( PPR ) with pending approver name.
-
Getting duplicate records from AP subledgerSummary: Getting duplicate records from AP subledger Content (please ensure you mask any confidential information): Hi All, I have a requirement where i need to fetch th…
-
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsSummary Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsContent Adding Project Classification (Class Code) to OTBI report duplicate Costs R… -
How to monitor the following reporting and analytics field : "Enable Monitor and Audit" fieldSummary: Under reporting and analytics, under Administration, Manage Publisher, Server configuration, under Monitor and Audit section How can monitor "Enable Monitor and…
-
Need details on PVO: FscmTopModelAM.NoteAM.CashAdvanceApprovalNotesPVOWe would like to request additional information regarding the PVO FscmTopModelAM.NoteAM.CashAdvanceApprovalNotesPVO. Specifically, we are seeking clarity on the followin… -
Which report is responsible for managing the approval notification in the application and the emailSummary: We would like to add the supplier name to the report that manages the sending of approval notifications. The goal is to display the supplier name in both the in… -
How to hide Common Content folder under Shared Folders on BIP Catalog pageSummary: Before the quaterly patch 25A, system did not show "Common Content" under Shared Folders on BIP Catalog page. But somehow system shows "Common Content" under Sh…
-
How to reduce Report post processing time or template processing time in oracle fusion BI Publisher?We are working on one custom report performance which is taking more time for post processing. Report XML generation takes around 40 sec time and to generate excel repor…
-
Bursting Feasibility for BIP Report having Multiple Data ModelsDear Team, We have one requirement wherein we need to enable bursting for one report having multiple data models, kindly confirm if that can be achieved. If yes, then pl…
-
Cross validation Rule extract by report / SQL querySummary Need report/SQL query for extracting Cross validation rulesContent I am looking for Cross-validation report or SQL Query to extract all cross-validation rules at…
-
How to create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as SourceSummary: I would like to know if it is possible to create a parameter in an ESS Job that is dependent on another LOV parameter that has a User-defined (SQL) LOV Source. …
-
https://cloudurl:443/fscmRestApi/resources/11.13.18.05/erpintegrations' failed:bad request (400)Summary: We have integration between ebs to scp cloud. we have schedule integration run on mulesoft. mulesoft site using Below one. https://cloudurl:443/fscmRestApi/reso…
-
OTBI Analysis Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversionHello, I'm getting the error in my OTBI Analysis: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion when I add a column Called "Requirement Text" fr…
-
ERP Period Close White Paper with Runbook Considerations (Doc ID 2506148.1)Summary Updated documentation availableContent Hi, Please note that we have posted an updated Period End document (21C) onto MOS 2506148.1 today. Also, based on customer…
-
Can we submit ESS job using BIP Report ??Summary: Can we submit ESS job using BIP Report ?? Content (required): Can we submit ESS job using BIP Report by setting data set as Procedural call ? Version (include t… -
otbi is fetching the amount details for only USD currencies not for all currenciesotbi is fetching the amount details for only USD currencies not for all currencies do we need to enable any profile options, apart from USD we are unable to get the amou…
-
Syntax for referencing a user privilege in an EL ExpressionSummary: Content (please ensure you mask any confidential information): Hi, I am trying to build a custom menu to access OTBI reports from the Navigator / springboard . …
-
Fixed Assets - Entered PeriodSummary Is the "Entered Period" available in any of the Fixed Asset subject areas?Content I have been searching through the various asset-related subject areas for a fie…
-
Assistance Required for OTBI Reports in SCM (Inventory Module)Hi, We are developing a few OTBI reports for the SCM module, specifically on the inventory side. However, we are facing difficulty in identifying the correct subject are…
-
How can I schedule a BI Publisher report with dynamic date parameters for the previous 3 months?Summary: We have a report used by many business areas. One particular business area would like to schedule this report to pick up the previous 3 months of data. How can …
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence having an impact.Summary: There's an issue with HCM Reports having said that some columns were not available and the root cause of it was when Import Oracle Fusion Data Extensions for Tr… -
Table/View for AP Invoice Approval History & Workflow (BPM Flow)We are in the process of creating a customized report to track the complete approval history of AP invoices in Oracle Fusion. The requirement is to fetch details of the … -
BI Report Pulled Into a Dashboard Displays the Parameters in TEST Environment but not PRODIn our Production environment I pulled a report into a dashboard and I can’t view the report parameters when I open the dashboard. However, when I create this report and…