R12: AP: ECC: ECC Payables Request Payables Command Center Data Load Goes Into Error Status: There is an error while committing dataset load detail audit request for dataset ap-trx (Doc ID 2802669.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

Symptoms

On : 12.2.10 version, ECC Payables

ECC Payables - Request - Payables Command Center Data Load goes into Completed-Error Status


ERROR
-----------------------

0:17:42.610 [pool-4-thread-1] ERROR 5.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is an error while committing dataset load detail audit request for dataset ap-trx and jobId 59,466 which finished with status trueorg.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLException: ORA-01653: unable to extend table ECC.ECC_AUDIT_LOAD_DETAILS by 128 in tablespace ECC_TSError Code: 1653Call: INSERT INTO ECC_AUDIT_LOAD_DETAILS (AUDIT_LOAD_DETAIL_ID, END_TIME, OPERATION, ROWS_FAILED, ROWS_PROCESSED, ROWS_SUCCEED, SQL_ID, SQL_QUERY, START_TIME, STATUS, STATUS_MESSAGE, TOTAL_SQL_TIME, AUDIT_LOAD_RULE_ID, AUDIT_DATASET_ID) VALUES



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Payables Responsibility > Run Payables Command Center Load

Changes

Cause

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