BI Publisher
Discussion List
-
We need to see the detailed patch notes from the mandatory security patch that was applied on Sep 19We need to see the detailed patch notes from the mandatory security patch that was applied on Sep 19 We are having issues with the Cash Management report integration pos…Nida Syed 26 views 1 comment 0 points Most recent by Devesh Tyagi Payables, Payments & Cash Management -
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
What is the field name of checklist status?Summary: Content (please ensure you mask any confidential information): Unfortunately it is not per_allocated_checklists_vl.CHECKLIST_STATUS, any other idea? Version (in…Stefano_Mazzocca 32 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
BI Publisher Report - Disable Schedule Report option for ESS/Employee roleSummary Ways to disable Schedul Report option for the users with only ESS/EmployeeContent Hi, We have developed a custom BI Publisher Report, the access to which, will b…Kalyan Amaravathi 257 views 15 comments 0 points Most recent by Gopinadh Vipparla Reporting and Analytics for HCM
-
Need sql Query to fetch the Job Applicants in Draft StatusSummary: We have a Requirement to build a BIP Report for fetching the Job Applicants in Draft Status. Can anybody please share the sql query for this requirement. Conten…Milan_Mohanty 72 views 3 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM -
Query to get the scheduled work hours of employee from shifts the employee has assignedContent I have a requirement to report the weekly work hours the employee is scheduled for. Employee will be assigned work schedule and work schedule will be liked with …Raghavendra M 6K views 10 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM -
How to track email deliveries of Print Receivables ESS Job?Summary: We are trying to track the delivery of invoices to the customers which are sent via email but we are unable to get any delivery failure notification in case cus…
-
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP …Himanshu245 379 views 3 comments 1 point Most recent by Kalyani-Oracle Reporting and Analytics for ERP
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…Sanender SP 78 views 9 comments 0 points Most recent by Fiona Marran Reporting and Analytics for ERP
-
Auto-Populate Employee Information from HCM When Creating an Expense Report in Header SectorSummary: When an employee creates an expense report in Oracle Expenses, the employee's address information is not readily visible in the expense report header. This ofte…
-
Oracle HCM Reporting - Disable or Hide Parameter Based on Selection of Another ParameterSummary: We have two report parameters, Payroll Name and Consolidation Set, and need to make them mutually exclusive. When a value is selected for Payroll Name, the Cons…HariPrasad$24 69 views 6 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 33 views 9 comments 0 points Most recent by User_16WBA Reporting and Analytics for HCM
-
How to call ESS job by API erpintegrationsHi Experts, I 'm trying to execute ESS job "General Ledger Trial Balances Report" by API erpintegrations in postman. POST https://xx.fa.us2.oraclecloud.com:443/fscmRestA…Marcos Allonso-53979 87 views 4 comments 0 points Most recent by Tanya Matani General Ledger & Intercompany -
Show OTBI Graph with no values rather than No Results messageSummary: There are instances when the OTBI bar graphs result in no data results. Instead of showing a "No Results" message, is it possible to show the graph instead? We …
-
ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_detailsSummary: ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_details This is fusion HCM extarct BIP report related issue, Can anyone please h…User_2025-07-18-07-07-18-338 3.4K views 7 comments 0 points Most recent by Consultant Ian HCM Extract
-
what is column for Taxpayer Identification Number (TIN) for customers in OracleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is there a way to identify if the business unit name is hardcoded in extracts or reports in hcmWe renamed the Business unit and this will have an impact on the seeded/custom reports and extracts so we wanted to do a global search using the string/hardcoded value l…
-
Unable to find “Enterprise Scheduler Job Application Identity for HCM” user/Application RoleSummary: Unable to find or assign “Enterprise Scheduler Job Application Identity for HCM” user after recent Oracle release Content (please ensure you mask any confidenti…Phani Sajja 459 views 9 comments 1 point Most recent by Consultant Ian Reporting and Analytics for HCM -
Unable to get data in HCM Extract linked BI report after 21D updateSummary: I have created a dummy extract, and have linked a BI report to the Extract delivery option (as we need to use autoload parameter in HCM extracts, data is coming… -
Display a Document of Records Image in a BIP ReportHi all, My customer has a requirement where they need to see a report that includes a Document of Record image (passport photo) in a BIP RTF report. Has anyone managed t… -
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
What entitlement and roles do I need to be able to create and run query using sqls in BI report.Summary: What entitlement and roles do I need to be able to create and run query using sqls in BI report. I can access Person Management from the UI. But I want to creat…Sunny G 62 views 8 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
HCM Profile-> Set Preference-> LanguagesI want table to get data from Profile-> Set Preference-> Languages. and want joins to create relation between profile and language. profile-> Set Preference-> Languages …Rajdeep_Chavda 48 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Can we use SQL table field in alert composer templateSummary: Hello experts, How can we use SQL table field in alert composer template? we are using SQL in filtering condition to pull our population and want to use SENIORI…
-
Unable to show the image file from UCM server in BIP report in pdf output (in html its comming )Summary: We are storing signatures in Document of records and we need to pull these signatures in the report output which is in pdf format. Content (please ensure you ma…Velidi Supraja 583 views 6 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM
-
Issue with bursting queryHi, Facing some issue with custom email notification for overdue learning in the learning module. Have developed a SQL query with bursting but employees are receiving mu… -
Replicating a few dozen Fusion tables to ADB for heavy reporting: what worked and what brokeThere was an error rendering this rich post.ANTHONY DANSO-LARTEY 52 views 0 comments 0 points Started by ANTHONY DANSO-LARTEY Reporting and Analytics for ERP
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 99 views 12 comments 0 points Most recent by User_H0GYP Reporting and Analytics for HCM