EGL: The Delivered 'No SetID' Chartfield Views Are Not Effective Dated. (Doc ID 2062716.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9 and later
Information in this document applies to any platform.

Goal

The following views require re-code to add the 'EFFDT' & 'EFF_STATUS' fields to the record output.

GL_ACCT_NS_VW
OPER_UNIT_NS_VW
FUND_NS_VW
DEPT_NS_VW
CLASS_CF_NS_VW
PROGRAM_NS_VW
PRODUCT_NS_VW
PROJECT_NS_VW

Using the DEPT_NS_VW record as an example, the SQL behind the view as delivered, is this:
SELECT DISTINCT DEPTID, DESCR
FROM PS_DEPT_TBL

Where there is an effective-dated change in the description on the underlying PS_DEPT_TBL, the view will return two rows (but no effective date) for the same department.
The record also returns 'Inactive' values, but with no way to discern which are 'Active' and which are 'Incative'.

Essentially, without the 'EFFDT' & 'EFF_STATUS' the views are effectively useless in any circumstance, and can not be used. (A quick 'Find' of the objects in App Designer reveals that they are NOT used anywhere in the system, and were likely put in the system as a query reporting tool)

The resolution should look something like this:
SELECT DISTINCT DEPTID, EFFDT, EFF_STATUS, DESCR
FROM PS_DEPT_TBL

Can this be fixed?
 

Solution

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