BI Publisher
Discussion List
-
Multi Language in Single BI Publisher ReportHello Community, We are having a requirement to Generate Invoice Report such that for certain Provinces the report should show the invoice in two languages in single fil…Sreedhar Elagandula 25 views 2 comments 0 points Most recent by Sreedhar Elagandula Reporting and Analytics for ERP -
How to default Invoice Template on customer basis?Summary: Content (please ensure you mask any confidential information): We have a requirement where we want to have separate invoice template on the basis of Credit card…
-
CAMT053 Bank Statement Import is failing with ERROR [LINE_NUM_MISSING]Summary: All Bank Statements imported with CAMT053 format is failing to import with the error message below for each of the lines: [2025-07-15 14:19:59.048] ERROR [LINE_…PwC Team Member 57 views 2 comments 0 points Most recent by Pablo IH Payables, Payments & Cash Management
-
Impact and considerations when the period name of the accounting calendar includes special characterContent (please ensure you mask any confidential information): There is a requirement that you want to include the deadline in the period name. Example: 6 month deadline…Yuyeon KIM-Oracle 11 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany
-
Options to control and monitor the download of Custom BI ReportsHi, We have a custom BI Report containing multiple layouts The client has raised a request to understand anyone options on how to do the below Information on options: Te…Steven_Bullock 11 views 4 comments 0 points Most recent by Steven_Bullock Reporting and Analytics for HCM
-
Organization tree OTBISummary: We have an Organization Tree in Fusion HCM where: LE = Top Parent Node Division = Child Node under LE Departments = Child Nodes under that Division LE-->Divisio…charan_Gudla 52 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table to get Assignment change historySummary: Table to get Assignment change history Content (required): Hi All, We got a requirement to show the assignment changes (Like Transfer). From which tables we can…Venkatesan 1.9K views 12 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM Approvals report secured by locationSummary: I have a requirement to create a report or analysis of approvals and their statuses, but it must also consider the employee’s location. The report should only d…Ismael Jimenez 11 views 4 comments 0 points Most recent by Ismael Jimenez Reporting and Analytics for HCM -
OTBI Report with SQL query filterSummary: Hi Team, We have a custom reporting requirement that involves applying complex, SQL-based filters. We are planning to implement this logic within an OTBI report…
-
Volume of email notifications by typeSummary: I have a stakeholder who has requested the volume of emails by template sent by HCM to workers by Month. We have BI Burst, Alert Composer, and Seeded Notificati…SusanJ 11 views 2 comments 0 points Most recent by Andre Brown-Support-Oracle Reporting and Analytics for HCM
-
Custom Remittance Advice Template not appearing in Manage formatsSeparate Remittance advice do not have a data model. I have created a custom template that in BI publisher in custom folder custom>financials>payments, but my custom tem…KanikaGupta 181 views 2 comments 0 points Most recent by GIRIJA BODLA Payables, Payments & Cash Management
-
pasteItem2Summary: Which value of flagACL I should use to correspond to the ACL option 'Create'? Content (please ensure you mask any confidential information): Unarchive the BIP c…Gary Wan Guanghui 23 views 1 comment 0 points Most recent by Gary Wan Guanghui Reporting and Analytics for ERP
-
Number of workflow Notification Emails sent from HCMSummary: Looking for number of emails sent from HCM through workflow notifications by Module identifier. For Example - Number of emails triggered by personal information…vinay karumanchi 22 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
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 332 views 4 comments 0 points Most recent by GIRIJA BODLA Payables, Payments & Cash Management
-
sql query for description details in Manage description rules taskHi Team, Need the sql query for description details in Manage description rules task.Here we have attached the screenshot for your reference We are unable to find table …
-
PGP Encryption is producing a .tmp file at vendor's endWe are using the public key provided by the vendor to encrypt the file being sent to the SFTP using the HCM Extracts vis BIP delivery. When the vendor is decrypting the … -
Need to Extract Termination Transaction Approval DetailsSummary: Need to Extract Termination Transaction Approval Details Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to …Vasanthakumar Ravi 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to add Days to Worker Hire Date in HCM Alert TemplateDear Team, Need help in rectifying below expression. ${AlertUtils.addDays(workers.workRelationships.StartDate, 10)} I need this add 10 days to hire date of an employee t…
-
Sample Attendance ReportSummary: Sample Attendance Report with a placeholder to capture signatures Content (please ensure you mask any confidential information): Could someone please share an A… -
need to fetch the timestamp when Invoice status changes to Approved at summary levelSummary: for every invoice, when clicked on 'Validate' it will kick a process in the backend "Validate Invoices" which will change the status of Invoice to Validated nee…Anjali Sidharthan 11 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Unable to see data in xml_data_cache column of HRC_txn_data table.Summary Unable to see data in xml_data_cache column of HRC_txn_data table.Content Hi Team, As we know, Data_Cache column is deprecating from 21A and new column xml_data_… -
Filter PER_EXT_PAY_EMPLOYEES_V2_UE to get the assignments of employees with payroll results onlySummary: Our custom HCM Extract contains the following UEs (per hierarchy): 1. PAYROLL ACTIONS RANGE UE (Root Data Group) 2. PAYROLL REL ACTIONS RANGE UE (Connected to #…
-
how to fetch top 10 otbi reports that users access frequentlySummary: The request is to fetch the top 10 OTBI reports that users access frequently on their dashboard Content (please ensure you mask any confidential information): R…SivaNallagatla 41 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Join XCC_BALANCES with PO tablesContent Hi all, I need to retrieve the budget available amount (see screenshot below) I found the amounts in the table XCC_BALANCES. But I can't find a way to join it wi…
-
Oracle Fusion Applications HCM Learning Deprecated PVO'sHello Oracle Learning Community, As part of the Oracle Fusion Applications Cloud R13 update, we noticed that several HCM Learning Public View Objects (PVOs) used for dat…
-
Using Multiple SSL Certificates for Different PrintersDear All, I have multiple printers and multiple SSL certificates. I need to use a different SSL certificate for each printer. However, when I enter the Delivery configur…George Mattar 21 views 0 comments 0 points Started by George Mattar Payables, Payments & Cash Management
-
Tax Box Allocation Data Model - Sample XMLSummary: Are you able to share sample XML for the "Tax Box Allocation Data Model", in order to support template customization. As the main source table (JG_ZZ_VAT_TRX_GT… -
we don't have access to OTBI report subject areaSummary: We don't have access to otbi report subject role with custom role, we unable find the exact privilege was missing. kindly help us on this. Thank you.