R12: JE: (jezzraib) After Patch 11891772 No Default For Tax Invoice Date On Ar Additional Tax Det. Factors (2)
(Doc ID 1366054.1)
Last updated on FEBRUARY 03, 2019
Applies to:
Oracle Financials for EMEA - Version 12.1 to 12.1.3 [Release 12 to 12.1]Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |