While Doing Transact Move Order Transaction Error Encountered "JAI_INV_MMT_TRIGGER_PKG.ARI_T1 ORA-01400:cannot insert NULL into ("JA"."JAI_CMN_RG_I_TRXS"."FIN_YEAR")"

(Doc ID 2131416.1)

Last updated on SEPTEMBER 01, 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, Material Move Orders

When attempting to transact move order for one of the sales order lines (order number 112506065), the following error occurs.

ERROR
-----------------------
Transaction processor error
Ex.. in updateMMToracle.jdbc.driver.OracleSQLException:
ORA-20001:APP--20110:Encountered an error in
JAI_INV_MMT_TRIGGER_PKG.ARI_T1 ORA-01400:cannot insert NULL into ("JA"."JAI_CMN_RG_I_TRXS"."FIN_YEAR")
ORA-06512: at "APPS.APPS.APP_EXCEPTION",line 72
ORA-06512: at "APPS.JAI_INV_MMT_ARUID_T1",line 462
ORA-04088:error during execution of trigger
'APPS.JAI_INV_MMT_ARUID_T1'


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. User navigate to Inventory > Move Order > Transact Move Order
2. Query the move order linked to sales order
3. Click on Transact Move Order button, and the form raises the error.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the sales order cycle, ship the product to their client, and recognize the revenue and cost goods sold.

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