EAP: Performance issue with AP Operational Dashboard Job (AP_DB_JOB) abending at Step AP_DB_JOB.CONV_CUR.Step09 (Doc ID 2255881.1)

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.

Symptoms

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.

ERROR

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

STEPS
1.  Navigate to Accounts Payables >  Batch Processes > Vouchers >  AP Operational Dashboard Job
2.  Run AP_DB_JOB

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