Oracle Financial Services Regulatory Reporting for US ...

Oracle Financial Services Regulatory Reporting for US Federal Reserve ? Lombard Risk Integration Pack

Release 8.0.5.0.1 Change Log for FR Y-7N

December 2017

DOCUMENT CONTROL

Version Number 1.0

Revision Date Created: December 2017

Created by: Naveen Harry D'Cruz

Reviewed by: Siju P B

Changes Done

Document contents are categorized to appropriate sections and structured considering all the 8.0.5.0.1 features. Approved by: Surag Ramachandran / Siju P B

OFS Regulatory Reporting for US Federal Reserve ? Lombard Risk Integration Pack Change Log 8.0.5.0.1

TABLE OF CONTENTS

1 ORACLE FINANCIAL SERVICES REGULATORY REPORTING FOR US FEDERAL RESERVE ? LOMBARD RISK INTEGRATION PACK CHANGE LOG

4

1.1 Schedule Changes.............................................................................................................................................................................................................. 4

1.2 Derived Entity Changes ...................................................................................................................................................................................................... 4

1.3 Metadata Changes.............................................................................................................................................................................................................. 5

1.4 MDRM Metadata Changes.................................................................................................................................................................................................. 6

1.5 Rule Changes ..................................................................................................................................................................................................................... 8

Oracle Financial Services Software Confidential - Restricted 3

OFS Regulatory Reporting for US Federal Reserve ? Lombard Risk Integration Pack Change Log 8.0.5.0.1

1 Oracle Financial Services Regulatory Reporting for US Federal Reserve ? Lombard Risk Integration Pack Change Log

This document introduces the change log between previous version (80500) and current released version (80501) of Oracle Financial Services Regulatory Reporting for US Federal Reserve (OFS REG REP USFED). The following changes are applicable for the FR Y-7N report.

1.1 Schedule Changes

Sl. No. Schedule Code Schedule Description

1

BS

Balance Sheet

2

BS-A

3

BS-M

4

IS-B

Loans and Lease Financing Receivables Memoranda Changes in Allowance for Loan and Lease Losses

Change Description

Removed holding type filter from DEFD4100 used in DEFD4102. Added absolute function for liabilities. Changed dataset from Join to Union. Latest record indicator removed if Join is based on Skey column. Product balance sheet category filter removed from FR Y-11 BS-M for those MDRM's which have filter on GL_TYPE_CODE.

Natural currency column moved to reporting currency columns.

Latest record indicator removed if Join is based on Skey column.

FR Y-9C / FR Y-9LP: MDRMs related to numbers for different misdate.

1.2 Derived Entity Changes

Sl. No. Schedule Code Derived Entity Code

1

BS

DE11BS01

2

BS

DE11BS02

3

BS

DE11BS07

4

BS

DE11BS09

5

BS

DE11BS10

6

BS

DE11BS11

7

BS

DE11BS12

8

BS

DEFD4003

9

BS

DEFD4005

10

BS

DEFD4007

11

BS

DEFD4011

12

BS

13

BS

14

BS-A

DEFD4100 DEFD4102 DEBSA001

Derived Entity Description

Type of Change

DE - BS-Common Account Summary

Modified

DE - BS-IFRS Account Summary

Modified

DE - 11-BS-IFRS-Management

Modified

DE - 11-BS-IFRS

Modified

DE - 11-BS-Borrowings

Modified

DE - 11-BS- Management Reporting

Modified

DE - Common Account Summary Affiliated Issuer Modified

DE - FRAS Balance Sheet

Modified

DE - Assets and Liabilities - IFRS

Modified

DE - Cards FRAS BS Other Liabilities

Modified

DE - FRAS Management Related Inst Memoranda Modified

DE - Unused Commitments DE - Unused Commitment Union DE - BS-A IFRS Account Summary

Modified Modified Modified

Change Description Latest record indicator removed if Join is based on Skey column. Latest record indicator removed if Join is based on Skey column. Changed dataset from Join to Union. Latest record indicator removed if Join is based on Skey column. Latest record indicator removed if Join is based on Skey column. Changed dataset from Join to Union. Latest record indicator removed if Join is based on Skey column. Latest record indicator removed if Join is based on Skey column. Added absolute function for liabilities. Latest record indicator removed if Join is based on Skey column. Product balance sheet category filter removed from FR Y-11 BS-M for those MDRM's which have filter on GL_TYPE_CODE. Removed holding type filter from DEFD4100 used in DEFD4102. Removed holding type filter from DEFD4100 used in DEFD4102. Natural currency column moved to reporting currency columns.

Oracle Financial Services Software Confidential - Restricted 4

OFS Regulatory Reporting for US Federal Reserve ? Lombard Risk Integration Pack Change Log 8.0.5.0.1

Sl. No. Schedule Code Derived Entity Code

15

BS-M

DEBSM001

16

BS-M

DEBSM014

17

IS-B

DERIBD01

Derived Entity Description DE - BS-M Common Account Summary DE - BS-M Asset Held Trading Account DE - Management Reporting EOPY - Dom Ofc

Type of Change Modified Modified Modified

Change Description Latest record indicator removed if Join is based on Skey column. Latest record indicator removed if Join is based on Skey column. FR Y-9C / FR Y-9LP: MDRMs related to numbers for different misdate.

1.3 Metadata Changes

Sl. No. Schedule Code Metadata Code

1

BS

BP11BSM3

2

BS

BP11BSM6

3

BS

BP11BSM7

4

BS

BPFD4006

5

BS

BPFD4023

6

BS

BPFD4050

7

BS

DS11BS01

8

BS

DS11BS02

9

BS

DS11BS07

10

BS

DS11BS09

11

BS

DS11BS10

12

BS

DS11BS11

13

BS

DSFD4003

14

BS

DSFD4005

15

BS

DSFD4007

16

BS

DSFD4011

17

BS

DSFD4100

18

BS

DSFD4102

19

BS-A

BPRBSA01

20

BS-A

BPRBSA02

21

BS-A

DSBSA001

22

BS-M

DSBSM001

23

BS-M

DSBSM014

Metadata Description BP - EOP Balance for all Other Assets BP - 11-BS-IFRS2 BP - 11-BS-IFRS-Management BP - 2314 Liabilities ? IFRS BP - Negative Balance FRS Excess Payment Cards BP - 2314 Mem Liabilities - IFRS DS - BS-Common Account Summary DS - BS-IFRS Account Summary DS - 11-BS-IFRS-Management DS - 11-BS-IFRS DS - 11-BS-Borrowings DS - Common Account Summary Affiliated Issuer DS - FRAS Balance Sheet DS - Assets and Liabilities - IFRS DS - Cards FRAS BS Other Liabilities DS - FRAS Management Related Inst Memoranda DS - Unused Commitments-FRAS DS - Unused Commitment Union BP - Net Book Value BP - Net Book Value Affiliated Party DS - BS-A IFRS Account Summary DS - BS-M Common Account Summary DS - BS-M Asset Held Trading Account

Metadata Type Business Processor Business Processor Business Processor Business Processor Business Processor Business Processor Dataset Dataset Dataset Dataset Dataset Dataset Dataset Dataset Dataset Dataset Dataset Dataset Business Processor Business Processor Dataset Dataset Dataset

Type of Change Modified Modified Modified Modified Modified Added Modified Modified Modified Modified Modified Modified Modified Modified Modified Modified Modified Modified Modified Modified Modified Modified Modified

Oracle Financial Services Software Confidential - Restricted 5

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download