BI Publisher
Discussion List
-
Dunnings - How to exclude the invoices which have not yet passed the due date from the dunning letteContent Hi, In Oracle Fusion - How to exclude the invoices which have not yet passed the due date from the dunning letters for a customer? Thanks, Kanika Version 21CKanika Mahajan 98 views 2 comments 0 points Most recent by Lavanyaa Damodaran Receivables & Collections -
What is the best way to prepare a consolidated Trial Balance of two business Units?Summary: What is the best way to prepare a consolidated Trial Balance of two business Units? Content (please ensure you mask any confidential information): There are man…Kirtee Jeetah-Naran 32 views 3 comments 0 points Most recent by Kirtee Jeetah-Naran Reporting and Analytics for ERP -
Need to allow holds resolution routing for system invoice Hold codeSummary Need to allow holds resolution routing for system invoice Hold codeContent Hi, For our user case, we need to allow holds resolution routing for system invoice Ho…Mohamed jouini 255 views 4 comments 1 point Most recent by AmitGoel Payables, Payments & Cash Management -
{ELE_NAME} in FND_MESSAGES_TLWe have a requirement to display Message Name and Message Text in Payroll Message Report. We are getting these values from FND_MESSAGES_TL table. Now our client wants th… -
BIP password change all extracts are failing - Need Solution or workaroundSummary: BIP reports password change all extracts are failing - Need Solution or workaround please Content (please ensure you mask any confidential information): Version…Ankusham Rakesh 21 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Oracle Fusion Payroll Balance QuerySummary:Performance Issue with my BI Publisher report Payroll Balance Query Content (required): My current payroll balance query is using pay_balance_view_pkg.get_balanc… -
Alert Composer for Oracle General Ledger and Fusion accounting HubSummary: We have implemented Fusion Accounting Hub in Oraclr fusion SaaS to intergrate our two EBS intances with different chart of accounts . We are looking for email a…Vipul_vipul 41 views 2 comments 0 points Most recent by Andreea Brem-Oracle Subledger Accounting & Accounting Hub -
Table that stores self-paced online reason codeSummary: Hello, I need the table that stores the self-paced online reason codes to be used in the report that I'm creating using BIP. What table should I use to get it? … -
Strange OTBI Error:[nQSError: 27046] Inaccessible columnSummary: Strange Behavior, getting the below error however respective Job Role/ Duty roles are assigned to the user but still users are getting the below error (Screensh… -
How to get approved by for Job Requisition ?Summary: I want a query to get approved by in transaction console for job requisitionMartin_Melek 1 view 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Eligibility tables for data modelSummary Eligibility tables for data modelContent I am having some difficulty creating a data model that i need for the report bursting. I want to create a report that wi…User_2025-01-22-19-28-29-985 97 views 6 comments 0 points Most recent by RJH.CC.gov.uk Reporting and Analytics for HCM -
How to go up from JELINE_ROW to CCID_S in my xml on my rtf templateSummary: Going up a level or two of my xml on my rtf template Content (please ensure you mask any confidential information): I have customised the Account Analysis rtf. … -
Staff and Student payments not picking custom seperate remittance adviceSummary: Staff and Student payments not picking custom seperate remittance advice Content (please ensure you mask any confidential information): A requirement exists for… -
Payment Approval Notification to include all related invoicesSummary: Is there a way for Payment Approval Notification to include all related invoices?Kaz 51 views 3 comments 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management -
How to add multiple IF function in the Field Browser using Microsoft Word - BI Publisher?In my RTF template, I'd like to put a message for employees who are not belong to a specific department: However, in our case, some employees under 'ABC Expert' departme… -
Can we able to send data from Oracle cloud to GCP directlyGot a requirment to send file from Oracle to GCP. Can we able to send the file directly? Need suggestions. Thanks, Keerthana.KeerthanaBaskaran 1 view 0 comments 0 points Started by KeerthanaBaskaran BI Publisher Learning Center -
Disbursement Separate Remittance Advice - Fusion - Print Delivery MethodHi All, There is a fusion standard program that triggers Disbursement Separate Remittance Advice Report, it is a standard report which does not have any Data Model assoc…Kunal Lalwani 171 views 2 comments 0 points Most recent by vardhmanjain Payables, Payments & Cash Management -
Table that stores BIP error detailsSummary: Which table stores BIP error details text? Content (required): We are trying to build a custom BIP report to summarize all BIP job errors into a notification em…Abhishek Potnuru 231 views 8 comments 1 point Most recent by Sneha Sao Reporting and Analytics for HCM -
Unable to fetch Resignation Transaction approval rules data in the reportWe have a requirement to fetch the approval rules data in the BI report. But we are not able to get the full approval flow from the tables.KeerthanaBaskaran 31 views 9 comments 0 points Most recent by KeerthanaBaskaran Reporting and Analytics for HCM -
Unable to Upload PGP key Post 24A UpgradeI'm Unable to Upload PGP key Post 24A Upgrade in BI Publisher using Administrator. It is giving 'Generating BI Publisher kaypair failed: reason = gpg --gen-key command f…SushantAnand 131 views 2 comments 0 points Most recent by SushantAnand Reporting and Analytics for HCM -
report to show timecards that aren't approved (when the last editor was not the worker him/herself)Summary: Just sharing BI SQL. We have a need to output instances onto a report to show which worker did not re-approve a timecard that was edited by a member of our time…Shant_Sarkissian_WJG 61 views 2 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
Learning AlertsContent Hello folks, Hope everyone is doing fine! We have requirements related to some Learning Alerts which we tried from Report Bursting but are not working as expecte… -
Privileges/Roles to access the Reports and Analytics Work areaSummary: Content (please ensure you mask any confidential information): Hi experts, I'm working with a custom job role that should be able to access the Reports and Anal…Elena_Panniello98 241 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM -
How to retrieve BAi2 bank statement files after processingSummary: Hi, I am looking for a way to download BAI2 files that are imported into Oracle Fusion as a way to create a back-up. Our current process is that Oracle Fusion i…Ramprakash09 241 views 3 comments 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management -
Candidate Risk of Loss and Candidate Impact of Loss field table namesContent HI All, We have a requirement to fetch the succession plan, Candidate Impact Loss and Candidate Risk of Loss details through BIP . I find the "HRM_PLANS " and "H… -
BI Publisher Bursting with Multiple Templates , Multiple Data setsSummary BI Publisher Bursting with Multiple Templates , Multiple Data setsContent Hi Friends We have a requirement where we need to burst BIP reports. Now i have 2 diffe…Mansur Khalil 332 views 4 comments 0 points Most recent by Alon Hadar Tamir Reporting and Analytics for HCM -
User-Defined tables name in Oracle HCM BISummary: Content (please ensure you mask any confidential information): Hello experts, do you know the BI table to extract user-defined tables? Thanks in advance for you…Valerio Curzi 21 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Extract completion percentage of a video/scormContent Hello, We want to extract the completion percentage of a video or a scorm. In particular, we want to extract the number of minutes for which a video/scorm is see…
-
table to get self service links for LMS courses in oracle hcmHi Team, We need a table name to get the LMS course and offering links in BI reports Thank you