Reporting and Analytics for ERP
Discussion List
-
otbi procurement subject areaSummary Has any one used procure to pay real time and pruchasing real time subject area togetherContent I am trying to get po number ,invoice number from procure to pay … -
Oracle BIP Report RTF Template - Distribution Accounting Date DisplaySummary Oracle BIP Report RTF Template - Distribution Accounting Date DisplayContent Hi All, Hope you are doing well. Could you please suggest me on below rtf template r…
-
New Cost Center Name Displays DifferentSummary New Cost Centre Name Displays Different FRS Rerport ParametersContent I have created a new Cost Centre, by adding its value in the 'Value Set Values' for the Cos…
-
Remove SpaceContent Hi, Below is the query which concatenates all the category names and provides in single column value which works fine. I have registered this report as ESS Job w… -
Balance Sheet totals different for different usersSummary Balance Sheet totals are different for two different users, same reportContent Two users in our office have opened the same Balance Sheet report, same parameters… -
List of Seeded OTBI reports in Oracle ERP CloudSummary List of Seeded OTBI reports in Oracle ERP CloudContent Hi, Is there a way to get the list of seeded OTBI reports from our instance? I would also like to query th… -
OTBI - ConcatenationSummary Is it possible to create a field that concatenates two or more text fields in an OTBI analysis?Content I am trying to create an OTBI Analysis using the Procureme…
-
Error while customizing BI Publisher ReportSummary We are trying to customize the Account Analysis Report (ESS Job Name - Account Analysis Report) but getting error while trying to modify the data modelContent Hi… -
Can we find all scheduled BI Reports instead of navigating to each reportSummary Can we find all scheduled BI Reports instead of navigating to each reportContent I was trying to find if we can find all scheduled BI Reports instead of navigati…
-
Public Sector - budget to actualsSummary Budget to Actuals reports in Public SectorContent Hello, Have any other public sector Oracle Cloud users developed a good budget to actuals report? We have one t… -
Print Receivables Transactions: Email Delivery --Override email address for non prod instanceSummary How to override or block emails to customers in non prod instanceContent For Print Receivables Transactions-Email Delivery , Is it possible to have an override e…
-
FR studio dividing by 0 causing issues.Summary FR studio dividing by 0 causing issues.Content Column a= 634.74 Columnb= 0.00 Columnc= -([a]-[b]) = (634.74) columnd= [c]/[b]*100 = (should be 0 but getting weir…
-
OTBI computed field and graphSummary creating computed field and graphContent Hi all, I am very new to Oracle Fusion business intelligence. Background: * Fusion 19C * try to analyze the company's em…
-
Receiving Error When Prompting Values from Field Created from a Case StatementSummary Cannot function ship the following expression: EVALUATE. (HY000)Content I have created a Dashboard Analysis and Prompt from the following subject area: Subledger…
-
Security setup for users who are creating BI reportsSummary What job role does an employee require to create and run BI reportsContent Morning everyone, We are currently implementing Oracle Expense Cloud. Our BI team has … -
"Apps Document Currency Code" in Procurement - Procure To Pay Real TimeSummary "Invoice Currency" missing in Procurement - Procure To Pay Real Time Subject Area.Content In 19B version, the invoice currency seems to be missing in Procurement…
-
XML Structure of BIP reportContent Hi, I need to create a BIP report which is extracted as an XML. Below is the sample xml structure and sample XSD. How do I define an attribute of an element whil…
-
Prompts is not showing in reporting analyticsContent While running reports in report analytics the defined prompt is not appearing but the prompt is showing under browse catalog page. can you please give me input t… -
PO-Requisition cross-subject area reportSummary PO-Requisition cross-subject area report in fusion saasContent I am trying to create a simple cross-subject OTBI Analysis to display PO details alongwith the Req…
-
What role can be assigned to give a user OTBI access for report writing?Summary What role can be assigned to give a user OTBI access for report writing?Content What role can be assigned to a user for OTBI access for report writing? I can see…
-
Changes to BIP report are not reflectingSummary Changes to BIP report are not reflecting in the data. We have changed few columns in the Dataset but the report output displays old column data.Content Changes t… -
Journal Entry Reserve LedgerSummary Customization of the Journal Entry Reserve LedgerContent I'm customising the Journal Entry Reserve Ledger report - I am trying to add new data columns and change…
-
Access for General Ledger DashboardsSummary Cannot view data for seeded GL Analytics DashboardsContent Hello, What security role do I need to access the General Ledger Dashboards: Account Analysis, General…
-
Report to show all invoices, amounts, VAT and attachmentsSummary A report that will identify all invoices, with invoice amount and VAT amount along with a field that pick up the file attached name (including extension i.e. .pd… -
Purchase Order PDF Report CustomizationContent Hello, I have to customize Purchase Order PDF Report data model and change the layout as per business requirement. I know we have to follow different process to …
-
How to Add the Serial No Column in OTBI ReportsContent How to Add the Serial No Column in OTBI Reports.
-
manager data access for usersSummary manage data access for users - users without data accessContent On Manager data access for user page what sql or tables do i use to get USERS WITHOUT Data Access…
-
Report Data Size exceeds limitSummary Report errors due to too many rowsContent I am creating an Oracle BI report to extract journal details however when I execute for a particular entity i get the e…
-
Formula to sum up linesSummary Formula to sum up linesContent Hi all, Just wondering if I have PO lines say 3 lines and I want to display the total sum of the PO amount. How to do it in BI pub…
-
BI Catalog name and path extractionContent Hi All, Is there a way to extract the name and location/path of all reports under share/custom folder? We need it for our documentation and we had 100+ reports s…