BI Publisher
Discussion List
-
Unable to fetch Enrollment Action time, Disclaimer status and Assigned date in a BI report.We need to retrieve the Action Time, Disclaimer Status, and Assigned Date fields from benefit enrollment records for a BI report. However, these columns do not appear to… -
How to default standard bip report output to excel?Summary: How to default standard bip report output to excel? Content (required): How to default standard bip report output to excel? Version (include the version you are…
-
Impact on BIP Schedule if Only Data Model is ChangedSummary: I’m planning to make changes to the data model of a BIP report. I want to confirm whether modifying only the data model will have any impact on the current repo…KHALED IHADDADENE 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
sql query to get course titleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How can we convert CLOB datatype to string in OTBI Reports?Hello, We are trying to remove HTML tags from a CLOB datatype column in OTBI report by using Substring and Replace function in the analysis. This is resulting us to get …Vaishnavi Katiyar 55 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 44 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 55 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 12 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 112 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 2K 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 236 views 2 comments 0 points Most recent by GIRIJA BODLA Payables, Payments & Cash Management
-
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 21 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
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 …
-
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 34 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_… -
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 23 views 0 comments 0 points Most recent 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…