J_Fact_PS_F_PYMNT_CHARGES Handling Of PS_ACAD_PROG (DRS_PS_ACAD_PROG_Lkp) May Need Review. (Doc ID 2003066.1)

Last updated on JUNE 09, 2017

Applies to:

PeopleSoft Enterprise EPM Campus Solutions Warehouse - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms


Issue / Errors

EPM 9.1: J_Fact_PS_F_PYMNT_CHARGES handling of PS_ACAD_PROG (DRS_PS_ACAD_PROG_Lkp) may need review.

Using J_Fact_PS_F_TERM_ENRLMT's DRS_PS_ACAD_PROG_PS_ACAD_PLAN_LKP as an example,
the select should use ACAD_CAREER, STDNT_CAR_NBR and DATA_ORIGIN <> 'D', we are missing some fields

Steps/Sequence of Events

1.Using J_Fact_PS_F_TERM_ENRLMT's DRS_PS_ACAD_PROG_PS_ACAD_PLAN_LKP as an example,
the select should use ACAD_CAREER, STDNT_CAR_NBR and DATA_ORIGIN <> 'D', we are missing some fields

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