My Oracle Support Banner

USFED RR 80512: Line Item 2340 - FRY2900 - 'AND' is used which sorts of only report credit balances from cards and loans. (Doc ID 2459282.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Financial Services Regulatory Reporting - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

For line item 2340 the DE logic ( DEFR2912 ) seems to be quite different from the logic that is there for line item 2514.
I believe the filters on these DE's should be similar except the logic where we look for the D_MATURITY_DATE greater than 7(for 2514) or less than or equal to 7(for 2340).

For 2340:
Looks at TO_DATE (A_MATURITY_DATE_PRIM_OBLG.D_CALENDAR_DATE,
  'DD-MM-YYYY')
  - TO_DATE (DIM_DATES.D_CALENDAR_DATE, 'DD-MM-YYYY') < 7

For 2514:
TO_DATE (A_MATURITY_DATE_PRIM_OBLG.D_CALENDAR_DATE,
  'DD-MM-YYYY')
  - TO_DATE (DIM_DATES.D_CALENDAR_DATE, 'DD-MM-YYYY') > 7

The only condition that changes for both these line items should be the above, as the balances not considered in 2340 is what goes into 2514. But as per the current DE filters the logic is completely different.

Changes

 

Cause

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
Symptoms
Changes
Cause
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.