My Oracle Support Banner

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

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Treasury - Version 12.0.0 to 12.2.8 [Release 12 to 12.2]
Information in this document applies to any platform.

Goal

NOTE:  In the data below and/or the attached document, account information/ user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

On importing deal type = 'EXP' into xtr_deals_interface table using Program - Import Deal data,

Deal transaction of deal type = 'EXP' Errors when cparty_account_no NULL in the import transaction as:

xtr_cparty_acct_reqd

Please Note: deal type = 'EXP', CpartyAccountNo - A counterparty account is required when a counterparty is specified and counterparty is a required data to valid deal for Import.

 

    CpartyAccountNo - A counterparty account is required when a counterparty is specified.

         Error Codes
         ---------------------------------------------------
         xtr_cparty_acct_reqd

 


Such Imported transactions are inserted into base table i.e. xtr_exposure_transactions :

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

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.