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.
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).
Looks at TO_DATE (A_MATURITY_DATE_PRIM_OBLG.D_CALENDAR_DATE,
- TO_DATE (DIM_DATES.D_CALENDAR_DATE, 'DD-MM-YYYY') < 7
- 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.
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