Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now
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.

Creating a new record for Personal Payment Method using the same details as end dated record

in HCM Data Loader (HDL) 2 comments

Summary:

We have encountered the scenario where an employee has an end dated Bank Transfer Personal Payment Method having the following details:

End dated record details »
LegislativeDataGroupName: DUMMY
OrganizationPaymentMethodCode: BANK_TRANSFER
PersonalPaymentMethodCode: Employee Salary Account
AssignmentNumber: E00001
EffectiveStartDate: 2023/01/01
EffectiveEndDate: 2024/02/29
BankName: DUMMY BANK
BankBranchName: DUMMY BRANCH
BankAccountNumber: 0123456789

We tried to create a new Personal Payment Method having the same details just different effective start date, bank details, and NULL effective date. However, HDL is encountering error: "You've provided a date-effective row that ends on 12/31/12 12:00 AM for an existing record that already exists with an end date of 2/29/24 12:00 AM."

It seems that instead of creating a new record, HDL is trying to update the end dated record. Is there a way to bypass this and have the HDL create a new Personal Payment Method?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!