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 table stores the system transactions reference number for Bank Statement (CE) reconciled itemsSummary: We are attempting to replicate the Cash Management Bank Statements>Manual Reconciliation page>Reconciled tab in a custom OTBI Report. For system transactions li… -
Pass Column as a Presentation VariableSummary: Using presentation variable, compare one column against another in Conditional Format Content (required): Hi All, Does anyone know how to go about creating a pr… -
Which PVO's have location level details (e.g., names, codes, address information)Summary: Which pvo should be used to join to in order to get the location information for the deliver_to_location_id for each purchase order distribution line? Content (…
-
schedule an analysis to run for sysdate and send email only if there is dataSummary: Content (required): Hi, I have created a very simple analysis - Project name, Project number, Project start date and project completion date and created by and …
-
ERP Cloud - Restrict value set by Data Set / Business UnitSummary: Create a value set that restrict values based on Data Set / Business Unit selected. Content (required): I am trying to create a value set that only displays val…
-
FRS report duplicating parent when opening in BI catalog, but does not when opening in WebStudioSummary: Content (required): Hello: Does anyone have an idea why a row would duplicate for a parent when opening the report from the Catalog, but not when opening viewin…
-
EPM OOTB report listSummary: Report list Content (required): Hi, Is there a consolidated list available that provides EPM OOTB reports like other areas in a speadsheet? Thanks Version (incl…
-
How to add standard report icon in springboardSummary: I have a requirement to add icon of a standard BIP report in springboard. I am using static URL to create page entry. We cannot open a standard BIP report from …
-
How to find latest record in table PJO_PLAN_VERSIONS_B for projectSummary: Hi Team, I want to know how to find the most recent record in PJO_PLAN_VERSIONS_VL as version_number is same for all 3 rows. Regards Nidhi... Content (required)…
-
Query or the table that contains financial catogory for manage value UISummary: Hello all, We have a report in which we need to pick the financial category code we put against an account in manage value UI.please advise! BR, Sushan Peiris C… -
File Error Data may have been lostin OTBI - BI Publisher report that has multiple tabs is showing this error on opening the excel file. File error : data may have been lost Users are able to provide a sp… -
GL Value set DFF's are not available in SmartView/ FRSSummary: GL Value set DFF's are not available in SmartView/ FRS. Please let me know is this standard functionality. My client want to track this. Let me know we have ano… -
Best practice to re-use same query in the same BIP data modelSummary: I have a common query say for selecting business unit based on certain user based login. Now I have a main data model query with multiple sub-queries in it. And… -
BI Publisher Report in Scheduled ProcessesHi. I created a BI Publisher report and included it as a scheduled process using "Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Ma…
-
View OTBI Report using BI Consumer RoleHi. I created some OTBI reports and was able to view them. I am now testing view only access with the OTBI reports using a user that only has the BI Consumer Role. It se…
-
Strange SQL results, can't explain causeHi, I am comparing the use of SQL via Analytics between instances used by 2 different customers, both on version 22A. Example URL: example.fa.ocs.oraclecloud.com/analyti…
-
Bank Statement Analysis Report > Bank Statement TransactionsWe are trying to validate the transactions being reflected on this report. Here's the full path of the seeded report: Shared Folders > Financials > Cash Management >Bank…
-
Is there any way to get the sub category for module identify column in HRC_TXN_HEADER tableWe could see lot of transactions for Manage Employment (Under Module Identify field --> Table HRC_TXN_HEADER). We are trying to segregate the transactions. We are trying…
-
Where can I find prebuilt report and analysis list and pdf samples?Summary: Location of prebuilt report and analysis list and pdf samples on docs.oracle.com Content (required): The links do not work at https://docs.oracle.com/en/cloud/s…
-
-
how to join inv_item_sub_inventories to inv_secondary_inventorieshow to join inv_item_sub_inventories to inv_secondary_inventories
-
LLP/Partnership Implementation in OracleSummary: LLP/Partnership Implementation in Oracle Content (required): Has anyone implemented LLP/Partnership Firms in Oracle. We want to know how the Partners Accounts w…
-
Invoice Count by Supplier From Prior MonthSummary: COUNT function to display number of invoices by submitted from supplier in prior month using Dynamic Date scheduling Content (required): Hi All, Using the COUNT…
-
Procurement Dashboard is not showing the correct informationSummary: My Procurement dashboard is not showing the correct information against the PR. The PR has been converted into the PO and system is showing it but Dashboard is …
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…
-
How to make a dashboard prompt work with a custom logical sql?Summary: Hi I have created a custom logical sql, because I needed an outer join between two Subject Areas(Payables Invoices - Transactions Real time and Payables Payment… -
q parameter not working with ADF describe service connectionI have created service connection using 'Define by specification' and ADF describe option. /fscmRestApi/resources/11.13.18.05/itemStructures/describe with get all end po…
-
How to download OTBI and BIP reports before the refresh of the instance ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
How to find Parameters passed for scheduled ESS jobSummary: ESS job 'Purge interface tables' was scheduled 4 years back for AP invoice, due to some issue we cancelled the schedule and now we want to find the parameters u…
-
Read a file from UCM via Web Service as Private Data SourceSummary: Read File from UCM Web Service BI Publisher Content (required): We need to be able to read a file from UCM utilizing a data model in BI Publisher. We were able …