Reporting and Analytics for ERP
Discussion List
-
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…
-
XML file for Disbursement Payment FormatsSummary XML file for Disbursement Payment FormatsContent All, I cannot see any Data model attached to disburse payment templates. how to get XML file for them if we need…
-
FR Web StudioSummary FR Web Studio Too Slow To Build ReportsContent Hi, We are trying to build reports in our ERP environment(s). When we open FR Web Studio the lag is too slow; it t…
-
BI Cloud Connector (BICC) White paper or DocumentsSummary Looking for Information on How to create Extract using BICCContent Hi, I need to send incremental feed of Data such as Customer , Supplier, GRN and POs to anothe…Prateek Parasar - GTUK, ACE Pro 203 views 6 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro -
Custom BI Publisher Report SQL ErrorSummary SQL or ORA exceptions error.Content Hello, We are receiving the following error when running a custom built BI Publisher report. This report was functioning with…
-
Subject Area in OTBI to extract default Expense Account information of userSummary Subject Area in OTBI to extract default Expense Account information of userContent Hi, I am trying to build a OTBI report which has cost center and company infor…
-
Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelSummary Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelContent Hi I have LACLS Colombia reports into Oracle ERP Cloud. However, they… -
Bank statement balances check reportContent Crossposting here from the Cash Management forum as per Oracle's suggestion. We want to have a report that shows bank statements for which the subsequent bank st… -
What is the Data Model that runs the 'General Ledger and Subledger Account Analysis' Report?Content Hi All, There is a report run via a scheduled process called 'General Ledger and Subledger Account Analysis'. The report is extremely useful and we would like to… -
Get the correct PO Number for an Invoice NumberContent Hi, We had some consultants in they wrote a large piece of SQL, of which the below is a small part. It's looking to get the correct PO number for a specific invo…