My Oracle Support Banner

Unable Change The Osp Batch Status From Wip To Complete due to error (Doc ID 728816.1)

Last updated on JUNE 12, 2023

Applies to:

Oracle Financials for India - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Database trigger JA_IN_GEM_RG23_PART_I_TRG1

Symptoms

-- Problem Statement:
While changing the status of the OSP batch to "WIP". System gives below mentioned error based on the item class:-

If the item class is FGIN-Finish good then


unexpected ORA-01400:cannot insert null into
("JA"."JA_IN_RG_I"."INVENTORY_ITEM_ID")
ORA-06512 at APPS.JA_IN_GEM_RG_I_TRG1 ,line 242
ORA-04088 error during executing of trigger APPS.JA_IN_GEM_RG_I_TRG1

If the item class is RMIN-Raw material then

unexpected ORA-01400:cannot insert null into
("JA"."JA_IN_RG23_PART_I"."INVENTORY_ITEM_ID")
ORA-06512 at APPS.JA_IN_GEM_RG23_PART_I_TRG1 ,line 242
ORA-04088 error during executing of trigger APPS.JA_IN_GEM_RG23_PART_I_TRG1


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
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.