ORA-01400: cannot insert NULL into ("JA"."JAI_AR_TRX_TAX_LINES"."TAX_LINE_NO") Error Appearing For Auto Invoice Import Program Of RMA Orders Consisting Of Kit Items (Doc ID 2172461.1)

Last updated on AUGUST 15, 2016

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, India AR Localizations

AR Auto Invoice Import Program is getting completed with the following error for RMA orders


ERROR
-----------------------

ORA-01400: cannot insert NULL into ("JA"."JAI_AR_TRX_TAX_LINES"."TAX_LINE_NO")



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create sales order for kit item with India Localization Taxes.
2. Book the Order.
3. Do Pick release and ship confirm. Do Autoinvoice import for the order.

1. Create RMA order with reference to that sales order.
2. Book the Order.
3. Receive the material and then try to do autoinvoice import for the RMA order.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create credit memo in AR.

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