My Oracle Support Banner

How to Create an OFSAA Date Data Filter for Origination Date in the Same Month as As Of Date and String Filter on a Varchar Column (Doc ID 2405206.1)

Last updated on JUNE 28, 2018

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Data Quality (DQ) Rules

Goal

Question 1: Currently have a need to filter out only same month of Origination date which is equal to As_of_date of instrument table.  For example: AS_OF_DATE = 31MAR18, need a filter for the Origination date which is of same month only (5MAR18, 18MAR18,27MAR18); if anything before the MAR it should not filter out those records.   AS_OF_DATE changes dynamically every month based on Application preferences set up.

Question 2: Need to filter out a column data based on some like operators (ie.. LOAN_TYPE = PL_ABC, PL_BCD, PL_CDE) only the data with the like 'PL_%' should be selected for the allocation.
 
Question 3: Can Data Quality Checks write data to a Custom Column in the Instrument table ?

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


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