Category 203
Discussion List
-
Integration File updates 18 MB of data on regular basis that is unusually highSummary: Integration File updates 18 MB of data on regular basis after the scheduled Job 'Maintain Candidates and Job Requisitions for Search’ run is complete. This seem… -
Convert whole number to Decimal in fast formulaHi Team, We have a requirement to convert the number with two decimal positions. I am able to do with Round/Round_up function for decimal numbers. However, if it is a wh…
-
Extract output file name concat with the extract parametersSummary: Hi All, I am working on a HCM extract where requirement is to generate the output file name which contains the interface name concats with the parameter as ment… -
How to add threading database item to existing root data group?I have an extract with performance issue and the suggested resolution is to add a threading database item. Bit I could not find an edit button to modify the root data gr…
-
I want to create one UDT for range for handling below condition.When BIRTHDATE < '1946-01-01' THEN 'Traditionalist' • When BIRTHDATE between '1946-01-01' AND '1964-12-31' THEN 'Boomer' • When BIRTHDATE between '1965-01-01' AND '1980…
-
Retro employees missing in PAYROLL REL ACTIONS RANGE UEHi All, We would like to know if we have any UE as like PAYROLL REL ACTIONS RANGE UE and not having "pra.retro_component_id is null" in it. By using above UE we are miss…
-
Connect Oracle HCM to AlteryxSummary: Hope you are all well. Is there any way of connecting Oracle to Alteryx, has anyone done this before.
-
sql to get the HCM extract failure list for specific datesSummary: Need to create report which gives extract failure details. Code Snippet (add any code snippets that support your topic, if applicable): Im trying below sql to g…
-
Submitting Extract with Parameter Date for output file name not working as expected.Summary: Submitting Extract with Parameter + Date for output file name not working as expected. Please see attached for detail screenshots. It should have file name with…
-
HDL - Uploading Manager Details - Assignment as BlankHi, I'm try to do HDL update where Manager Details need to be blank as they sit on top of hierarchy. Together with WorkTerms and Assignment, I'm passing below [Assignmen… -
How to set {$SYSDATE()$} into Effective Date on Scheduled Extract ?Summary: How to set {$SYSDATE()$} into Effective Date on Scheduled Extract ? Content (please ensure you mask any confidential information): How to set {$SYSDATE()$} into… -
Delivered report to identify unpaid third party checksWe are looking for any delivered report to identify unpaid third party checks that requires us to run generate check payments. Run Third-Party Payment Register Report is… -
Is it possible to use HSDL to load or NULL a value in a field that has a LOVs?Summary: Is it possible to use HSDL to load or NULL a value in a field that has a LOVs? Version (include the version you are using, if applicable): 24ASarah Tobio 1 view 2 comments 0 points Most recent by Keerthi Masireddy-Support-Oracle ERP Integrations -
Address Fields Rest API MatchingDear ALL, I am trying to create an address of an employee using this rest api : /hcmRestApi/resources/11.13.18.05/workers/{workersUniqID}/child/addresses. Is there a met…George Mattar 11 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Integrations
-
Custom balance group showing data in application but not pulling in extract.Summary: We have used this dimension "Relationship Tax Unit, Reference Code Run " in LOAN 403B custom balance group. The underlying element feed is Loan 403B Results. Pl… -
TYPE field on HR_ALL_ORGANIZATION_UNITS_FSummary: There is a field called "TYPE" in the HR_ALL_ORGANIZATION_UNITS_F table. As per the table reference documentation… "This is a user defined type for differentiat…Kammasavala Ramadevi 62 views 1 comment 0 points Most recent by Keerthi Masireddy-Support-Oracle Human Capital Management
-
-
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…
-
How to configure employee notice period based on person typeSummary: We have requirement to configure notice period based on person type like Employee, Trainee, Contract Employee but currently oracle provide feature to configure …
-
W2 Box balances on Payroll ExtractSummary: We have a reporting requirement where we are fetching Payroll balances. The report also needs W2 Box balances on the report. After we add the W2 Box balances an…Vibha Pandey - Oracle 21 views 3 comments 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
Error while loading HDL for allocate checklistSummary: We are trying to load checklist task flexfield and getting error as "You must provide a valid reference to the parent record. Ensure that the parent record is s…
-
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 …
-
REST API authentication with OKTA SSOSummary: Is there any option to use OKTA authentication for REST APIs Content (please ensure you mask any confidential information): We use OKTA as the SSO identity prov…Muhammed_HCM 322 views 25 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security
-
Mohammed Raza 21 views 3 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
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…
-
-
-
Guardrail for dates to transactions to be back-datedSummary: Hello Experts, Got a requirement on Back dated transaction. any inputs on this are really appreciable. 1. Identify a guardrail for dates to transactions to be b…RamkumarKadhiravan 21 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Integrations