BI Publisher
Discussion List
-
Create smart view report using querySummary Create smart view report using queryContent Hi All, We have created an Oracle BI report to display PO related details using query. And we would like to implement…Anjali Ravichandran 50 views 2 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
are there any SOAP/REST services available to Execute Report using JWT token instead of username andSummary are there any SOAP/REST services available to Execute Report using JWT token instead of username and password?Content Hi Team, Are there any SOAP/REST services a…
-
SQL gives me wrong purchase order number for invoiceContent Hi, When I go into the front end of Fusion, I can see that an invoice number of 26427 only has 1 purchase number matched against it which is PO 911753 When I do … -
Amending SQL slightly brings me: ORA-01427: single-row subquery returns more than one rowSummary ORA-01427Content I am using Oracle Fusion, the finance/payables reporting side of things I have the following code: SELECT DISTINCT PHA.SEGMENT1 FROM AP_INVOICES…
-
Which table stores 'Transaction Number' in Project CostsSummary Looking for backend table that stores 'Transaction Number' in Project CostsContent Hi All, I'm looking for backend table that stores 'Transaction Number' in Proj…Sumanth Kunimakki-21932 316 views 7 comments 0 points Most recent by Rasu P Reporting and Analytics for ERP
-
Reports with hardcoded parameters performing better then those with bind variablesContent Hello, We have a peculiar problem, we have a query for gl balances report which when run by hardcoding the Legal entity and period runs fine fetching all our dat…
-
Change Order History on POSummary Status, Amount and Qty of POContent Hello, How and what fusion tables can I get the status, calculated amount and quantity of a change order? Basically get the l…
-
Policy Predicate ErrorSummary When querying some tables and views we are getting Policy Predicate ErrorContent Selecting data from per_person_names_f or hz_parties is giving a policy predicat…User_2025-02-05-18-28-58-388 27 views 12 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
SQL Table to bring in Audited by from the AP module to a BI reportSummary SQL Table to bring in Audited by from the AP module to a BI reportContent I am searching for the SQL table to bring in Audited by from the AP module to a BI repo…User_2025-01-30-21-55-25-752 36 views 2 comments 2 points Most recent by Amitabha Reporting and Analytics for ERP
-
Drill to Fusion from a BI Publisher ReportContent Hi, I have created a very useful data model that will allow our users to search for payments, what I would like to do is link the invoice numbers to oracle fusio…User_QEU3G 87 views 9 comments 4 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP
-
Expenses Overview Real Time subject areaSummary A summarization program needs to be run to gather information before data is available in this area.Content We are creating some test reports from the Expenses O… -
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…
-
Reports based on SaaS extensions built in PaaSSummary How to created reports consolidating data from JCS-SX and ERP CloudContent Does any one have a documentation or experience on what's is the best way to achive th… -
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…OraFusionworld 40 views 4 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
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…Sudha KOVURU 94 views 10 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
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…User_2025-02-01-07-43-15-700 59 views 3 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
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…User_2025-02-05-07-37-39-271 24 views 0 comments 1 point Most recent by User_2025-02-05-07-37-39-271 Reporting and Analytics for ERP
-
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 …Jennifer Wolfe 57 views 5 comments 1 point Most recent by Michael Cook Reporting and Analytics for ERP
-
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…User_2025-02-05-07-46-04-895 109 views 3 comments 2 points Most recent by Rasu P Reporting and Analytics for ERP
-
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…User_2025-01-31-00-03-48-847 104 views 6 comments 1 point Most recent by User_2025-01-31-00-03-48-847 Reporting and Analytics for ERP
-
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…Thiru Vedantham 549 views 3 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
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…Elliot Hall-Walker 75 views 1 comment 1 point Most recent by Manish Pesswani Reporting and Analytics for ERP
-
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…User_2025-02-05-07-37-39-271 57 views 4 comments 0 points Most recent by User_2025-02-05-07-37-39-271 Reporting and Analytics for ERP
-
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…
-
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…Angela.Ahrens 65 views 1 comment 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
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…User_2025-02-04-05-26-22-197 50 views 5 comments 0 points Most recent by Ramesh Nayak Reporting and Analytics for ERP
-
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…
-
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…User_2025-02-05-07-37-39-271 89 views 14 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
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…User_2025-01-30-22-31-23-162 42 views 1 comment 0 points Most recent by User_2025-01-30-22-31-23-162 Reporting and Analytics for ERP
-
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…Aaron Leggett 187 views 10 comments 2 points Most recent by Bharath Dondapati Reporting and Analytics for ERP