BI Publisher
Discussion List
-
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 537 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 76 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 55 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 87 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 186 views 10 comments 2 points Most recent by Bharath Dondapati Reporting and Analytics for ERP -
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…
-
How to set/enable the menu "Reports and Analytics" regardless of responsibilitySummary We’ve created the BI reports to General Ledger but is not possible see the “Reports and Analytics” option on the responsibility menu area, is possible enable thi… -
No response after import sample XML data into excel through BI PublisherSummary No response after import sample XML data into excel through BI PublisherContent Hi all, I have export xml data and want to create xml template in BI publisher in…User_2025-02-04-05-26-22-197 48 views 6 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP
-
How to avoid special characters from rtfContent How to avoid new line feed coming as special symbols from rtf template.? Ex.. text entered to item description from application is like line 1. press Enter Line…
-
rtf template - display constant text on every pageContent Hi All, I have a rtf template which contains nothing but a (row*column) table. I need to display a constant text like "Hello" at the bottom of every page, other …Rinku Gautam 85 views 12 comments 1 point Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
How to save a report output with date suffix?Summary How to save a BIP report output with date suffix.Content I managed to get a complete XML output using select query with XMLELEMENT () tag using Data Model. Now I… -
Can we extract AP BPM Rule through BI Report in CloudContent Can we extract AP BPM Rule through BI Report in Cloud , or we have any other optionNidhi Chhajed 43 views 1 comment 1 point Most recent by Julien_Dubouis Reporting and Analytics for ERP
-
Subledger Distributions to General LedgerSummary Subledger Distributions to General LedgerContent All-> Need to show the amounts of Invoice distributions/Matched/not matched POs related to Payables payments/rec…
-
Monitoring approval errors in Financial CloudContent We are trying to create a BIP report that will be scheduled to run to collect all workflow instances that have erred while/during approval. This is required for …User_2025-02-05-11-44-44-738 37 views 2 comments 1 point Most recent by User_2025-02-05-11-44-44-738 Reporting and Analytics for ERP
-
Accounts Receivable Reconciliation ReportContent Hello, I am looking to build a reconciliation focusing on the Accounts receivable transactions, I want to show the number of Accounts Receivable transactions tha…Elliot Hall-Walker 43 views 3 comments 0 points Most recent by Elliot Hall-Walker Reporting and Analytics for ERP
-
Business Date calculation in BI PublisherSummary Business Date calculation in BI PublisherContent Hi, We have a requirement to populate settlement date in 'Disbursement Payment file' with following logic in BIP…User_2025-02-05-10-42-50-458 40 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP
-
Fetch Data from Last run dateSummary Only get updates and creates after the previous run of the reportContent This is something I know can be done in hcm extract but I would like to knoe if at all i…Prateek Parasar - GTUK, ACE Pro 466 views 5 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP -
Convert SYSDATE to Mon-YY format in oracleSummary Convert SYSDATE to Mon-YY format in oracleContent Hi , Can you please suggest how to convert SYSDATE to Mon-YY format. Version 19B
-
Who can edit the report?Summary Who can edit the report?Content Can any user edit the OTBI reports or is that something that only the owner of the reports (for example : FASETUP) can edit the r…Mukund Kudrimoti-144443 27 views 5 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP
-
Schedule and distribute a report to specific usersSummary Schedule and distribute a report to specific usersContent Hello Friends, I need to schedule and distribute a report to specific users. I clicked the "More" optio…Mukund Kudrimoti-144443 35 views 2 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
Process name not filled for bip job in 'scheduled processes'Summary Process name not filled for bip job report in 'scheduled processes'Content Hello, When we schedule bip report (manually or via web services), a process is execut…Médéric Chauvin 330 views 3 comments 3 points Most recent by Manish Pesswani Reporting and Analytics for ERP
-
Fusion table which store all Data Model SQL?Content Hi, Can anyone share Fusion table(s) which stores SQL's of all data models? Thanks, RinkuRinku Gautam 287 views 5 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP
-
How to generate and view the trace file for a BIP Report submitted thru ESS Job Scheduler.Summary How to generate and view the trace file for a BIP Report submitted thru ESS Job Scheduler.Content Can anyone guide us on how to generate and view the DB trace fi…Umamaheswara Reddy Karri 82 views 5 comments 2 points Most recent by Hannah Dorman Reporting and Analytics for ERP -
Non - standard SQL data model bind to different templatesSummary Non - standard SQL data model bind to different templatesContent Hi there I was wondering if it was possible to bind a non-standard SQL query parameter to a Repo…User_2025-02-05-10-38-08-223 24 views 3 comments 0 points Most recent by User_2025-02-05-10-38-08-223 Reporting and Analytics for ERP
-
Fusion Cloud AnalyticsSummary Fusion Cloud AnalyticsContent Hi -> Any one please let me know details about Oracle Cloud Analytics? Thanks,