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 SEPTEMBER 07, 2017

Applies to:

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

Symptoms

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

Error
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:

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