APP-PO-14142: PO_SHIPMENTS_SV6.insert_po_shipment-015:ORA-01400: Cannot Insert NULL Into ("PO"."PO_LINE_LOCATIONS_ALL"."OUTSOURCED_ASSEMBLY") (Doc ID 2994549.1)

Last updated on DECEMBER 21, 2023

Applies to:

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

On : 12.2.12 version

This document provides datafix after root-causes fixes from Doc ID 2389751.1 , Doc ID 2710504.1 were applied.

During the update of an approved purchase order by adding new line, when trying to save the document the following error occurs:

ERROR

-----------------------

APP-PO-14142: PO_SHIPMENTS_SV6.insert_po_shipment-015: ORA-01400: cannot insert NULL into ("PO"."PO_LINE_LOCATIONS_ALL"."OUTSOURCED_ASSEMBLY")

STEPS

-----------------------

The issue can be reproduced at will with the following steps:

1. Purchasing > Purchase Orders > Purchase Orders Summary > Query PO

2. Open PO > Add new line

3. Go to Shipment tab > Add shipment line

4. Press Save > Error is encountered

	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

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