11i AR Tax Code, Tax rates to replace in R12 Receivable
Hello All,
Client has upgraded from 11.5.9 to R12.1.3.
In one of the custom receivables distribution report they are picking up Tax Code and Tax Rate from this view "ar_vat_tax_vl",
which is showing correct data for older receipts but for new receipts tax code and rates are not appearing.
As per R12 data model, we need to replace these tables with new tables.
Has anyone done this kind of retrofit, if yes, please send me the query or rdf for reference.
Below is one of the existing query:
---------------------------------------
SELECT rctl.customer_trx_id line_cust_trx_id,
Client has upgraded from 11.5.9 to R12.1.3.
In one of the custom receivables distribution report they are picking up Tax Code and Tax Rate from this view "ar_vat_tax_vl",
which is showing correct data for older receipts but for new receipts tax code and rates are not appearing.
As per R12 data model, we need to replace these tables with new tables.
Has anyone done this kind of retrofit, if yes, please send me the query or rdf for reference.
Below is one of the existing query:
---------------------------------------
SELECT rctl.customer_trx_id line_cust_trx_id,
0