My Oracle Support Banner

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 13, 2021

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.10 and later
Information in this document applies to any platform.

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

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
Changes
Cause
Solution


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