EAP: Application Engine VCHR_APRV_AF - Effective Dated Logic Issue In MAIN.Step03

(Doc ID 2347551.1)

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.

Symptoms

Issue:

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.

Current code:
==============
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.

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