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
-
I'm new to BICC - any PVO advice?I hope this is the right community. I couldn't find one specific to BICC. My background is in integration platforms such as OIC and BizTalk, so working with the Fusion &… -
Extra space at the top of the page : RTF TemplateSummary: Having a strange issue with PDF generated form RTF Template. The RTF template has a header. The PDF output when generated has a blank space at the top of the he… -
Unable to see and run "Input Tax Gain and Loss Report for Singapore"As per suggestion given on "https://docs.oracle.com/en/cloud/saas/financials/25b/ocuar/input-and-output-tax-gain-loss-reports-for-singapore.html#Frequently-Asked-Questio… -
Connect to PaaS db from BIP to create report from custom tables created in PaaSSummary: Connect to PaaS db from BIP to create report from custom tables created in PaaS Content (please ensure you mask any confidential information): We have a require… -
Report that can extract information about the user's active tasksIs there a report that can extract information about the user's active tasks, which are displayed in the task area of each module? A report on the privileges assigned to…
-
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 …
-
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…
-
How to pass system date in subject line of email notification when scheduling an Ess jobSummary: I am scheduling ESS job set, our requirement is to print system date in email notification subject line and attachment name. How to configure dynamic date (Sysd…
-
Is there a report to show users' roles and privileges or what's table of them?Summary: We want a report to show users' roles and privileges or we can customize a new if there's no statndard process, but we don't know the table for these infoematio…
-
forgetaccount utility not working for one of the userSummary: Hi All, I am trying to use forget accounts from this document and it is not working How To Run renameAccounts/forgetAccounts When User is Unable To Login to Ana…
-
Mass reassign of approvalsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is there a query to get job board (e.g. LinkedIn, Broadbean) posting status?Summary: Is there an SQL query to get job board (e.g. LinkedIn, Broadbean) posting status for a specific job requisition? Content (please ensure you mask any confidentia…
-
PVO SubledgerJournalTransactionEntityExtractPVO and SubledgerApplicationExtractPVO generating blankSummary: PVO SubledgerJournalTransactionEntityExtractPVO and SubledgerApplicationExtractPVO generating blank files even after reseting to full extract Content (please en…
-
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…
-
OTBI reportOTBI report
-
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…
-
What table store approval rules configuration in FusionSummary: We are looking tables name for approval rule configuration. Navigation: Tools>Transaction Console>Approval Rules Content (please ensure you mask any confidentia…
-
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…
-
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…
-
Fusion SCM Analytics Prebuilt KPI Library for MFGHi, I am looking for prebuilt KPIs library for MFG subject area. I checked the documentation link 25R1. but could not find the list for MFG, although for OM,INV etc I co…
-
Is there a way to reset a PVO in a particular job from DB or any REST API or any other way in BICC ?We are looking to reset a PVO in a specific job by any other options like REST or other API or DB. We don't want to perform from the BICC page. If there are any inputs o…
-
OTBI reporting errors after 25B release - Error generating view. Error getting cursor in GenerateSummary: After the 25B release on May 17th 2025, many of our reports are now failing to run, and presents error below. Reports which are run return a mixture of differen…
-
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…
-
BIP Joining GL with PJF_PROJECTS_ALL_BI'm trying to join PJF_PROJECTS_ALL_B with this query so that I can add segment1 from the table to this GL report. Does anyone have any insight for easiest way to achiev…
-
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… -
Requirement to get user environment languageThere is one requirement to get user environment language. Tried to logged in cloud with German language to get the expected output. However, when I run the following qu…
-
How to convert WD attachment in the rtf into table formatHi everyone I want to check if there is any possibility to convert the attachment from Work definition screen into table format. Below is the attachment being printed in…
-
How to restrict User From Submitting Create Accounting for a Certain SubledgerSummary: How to restrict User From Submitting Create Accounting for a Certain Subledger Content (please ensure you mask any confidential information): Hi All, We have a …
-
how add user variable to report header #2Summary: I need to add user variables into a report header. Is there any way to do this? What is shown below doesn't work.