Skip to Main Content

APEX

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Return value in select List issue

Harsha VardhanFeb 16 2024

I have requirement where there two below fields in a Form,
and when i select a value in P4_BATCH_NO,i need get relavent batch_id and set to P4_BATCH_ID
P4_BATCH_NO
P4_BATCH_ID

This is done by a dynamic action on P4_BATCH_NO defined as follows:

Event: Change  
Selection Type: Item(s)  
Item(s): P4\_BATCH\_NO  
  
TRUE Action:  
Action: Set Value  
Set Type: SQL Statement  
SQL Statement: select BATCH\_ID from CTC\_BATCH\_DETAILS where BATCH\_NO = :P4\_BATCH\_NO  
Items to Submit: P4\_BATCH\_NO.

But i am getting below error :-

Ajax call returned server error ORA-20987: APEX - Attempt to save item P4_BATCH_NO in session state during show processing. Item protection level indicates:
Item may be set when accompanied by a "session" checksum.

No checksum was passed in or the checksum passed in would be suitable for an item with protection level "(No checksum was provided)".

Note: End users get a different error message. - Contact your application administrator. for ajax_set_session_state.

Comments
Post Details
Added on Feb 16 2024
4 comments
110 views