Feb 2, 2010

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:

OraApps Search

Custom Search

Search This Blog