EGL: The Delivered 'No SetID' Chartfield Views Are Not Effective Dated.
Last updated on SEPTEMBER 27, 2017
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9 and later
Information in this document applies to any platform.
The following views require re-code to add the 'EFFDT' & 'EFF_STATUS' fields to the record output.
Using the DEPT_NS_VW record as an example, the SQL behind the view as delivered, is this:
SELECT DISTINCT DEPTID, DESCR
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
Can this be fixed?
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