EAP: Performance issue with AP Operational Dashboard Job (AP_DB_JOB) abending at Step AP_DB_JOB.CONV_CUR.Step09
Last updated on JUNE 26, 2017
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On FSCM 9.2 Image 19, PT 8.55.10, AP_DB_JOB is failing with an error due to a performance issue at Step AP_DB_JOB.CONV_CUR.Step09.
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 12 Return: 30 036 - ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1' Failed SQL stmt: DELETE FROM PS_AP_DB_VND_TMP5 WHERE PROCESS_INSTANCE >= 0
7:56:32PM Process 1719232 ABENDED at Step AP_DB_JOB.CONV_CUR.Step09 (SQL) -- RC = 30036
7:56:32PM 1719232 AP_DB_JOB CONV_CUR Step09 SQL 30036
1. Navigate to Accounts Payables > Batch Processes > Vouchers > AP Operational Dashboard Job
2. Run AP_DB_JOB
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