GST: Taxes From Receipts Are Not Flowing To AP Invoices

(Doc ID 2340120.1)

Last updated on DECEMBER 18, 2017

Applies to:

Oracle Financials for India - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On R12.1.3

Reported issue
-------------------
GST Taxes which are applied on Receipts are not flowing into The AP Invoices.

Expected Behavior
---------------------
GST Taxes which are applied on Receipts are expected to flow on the AP Invoices.


Error message
---------------------
( as observed from the fnd debug log )

JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.jai_insert_ap_inv_dist() ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."ASSETS_TRACKING_FLAG")
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log --1400: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."ASSETS_TRACKING_FLAG")
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.jai_populate_tax_dist_ap ORA-20001: --1400: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."ASSETS_TRACKING_FLAG")
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.jai_populate_tax_dist_ap jai_populate_tax_dist_ap----End----()+
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.jai_populate_tax_dist jai_populate_tax_dist----End----()+
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.populate_tax_lines populate_tax_lines return status:U,message:Unexpected error:ORA-20001: --1400: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."ASSETS_TRACKING_FLAG")
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.populate_tax_lines Unexpected error:ORA-20001: --1400: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."ASSETS_TRACKING_FLAG")
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.populate_tax_lines populate_tax_lines----End----()+
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.determine_tax populate_tax_lines return status:U
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.determine_tax Unexpected error:ORA-20001: --1400: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."ASSETS_TRACKING_FLAG")
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.determine_tax determine_tax----End----()+
JAI.PLSQL.JAI_AP_TAX_PROCESS_PKG..Populate_Stnd_Inv_Taxes jai_tax_determination_pkg.determine_tax return status->U message->Unexpected error:ORA-20001: --1400: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."ASSETS_TRACKING_FLAG")

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