My Oracle Support Banner

Information Required On CASH_TRXN Logic Differences Between 5.9 And 8.0.4 (Doc ID 2692877.1)

Last updated on JULY 22, 2020

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.


Customer have a following queries:

1. We observe the logic difference between 5.9 and FCCM while populating CASH_TRXN data from FOT and FOTP, In 5.9 FIRST function is used to populate ACCT_INTRL_ID and DBT_CDT_CD whereas MAX is used in FCCM for both columns. Whenever we are getting two parties for CASH_TRXN i.e. ORG and BENE then CASH_TRXN.ACCT_INTRL_ID is different in 5.9 and FCCM for same transaction.

Can you please provide an information on why this logic has changed.
Can CASH_TRXN have multiple parties.

2. As per Oracle documentation, we see the below definition for CASH_TRXN

Each record in the Cash Transaction table captures details of a cash (currency) or commodity transaction that occurs
in the Oracle client’s customer or firm account. An entry is made in the Cash Transaction table when a new
transaction is found in the Front Office Transaction and the Front Office Transaction Party data interfaces that
conform to the specific values for the following codes that pertain to the cash transactions in Table 250:
Mantas Asset Class Code
Mantas Transaction Product Type
Mantas Transaction Channel
A Cash Transaction record is also designed to capture details of a conductor and location of the transaction. A
conductor is a party external to the Oracle client (typically an individual) who is not a customer of the client but is
authorized to perform cash transactions in a customer’s account. Alternately, a walk-in non-customer who performs
a cash transaction at a branch of the Oracle client is considered a conductor. The location where a cash transaction
is conducted can be captured in the Cash Transaction table (for example, ATM location used for withdrawing cash).

As mentioned, a CASH transaction record is designed to capture the details of conductor of transaction which are external to Oracle client.

is there any scenario to monitor these types of transactions which are included conductor party which are external to oracle client?


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

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