My Oracle Support Banner

API JL_BR_SPED_PUB Error Updating Invoice Status From SYNCHRO To ORACLE (Doc ID 2165082.1)

Last updated on MAY 20, 2024

Applies to:

Oracle Receivables - Version 12.1.3 and later
Oracle Financials for the Americas - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Receivables Globalizations

Error in updating invoice status from SYNCHRO to ORACLE

The below error occurs when SYNCHRO returns the invoice status to Oracle:

06 May 13:30:50 DEBUG ProcessRetornoDfe - [3.0.18] - "Status -> 3 ChaveAcesso -> 35160551979359000193550010000686261900600548 Protocolo -> " - [3.0.18]
06 May 13:30:50 ERROR ProcessRetornoDfe - Problema no acesso da API JL_BR_SPED_PUB.UPDATE_ATTRIBUTES da Oracle, processo não concluído null - null
java.sql.SQLException: ORA-20001: Oracle error -6550: ORA-06550: line 1, column 7:
PLS-00201: identifier 'FND_CTL.FND_SESS_CTL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
 has been detected in fnd_global.initialize[fnd_init_sql].
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_GLOBAL", line 280
ORA-06512: at "APPS.FND_GLOBAL", line 2507
ORA-06512: at "APPS.FND_GLOBAL", line 2652
ORA-06512: at "APPS.FND_GLOBAL", line 2804
ORA-06512: at "APPS.FND_GLOBAL", line 2742
ORA-06512: at line 1
  at oracle.jdbc.driver.DatabaseError.throwSqlException(

The issue has the following business impact:
Due to this issue, users cannot update status of invoice.




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

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