ASCP Collection Errors for Non-Planned Items on Purchase Order Lines (Doc ID 1951752.1)

Last updated on OCTOBER 30, 2015

Applies to:

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

Symptoms

Using Purchasing for Requisitions and Purchase Orders with need by date set at saved, value of expected_delivery_date from mtl_supply is null.
This causes data collections to fail in ASCP with the following error :

Error

Error in PROCEDURE=LOAD_SUPPLY, TABLE=MSC_SUPPLIES
19-NOV 23:07:48 : COLUMN=MSC_CL_ITEM_ODS_LOAD.ITEM_NAME, VALUE=5726
19-NOV 23:07:48 : COLUMN=ORGANIZATION_CODE, VALUE=VCP:501
19-NOV 23:07:48 : COLUMN=ORDER_TYPE, VALUE=Purchase requisition
19-NOV 23:07:48 : ORA-01400: cannot insert NULL into ("MSC"."SUPPLIES_VCP"."NEW_SCHEDULE_DATE")


Steps to reproduce

1. Create Requisition or Purchase Order for non-planned item. Approve document

2. Nvaigate to ASCP Module

3. Run Data collection. Error occurs


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms