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 laterOracle Financials for the Americas - 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
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 |