Location Flexfield (State) Description not displaying in Oracle Reports
Hi All
In my Report i am trying to retrieve the State Location Flexfield Description for each State through the code :
SRW.REFERENCE(:P_STATE);
SRW.USER_EXIT('FND FLEXIDVAL
CODE="LOC#"
APPL_SHORT_NAME="OFA"
DATA=":P_STATE"
NUM="101"
DISPLAY="2" --Display only Second Segment i.e State Segment
DESCRIPTION=":P_STATE_DESCR"');
RETURN(:P_STATE_DESCR);
In my Report i am trying to retrieve the State Location Flexfield Description for each State through the code :
SRW.REFERENCE(:P_STATE);
SRW.USER_EXIT('FND FLEXIDVAL
CODE="LOC#"
APPL_SHORT_NAME="OFA"
DATA=":P_STATE"
NUM="101"
DISPLAY="2" --Display only Second Segment i.e State Segment
DESCRIPTION=":P_STATE_DESCR"');
RETURN(:P_STATE_DESCR);
The :P_STATE_DESCR is returning like this in Output
** CODE=LOC#, NUM=101 : invalid segments **
Please help since this is a high priority report to be delivered.
Thanks
Nakul.V
0