My Oracle Support Banner

ETL9.2: Batch Approval Process TL_APPRV_AE Receives Error (18081,1041) (Doc ID 2410325.1)

Last updated on JUNE 30, 2020

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

Batch Approval process TL_APPRV_AE receives error at step TL_APPRV_AE.GA000.GBL.default.1900-01-01.Step010. This occurs while managers are manually approving time while the process is running.

ERROR
-----------------------
[Process: 'TLPayableTime']: there is no transaction record at level -1 for this approval process. (18081,1041) EOAW_CORE.DEFN.AWTxn.OnExecute Name:GetRecAtLevel PCPC:1500 Statement:29
Called from:EOAW_CORE.ENGINE.AppInst.OnExecute Name:ApproveByRowSet Statement:523
Called from:EOAW_CORE.ApprovalManager.OnExecute Name:DoApproveRowSet Statement:94
Called from:HMAF_AWE.WRAPPERS.ApprovalManager.OnExecute Name:DoApproveRowSet Statement:41
Called from:TL_APPRV_AE.GA000.GBL.default.1900-01-01.Step010.



The issue can be reproduced at will with the following steps:

  1. Enter reported time on a period (for example, 11/20/2017 - 11/24/2017) for a group of  people 
  2. Pick one of the employees as the scenario for manual approval. 
  3. Login as the employee's supervisor, access the MSS approve payable time page. Pull out the employee's  payable time. 
  4. Use a different browser (or different machine), log in as a batch ID to submit batch approval  process TL_APPRV_AE (go -> Time and Labor * Approve Time * Request Batch Approval  Process). Make sure the group ID is entered and From/End Date are entered. 
  5. Use SQL developer to query Payable Time table. select * from PS_TL_PAYABLE_TIME  where emplid = 'KUTLWC07' and dur between 20-NOV-2017 and 25-NOV-2017; 
  6. Once the payable time has AP status, approve the employees's payable time on MSS (see step (3)). 
  7. Run SQL to verify the employee's AWE having AP (approved) status. Select * from PS_TL_APP_PAY_XRF  where emplid = 'XXXXX' and dur between 20-NOV-2017 and 25-NOV-2017; 
  8. If the timing matches up right TL_APPRV_AE would abend. 



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.