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

Last updated on JANUARY 12, 2021

Applies to:

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

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