BI Publisher
Discussion List
-
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 49 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 396 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 273 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 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 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 684 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 232 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 376 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…
-
Project Invoice DistributionSummary Project Invoice DistributionContent Hello All, I want to know from which table we can get below information:-Lucky Sharma 61 views 3 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
SOAP request for BI Publisher report works for Test pod but not for Production podSummary SOAP request for BI Publisher report works for Test pod but not for Production podContent I am running BIP report by using SOAP request. the problem is that it w…Shlomo Elnekave 30 views 2 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP -
Need number of asset transfers and modifications in 2020Content Hi, I need to find the total number of asset transfers and modifications made in 2020. Is there a BIP query that can return this information please? regards Nige… -
Depreciation reserve of assetContent We're building a Fixed Asset Balances report out of Subject area Fixed Asset Balances - Real Time'. But we are not able to get the balances for Accumulated Depre…JL-JL 65 views 1 comment 0 points Most recent by Greg Jonovich-Oracle Reporting and Analytics for ERP
-
ESS Schedule Process Job Name not availableSummary ESS Schedule Process Job/Program Name not able find any tableContent Hi All, We need to build a BIP Report for audit purpose with all ESS job details but unfortu… -
BIP Deeplink in report to view Purchase OrderContent Has anyone added a deeplink in a BIP report to view a PO? Please could you share.User_2025-02-05-23-02-10-916 65 views 3 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP
-
Schedule Job Manager in OTBI to export the report output to Object Storage (OCI)Content Is there a way to export an OTBI BI publisher report to object storage (OCI) as part of a Job Manager scheduled job?