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 3.4K views 84 comments 9 points Most recent by Sean Rogers -
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… -
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… -
Join GL and RCV_TRANSACTIONS in Fusion/ERP CloudSummary: HI All, We are looking a solution to create a SQL query for BIP report to Drill down Join from GL To RCV_TRANSACTIONS in Fusion/ERP Cloud where JE_Source='Recei…
-
Chart Labels mashing with line valuesSummary: Chart Labels mashing with line values Content (please ensure you mask any confidential information): I am building a dashboard using the BIP Online template bui…
-
The FRS report is not returning any data and does not populate any results.Summary: Hello, The FRS report is not returning any data and does not populate any results. I have tried adjusting the parameters, but there is still no impact. What is … -
How can Fusion BI Report generate two different PDFs for same data at each ESS run.I have a requirement where my report should have two outputs one with all price columns other without for same data. Based on my bursting logic I can generate two emails…
-
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeAs per the business custom requirement OTBI subject areas to be used are Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real time which is cc…
-
What is the recommended way to extract item data in bulk from Fusion Cloud(PDH) by External SystemSummary: What is the recommended way for an external system to extract item data in bulk from Oracle Fusion Product Data Hub (PDH) to be used with OIC. Content (please e…
-
Is it possible to see the Old Value and New Values for Project Management Changes in Audit Data?Summary: I am trying to identify Project Management changes in BIP tables, specifically Project Org or "CARRYING_OUT_ORGANIZATION_ID" . We need to include the historic d…
-
What are the different ways we can get consolidated reports for a ledger setSummary: We need to present consolidated reports for our ledger set containing 5 Ledgers. What are the different ways we can get the reports. Content (please ensure you …
-
Help with query to pull Spoke System Items for a given itemHi, I need to create a query to pull all "Spoke System" linked to a item. A have tried the query below, however if won't work because the source_system_id on EGP_ITEM_RE…
-
We need a tables or Query to get Opt-in Features for Financial in oracle fusionSummary: Hi Team, Could you please provide us the Query or Tables to get Opt-in Features for Financial in oracle fusion. We could find the below table, but these are not…
-
Download Attachment File from Oracle REST API (HCM/SCM) without MiddlewareI was able to successfully retrieve the download URL from Oracle Fusion REST API within BI Publisher (Data Model only), and the link works correctly. However, when downl…
-
OTBI Risk Management Catalog Deployment After Instance RefreshSummary: Hi, We have deployed the OTBI dashboard for Risk Management by unarchiving the Risk Management OTBI catalog into our lower environment. We would like to underst…
-
When using Journals real time subject area the amount for a journal is getting doubledSummary: When I add the Journal Batch details folder columns, especially the 'Created By' field to the OTBI analysis, the amount gets doubled for the journal. This is ha…
-
How to populate JG_ZZ_VAT_REP_STATUS tableSummary: We are working on a Bulgaria rollout. VAT reports are customized and uses JG_ZZ_VAT_REP_STATUS table.We could not find how to populate this table Content (pleas…
-
Standard oracle functionality is not working when one custom button added in the Edit Journal Page.Summary: I have created one custom button in the Edit journal page name 'Validate' for a business requirement in my project. That custom button itself is working as expe…
-
How to replace invalid XML character (fffe)Summary: Due to invalid characters in Purchase Requisition header description (mostly likely due to requestor copied and pasted content containing this invalid control c…
-
Item EFF/DFF public viewobject in BICCSummary: What is the BICC Public View Object to extract the Item EFF and DFF values from Fusion Cloud. I am unable to download the 26A version BICC extract files for HCM…
-
Fixed Assets – Asset Description Real Time report OTBIHi, We have identified an issue in the Fixed Assets – Asset Description Real Time report. It appears that the asset number is not being correctly mapped to the asset boo…
-
Project field is blank for below querySummary: WITH hours_data AS ( SELECT prr.payroll_assignment_id, prr.run_result_id, TRUNC(prr.ora_part_key) AS trx_date, SUM(TO_NUMBER(prrv.result_value)) AS hours FROM p…
-
Is there a way to change the default export format to xlsx in ERP?Summary: We use Excel 2024. When exporting reports out of ERP, they default to Excel 2007. Is there a way to change the export format to xlsx? Content (please ensure you…
-
Payable Invoice lifecycleSummary: looking for any OTBI Analysis which provides AP Invoice lifecycle view. Content (please ensure you mask any confidential information): Version (include the vers…
-
Financial Reporting Studio Issue: 2026 Data Not Appearing (current Year)Dear Oracle Support, We are encountering an issue in Financial Reporting Studio (FRS) that is affecting the display of 2026 data in our reports. Pervious year data showi…
-
Balance Sheet SQL query requirement in BIPHi everyone, I need to build a custom balance sheet report in Oracle Fusion Cloud Financials using BI Publisher**,** and I’m completely stuck at the starting point. I ha…
-
issue with custom bip reportSummary: our team has developed a custom report for weekly notification on held invoices. report purpose is if any approval pending or hold to be released it will send i…
-
Standard Purchase Order Report sub template logicSummary: Hi Team, Theres a subtemplate being called in PO template rest of contents in rtf template has english content with fields no language specfic condition. but w…
-
SQL to get the list of all tax codes definedSummary: Hi, Can anyone please share the SQL to get the list of all tax codes defined. Or are you aware if there is any standard reports which is available that can prov…
-
Can a ESS job have 2 different BIP report layout which will execute 2 different queriesSummary: We have a requirement wherein client is expecting one ESS job will execute different queries based on parmater and both quries are having different report layou…
-
AR Transaction Approval QuerySummary: Hi Team, Please help to get table that stores AR transaction approval History.
-
Missing informations in FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVOSummary: Why ZX_PARTY_TAX_PROFILE Informations regarding Suppliers are not in the PVO 'FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO' but only in the o… -
CX Sales BI Publisher report to show payment terms for accountsSummary: Is it possible to have a BI publisher report to show list of account and their payment terms which would have been setup in accounts receivables ? What tables a…