My Oracle Support Banner

TL_RAPIDTIME Application Engine Process Fails with Error "ORA-01407: cannot update ("EMDBO"."PS_TL_MTCHD_16"."BUSINESS_UNIT") to NULL" at Step TL_ST_LIB.GA000_P.Step090 (SQL) (Doc ID 3018286.1)

Last updated on OCTOBER 02, 2024

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

TL_RAPIDTIME Application Engine process  is failing with the following error:

Process 507888 ABENDED at Step TL_ST_LIB.GA000_P.Step090 (SQL) -- RC = 1407

SQL error. Stmt #: 1851 Error Position: 26 Return: 14 07 - ORA-01407: cannot update ("EMDBO"."PS_TL_MTCHD_16"."BUSINESS_UNIT") to NULL Failed SQL stmt: UPDATE PS_TL_MTCHD_16 SET BUSINESS_UNIT = ( SELECT B.BUSINESS_UNIT FROM PS_JOB B WH ERE PS_TL_MTCHD_16.EMPLID = B.EMPLID AND PS_TL_MTCHD_16.EMPL_RCD = B.EMPL_RCD AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_JOB B1 WHERE B1.EMPLID = B.EMPLID AND B1.EMPL_RCD = B.EMPL_RCD AND B1.EFFDT < = PS_TL_MTCHD_16.DUR) AND B.EFFSEQ = ( SELECT MAX(B2.EFFSEQ) FROM PS_JOB B2 WHERE B2.EMPLID = B.EMPL ID AND B2.EMPL_RCD = B.EMPL_RCD AND B2.EFFDT = B.EFFDT) ) WHERE BUSINESS_UNIT = ' ' AND ACCT_CD <> ' ' AND EXISTS ( SELECT 'X' FROM PS_JOB J WHERE J.EFFDT <= PS_TL_MTCHD_16.DUR)


Steps to replicate the issue:

1. Navigate to Workforce Administration > Job Information > Job Data page and add a new "Hire" Action for an employee (e.g. Dec 8, 2023).

2. Navigate to Time and Labor > Report Time > Rapid Time page and add time for this employee with a Date greater than Hire date (e.g. Dec 11, 2023) . Add and Account Code to the Rapid Time but do not add a Business Unit value. Do not press Submit, just Save it. 

3. Go back to Job Data page in Correction mode and change the hire date (e.g. from Dec 8, 2023 to Dec 13, 2023). Save the modification.

4. Go back to Rapid Time page and press Submit for the data you entered earlier at step 2.

5. Click on Process Monitor link

Result: TL_RAPIDTIME ends in error with the above error message.

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.