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
-
How to tackle different date formats being entered by user in Supporting Reference in BIP Report?I have a scenario when users input dates in multiple formats eg.18/Mar/2022, 18/March/2022, 18/03/2022, 2022/03/18 while posting a Journal in the Supporting References. …User_2025-02-12-15-34-52-841 21 views 2 comments 1 point Most recent by User_2025-02-12-15-34-52-841 -
Unable to find PVOs related to MSC(Planning Table)Summary: Hello, We need PVOs for following(Fusion) tables in BICC, as we couldn't find these in Data Lineage Sheet. If anyone has any idea on how to get those or any doc… -
BI - Seeded and Custom Folders Mirroring Each Other?!Summary: We are experiencing several custom template issues and have noticed that our Custom and Seeded Folders are mirroring each other without human intervention. Cont… -
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): …
-
Functional / logical ER diagrams for Fusion Apps?Summary: Where can I find functional or logical ER diagrams for Fusion Apps / Cloud ERP? Content (required): I am looking for something like https://architect.salesforce… -
How to check Agent HistorySummary: How to check Agent History Content (required): As JOb history in BI shows executions of BI reports, do we have similar place to see executions of Agents ? Versi… -
In OTBI Report, can we have details in single row per transaction with tax amount?Summary: We are looking to have only 1 line per transaction and when I add tax amount it splits the report to multiple lines per transaction. Is there a way around this?… -
R13 Higher Ed and Public Sector Cloud OTBI subject area to database lineage mapping spreadsheetSummary: This spreadsheet documents R13 Higher Education and Public Sector Cloud OTBI subject areas to database lineage mapping and subject area security Content: This s… -
How to audit the consumption of reportsHello, Is there a way we can view who is consuming OTBI and BIP reports? is there some sort of usage stat or which user is running the reports? Many thanks, James
-
Report to find details of history of all reportsHi Team, Could you please let me know if there is a way/ there is a report to retrieve details of all custom reports (OTBI/BIP) in terms of last updated by and last upda… -
To create custom subject areaHi All, Could you please let us know if there is a way to register a sql query as a custom subject area that can be used for creating an OTBI report. Our requirement is …
-
Financial Cloud: Are Allocation rules impacted by a Refresh?Summary: I am new to Financials Cloud Oracle. I was hired to be the Quarterly Update Coordinator. I am trying to learn and absorb as much information as possible to help…User_2025-02-12-17-31-01-725 31 views 8 comments 1 point Most recent by User_2025-02-12-17-31-01-725
-
Filter ReceiptHi, I am receiving output of the query as below I would like to modify the below query to have separate queries one query to display row number 1,2,3 which are highlight… -
Procurement Agent ListSummary: Content (required): Is there a report that will show a list of our procurement agents and the permissions they have been assigned? We feel like many of them are… -
When running BIP report on Oracle fusion ERP we are getting Time our error.Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Combine BiP and OTBI audit data in custom reportSummary: Is it possible to combine BiP and OTBI audit data? Content (required): We have enabled the BiP audit feature and have compiled an OTBI audit report. Business is…
-
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…
-
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…
-
BICC - Get Full Extract on every scheduled runSummary: BICC - Get Full Extract on every scheduled run Content (required): We have a requirement where we need to schedule a PVO on a daily basis. And the output of the…
-
How to get 'Payment date' on the Procure to Pay Real Time subject areaSummary: How to get 'Payment date' on the 'Procure to Pay Real Time' subject area Content : I am trying to build a report using the 'Procurement - Procure to Pay Real Ti… -
Can BI Deep Link use variable to represent the servername in the URLSummary: Deep Links present an issue during P2T environment copy downs because after each refresh all Deep Links embedded in BI report definitions have to be modified, i… -
Are you still maintaining a GOLD environment?Summary: Whilst there are a number of promotion tools on the market it still seems there is always something you can't export/extract with them in order to remove the ne… -
Scheduling BIP Report in Fusion Financials (Cloud) - Conditional SendSummary: Is a trigger necessary on a data model to conditionally send or not send a report in BI Publisher or will a data model that returns rows or doesn't suffice? Con…User_2025-02-10-15-12-48-631 21 views 2 comments 1 point Most recent by User_2025-02-10-15-12-48-631
-
Is it possible to have default prompt value specific for each user in an OTBI dashboardSummary: We have an OTBI dashboard for which each user is searching a specific account combinasion. Instead of always typing the account in the prompt of the dashboard, …
-
Fusion Process Maps (Visio)Summary: im finding the Fusion Process maps and the references or lack of them being clearly defined a little difficult to follow, previously being used to a clear struc…
-
Role required to view Analytics section on Fusion Home PageContent Dear All, Could you please help me with the role required in Fusion to make the Analytics section visible on the home page. Regards, Mahesh
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to filter BI Report PARAMETER for COA Segment Values based on the security rules defined … -
Post report Completion event for External SystemsSummary Post report Completion event for External SystemsContent Hi, There is a scenario wherein client needs an event once the report is completed successfully, an even…
-
Get Invoices API not working Fusion Financial CloudSummary 500 Internal Server ErrorContent I have managed to successfully test many Rest API's in Postman however the Invoices API returns a '500 Internal Server Error'. I…
-
Rest API to GET reports from BIP in Fusion Financials SAASSummary Is there a Rest API to get BI Publisher reportsContent Hi All Is there a Rest API to call BI Publisher reports from Fusion Cloud Financials within SAAS financial…