ORA-24323: value not allowed,REP-1401

Report Problem

While Delevoping report I got following error :
ORA-24323: value not allowed ==> SELECT WE . WIP_ENTITY_NAME Job , DECODE ( : P_SORT_BY , 11 , WE . DESCRIPTION , 'X' ) Job_Desc , BOD . DEPARTMENT_CODE Department , MSI.SEGMENT1 C_ASSY , NVL ( WDJ . PRIMARY_ITEM_ID , - 1 ) Assembly_ID , DECODE ( : P_SORT_BY , 11 , MSITL . DESCRIPT REP-1401: '': Fatal PL/SQL error occurred. REP-0069: Internal errorREP-57054: In-process job terminated:Terminated with error: REP-1401: value not allowed ==> SELECT WE . WIP_ENTITY_NAME Job , DECODE ( : P_SORT_BY , 11 , WE . DESCRIPTION , 'X' ) Job_Desc , BOD . DEPARTMENT_CODE Department , MSI.SEGMENT1 C_ASSY , NVL ( WDJ . PRIMARY_ITEM_ID , - 1 ) Assembly_ID , DECODE ( : P_SORT_BY , 11 , MSITL . DESCRIPT
 

REP-1401: '': Fatal PL/SQL error occurred.
 

Solution :
Make sure the report field sourced with this formula is wide enough to accept the output. Also make header likefunction CF_2 return CHAR is
and it will return at least 200 characters.
Its Done!!! Running Fine!!!

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...