Last updated on JANUARY 26, 2017

Applies to:

Symptoms

Applied <patch 11891772> to have the tax invoice date populated with the gl_date for transaction imported from OM. In this bug the following fix was done by JE team:

As part of Auto invoice, AR calls a code hook in jg_zz_auto_invoice.
In jg_zz_auto_invoice, calling je_zz_auto_invoice.
If the coutry is 'Poland','Checz Republic','Hungary' or
'slovakia' then updating tax_invoice_date of zx_lines_det_factors to GL Date of that transaction.

the insert done is the following:

arp_standard.debug('JG Updating Tax Invoice Date ');

BEGIN

update zx_lines_det_factors zxld
set zxld.tax_invoice_date = (select trxd.gl_date
from ra_cust_trx_line_gl_dist_all trxd
where trxd.request_id=p_request_id
and trxd.org_id= l_org_id
and trxd.customer_trx_id=zxld.trx_id
and trxd.customer_trx_line_id = zxld.trx_line_id
and zxld.application_id=222
and zxld.tax_invoice_date is null
and rownum=1)
Where exists (select 1
from ra_cust_trx_line_gl_dist_all trxd1
where trxd1.request_id=p_request_id
and trxd1.org_id= l_org_id
and trxd1.customer_trx_id=zxld.trx_id
and trxd1.customer_trx_line_id = zxld.trx_line_id
and zxld.application_id=222
and zxld.tax_invoice_date is null
and rownum=1);


As you can check for the fnd debug file (20110630_Select_JG.xlsx) the call is done: ar.plsql.jg_zz_auto_invoice.validate_gdff 1 JG Updating Tax Invoice Date

but in ra_cust_trx_line_gl_dist_all  the gl_date is not populated for all lines

If the GL_DATE is not populated the tax_invoice_date will be not filled in zx_lines_det_factors

Changes

Cause