1. HCM Data Loading Business Objects
  2. Example of Loading Object Groups

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.

  1. Using HCM Data Loader, load the details returned by the bank.

  2. Submit the Process Bank Corrections File flow to update his personal payment method.

As this image shows, load the details returned by the bank. Submit the Process Bank Corrections File flow to update the 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.

  1. 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||

  2. 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.

Related Topics