My Oracle Support Banner

PROJ_ACT_STATUS Is Sent With Blank Content When The Project Is Created From a Template (Doc ID 2427350.1)

Last updated on FEBRUARY 06, 2019

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Time and Labor Integration

Issue with PROJ_ACT_STATUS message

When creating project using "copy from template" where template project has no Proj_act_status defined, system sends the dummy PROJ_ACT_STATUS message to HCM with AUDIT_ACTION populated. This is causing issue in HCM subscription code to error with message 'ORA-01400: cannot insert NULL into ("SYSADM"."PS_PROJ_ACT_STATUS"."EFFDT"). FIN should either not publish PROJ_ACT_STATUS or send with blank AUDIT_ACTION when template has no activity status defined.

ERROR
-----------------------
Fatal SQL Error occurred. (2,125)
FUNCLIB_EOEIP.SUBSCRIBE_MSG_PC.FieldFormula ame:Audit_Actn_Add PCPC6083 Statement 102 Called from: FUNCLIB_EOEIP.SUBSCRIBE_MSG_PC.FieldFormula Name: Process_Row_Action Statement:242 Called from......

ORA-01400:Cannot insert NULL Into(SYSADM.PS_PROJECT_ACT_STATUS.EFFDT...

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Configure the IB set up between FSCM and HR systems to include the integration of Project/Activity/Activity Status

Service Operations : PROJECT_SYNC, PROJ_ACTIVITY_SYNC, PROJ_ACTIVITY_STATUS_SYNC

2. Create a Template Project with an Activity. No Activity Status created
3. Create a project from this template.
4. Notice that PROJ_ACTIVITY_STATUS_SYNC is triggered. This is incorrect.
5. The message is created with blank content but with an AUDIT_ACTN of 'A'
6. When the message goes to HCM, it is throwing an error

Fatal SQL Error occurred. (2,125)
FUNCLIB_EOEIP.SUBSCRIBE_MSG_PC.FieldFormula ame:Audit_Actn_Add PCPC6083 Statement 102 Called from: FUNCLIB_EOEIP.SUBSCRIBE_MSG_PC.FieldFormula Name: Process_Row_Action Statement:242 Called from......

ORA-01400:Cannot insert NULL Into(SYSADM.PS_PROJECT_ACT_STATUS.EFFDT...


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.