My Oracle Support Banner

R12:XTR:XTRSTRMM: Program - Accounting Streamline Processing Completes In Error "Revaluation details for batch xxx do not exist" (Doc ID 2972606.1)

Last updated on NOVEMBER 01, 2023

Applies to:

Oracle Treasury - Version 12.0.1 to 12.2.12 [Release 12 to 12.2]
Information in this document applies to any platform.

Symptoms

When executing the concurrent Program - Accounting Streamline Processing, the following error is obtained:

Error in log file of concurrent program:
Revaluation details for batch 42xx24 do not exist.
Details are either not generated, incomplete, or not authorized.





 

FND Debug Log Messages

SQL_PLSQL_ERROR
"java.sql.SQLException: ORA-06550: línea 1, columna 56:
PLS-00302: el componente 'AUDIT_CLIENT_IP' se debe declarar
ORA-06550: línea 1, columna 45:
PL/SQL: Statement ignored
...
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
...
p_err_code ==> XTR_INCOMPLETE_REVAL
p_batch_id ==> 42xxx4
p_batch_BED ==>
Exiting CHK_ELIGIBLE_COMPANY - LOG_ERROR
sid:876983150: El lote 42xxx4 tiene detalles de revaluación incompletos.
...
sid:876983150: Cantidad de compañías ejecutadas: 0
sid:876983150: Cantidad de compañías no ejecutadas: 1
sid:876983150: Cantidad total de compañías procesadas: 1
sid:876983150:
STOP_DEBUG********
...



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
References


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