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-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...