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
-
What tables stores fixed choice list dependency created using application composerSummary: A custom application was created using Application Composer. A fixed choice list field was set up to depend on another fixed choice list. However, the selected …
-
Could you please help with fusion table details or query to get Supplier Email Address.Summary: Looking for list of all Oracle Suppliers email addresses held in Oracle fusion. Thanks. Content (please ensure you mask any confidential information): Looking f…
-
Is there something similar to srw.abort_program in Fusion ERP bip reportIn Oracle report writer one could abort the report using SRW.ABORT_PROGRAM Built in. Is there similar built in in FUSION ERP BIP Report?
-
FRS scheduler how to pass current month or Date to PromptSummary FRS scheduler how to pass current month or Date to PromptContent We are scheduling FRS reports. When we create batch it requests to enter the prompt values. Thes…
-
UCM Bursting not working for Fixed Assets Seeded ReportSummary: Issue in UCM Bursting for Seeded FA report Content (required): Hi, We are trying to create bursting for seeded FA What-If Depreciation Analysis Report to push o…
-
SQL Query to Extract Accurate Last Login Date for Active Users in Oracle Cloud SCM PlanningDear Oracle Experts, We are seeking assistance in generating a report from the PROD environment that provides a list of all active users across the following Oracle Clou…
-
FRS reporting - multiple cubes and concatenated segmentsSummary: Hi Team, We are trying to prepare balance sheet in FRS but have below questions. Can we use multiple Essbase cubes in the same report (as an example, can we pul…
-
Can anyone please share OTBI dashboards for procurement?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Include URL in BI Publisher report to allow viewing of invoice attachmentsSummary: I am trying to find a way to include a url link to a scanned invoice images stored as pdf attachments in Oracle from a BI Publisher report. Content (required): …
-
Is GDPdU (German Audit File) and GoBD Data Extract Same and Oracle ERP Solution is Generic SAF-TSummary: I have one question on Germany and Poland's localization report. Business requirement is to generate GDPdU (German Audit File) for Germany and Poland. When I tr…
-
What is the role or data access that allows to visualize the Subject Area.?Summary: What is the role or data access that allows to visualize the Subject Area. When I need to search, it is empty. Please your help Thanks Content (please ensure yo…
-
I have to create a actual vs budget amount report for revenue and expense accounts in OTBI.Summary: I have to create a actual vs budget amount report for revenue and expense accounts in OTBI. I have used GL balances real time subject area. The columns selected…
-
Capture SaaS Usage Metrics for FinancialsSummary: We have noticed that ESS job 'Capture SaaS Usage Metrics for Financials' is scheduled in production instance. It seems it is auto scheduled in the environment a…
-
Validation Status from AP InvoiceSummary: I am creating the Data Model of our BIP Report and I need to find out which field from what table should I use as Validation Status. Content (please ensure you …
-
Unable to find invoice validation status through BIP sqlSummary Unable to find invoice validation status through BIP sqlContent We are not bale find invoice validation status through BIP sql by using AP_INVOICE_ALL. Will be a…
-
BIP - Change Content Type in Content Server Data SetHi, Is it possible to change the "Content Type" from a content server data set in a data model in order to read PDF / Docx content. Thanks! Guillaume
-
ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMPSummary: we have one custom report keeps failing with error ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP in saas application. could you plea…
-
To connect Oracle Fusion database table with Oracle APEX to create oracle APEX ReportSummary: How to connect Oracle Fusion database table with Oracle APEX to create oracle APEX Report
-
OTBI reportOTBI report
-
PVO SubledgerJournalTransactionEntityExtractPVO and SubledgerApplicationExtractPVO generating blankSummary: PVO SubledgerJournalTransactionEntityExtractPVO and SubledgerApplicationExtractPVO generating blank files even after reseting to full extract Content (please en…
-
BIP SFTP Bursting vs BIP SOAP API calloutSummary: Advantages of BIP API download option (for data reports) Vs BIP report sent to SFTP channel Content (please ensure you mask any confidential information): We us…
-
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…
-
Some of the PDF attachments not appearing on printed AR Invoice in Print Receivables TransactionsHi Team, We are facing an issue where attachments in receivables transactions are not consistently getting attached or sometimes dropped during the printing of the invoi…
-
Convert this filter to SQLSummary: Convert this filter to SQL does not function Content (please ensure you mask any confidential information): I try to using 'Convert this filter to SQL' function…
-
R13 Projects OTBI subject area to database lineage mappingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Financial Reporting Studio Issue: 2025 Data Not Appearing CorrectlyDear Oracle Support, We are encountering an issue in Financial Reporting Studio (FRS) that is affecting the display of 2025 data in our reports. Problem Description: Whe…
-
Report not displaying Barcode when executed from ESS jobSummary: Report not displaying Barcode when executed from ESS job Content (please ensure you mask any confidential information): We have customized the Receipt Traveler …
-
we need to modify the "reply to" on the dashboards and analysis that we send via emailSummary: We have different dashboards or emails that are sent via email to different users. However we want the users to be able to "reply" to any of those emails and th…
-
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…
-
How to Extract the whole Transactional Data of Finance and ProcurementSummary: Want to extract the transactional data of Finance and Procurement which can be easily accessible and viewed via Excel. Content (please ensure you mask any confi…