BI Publisher
Discussion List
-
oracle.xdo.template.online.dms.common.XDODmsException: IO Exception was thrown! nullSummary: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.online.dms.common.XDODm…Malak 101 views 7 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…Manoharan 9.6K views 12 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Need query to get the list of all users for a given roleSummary: Need query to get the list of all users for a given role Could you pleaes provide me the query to get list of all users for a given role. attached the screen sh…User_7A1QO 979 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Alert Composer: Message text stored in which tableSummary: I want to get the message text of an alert composer. where it will be stored, Only message body was able to found-. which is in HTML format. most of the alerts …Merwin 56 views 2 comments 0 points Most recent by Jason Lobo Deloitte Reporting and Analytics for HCM -
Form Personalization Column HideWe have a form personalization requirement to hide the Distribution combination field if the Invoice type is 'Prepayment' from the AP invoice lines in create Invoice pag…Arkaprabha Pal 1 view 0 comments 0 points Most recent by Arkaprabha Pal Reporting and Analytics for ERP -
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…User_2025-01-28-19-14-07-225 587 views 19 comments 2 points Most recent by cylim Reporting and Analytics for ERP -
How to include fields in the bell/email notifications?Summary: In external learning requests, there is a field to include the course URL. I would like to include this field in the notifications that come to the bell/email: … -
Which privilege to access per_assignment_secured_list_vHello, I am struggling with the per_assignment_secured_list_v secured view in BI Publisher, as I can't seem to pinpoint the exact duty role that gives the "Report assign…Sara Suleiman 27 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to send the report "Budget Import Result Report" automatically?There was an error rendering this rich post. -
Request Documentation on Critical PVOs for Oracle Fusion HCM Integration with Data LakeDear Team, We have recently implemented Oracle Fusion HCM and are now working on integrating it with our Data Lake. To better understand the critical PVOs required for t…
-
Supplier Balance Aging Report oracle standard report customizationSummary: We are experiencing issues while exporting the report in excel format when there is huge volume of invoice data and output xml file size is exceeding 1gb. We ar…Swapnil_Mangnalikar 21 views 1 comment 0 points Most recent by Milton Payables, Payments & Cash Management -
Restrict Quick Payment and Allow only Manual PaymentIssue: There ate no apporvals for Payments created via create payments tab. So, Business wants to restrict the users only to make manual payments from Create Payments Ta…Jagjit Singh Arora 355 views 7 comments 0 points Most recent by inoappsms Payables, Payments & Cash Management -
Is there a lag period before OTBI displays new invoices/data?Summary: Hi everyone, I am running the Payable Withholding Tax report from Reports and Analytics. Navigation: Shared Folders/Financials/Payables/Income Tax and Withholdi… -
AI Agent Audit ReportSummary: Two different BI Publisher reports to track AI Agent usage by end-users and administrators. Summary Audit Report that audits a completed conversation from a pub…Race Schreimann-Oracle 104 views 3 comments 0 points Most recent by Race Schreimann-Oracle AI for Fusion Applications -
Looking for Primary flag for phone number in HCMIn HCM, I am trying to add a flag for "Primary" phone number in a BIP report. I didn't see the flag as a field in the per_phones table. Is there another table that I can…Rich R. 22 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
AR Invoice Email Delivery with AttachmentHi I am attempting to send an Accounts Receivable (AR) invoice with an attachment to a customer via email. I followed all the steps outlined in Document ID: KB92757, and… -
How to capture Tax Classification Code at Supplier Address level in OTBI report.Hello Experts, we want to capture the Tax Classification Code at Supplier Address level using an OTBI report. We are checking on Supplier Real Time subject area. Is ther… -
BFB XML - Data Mixing Across Different BillsSummary: Content (please ensure you mask any confidential information): We are observing inconsistent behavior in the Balance Forward Billing (BFB) XML output related to… -
HCM Extract Delivery via emailSummary Attempting to send a extract via BI report in emailContent We have an extract setup that uses Bi to deliver the data in a report. In the extract, we are able to …Rob Stahly 714 views 7 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
How to pull the course completion details and status that are assigned via specialization?Summary: How to pull the course completion details and status that are assigned via specialization. We wanted to populate course completion details, status and respectiv… -
Delivery of balance forward bills stops in Retry In Progress statusSummary: Delivery of balance forward bills stops in Retry In Progress status Content (please ensure you mask any confidential information): You're about to run create a … -
Need sql quest for auditNeed a sql query to develop AUDIT report to satisfy following columns DateUserUser IDImpersonatorImpersonator IDEvent TypeBusiness Object TypeDescription in fusion cloud…User_CNE9Q 2 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Issue With Notification Templates - Logo Breaks Approve, Reject, and Request Info ButtonsSummary: Editing the Logo in the Workflow Notification Subtemplate referenced in other notification reports e.g. Journal Approval Notification Report causes the approve/…Matthew - Town of Aurora 13 views 2 comments 0 points Most recent by Matthew - Town of Aurora Reporting and Analytics for ERP -
BI Publisher eText (Fixed Position) Number formatting issue.Summary: Hi everyone, I’m working on a BI Publisher eText template (fixed-position layout). I have a column that must display an amount as a 13‑character, left‑padded nu…Raghavendra M 25 views 2 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Accrual Plan Balance value for the future dateSummary: We are trying to fetch the accrual Plan Balance value for the future date records. Content (please ensure you mask any confidential information): As of now, we … -
EBSR12 : Purchasing columns mapping issueSummary: Trying to map EBSR12 Purchase tables »Fusion Cloud (PO/POR) EBSR12 EBSR12-Column Name po_cwk_associations status po_headers_all closed_code org_id po_line_locat… -
R12Table/HCM/FND & AP Approvals mapping issueSummary: How it is mapped on oracle fusion Cloud R12Table/HCM/FND : wf_item_activity_statuses Columns: CTIVITY_STATUS ASSIGNED_USER BEGIN_DATE END_DATE & R12TABLE: AP_in… -
Employment contracts - Audit missing action code fieldSummary: Hi experts, we are trying to add the field "Action code" as selected attribute in the audit for the Worker Employment Contract business object but it seems it i…Oliviero Riva 11 views 0 comments 0 points Most recent by Oliviero Riva Reporting and Analytics for HCM -
Can we restrict jobs based upon roles?Summary: Hi Team, We are looking for a possible solution which might help us to satisfy the below requirement Step 1: A Custom roles to be created and assigned to a user…Dileep Varanasi 71 views 4 comments 0 points Most recent by Aniket S C Reporting and Analytics for ERP -
Old value of Seniority Date doesn't appear in the report.Summary: Hi, We are building a BI Publisher report to track changes in different attributes in the system alongside Seniority Dates. So while we perform changes in that …Smaragda.gg 21 views 9 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM