My Oracle Support Banner

OFS_AGILE_RP_EBA_8.1.x:Anacredit FRACRD Role RA Rules are getting failed (Doc ID 2735095.1)

Last updated on DECEMBER 14, 2020

Applies to:

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

Symptoms

RR-EBA application (Anacedit) from 8.1.0.1. Post upgrade

While performing the run, rule "Anacredit FRACRD Role RA"(REGANARL158) has failed with below error.
Original message: ORA-01427: single-row subquery returns more than one row

This issue is applicable for all the rules which make use of the table dim_reg_party_role_ranking in sub query

List of rules are:
Anacredit FRACRD Role RA
Anacredit FRACRD Role One DEBTOR 2
Anacredit FRACRD Role One DEBTOR 1
Anacredit FRACRD Role CREDITOR
Anacredit FRACRD Role OA
Anacredit FRACRD Role PROTPROV
Anacredit FRACRD Role ORIGINATOR
Anacredit FRACRD Role SERVICER
Anacredit FRACRD Role HOU
Anacredit FRACRD Role IPU

Changes

 Upgraded to RR-EBA application (Anacedit) 8.1.0.1.0

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.