BI Publisher
Discussion List
-
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 695 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 1 view 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 11 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 -
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 14 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 75 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 -
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 14 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
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 13 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 721 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 21 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 58 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 53 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 57 views 2 comments 0 points Most recent by User_G9ACJ Reporting and Analytics for HCM -
Need to find a Learning OTBI subject Area for Audience Occurrence ColumnSummary: Hi Team, I need the assistance to get the "audience occurrence" column in Learning OTBI subject Area. we have tried the below subject areas but we are unable to… -
The Payee Email Address is always appearing as blank in the OTBI report for onetime PaymentOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): We would like…NarasimhaPalla 2 views 0 comments 1 point Most recent by NarasimhaPalla Payables, Payments & Cash Management -
BI Publisher Report - Prompt IssueSummary The drop down list for selecting criteria will not wipe cleanContent Hi, Everytime someone opens this report the Business Unit, Package Type, Legal Entity and Lo…User_2025-02-05-22-44-35-842 29 views 7 comments 0 points Most recent by Stacey Williams Reporting and Analytics for HCM -
There is a image placed in Custom/Image folder. How to access this image in the BI report template?Unable to access images from Custom folder in BI report template. We have placed the test image in Custom/Image folder and tried to access this image in the template but… -
From which tables can I get the Workflow details of transactions archived in transaction console.Summary: Tables to get the Workflow task details of transactions archived in the transaction console. Content (please ensure you mask any confidential information): Vers…JSAHOO1988 22 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…MikeW 1.6K views 12 comments 0 points Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM