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

Last updated on JULY 12, 2017

Applies to:

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

Symptoms

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:


ERROR
-----------------------
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(DatabaseError.java:112)



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

Changes

 NA

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