BI Publisher
Discussion List
-
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 917 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 42 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 95 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 60 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 372 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.1K 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 56 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 40 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 23 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 50 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 395 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 73 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 56 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 50 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 274 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 53 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 24 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 135 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 74 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 691 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 25 views 3 comments 3 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP
-
Extract Cost Center from "Code Combination Description" field - (Procurement - Spend Real Time) subjSummary Extract Cost Center from "Code Combination Descpription" fieldContent I am using "Code Combination Description" field as one of my select columns from (Procureme…UjasB 234 views 5 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Best practice for Developing Custom BIP reports and securing them in ERPSummary Looking for best practices for custom BIP reports for ERP which can be secured by Role and Data Access Sets similar to UIContent Hi, Our client has complex enter…Subhash Valiveti 378 views 15 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP
-
Tables to query files imported to ERPSummary We want to create a report that list the files imported to the ERP from external systems for reconciliation purposes.Content Hello evryone, Anyone can hep me to …User_B9AX9 69 views 1 comment 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP
-
OTBI Report that shows the element details field "Description"Summary OTBI Report that shows the element details field "Description"Content I am trying to build a report where I can pull in the field 'Description' on an element. Fo…