EEX 9.1+: Load Employee Bank Data (EX_EE_BNK_LD) Not Properly Updating PRENOTE_STATUS And PRENOTE_DATE Fields From Record PS_EX_EE_PYMNT_DTL (Doc ID 2133359.1)

Last updated on JUNE 07, 2016

Applies to:

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

Symptoms

ISSUE:

The Load Employee Bank Data Application Engine Program (EX_EE_BNK_LD) is not properly updating the Prenote Status (PS_EX_EE_PYMNT_DTL.PRENOTE_STATUS), and Prenote Date (PS_EX_EE_PYMNT_DTL.PRENOTE_DATE) Record Fields from the Employee Bank Account details information with the 'Confirmed' status, and Date value as it should.

When Employee Bank information is entered into HRMS systems, the initial data gets interfaced to FSCM databases with the delivered Service Operations DIRECT_DEPOSIT message populating Records PS_DIRECT_DEPSOIT, and PS_DIR_DEP_DISTRIB. Later on, any further updates will require the launch of DIRECT_DEPOSIT_FULLSYNC Service Operations messaging, as subsequent modification on existing data only triggers SQR Process DDP001, which does not call any integration.

Even after the fix from Defect # 11635038 (PRENOTE_STATUS Always Remains In New Status Due To EX_EE_BNK_LD) has been installed, a sub-scenario has been detected, where the problem seems to persist if the PS_DIR_DEP_DISTRIB.PRENOTE_DATE value changes from the initial load.

REPLICATION STEPS:

     - Make sure to enable the integration of Service Operations DIRECT_DEPOSIT_SYNC, and DIRECT_DEPOSIT_FULLSYNC between HRMS and FSCM systems
     - Log into the FSCM Online Application as User ID VP1
     - Navigate to: Set Up Financials/Supply Chain > Install > Installation options > Expenses
     - Make sure to set at the 'Payment Destination' section the option of Accounts Payable = Y
     - Run the below 2 SQL Insert Statements into the FSCM Database: (This will simulate a DIRECT_DEPOSIT_SYNC message)

          INSERT INTO PS_DIRECT_DEPOSIT VALUES ('KU0021',TO_DATE('28-DEC-15','DD-MON-RR'),'A','Y');
          INSERT INTO PS_DIR_DEP_DISTRIB VALUES ('KU0021',TO_DATE('28-DEC-15','DD-MON-RR'),'999','157135','C','296076123',' ',0,0,'N',TO_DATE('01-JAN-16','DD-MON-RR'),'Y','C','19-MAR-09','B');

     - Navigate to: Travel and Expenses > Manage Employee Information > Load Employee Data
     - Create a brand new Run Control ID, select the option of 'Load Employee Bank Data', and launch the process
     - Proceed to query PS_EX_EE_PYMNT_DTL for EMPLID = 'KU0021', and confirm that the new row has been added, with the below Field values:
     - PRENOTE_STATUS = 'N'
     - PRENOTE_DATE = '01-JAN-16'
     - Run the below SQL Update Statement into the FSCM Database: (This will simulate the DIRECT_DEPOSIT_FULLSYNC message, where the Bank Account details of the Employee have been confirmed)

          UPDATE PS_DIR_DEP_DISTRIB SET PRENOTE_STATUS = 'C', PRENOTE_DATE = TO_DATE('07-JAN-16','DD-MON-RR') WHERE EMPLID = 'KU0021';

     - Navigate to: Travel and Expenses > Manage Employee Information > Load Employee Data
     - Open the Run Control ID created before, make sure to have the option of 'Load Employee Bank Data' selected, and launch the process
     - Proceed to query PS_EX_EE_PYMNT_DTL for EMPLID = 'KU0021', and confirm that the existing row has not been updated properly on the below Field values:
     - PRENOTE_STATUS = 'N' (While it should be 'C' for Confirmed)
     - PRENOTE_DATE = '01-JAN-16' (While it should be '07-JAN-16' instead)

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

ACTUAL RESULT:

Because the Bank Account details Prenote Status is not updating properly in Record Field PS_EX_EE_PYMNT_DTL.PRENOTE_STATUS by the Load Employee Bank Data Application Engine Program (EX_EE_BNK_LD), electronic payments cannot be performed. Accounts Payable Pay Cycle does not pick up the Employee's Expenses for payment, as the Bank Details for a Direct Deposit are not yet confirmed.

EXPECTED BEHAVIOR:

The Load Employee Bank Data Application Engine Program (EX_EE_BNK_LD) should be setting PS_EX_EE_PYMNT_DTL.PRENOTE_STATUS = 'C', and PS_EX_EE_PYMNT_DTL.PRENOTE_DATE with the correct value when appropriate.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms