My Oracle Support Banner

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.

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

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
Symptoms
Cause
Solution
References


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