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:

Symptoms

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'.

STEPS TO REPRODUCE

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

Changes

 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.

Cause

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