My Oracle Support Banner

CRM 8.0.1 (Doc ID 2855251.1)

Last updated on MARCH 16, 2022

Applies to:

Oracle Financial Services Credit Risk Analytics - Version 8.0.0 and later
Information in this document applies to any platform.

Goal

1. Downloaded the DL specs, reporting metadata from MOS. Observed some metadata documents under 8.0.1 are still refering to 8.0.0. Are there any specific documents for version 8.0.1? 

2. In DL Specs, these two tables: STG_COLLECTIONS & STG_RECOVERIES seem to be storing similar data. In Reporting metadata, both these tables are mapped to FCT_COLLECTIONS, FCT_RECOVERY.

3. Below columns are mentioned in technical metadata (for T2T), however these columns are not mentioned in DL specs:

STG_COLLECTIONS.D_LAST_SYS_ACTIVE

STG_COLLECTIONS.D_RECENT_ACTIVITY_DATE

STG_COLLECTIONS.F_FPD_IND

STG_COLLECTIONS.F_SPD_IND

STG_COLLECTIONS.N_CURRENT_BALANCE

STG_COLLECTIONS.N_TOTAL_OVERDUE

STG_COLLECTIONS.V_DATA_ORIGIN

STG_COLLECTIONS.V_DELQ_SYS_IND

STG_COLLECTIONS.V_RECENT_ACTIVITY_CODE

Please confirm which of these are incorrect DL specs or technical metadata document?

4. Table STG_PAYMENT_PATTERN: This table is not part of any T2T in technical metadata. It is not used for reports either. Where is this table used in the system?

5. STG_ATTRITION_REASON_MASTER: Where is this table used further? Not able to find attrition related columns in T2T or reports.

6. Are there still a lot of differences in DL Specs or data source requirements between CRM 8.0.1 and CRA 8.1.x?

7. What other OFSAA application(s) data will be utilised by CRA/CRM? 

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
References


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