Example of Loading Object Groups
Rahul has an invalid branch number due to the closure of the bank.
And you want to update his bank account details. In this case, you don't end date the personal payment method, but update the existing personal payment method with the correct bank details.
To update Rahul's branch number, you do these tasks as shown in the figure.
-
Using HCM Data Loader, load the details returned by the bank.
-
Submit the Process Bank Corrections File flow to update his personal payment method.
Load the Bank Account Details
The bank returns a file containing details of the payments that are rejected. To process this bank information, use these .dat files.
-
ObjectGroup.dat file to create the object group.
METADATA|ObjectGroup|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|ObjectGroupCode|ObjectGroupName|ObjectGroupTypeCode|Description|StartDate|EndDate|FormulaName MERGE|ObjectGroup|VISION|PPM_E8185311|US LDG|PPM_E8185311|PPM Update for 8185311|PROCINFO|PPM update for employee 8185311|2019/10/01||
-
ObjectGroupStore.dat file to load the bank information returned by the bank
METADATA|ObjectGroupStore|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|ObjectGroupId(SourceSystemId)|SequenceNumber|FLEX:PAY_OBJECT_GROUP_STORE_DDF|amount(PAY_OBJECT_GROUP_STORE_DDF=ORA_PAY_BANK_CORRECTION)|assignmentNumber(PAY_OBJECT_GROUP_STORE_DDF=ORA_PAY_BANK_CORRECTION)|checkNumber(PAY_OBJECT_GROUP_STORE_DDF=ORA_PAY_BANK_CORRECTION)|makeExternalPayment(PAY_OBJECT_GROUP_STORE_DDF=ORA_PAY_BANK_CORRECTION)|paymentDate(PAY_OBJECT_GROUP_STORE_DDF=ORA_PAY_BANK_CORRECTION)|paymentReference(PAY_OBJECT_GROUP_STORE_DDF=ORA_PAY_BANK_CORRECTION)|processDate(PAY_OBJECT_GROUP_STORE_DDF=ORA_PAY_BANK_CORRECTION)|replacementAccountType(PAY_OBJECT_GROUP_STORE_DDF=ORA_PAY_BANK_CORRECTION)|replacementBranchNumber(PAY_OBJECT_GROUP_STORE_DDF=ORA_PAY_BANK_CORRECTION)|returnreasoncode(PAY_OBJECT_GROUP_STORE_DDF=ORA_PAY_BANK_CORRECTION)|employeeName(PAY_OBJECT_GROUP_STORE_DDF=ORA_PAY_BANK_CORRECTION)|replacementAccountNumber(PAY_OBJECT_GROUP_STORE_DDF=ORA_PAY_BANK_CORRECTION) MERGE|ObjectGroupStore|VISION|E8185311_BANK_CORRECTION|US LDG|PPM_E8185311|1|ORA_PAY_BANK_CORRECTION|5000|E8185311|222324|YES|2019/10/31 00:00:00|185805|2019/10/31 00:00:00|Checking|004|AccountType Chg|Rahul|00456754231
Submit the Process Bank Corrections File
On the Home page, click the Submit a Flow quick action under the My Client Groups tab. On the Flow Submission page, submit the Process Bank Corrections File flow. When you load the ObjectGroupStore.dat file into the Oracle Web Center Content server, a UCM ID is generated. The Process Bank Corrections File flow uses the UCM ID to retrieve and use the bank information necessary for the flow. The flow updates the Personal Payment Method with the new branch number details.