Unable to Create Account for Employee Type Supplier by Using API IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_ACCT (Doc ID 602039.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.0.4 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.

Symptoms

When trying to create External Bank accounts to the Employee Type Suppliers by using the "IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_ACCT" API, the account gets created
but it fails to attach this account to the supplier saying that Invalid Party_Site_Id. Since there is no Party_Site_Id for these employee type suppliers attaching these accounts to the Supplier site failed.

API log file shows message: l_bank_acct_response.result_message: A party context attribute is missing, or
does not have referential integrity with its source table.

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