Deals Interface Deal Type = 'EXP', When Counterparty Account Is Inserted Gives Error: xtr_cparty_acct_reqd (Doc ID 1958344.1)

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.

Goal

Deals interface deal type = 'EXP', errors xtr_cparty_acct_reqd
(1).
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.
Error Codes
---------------------------------------------------
xtr_cparty_acct_reqd

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
Exiting XTR_EXP_TRANSFERS.VALID_CPARTY_CODE
Entering XTR_EXP_TRANSFERS.VALID_CPARTY_REF
Exiting XTR_EXP_TRANSFERS.VALID_CPARTY_REF
Entering XTR_EXP_TRANSFERS.GET_CPARTY_ACCOUNT
Exiting XTR_EXP_TRANSFERS.GET_CPARTY_ACCOUNT
Entering XTR_EXP_TRANSFERS.LOG_ERRORS
Exiting XTR_EXP_TRANSFERS.LOG_ERRORS
Exiting XTR_EXP_TRANSFERS.VALIDATE_DEALS
TRANSFER_EXP_DEALS: validation_error ==> TRUE
Exiting XTR_EXP_TRANSFERS.TRANSFER_EXP_DEALS
Entering XTR_EXP_TRANSFERS.TRANSFER_EXP_DEALS
Entering XTR_IMP_DEAL_DATE.CHECK_USER_AUTH
CHECK_USER_AUTH: p_company_code ==> HCA
Exiting XTR_IMP_DEAL_DATA.CHECK_USER_AUTH
TRANSFER_EXP_DEALS: user_error ==> FALSE
 

Solution

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