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:

Manage Inactive session in Oracle 23AI Database.

# CONNECT WITH PDB DATABASE(ORACLE 23AI) [oracle@prd-23ai ~]$ sqlplus / as sysdba  SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engin...