My Oracle Support Banner

EEX 9.2: EX_EE_BNK_LD AE Program Is Defaulting Bank Account Country Code from GL Business Unit, Instead of HCM Payroll after DIRECT_DEPOSIT_SYNC Interface (Doc ID 2711662.1)

Last updated on SEPTEMBER 16, 2020

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


It has been detected that the Load Employee Data process (EX_EE_UPDATE AE Program), is updating new Employee Bank Account details from HRMS Payroll systems incorrectly. This is because delivered sub-program EX_EE_BNK_LD is defaulting as the Bank Account's Country Code from the Employee's Expenses Profile General Ledger Business Unit definition, instead of the one defined in HCM Payroll systems for Direct Deposit Requests.

If the Bank Account Country Code in HCM Payroll is different than the one defined for the General Ledger Business Unit set as default to the Employee in FSCM systems, the latter will always prevail, and as such, the Bank Account's Bank ID Qualifier also defaults incorrectly.

Looking at the Service Operations DIRECT_DEPOSIT_SYNC, HCM Payroll Bank Account details impact into FSCM Records PS_DIRECT_DEPOSIT, and PS_DIR_DEP_DISTRIB. Neither seem to have the COUNTRY_CODE Field in it.


    1.- Configure all needed set up for the Service Operations DIRECT_DEPOSIT_SYNC integration between HCM Payroll and FSCM systems
    2.- Confirm that in FSCM systems an existing Employee is linked to General Ledger Business Unit CAN01 (Canada) at the Expenses Profile level, but that the Address is set in Country Code USA (Say it is am Employee living in one Country, but working on another)
    3.- Log into the HCM Payroll system, and define a new Direct Deposit Request for the Employee at hand, with Bank Account details from Country Code USA
    4.- Confirm that the DIRECT_DEPOSIT_SYNC message has been successfully sent by HCM Payroll, and received by FSCM systems
    5.- Launch the Employee Data Load process, with the option of 'Load Employee Bank Data' selected
    6.- Check the Expenses Profile of the Employee at hand, under the Bank Accounts tab, confirm that the Bank Account's Country Code is CAN, and Bank ID Qualifier is 002 (Canadian Bank)

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

The Bank Account details of the Employee are pointing to the incorrect Country Code, and Bank ID Qualifier field values, and as such, the details are out of sync with those in HCM Payroll systems, and cause problems with the generation of payments through Pay Cycle.

The delivered Service Operations DIRECT_DEPOSIT_SYNC should include COUNTRY_CODE Field, and allow EX_EE_BNK_LD AE Program default the correct Country Code, and Bank ID Qualifier into the Expenses Profile Bank Account details.

NOTE: In the images/screenshots/examples mentioned and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.