BI Publisher
Discussion List
-
Why is there no output from a scheduled OTBI report when the interactive version works fineSummary A report with csv output with parameters can be run interactively, but when scheduled no output can be found in scheduled processes, but available though e-mailC…Warren Murray 63 views 3 comments 2 points Most recent by Warren Murray Reporting and Analytics for ERP -
Subledger Period Close Exceptions Report query timeoutSummary SQL query time exceeds the limit (2400 sec). Stopped processing.Content Hi, just wondering if anyone has any experiences with the Subledger Period Close Exceptio…User_2025-02-10-13-18-56-927 35 views 0 comments 2 points Most recent by User_2025-02-10-13-18-56-927 Reporting and Analytics for ERP -
Report to find requisition approval reassignmentsContent Hi, We need to create a BI Report showing which requisitions were reassigned to other users. The FND_BPM_TASK_VL/HISTORY tables don't seem to have this informati…
-
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion …Patrick Chrabieh 232 views 2 comments 7 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
Query to fetch sum of debit memos and credit memos for an original invoiceSummary Am looking for a query to get sum of credit memos linked to original invoice ie Original invoice -HCS1 Credit memo-HCS2 as shown in below screenshots.Content I w…Sankeerthana Anumasula-Oracle 942 views 2 comments 1 point Most recent by Sankeerthana Anumasula-Oracle Reporting and Analytics for ERP
-
BI Publisher report should send email with Digital signatures in email body.Summary We have a business requirement to digitally sign the email while transmitting transaction prints to customers. Basically, the email body needs to have the digita…User_85V95 49 views 4 comments 2 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
BI REST APIsSummary BI REST APIsContent Hi All, Has anyone tried using the REST APIs to invoke a BI Report? I am having a hard time to get it working. If you have sample code and ca…Arun Raj 98 views 1 comment 0 points Most recent by Suresh Pallapothu Reporting and Analytics for ERP -
Missing account coding data for Invoices in Workflow tables in PRODContent Hello, We have a custom BI report that tracks the Account coding details for AP Invoices. We are using the workflow tables to get these details. Per my understan…Shruthi Ramesh 68 views 3 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Bursting A Report With SubTemplatesSummary How to burst a report using a sub template.Content Hi Experts, We have a custom report which uses a sub-template. The report also uses bursting to email. But the… -
ExternalReportWSSService sample payload to pass template nameSummary ExternalReportWSSService sample payload to pass template nameContent Hi, Can we pass report template name to ExternalReportWSSService SOAP service which triggers…Vinod Kumar Mohanraj 402 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP
-
Table to get BI Report Template and Data Model DetailsSummary Table to get BI Report Template and Data Model DetailsContent Hello, In EBS, we had XDO tables which stored BI Report and Data Definition details. Do we have any…Vinay Gharge 1.2K views 3 comments 2 points Most recent by SimonTomey Reporting and Analytics for ERP
-
How to use Flexfield feature at BIP data model?Content Hi, Are there any document about BIP data model flexfield feature? I hope the feature make me easy to query AFF info when I create custome BIP report. ThanksTsubasa Kokubu-Oracle 61 views 4 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for ERP
-
Change ESS Job Description while submitting it from BIPSummary Change ESS Job Description while submitting it from BIPContent In Cloud, we can submit the ESS Job from BIP using "ESS_RUNTIME.set_submit_args" procedure. Is the…Vinay Gharge 46 views 0 comments 1 point Most recent by Vinay Gharge Reporting and Analytics for ERP
-
tables that stores the submission of BI Publisher reports which are not scheduledSummary tables that stores the submission of BI Publisher reports which are not scheduledContent Hello, Are there any tables that stores the submission of BI Publisher r…
-
Geography Municipalities ExtractionContent Hello Guys, We need to create a report in order to extract Geography Municipalities data, where could we find this information? Best Regards, GiuseppeGiuseppe Iacono 27 views 0 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for ERP -
Inventory Reconciliation with GL - ReportContent All - I have a requirement to show the Inventory Reconciliation with GL and I see two OOB reports (Costing balances and Inventory Valuation) to satisfy the requi…Hari Thyagaraj 61 views 2 comments 0 points Most recent by Ahmed Eldemerdash Reporting and Analytics for ERP
-
Customize Print Receivables Transaction for all Invoice TypesSummary Customize Print Receivables Transaction for all Invoice TypesContent Hello, Oracle has provided 4 different templates for 4 Invoice Types: Invoice, Debit Memo, C…Vinay Gharge 451 views 1 comment 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Unsuccessful Login Audit Report & Sign-on Responsibilities Audit ReportSummary Oracle Fusion does have a seeded report/ Bi-report for audit purposes.Content Hi All, We would like to know if there is a fusion seeded report that can give belo…User_2025-02-07-22-21-23-100 74 views 2 comments 2 points Most recent by SimonTomey Reporting and Analytics for ERP
-
How to track the BI publisher report which calling the specific table and attributeContent Hi, How to track the BI publisher report that calling the specific table (eg.POZ_BUS_CLASSIFICATIONS) and attribute. Thanks, Felicia
-
Joining between database SQL and Excel Data Sources in the Data ModelContent Hi, I hope someone can help me out here. We have created a report where we have defined a data model with a join between an SQL data set and an Excel (xlsx) data…
-
Inventory Reconciliation ReportSummary Inventory Reconciliation to GL ReportContent Hello All - I have a requirement to create a sub-ledger report that shows inventory subledger detail and its reconci…Hari Thyagaraj 60 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
find field name behind oracle formSummary find the 'activity class' field in the the AR tablesContent Hello all, Can you please help me with something? I am trying to find out the table behind the Transa…User_2025-02-04-08-34-10-102 56 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
Accessing External DataSource via Fusion BIP reportsSummary We have a requirement to build a report the data of which will be in oracle cloud as well as in external database.Content Hi Guru's We have a requirement to buil…_IshanAgarwal 285 views 5 comments 0 points Most recent by Pradeep Rananaware-216731 Reporting and Analytics for ERP
-
BIP Report Error with XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid numberSummary As soon as report is submitted it throws XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid numberCode Snippet WITH tax_cal_datesAS (SELECT (SELE…
-
BI Report Bursting queryContent Hi All, We have requirement that notification should be sent to team member when they are added to project. Since we dont have this feature in oracle we were thi…Nidhi Chhajed 62 views 3 comments 1 point Most recent by Aaron Leggett Reporting and Analytics for ERP
-
Need query to get Punchout item detailsSummary Need query to get Punchout item detailsContent Hi Experts, We have a requirement to get punchout item details in existing PO PDF report, Can you please provide m…Pradvin Prabhakar 35 views 1 comment 2 points Most recent by Cezar - Fusion Oracle Support-Oracle Reporting and Analytics for ERP
-
Code migration tool -Automation of BIP report MigrationSummary Any code migration tool which can migrate BIP report from one instance to other automatically without manual interventionUser_8Y0M6 138 views 4 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for ERP
-
downloadESSJobExecutionDetails returns NULL when the ESS Job Output Size is more than 2GBSummary downloadESSJobExecutionDetails returns NULL when the ESS Job Output Size is more than 2GBContent Hi, We have an Integration built to send Oracle POET(Project,Org…Ragavendran kalatheeswaran 94 views 1 comment 5 points Most recent by Murthy Kodavati Reporting and Analytics for ERP
-
Unable to preview BI Publisher output in RTF:Summary Unable to preview BI Publisher output in RTF:Content Hi Guru, I am facing one strange issue in BIP Desktop , i am able to load and design the RTF but when i am t…Rohit Soni-259808 758 views 6 comments 3 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Infolet Dashboard to be Printed as a Page for Management ReportingSummary Infolet Dashboard to be Printed as a Page for Management ReportingContent We have built Risk Management Infolet section and Client wants to download this as a re…ArunMajumdar 28 views 3 comments 3 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP