EAP: Application Engine VCHR_APRV_AF - Effective Dated Logic Issue In MAIN.Step03
(Doc ID 2347551.1)
Last updated on OCTOBER 01, 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!