OEOIMP : Order Import fails with error "User-Defined Exception in Package OE_Order_GRP Procedure Automatic_Account_Creation" (Doc ID 1397424.1)

Last updated on AUGUST 02, 2016

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 22-JAN-2015***

Symptoms


On : 11.5.10.2 version

Order Import request is failing to import order successfully.
The request log shows the following error

ERROR
-----------------------
User-Defined Exception in Package OE_Order_GRP Procedure Automatic_Account_Creation

OM Debug Log shows


party_site_use_id = 25495449
party_site_id = 8217594 site_use_code = BILL_TO
site_use_id =
site level customer: party_id:5606666
site level customer: account_id:116517330
site_use_id not passed
checking for party_site_use_id =25495449
not a valid party site use id
LEAVING OE_MSG_PUB.ADD
LEAVING OE_MSG_PUB.COUNT_AND_GET 2
XX ...done calling check_and_create_sites
not commiting the txn
LEAVING OE_MSG_PUB.COUNT_AND_GET 2
checking contact failure status = XXX
p_account_tbl: 1
AAC: after calling Create_Account_layer for header level site creation}
AAC: Main Status is not success msg= count=2
LEAVING OE_MSG_PUB.ADD
LEAVING OE_MSG_PUB.COUNT_AND_GET 3
PROCESS_ORDER RETURN STATUS BEFORE ACTION : U
PROCESS ORDER FAILED. NO NEED TO CALL FOR ACTIONS
...
User-Defined Exception in Package OE_Order_GRP Procedure Automatic_Account_Creation



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate Order Import Interface tables
2. Run Order Import

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