My Oracle Support Banner

STR - Regulatory Reports Are Not Visible Under Search/List/File Reports (Doc ID 2742100.1)

Last updated on JANUARY 12, 2021

Applies to:

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

Symptoms

STR reports are not visible in the UI under Search and List, File Reports menus.

 

Below error is the cause for the issue:-

---------------------
Task LOAD_FCT_CUST_REVIEW_REASONS fails with an error [RUNPROCEDURE]
Statement to execute : BEGIN :D :=
LOAD_FCT_CUST_REVIEW_REASONS('OFSAAAIINFO_1604076169471_20200922_1','20200922'
,'$RUNID=1604076160626','$PHID=IPE_KY_CRT_ASSMENT','$EXEID=1604076169471','$RU
NSK=78'); END;
Error Msg :-> ORA-12801: error signaled in parallel query server P01H
ORA-64451: Conversion of special character to escaped character failed.
ORA-06512: at "OFSAAFCCM.LOAD_FCT_CUST_REVIEW_REASONS", line 13
ORA-06512: at line 1

------------

STR reports are not visible in the UI under Search and List, File Reports menus. Log is showing below error.

ORA-01489: result of string concatenation is too long
01489. 00000 - "result of string concatenation is too long"
*Cause: String concatenation result is more than the maximum size.
*Action: Make sure that the result is less than the maximum size.

-------------

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
Cause
Solution


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