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 |