AutoInvoice (RAXTRX) Completes with Error - raaudn: Call To FND_SEQNUM.GET_SEQ_VAL Failed (Doc ID 1960661.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version,

AutoInvoice (RAXTRX) completes with error. 
When importing an invoice, and a credit memo applied to this invoice, in the same file you receive the following error:

raaudn: Call to FND_SEQNUM.GET_SEQ_VAL failed.

When invoices only are imported, it completes successfully.
When credit memos applied to existing invoices are imported separately, it completes successfully.

This error happens only when invoices AND credit memos are in the same file.

Changes

Applied Patch 14182626 and following prerequisite patches:
1. TAX patch 8452606
2. Inventory patch 8529225
3. AR Patch 8627857 and 8623783
4. JL patch 7585468

When trying to compile the package manually, following error messages occur:
Erreurs de compilation dans PACKAGE BODY APPS.JG_ZZ_AR_AUTO_INVOICE

Erreur : PLS-00201: identifier 'JE_COMMON_PKG.NULLIFY_GLOBALCOLUMNS' must be declared
Ligne : 296
Texte : JE_COMMON_PKG.nullify_globalcolumns(p_request_id); 

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