BI Publisher
Discussion List
-
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 21 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 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 …
-
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 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… -
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.
-
BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the YeaSummary BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the Year ParameterContent Hi, This is related to earlier post: https…User_MC37Q 1.1K views 5 comments 1 point Most recent by NIRMAL KUMAR L Reporting and Analytics for HCM -
Query Supplier Account Bank Information TableSummary: I Want to export all information about supplier account bank via BI Report Content (please ensure you mask any confidential information): Supplier on Procuremen…Muhammad Fahmi 142 views 3 comments 0 points Most recent by User_U58AH Payables, Payments & Cash Management
-
Report or SQL Query to Identify Unused Departments in Department TreeHi Team, We’re looking to generate a report that identifies unused departments within our department tree. Specifically, we’d like to find departments that: Have no asso…Mahendra Y 1 view 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Access to customize reports in Publisher greyed outHi all, Hoping someone could assist with an issue regarding access to customize reports in Publisher. The user has BI Author and BI Admin. The folder permissions for the…G. Class-Peters 21 views 0 comments 0 points Most recent by G. Class-Peters Reporting and Analytics for HCM -
NETWORKDAYS Logic In BI ReportHi , As a Business requirement we want to get the Working days between 2 days. I tried to get this using below query. But getting 0 as output. (select count(*) from tabl…GaneshSKulkarni 1 view 0 comments 0 points Most recent by GaneshSKulkarni Reporting and Analytics for HCM
-
Burst to multiple email addresses stored in a parameterSummary: Burst to multiple email addresses stored in a parameter Content (please ensure you mask any confidential information): I would like to have Bursting to multiple…
-
Reporting/Managing on Goal Plan EligibilitySummary Can goal plan eligibility be managed like Performance documents can?Content I've been searching the forums but haven't found a clear answer. I have a lot of ques…