BI Publisher
Discussion List
-
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 27 views 1 comment 0 points Most recent by Milton 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… -
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. 26 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 730 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… -
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 9 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 12 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 22 views 2 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
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 89 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 22 views 9 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
BI Publisher Server host and Port NumberSummary How to get BI Publisher Server host and Port NumberContent Hello Everyone, I'm unable to login to BI Publisher RTF template using following url. Does anyone know… -
Which table stores the Action Reason for salary?Summary: It doesn't seem the per_all_assignments_m but some other pay_* table, any idea? Content (please ensure you mask any confidential information): Version (include …Stefano_Mazzocca 13 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
customize a seeded dashboard with otbiSummary: I want to add three parameters in trial balance report which is a seeded dashboard I have customized it but not able to add the parameters that are cost center … -
How to Prevent Spacing between unmet conditions?Summary: I am currently in the process of consolidating multiple offer letters into a single document. Within this composite offer letter, I've included several sequenti…Emily Cox 11 views 4 comments 0 points Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM -
Numbering Adjustment in RTF TemplatesCustomer have multiple paragraphs in a report built using RTF template which are numbered and some of them have conditions so if the condition is met the paragraph is di…Sonal_Lalwani 41 views 4 comments 0 points Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM -
Unable to open the DM after UnachiveSummary: We successfully Unarchive Data model but unable to Open the Data Model Content (required): We Archive the Data Model from one instance and successfully Unarchiv…Visu 741 views 12 comments 0 points Most recent by SudiptaDey-Oracle Reporting and Analytics for HCM -
I want to check any report available which give the Org Chart data.Summary: We have requirement to fetch the Org Chart data from BI report. So is there any report available which give this data. Navigation : Me → Connection → Search Emp… -
Which table store the ESS Scheduled Process frequency, actual schedule start date and end dateSummary: We have requirement to get the ESS Scheduled Process frequency, actual schedule start date and end date details. I have validate the fusion_ora_ess.request_prop… -
DFF field should autopopulate based on the other field(actual field from UI)Summary: We have created a DFF field in Invoice header page under additional information tab. The business requirement is , we need to populate the list of values for th…Chandana Priya-Oracle 22 views 2 comments 0 points Most recent by AndresGlz2109 Payables, Payments & Cash Management -
Check Payment MICRSummary: Need a clear answer from Oracle regarding the support of MICR font for check print. Content (please ensure you mask any confidential information): from the note…DavidOliveiraPeloton 71 views 3 comments 0 points Most recent by DavidOliveiraPeloton Payables, Payments & Cash Management -
AP Check print squares instead of MICR Numbers at bottom of the CheckSummary: AP Check print squares instead of MICR Numbers at bottom of the Check BIP Report = Downloaded the Disbursement Payment File Formats Shared Folders > Financials …Vincent T 58 views 4 comments 0 points Most recent by User_JJ2YO Payables, Payments & Cash Management -
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp…MaheshRayudu7 68 views 2 comments 0 points Most recent by User_G9ACJ Reporting and Analytics for HCM