Examples of Using Expressions in a T2T Extract to Populate a Column with New Values (Doc ID 2005772.1)

Last updated on FEBRUARY 24, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure, when creating a T2T Database Extract, can you use Expressions to calculate and populate new values in columns?

Can you do the following logic in an Expression for a T2T Extract:

Logic #1:  STG_CASA.D_MATURITY_DATE - STG_CASA.D_ORIGINATION_DATE

Logic #2: STG_CASA.D_MATURITY_DATE +365 days

Logic #3: (1|| ACCOUNT_NUMBER||DATA_SOURCE_CD)

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