My Oracle Support Banner

API JL_BR_SPED_PUB: Unable to Change Electronic Invoice Status from 'Contingency' to 'Finalized' (Doc ID 2915908.1)

Last updated on JANUARY 29, 2023

Applies to:

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


API JL_BR_SPED_PUB fails in updating the invoice status for certain situations when the Brazil Tax Authority - SEFAZ is out of service.

Example case: the status was set to '7' - 'Contingência' (Contingency) in a first moment while SEFAZ was out of service. When SEFAZ system gets back available, the status updates to '2' - Approved/Finished. But the table JL_BR_CUSTOMER_TRX_EXTS is not updated. 

The expectation is for the system to allow the change of status from '7' to '2'.



  1. Brazilian Receivables Electronic Invoices > trigger communication with partner software/tax authorities. API JL_BR_SPED_PUB is used in the process
  2. SEFAZ system gets out of service > the status is set to '7' - 'Contingência' (Contingency)
  3. SEFAZ system gets back available and the process continues, the status updates to '2' - Approved/Finished
  4. Check table JL_BR_CUSTOMER_TRX_EXTS > updating this one is skipped in the process



 Post upgrade from 11i to R12. Note the same issue may reproduce outside any upgrade context as the R12 code is not handling certain situations properly.


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.