Deals Interface Deal Type = 'EXP', When Counterparty Account Is Inserted Gives Error: xtr_cparty_acct_reqd
(Doc ID 1958344.1)
Last updated on FEBRUARY 03, 2019
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
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|