My Oracle Support Banner

AD_ZD_TABLE_APPLY.sql MRP_INVENTORY_LOTS_F1 Fails While Applying a Patch (Doc ID 2677601.1)

Last updated on AUGUST 06, 2020

Applies to:

Oracle Materials Requirement Planning - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

This has been reported on multiple versions and while applying different patches

AD_ZD_TABLE_APPLY.sql MRP_INVENTORY_LOTS_F1 fails

ERROR:

ERROR at line 1:
ORA-20001: Could not apply crossedition trigger "APPS"."MRP_INVENTORY_LOTS_F1":
ORA-20001: Parallel update task failed: "MRP_INVENTORY_LOTS_F1" status=8 Error:
ORA-01407: cannot update ("MRP"."MRP_INVENTORY_LOTS"."INVENTORY_LOT_NUMBER#1")
to NULL
ORA-06512: at "APPS.AD_ZD", line 26
ORA-06512: at "APPS.AD_ZD_TABLE", line 19
ORA-06512: at "APPS.AD_ZD_TABLE", line 1787
ORA-06512: at line 1


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.