Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
HCM Extract
Discussion List
-
DataTerrain PreBuilt Report : Balance Adjustment ReportingSummary Balance Adjustment ReportingContent This is part of a series of sample PreBuilt reports created by DataTerrain. You can copy the setup for this report and add it… -
-
What UE is effective date for marital change, gender change, name change located?Summary: We are not able to find Effective Date for the fields: Marital Status, Gender, Name changes or salary changes. We're able to find the field for these, just not … -
control the FTP/NON FTP delivery option at run time in the seeded HCM ExtractSummary: we are usin the seeded extract and would like to control the FTP/NON FTP delivery option at run time, Kindly let us know how to achieve this?
-
PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE giving duplicate outputSummary: We have a requirement to fetch future, past dated current effective records. I am using the UE PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE As child and root is PER_EXT…
-
Multiple report cat isn’t possible from 24A in HCM Extract. How is dynamic delivery option achieved?We have a requirement to execute delivery option based on run time parameter. We had been achieving this using report category so far. As addition of report category is …
-
I want to generate CSV and deliver it to SFTP from HCM Extracts with Only the Attribute HeadersThere is an option HCM Extract WebCenter Content delivery option to print only Attribute Headers. We want the same kind of file delivered to SFTP. Is there any way to ac…
-
-
How to Revert back to Old Title in BPM notificationSummary: Content (required): Hi Team, We have modified the title in Resignation notification but we would like to revert back to old Oracle title. If i put back the same… -
Newly released data loader interface delivery option not workingSummary: Regarding the new release on HCM Data Loader for 24A, we tried to implement and followed the same steps as per the below Oracle Doc for the new delivery option …
-
Change Report for PayrollSummary: We are looking for a Report to show previous and current values for any change to Person Name, Address, Assignment, reason for change and who approved the chang…
-
How to include non workers into HCM ExtractSummary: Hello, we need to add non workers in HCM extract. I tried to add the following filters ((((asg.assignment_type IN ('N')) AND (asg.primary_assignment_flag='Y')) …
-
Add extract rule to new attribute extractSummary: How do i Add a Date attribute columm derived from Extract Rule Fast Formula in my HCM Extract How do i add the Date column to end of my Person record and also a… -
Extracting ORC Responsibilities and Qualification in Custom ExtractSummary: Extracting ORC Responsibilities and Qualification in Custom Extract Content (please ensure you mask any confidential information): Hi Team, Greetings! This ques…
-
where to see full sql hcm extracct?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Future dated person Contact HCM ExtractSummary: Hi, I have created an HCM Extract with root UE PER_EXT_SEC_PERSON_NOW_FUTURE_UE. Child UE is PER_PER_CONTACTS_UE and for phones this contact has a child UE PER_…
-
How to get EFF (Extensible Flexfield) or DFF (Descriptive Flexfield) from HCM ExtractSummary: Hi, My requirement is to get EFF and DFF value from HCM Extract. AS far as DFF is concerned, I am assuming that we can add attribute(the column where DFF value …
-
FND_TIMEZONES_PVT error in extractsSummary: FND_TIMEZONES_PVT error in extracts Content (please ensure you mask any confidential information): Hi Team, Greetings! We have got below error in 24A for the ex…
-
How to consolidate multiple extracts in a single extractSummary: Hi, I need to develop three separate HCM extracts. However, I would like to consolidate the data from all three extracts into a single XML file. Is there a meth…
-
Consolidate multiple extract in single extractSummary: I need to develop three separate HCM extracts. However, I would like to consolidate the data from all three extracts into a single XML file. Is there a method a…
-
How to compare dates using TRUNC in DISPLAY CONDITION in eText templatesSummary: How to compare dates using TRUNC in DISPLAY CONDITION in eText templates Content (please ensure you mask any confidential information): Currently we have a requ… -
Fusion HCM cloud data 'syndication' process / seeding data through different pagesHello, We have following requirement: seed/synchronize data from one Fusion HCM Cloud page to another Fusion HCM Cloud page. The advantage is that a syndication process …
-
HCM Extracts: How do I get the resulting SQL Statement of the extract?Summary: I want to get the SQL(s) my HCM Extract definition is using when it gets executed. Is there any logfile which traces SQL information? Content (please ensure you…
-
HCM Extract to compress multiple reports in a Single Zip FileSummary: I'm loading Job Requisition Template Description. For this I combined ClobFiles and JobRequisitionTempalte.dat into .zip file manually, i 'm able to load data ,…
-
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 … -
Data Group Filter Criteria for multiple assignmentsSummary: How to write Fast formula for data group filter criteria where I can select the Work relationship has multiple assignment or not. please help Content (required)…
-
Unable to fetch primary email address for the person in alert composerSummary: In Alert composer, we tried to sent a notification to the person on driver license expiry and trying to send to the person's primary email address, But not supp…
-
Create Row Number in HCM ExtractsSummary: I am using PAY_EXT_USER_TABLE_COLS_UE to join the PAY_EXT_USER_TABLE_ROWS_UE on col.row_number = row.display_sequence Is there a way to create this function in …
-
Sample delete in hcm extractSummary: Does anyone have a sample HCM Extract for delete. We need an HCM extract that can track deleted records using HCM extract. Sample extract will help. Content (pl…
-
24A HCM Extract Column OrderSummary: In 24A the Column Order for attributes is read only when trying to edit created items. How is it possible now for an existing list of attributes, to rearrange t…