Deals Interface Deal Type = 'EXP', When Counterparty Account Is Inserted Gives Error: xtr_cparty_acct_reqd
Last updated on MARCH 08, 2017
Applies to:Oracle Treasury - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Deals interface deal type = 'EXP', errors xtr_cparty_acct_reqd
For Deals interface where deal type = 'EXP', when counterparty account is inserted gives error.On importing deal into xtr_deals_interface table, the deal type is EXP, the requirement is that counterparty account should also be inserted in order to complete transactions sucessfully. The counterparty account information is showing in the xtr_deals_table. after inserting data into xtr_deals_interface table when try to import with the help of Program - Import Deal data it gives error. when try to insert counterparty account number from cparty_account_no column of xtr_deals_interface table into it errors complete transaction by giving error-CpartyAccountNo - A counterparty account is required when a counterparty is specified.
When keep counterparty account number column i.e. cparty_account_no NULL, it inserts the deal into base table i.e. xtr_exposure_transactions, But this insert does not solves our purpose of interface. Even in the xtr_interface_errors table it is showing the error column cpart_account_no with error code as xtr_cparty_acct_reqd. The account is set as default and authorised, even we changed the default settings still it is not helping us.
Counterparty Account Number - A Counterparty Account is required when a counterparty is specified.
ALID_CPARTY_CODE: p_cparty ==> HT2010A
VALID_CPARTY_CODE: p_comp ==> HCA
TRANSFER_EXP_DEALS: validation_error ==> TRUE
CHECK_USER_AUTH: p_company_code ==> HCA
TRANSFER_EXP_DEALS: user_error ==> FALSE
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms