My Oracle Support Banner

Unable to Delete Shipment from a Historical Purchase Order (Doc ID 2554028.1)

Last updated on MAY 06, 2020

Applies to:

Oracle Purchasing - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Accounting related

ACTUAL BEHAVIOR
---------------
In oracle purchasing, users were not allowed to match billed
amount to shipments and distributions while converting
historical PO to single shipment and single distribution.



When delete the shipment and Save
and Submit for approval received
unhandled java exception.



## Detail 0 ##
java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_LINE_LOCATIONS_DRAFT_PKG", line 657
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_LINE_LOCATIONS_DRAFT_PKG", line 585
ORA-01400: cannot insert NULL into ("PO"."PO_LINE_LOCATIONS_DRAFT_ALL"."OUTSOURCED_ASSEMBLY")
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
References


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