AutoCreate Final Assembly Is Showing GET_DELIVER_TO_LOCATION_ID_ER Errors For Some Items

(Doc ID 2368234.1)

Last updated on MARCH 01, 2018

Applies to:

Oracle Work in Process - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

When attempting to run AutoCreate Final Assembly Orders (run WICDOL), the following error occurs.

ERROR

GET_DELIVER_TO_LOCATION_ID_ER: Initializing the assignment set
initialize_assignment_set: Default assignment set is 1125
initialize_assignment_set: Default assignment set name is Purchasing Assigment Set
GET_DELIVER_TO_LOCATION_ID_ER: gMrpAssignmentSet:1125
GET_DELIVER_TO_LOCATION_ID_ER: Vendor_Id =2499012
GET_DELIVER_TO_LOCATION_ID_ER: Vendor_Site_Id =999885
GET_DELIVER_TO_LOCATION_ID_ER: Count:0
GET_DELIVER_TO_LOCATION_ID_ER: No ASL defined for item. Getting STL from sourcing.
GET_DELIVER_TO_LOCATION_ID: Going to get STL from vendor site
GET_DELIVER_TO_LOCATION_ID_ER: STL from vendor site:
GET_DELIVER_TO_LOCATION_ID_ER: Going to get STL from vendor
GET_DELIVER_TO_LOCATION_ID_ER: Going to get STL from financial params for Org :
GET_DELIVER_TO_LOCATION_ID_ER:: Other::70::ORA-01403: no data found
populate_req_interface: UnExpected Error in get_deliver_to_location_id.
get_deliver_to_location_id: unexpected error: User-Defined Exception
populate_req_interface: unexpected error in get_deliver_to_location_id
populate_req_interface: POPULATE_REQ_INTERFACE::unexp error::20::User-Defined Exception
create_subassembly_jobs: CTOSUBSB.create_sub_assembly_jobs UN expected excpn: 260: User-Defined Exception
insert_wip_interface:  failed after call to get_working_dayU
insert_wip_interface: error message260: User-Defined Exception
insert_wip_inetrface:  UN expected excpn:  CTOWIPUB.insert wip interface N expected  excpn: :User-Defined Exception
get_order_lines: Insert Error Message: CTOWIPUB.insert wip interface N expected  excpn: :User-Defined Exception
get_order_lines: FAILED in Insert WIP Interface: UFor Order Line 85534767
.................


STEPS

The issue can be reproduced at will with the following steps:
1. Responsibility = Work In Process (WIP)
2. Navigation = Discrete-> AutoCreate Orders
3. Submit concurrent request


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