APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IG, Created Column, Target Type PL/SQL "Column must match the values Y and N."

Gary PerkinsOct 1 2022

Hi,
Apex 22.1.1
I would like to display a list of records giving the user the choice to select which record to process. So I created an IG and added a column and set as a CheckBox. I'm pretty sure I've done this before but it might have been a few patches ago.
The error comes up even if I delete the IG Process.
When I click on the information in the erro message I see this:
Technical Info (only visible for developers)
is_internal_error: false
component.type: APEX_APPL_PAGE_IG_COLUMNS
component.id: 52784859423561638
component.name: TEST
association_type: REGION_COLUMN
region_id: 54493388875263286
column_alias: TEST
model_record_id: lkjhkjh
error_backtrace:
----- PL/SQL Call Stack -----
object line object
handle number name
0x96cad568 980 package body APEX_220100.WWV_FLOW_ERROR.INTERNAL_GET_ERROR
0x96cad568 1048 package body APEX_220100.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR
0x96cad568 1201 package body APEX_220100.WWV_FLOW_ERROR.ADD_ERROR
0x94d186c8 10760 package body APEX_220100.WWV_FLOW_INTERACTIVE_GRID.ADD_ERROR
0x94d186c8 10742 package body APEX_220100.WWV_FLOW_INTERACTIVE_GRID.PERFORM_BASIC_VALIDATIONS
0xa3fb1c98 673 package body APEX_220100.WWV_FLOW_REGION.PERFORM_BASIC_VALIDATIONS
0xa9482608 613 package body APEX_220100.WWV_FLOW_VALIDATION.PERFORM_BASIC_VALIDATIONS.VALIDATE_REGION_COLUMNS
0xa9482608 648 package body APEX_220100.WWV_FLOW_VALIDATION.PERFORM_BASIC_VALIDATIONS
0xa9482608 1007 package body APEX_220100.WWV_FLOW_VALIDATION.PERFORM
0x94d186c8 10246 package body APEX_220100.WWV_FLOW_INTERACTIVE_GRID.AJAX_SAVE_DATA
0x94d186c8 10533 package body APEX_220100.WWV_FLOW_INTERACTIVE_GRID.AJAX
0x8e879c80 2419 package body APEX_220100.WWV_FLOW_REGION_NATIVE.AJAX_REGION
0xa07af518 2825 package body APEX_220100.WWV_FLOW_PLUGIN.AJAX_REGION
0xa07af518 4137 package body APEX_220100.WWV_FLOW_PLUGIN.AJAX_CALLBACK
0x94a40988 1634 package body APEX_220100.WWV_FLOW.AJAX_DISPATCH_REQUEST
0x94a40988 2968 package body APEX_220100.WWV_FLOW.SHOW
0x94a40988 4335 package body APEX_220100.WWV_FLOW.AJAX
0x61e5f170 2 anonymous block

Looks like a bug?
Thanks
Gary

This post has been answered by Hamza Al-abbasi on Oct 1 2022

Jump to Answer

Added on Oct 1 2022

#apex-discussions

2 comments

1,589 views