The Information Is Not Inserted Automatically Into the table JL_BR_CUST_TRX_LINES_EXTS After Autoinvoice

(Doc ID 2178198.1)

Last updated on OCTOBER 10, 2017

Applies to:

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

Symptoms

You followed Doc ID 2087132.1 and performed setup suggested in this document and also applied patch 22448423:R12.JL.B mentioned
in the same document.
After running Autoinvoice Master Program you found that  the information is not being inserted  into the table  jl_br_cust_trx_lines_exts automatically
for the Transaction created.
The information is only loaded when you open Electronic Invoice Line Attributes form (JLBRREIL) after going to the Lines window and selecting one line.

Responsibility: Brazilian Receivables
Navigation: Transactions > Transactions
Steps:
1. Run Autoinvoice and create Transaction.
2. Run this select for the Transaction created:

select * jl_br_cust_trx_lines_exts
where Customer_Trx_Id=1185475;
No rows returned


3. Next Open Transactions for and find Transaction created.
2. Click Lines 
3. Select Line and open Electronic Invoice Lines Attributes form (path: Actions / Electronic Invoice Lines Attributes from the Menu).
    Select ICMS tab. Fields are populated.
4. Run the same select again:

select * jl_br_cust_trx_lines_exts
where Customer_Trx_Id=1185475;
1 row returned

 

Changes

 

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