My Oracle Support Banner

The Information Is Not Inserted Automatically Into the table JL_BR_CUST_TRX_LINES_EXTS After Autoinvoice (Doc ID 2178198.1)

Last updated on MARCH 14, 2018

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.


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



To view full details, 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 a vibrant support community of peers and Oracle experts.