BI Publisher
Discussion List
-
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… -
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"… -
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 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 … -
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…
-
DELETE Data into HCM Fusion using parameterized BI Publisher ReportSummary: We want to delete time cards via parameter through flow pattern. QUERY: SELECT HTRG.TM REC GRP ID TIMERECORDGROUPID, substr(replace (HTRG.START_TIME, '-','/'), … -
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… -
CANCELED_HIRE system person type not populated after cancellation of employee work relationshipSummary: CANCELED_HIRE system person type not populated after cancellation of employee work relationship Content (please ensure you mask any confidential information): W…
-
Does anyone knows how to query current task in Performance Document?Summary: I need the select statement to fetch this value Content (please ensure you mask any confidential information): I'm trying to write a query that selects this fie…Stefano_Mazzocca 174 views 4 comments 0 points Most recent by RahulMore Reporting and Analytics for HCM -
pay_range_items_f table VALUE1 is empty.Summary: The VALUE1 column for a calculation card element is coming out to be '-999999999' in this table even though the value exists in the front end. The same value is…
-
How to convert calculated fields into measures OTBISummary: We're using data from the Recruiting - Recruiting Real Time subject area. We need to create a performance tile to display Total Openings Left to Fill however th…Mark kristan De los Reyes 185 views 2 comments 0 points Most recent by Abhishek Bagh HCM Integrations -
how to group multiple datasets into single table in RTF template for HCM Global report extract?Hi I am trying to create RTF template from global report data model for HCM. there are 15 data sets into this data model. I need only 4 attributes from 2 data sets Basic…
-
Fusion Application BI Publisher - SSH Public Key authenticationSummary: How to setup FTP connection to a vendor, using SSH public key authentication? Content (please ensure you mask any confidential information): The FTP server setu…
-
OIC Integration call from HCM CloudSummary: Call OIC Integration form Oracle HCM Cloud Content (please ensure you mask any confidential information): We have created one lookback integration using OIC. In…
-
Unable to modify JobOfferLetterDM as it is giving the error ORA-01719.Summary: I would like to add the candidate's preferred language column in the OfferRecipient data set Cand.CAND_PREF_LANGUAGE_CODE but when saving the data model, it thr…
-
Extract FTP Shows succesful but file missing on serverSummary: Extract FTP Shows succesful but file missing on server Content (please ensure you mask any confidential information): Hi Team, Greetings! We have observed that … -
GET_VALUE_SET FF function is instableSummary: Hi Community, For some reason, GET_VALUE_SET FF Function is not returning date for all employees that it should, but interestingly though, it returns for some. … -
Uploading PGP keys in BI Administration failed with errorSummary: Uploading PGP keys in BI Administration failed with error 'Importing public key file .asc failed: reason=key file could not be imported: exit value=2' in 24D. I…Vidhya Nadarajan-Oracle 26 views 6 comments 0 points Most recent by Vidhya Nadarajan-Oracle HCM Extract
-
Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause.Summary: Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause. Content (please ensure you mask any confidential information): In the custom HCM Extrac…