EAP: Application Engine VCHR_APRV_AF - Effective Dated Logic Issue In MAIN.Step03
Last updated on JANUARY 11, 2018
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Program: VCHR_APRV_AF (Application Engine)
The SQLEXEC statement in MAIN.Step03 that selects from PS_BUS_UNIT_OPT_AP does not contain effective dated logic. This caused us an issue as we have more than on record in the table for a specific SETID. In customer's case it pulled no value for AP_WF_RQSTR_OPTION because previously it was set to Pre-Approved. It appeared to pull the earliest value of the list that came back.
The PS_BUS_UNIT_OPT_AP is a effective dated record but the SQLEXEC statementin MAIN.Step03 that selects from PS_BUS_UNIT_OPT_AP does not contain effective dated logic.
SQLExec("Select AP_WF_RQSTR_OPTION FROM PS_BUS_UNIT_OPT_AP WHERE SETID = :1", &SETID, &AP_WF_RQSTR_OPTION);
This should have been effective dated.
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