BI Publisher
Discussion List
-
External Invoice Status for Project Expense in FusionContent I am looking to pull the External Invoice Status of project expense in Oracle Fusion for a BIP Report. There is a invoiced_flag and ic_invoiced_flag(Invoiced fla… -
Reporting for Multiple Asset BooksContent Assets partitions transaction data by asset book. This could be a challenge on complex implementations with multiple asset books sharing the same ledger. Oracle …Gergana Radoutcheva-Oracle 45 views 1 comment 5 points Most recent by Subramanyam Tumarada-Oracle Assets -
Approval Remarks for Completed Bank Reconciliation in Oracle Cash ManagementContent Hi I would just like to inquire if there is a way to mark the completed bank reconciliation in oracle cash management as "Approved"? because currently, what i ca…User_2025-02-11-12-30-38-982 46 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Payables, Payments & Cash Management -
Adding run_result_values for multiple element_names in OTBI analysisSummary Need help in OTBI analysis with adding the run_result_values for different element_namesContent Hello Everyone, I am new to OTBI analysis and I need help with co…GauravGupta39 25 views 3 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM -
How to display embedded dashboard only on a custom page categoryContent Hi Team, I have embedded a dashboard on homepage springboard. Now that dashboard is embedded to all tabs of the springboard. 1) Is there a way to embed it only t…Punam Roy Karmokar 26 views 1 comment 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
Payables Matching Hold Report is not picking any hold gains invoice not PO matchedSummary Payables Matching Hold Report is not picking any hold gains invoice not PO matchedContent do we have any hold report in AP module which will pull all invoices re…Sam Samaddar 70 views 2 comments 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management -
Need Help : 9 BOX Talent ReviewContent Hi Expets, I have been looking catlog or some kind of link form which we can build or design 9 BOX Talent Review. Tried in different sources and not able to find…Kiran Kancherla 37 views 5 comments 0 points Most recent by Aparna Damle Reporting and Analytics for HCM -
Post 21B release HRC_TXN_DATA.Data cache column doesn't show XMLSummary Approved/Rejected Global transfer transaction XML data is not coming up in HRC_TXN_DATA data cache column.Content Hi All, We are aware of HRC_TXN_DATA data cache…Hari Arumugam 39 views 1 comment 0 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
Briefing Books FunctionalitySummary Briefing Books FunctionalityContent Hi All, I would like to know the briefing books functionality, Please share the briefing book document or session video if an…[Deleted User] 40 views 2 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM -
Supplier Email on Print Remittance AdviceContent Hi, The Supplier Email is not showing up in the remittance advice, when printed but it does gets populated when Remittance advice is sent through email. We need …Kanika Mahajan 64 views 1 comment 2 points Most recent by Ruchika Gujral Payables, Payments & Cash Management -
SQL statements for DatastoresSummary What are the concrete SQL statements for an Datastore and what kind of joins are used for joining relevant database tables?Content Hello, we are looking for the …User_0HYL0 47 views 2 comments 5 points Most recent by Srinivas Malyala-Oracle Reporting & Analytics for Sales -
Procure to Pay dashboard not displaying invoice amount on Invoices tabContent We have just discovered the Procure to Pay dashboard and are very interested in the Invoices charts and metrics however every reference to a display which involv… -
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…Sam Samaddar 47 views 4 comments 1 point Most recent by Sam Samaddar Reporting and Analytics for ERP -
eText Template File for Journals Import InterfaceSummary Looking for an existing eText Template to use for importing journal entriesContent Has anyone created an eText Template for the Journal Import Interface that can…Meredith Bickell 33 views 5 comments 2 points Most recent by Meredith Bickell General Ledger & Intercompany -
Combine CSV Files to ZIP fileSummary Combine CSV output to ZIP fileContent We have requirement to combine the multiple CSV output files to single ZIP file and move it to UCM server. There were enhan… -
How to display data of a column horizontally in RTF?Content Hi all, I have a requirement where I need to display some data that comes from a column horizontally on RTF.Hereby, I'm attaching a screenshot of the RTF and wha…Sushan Peiris 379 views 7 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
DATA_CACHE column deprecation from HRC_TXN_DATA tableContent We are currently on Oracle HCM Cloud 20D. We have a scenario where we need your suggestion/feedback. Oracle is deprecating DATA_CAHE column from HRC_TXN_DATA tab…Abhishek_Jain 92 views 2 comments 2 points Most recent by Hari Arumugam Reporting and Analytics for HCM -
Mail Merge TemplateSummary Create a document that will populate certain fields directly into the documentContent Looking to create a document i.e. VOE that will grab and populate the data … -
Tables regarded to Manage Item Quantities page on Oracle Inventory ModuleContent Hello all, I need to know the tables which contain the data related to the Manage Item Quantities page on Oracle ERP. I need to capture some fields from the page…Sushan Peiris 337 views 5 comments 5 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Report Recipient's list ReportContent Hi All, Is there any way to get Report for all recipients list. Recipient Name Report Name Frequency abc Report1 Daily xyz Report 12 Monthly Thanks, VijayUser_2025-02-07-19-03-14-525 30 views 1 comment 0 points Most recent by Prudence K Reporting and Analytics for HCM -
Do we have any report to see configured Approval Rules?Content Hello, We need a list of all HCM related processes for which approvals are configured in system. Do we have any report or query through which it can be extracted…Devanshi Fulvani 28 views 2 comments 0 points Most recent by Devanshi Fulvani Reporting and Analytics for HCM -
How can I Remove Create/Catalog for some usersSummary How can I Remove Create/Catalog for some usersContent How can I Remove Create/Catalog for some users, because I need buttons enable specific usersMurilo Damasceno 44 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Passing comma seperated parameter values through SOAP requestSummary Passing comma seperated parameter values through SOAP requestContent I running a BI Publisher report through SOAP request. the BI Publisher data model contain th…Shlomo Elnekave 58 views 6 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP -
Need help with BI publisher reportSummary Need help with SQL for BI publisher ReportContent Hello, I have a BI publisher report that is run at the end of every pay period to provide payroll information o…GauravGupta39 51 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
How to schedule BI report only when it has dataContent Hi All, Can some please help me if its possible to schedule BI Report when there is data. I know we do it in OTBI in condition tab. Thanks, VijayUser_2025-02-07-19-03-14-525 37 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM