My Oracle Support Banner

R12.1.3: Unable To Update Customer Trade Profile - Error: Private API: Create Trade Profile No Cust or Party (Doc ID 1906085.1)

Last updated on AUGUST 11, 2020

Applies to:

Oracle Trade Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


When updating the Customer Trade Profile and removing the Bill To Site record, the following error is encountered:

Private API: - Open Cursor to Select
Private API: - Close Cursor
before create in update!!
into create
Private API: Create trade profile
no cust or party 21
p_trade_profile_rec.payment_method : AP_DEFAULT
Private API: Validate_dm_model_rec
Into begin 1
before insert 2
Party id is 123456
vendor id is 12345
vendor site id is 12345

 This can be reproduced with the following steps:


To view full details, 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 a vibrant support community of peers and Oracle experts.