EEX9.2: SQL Error in Exec When Approving Time Adjustment with Personal Time (Doc ID 2305650.1)

Last updated on SEPTEMBER 11, 2017

Applies to:

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

Symptoms

Approver gets an error when trying to approve the Revised TimeSheet with personal / leave hours.

Steps:
---------
1) Create and submit a Time Report with Project and Personal Time.
2) Approve the Time Report.
3) Stage the time to Project Costing.
4) Create a revision of the time report.
5) Approver tries to approve the time revision / adjustment.


Error:
-------
SQL error. Function:  SQLExec
Error Position:  0
Return:  1400 - ORA-01400: cannot insert NULL into ("EMDBO"."PS_EX_TIME_POL"."APPROVER_OPRID")
Statement:  INSERT INTO PS_EX_TIME_POL (TIME_SHEET_ID, LINE_NBR, VERSION_NUM,
EX_LINE_STATUS, TRC, DESCR60, LASTUPDDTTM) VALUES(:1, :2, :3, :4, :5, :6, CAST(SYSTIMESTAMP AS TIMESTAMP))
Original Statement:  INSERT INTO PS_EX_TIME_POL (TIME_SHEET_ID, LINE_NBR,
VERSION_NUM, EX_LINE_STATUS, TRC, DESCR60, LASTUPDDTTM) VALUES(:1, :2, :3, :4, :5, :6, %CurrentDateTimeIn)

SQL error in Exec. (2,280) EX_TADJ_APPR.GBL.SavePreChange  PCPC:7391 Statement:76.

Please see replication steps document for more details.

Changes

 

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