My Oracle Support Banner

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 JUNE 25, 2019

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

Order Import request is failing to import order successfully with the following error:


ERROR
-----------------------

party_site_use_id = XXXXXXX
party_site_id = XXXXX site_use_code = BILL_TO
site_use_id =
site level customer: party_id:XXXXXXX
site level customer: account_id:XXXXXXXXX
site_use_id not passed
checking for party_site_use_id =XXXXXXX
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

Changes

 

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
Changes
Cause
Solution


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