ETL9.2: AWE Payable Time Status Remains Pending For Approval After Request Batch Approval Process (Doc ID 1643087.1)

Last updated on APRIL 26, 2023

Applies to:

Symptoms

On : 9.2 version, Approvals

TL AWE Payable time status remains pending for approval after Request Batch Approval process

Ran Batch approval process from 11/1/2013 to 02/15/2014, TL_PAYABLE_TIME.PAYABLE_STATUS = ‘AP’. TL Workcenter Pending Payable time count remains the same even all payable time status are updated and no pending approval transactions.

When batch approval process is run payable time along with EOAW_stepinst and EOAW_USERINST rows should also be approved.


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

The issue can be reproduced at will with the following steps:
1)login as employee, the workgroup Is set for approval definition tlbysupervisorid, report time on the timesheet
2)Run TA
3)View payable time: payable status = NA
4)view the tl_app_pay_xref table the eoawthread_status = P
5) Use the tl approval batch process to approve employees time
6)Once the approval process is complete the payable status is changed to AP
7) But the tl_app_pay_xref table still shows the eoawthread_status = ?P? pending
8) Login as the supervisor id, the Pending approval count remains the same in tl work center even though the time has been approved by batch approval process.
9) The eoawstep_status = P where eoawthread_id used from the tl_app_pay_xref table.
10) Eoaw_userinst; the eoawstep_status is pending.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.