My Oracle Support Banner

Create Purchase Order - 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 2710504.1)

Last updated on SEPTEMBER 14, 2020

Applies to:

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

Symptoms

Using Purchasing, Version 12.2.8


Actual:
Creating the purchase order is resulting in errors.

Expected:
The purchase order should allow creation - and not error upon saving.

Error:
APP-PO-14142: PO_SHIPMENTS_SV6.insert_po_shipment-015:ORA-01400: cannot insert NULL into ("PO"."PO_LINE_LOCATIONS_ALL"."OUTSOURCED_ASSEMBLY")
Cause: A SQL error has occurred in PO_SHIPMENTS_SV6.insert_po_shipment. The SQL error is ORA-01400: cannot insert NULL into ("PO"."PO_LINE_LOCATIONS_ALL"."OUTSOURCED_ASSEMBLY").



Replication Steps:
The issue can be reproduced at will with the following steps:
1. Purchase Orders - enter the header - lines - etc.
2. Attempt to save
3. Error is encountered.


Other:
<>:R12.PO.D is in place - but the error persists.
Also <>:R12.PO.D

FND Logging:

po.plsql.PO_SHARED_PROC_PVT.validate_ship_to_org.invoked shipto org ID: 124 item cat ID: 3123
po.plsql.PO_SHARED_PROC_PVT.check_transaction_flow.invoked startou ID: 123 endou ID: 123 shipto org: 124 item cat ID: 3123 txn date: 09-SEP-2020 09:48:58
po.plsql.PO_SHARED_PROC_PVT.check_transaction_flow.030 Start OU and End OU same, so just return
po.plsql.PO_SHARED_PROC_PVT.validate_ship_to_org.090 x_in_current_sob = TRUE
po.plsql.PO_SHARED_PROC_PVT.validate_ship_to_org.090 x_check_txn_flow = TRUE
po.plsql.PO_SHARED_PROC_PVT.validate_ship_to_org.090 x_is_valid = TRUE
po.plsql.po_message_s.PO_SHIPMENTS_SV6.insert_po_shipment.015.EXCEPTION ;SQLERRM = ORA-01400: cannot insert NULL into ("PO"."PO_LINE_LOCATIONS_ALL"."OUTSOURCED_ASSEMBLY")
per.resource.HRKPI.hr_kpi_extlib.event begin
per.resource.HRKPI.hr_kpi_extlib.event #event_name#WHEN-NEW-BLOCK-INSTANCE*formname*POXPOEPO
per.resource.HRKPI.hr_kpi_extlib.event end

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.