BI Publisher
Discussion List
-
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 … -
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 #… -
What is the efficient way to get balance value in BIP report?Summary: Currenly we are using below subqueries to get the balance values for any payroll_rel_action_id. But our report has many columns to get the balance value and it … -
The extract chunking task does not generate the default XML(at least parameter data) file.Hi Team, We observed that when there is no data to chunk, the extract chunking task completes successfully after 25C; however, it does not generate the default XML file …
-
Burst multiple data sets using ExcelSummary: Hi, I have a requirement to send excel file with 5 different tabs via bursting. Currently I have 5 data sets (all 5 have different columns). I am aware of the e…
-
HCM Extract for assignment changes only generating previous sequenced rowSummary: I've created a HCM Extract that pulls assignment details for employees, including past, present, and future assignments. The only filtering criterion I use is t…
-
How to add a data group as child of a record in a parent data group in HCM Extracts in 25BHi Experts, I need to add Emp_1_DG as a child of the Emp_DG. So I want to declare a record in Emp_DG and in that record, under "Next data Group", I want to refer the Emp… -
Payslip is not sending to FTP through Payslip ExtractHello Team, Greetings of the day!! In seeded Payslip Extract, we have an additional delivery option which will send the Payslip XML data to FTP and it is working fine ea…
-
how to merge data from 2 different data sets into Etext template in one line?Hello, I am creating a Etext template using seeded data model globalreportsdatamodel. I am adding fields from 2 different datasets so in the output it is not showing in …
-
User entity or data base item of learn moduleSummary: Hi all, I have a requirement to fetch course and it's assignee/learner data but unable to find any learn module user entity or database item. Can someone please…
-
Info required on Docusign IntegrationWe have a requirement to integrate with Docusign for some of the HR Processes. We understand that the DocuSign integration is available for Oracle recruiting cloud modul… -
what is the difference between SQL bind and Post SQL bind.Summary: Hi all, I have a requirement where I have to make a dependent parameter in HCM extract. I used refine extract and now need to decide what to use SQL bind or Pos… -
Loop back integration using HCM Extract Inbound InterfaceSummary: Loop back integration using HCM Extract Inbound Interface with HCM Data Loader - If the extract not return any rows on a particular run , it won't have any HDL …
-
HCM user entities to pull published schedule details for group of employeesWe are working on an integration where we need to extract published schedule details for a group of employees within a time period (past 3 months). We also need to track…
-
REST APIs for fusion user defined tables (UDT)Summary: Hi Experts Are there any REST API's to fetch the details from user defined tables created in Fusion (Oracle SaaS). Please let me know if you are aware pf the sa…
-
How to Add Representative information into ExtarctSummary: Hi Expert, I'm new in Oracle Extract, and I need your assistance regarding adding representative information to the worker extract file. I tried to search the u…
-
Inbound HCM Extract to compress multiple reports in a Single Zip FileSummary: Hi, We have a Inbound BI Report created. The Inbound Interface HCM Extract needs to run multiple reports and compress all those reports into single zip file and… -
Can Not Copy And Rename An Seeded HCM Extract such as "Payments"Summary: Hi All, When we are trying to copy the existing HCM Extract getting below error on the same instance. JBO-26041: Failed to post data to database during "Insert"…
-
User Entity to get deleted Absence Records - HCM ExtractHi, I have a requirement to extract deleted Absence Records using HCM Extract and send it third party payroll. Could someone suggest the appropriate User Entity?
-
HCM Position extract from EPBCS not generating records in HCM view extractWe have downloaded the HCM extract from EPBCS and uploaded the extracts to HCM. When we run data extract for Position in HCM, there is no data being generated in HCM. We…
-
How to zip multiple output files from HCM Extract and FTP to third partySummary: How to zip multiple output files from HCM Extract and FTP to third party Content (please ensure you mask any confidential information): We have a requirement to…
-
How to upload multiple documents to same DOR Type using HCM Extract Delivery optionSummary: I have a requirement to upload multiple documents to single DOR. Do we have any option to upload the multiple documents in single DOR record instead of creating…
-
HCM Extracts PGP Encryption converts file to ANSI FormatHi Experts, We have built an HCM extract with e-text template which generates CSV file. Without encryption turned on, the file format is UTF-8, but after PGP encryption …
-
Job History of BIP Reports/Flow History of HCM ExtractsSummary: Hi, We have a few questions on the Job History of BIP Reports/Flow History of HCM Extracts; as I could not find any document for this information: 1.) How many …User_2025-02-11-23-20-16-609 93 views 4 comments 0 points Most recent by Akash Katiyar-Oracle HCM Extract -
Query for Acknowledgement / Approve section for Overall Performance EvaluationHello! I would like to build a query which will receive the approval/acknowledgment of a specific section. Unfortunatelly in the ratings or section tables we cant corela…
-
change assignment numberSummary: Hi,is it possible to change assignment number via HDL? Content (please ensure you mask any confidential information): Version (include the version you are using… -
HCM EPBCS Metadata Extract Not Pulling All EmployeesHello, We are using the OOTB HCM Extract to EPBCS. We are having an issue where active employees are not coming through our Metadata extract, but do come through our Ass… -
how to restrict person details post Global transfer in extractWe have an HCM extract with PER_EXT_PAY_EMPLOYEE_UE. After a global transfer of any record, there may be changes in person address, SSN of a person. for example, US to C…
-
Change Only HCM extract for Recruiting/Job RequisitionSummary: Hi Team, We have a requirement to send the Job Requisitions changes using the HCM extract to the third Party system. Kindly share the code pack if anyone had co… -
Regarding Extract DBI of work-schedule asisgnment when assigned at Enterprise levelSummary: Hi Folks, When I assigned work schedule at assignment level then I got the value in HCM extract of WS and the Pattern as well but if i remove the assnment level…