EGL: FAH PeopleSoft Integration Export Chartfield Process(CF_EXP) Does Not Export Projects With Same Begin and End Dates. (Doc ID 2003486.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

On : 9.2 version, Chartfields

Running the export chartfield process(CF_EXP) from PeopleSoft as part of the
standard  OOTB process for FAH - PSFT integration. Facing issue  in exporting
the project chartfields from PeopleSoft due to Start and end dates. The start
and end date for most of the projects n PeopleSoft are the same date and
hence the export  process fails to extract such records. There are 1126174
projects  but the program was only able to extract 66 projects.

Support Example of issue:

US004 Project 000000000000204  

Start Date                        End Date
26-JAN-15 00:00:00         26-JAN-15 00:00:00

Use As of date of 1/01/2015 on CF_EXP run control

Will not pickup project who START_DT and END_DT are both 1/26/2015
per trace:

-- 17:37:52.747 ......(CF_EXP_PRCS.Project.iTAO) (SQL)
INSERT INTO PS_CF_EXPV_TAO4 (SETID, CHARTFIELD, CHARTFIELD_VALUE, EFFDT,
BUSINESS_UNIT, EFFDT_FROM, EFFDT_TO, EFF_STATUS, DESCR, PROCESS_INSTANCE,
VALUE_SET_CODE, ACCOUNT_TYPE) SELECT A.SETID, 'PROJECT_ID', A.PROJECT_ID,
TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'), A.BUSINESS_UNIT,
A.START_DT, A.END_DT, A.EFF_STATUS, A.DESCR, 28778, ' ', ' ' FROM
PS_PROJECT_FS A WHERE A.SUMMARY_PRJ = 'N' AND (A.START_DT <=
TO_DATE('2014-01-01','YYYY-MM-DD') AND A.END_DT >=
TO_DATE('2014-01-01','YYYY-MM-DD')) AND A.BUSINESS_UNIT =  'US004'
/
-- Row(s) affected: 14

Run the process using As of date 1/26 that same project did get picked up.

Per trace:
-- 18:22:06.550 ......(CF_EXP_PRCS.Project.iTAO) (SQL)
INSERT INTO PS_CF_EXPV_TAO4 (SETID, CHARTFIELD, CHARTFIELD_VALUE, EFFDT,
BUSINESS_UNIT, EFFDT_FROM, EFFDT_TO, EFF_STATUS, DESCR, PROCESS_INSTANCE,
VALUE_SET_CODE, ACCOUNT_TYPE) SELECT A.SETID, 'PROJECT_ID', A.PROJECT_ID,
TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'), A.BUSINESS_UNIT,
A.START_DT, A.END_DT, A.EFF_STATUS, A.DESCR, 28786, ' ', ' ' FROM
PS_PROJECT_FS A WHERE A.SUMMARY_PRJ = 'N' AND (A.START_DT <=
TO_DATE('2015-01-26','YYYY-MM-DD') AND A.END_DT >=
TO_DATE('2015-01-26','YYYY-MM-DD')) AND A.BUSINESS_UNIT =  'US004'
/
-- Row(s) affected: 8

REPLICATION STEPS
=================
1. Navigation:
General Ledger->External System Integration-> Export Chartfields->Export
Chartfields
2. There are various project but include project_id in PS_PROJECT_FS
with same START_DT and END_DT, ex 1/26/2015.
3. Select as of date of 1/01/2015.
4. Run process and project will not get picked up.
5. Run another test but specify as of date as 1/26/2015.
6  Run process and project will then get picked up.
Should not have to specify the as of date same as START_DT to pick up various
project including ones with the same START_DT and END_DT.  Please see
attachments.

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