I'm having a problem passing a Web Source Parameter to a List of Values that's using a Web Source Module
I'm querying Jira API's for boards and sprints.The Jira sprint API has a single parameter (board_id) in the Web Source module. I've used this same Web Source to successfully display Jira sprints using an Interactive Report to confirm it's working.
The Jira sprint API URL I'm using looks like this in the Web Source Module:
Base URL: https://deliver.atlassian.net/rest/agile/
URL Path Prefix: latest/board/:board_id/sprint?state=active,future
I setup the Jira Sprints LOV using a data source of "Web Source". The Web Source Parameter of board_id was created as expected, and I set it to:
Type: Item
Item: P10_ISSUES_BOARD_ID (The Jira Boards LOV I'm using to select the board id)
Unfortunately, I didn't find much documentation or an example of this particular setting. The inline documentation on this item says "Enter the page or application item used as the source for this parameter value.".
When I run the page, I get the following error. I don't seem to be able to pass in a value to the Web Source Parameter in the LOV. I've tried various variable substitutions and setting a session variable.
Technical Info (only visible for developers)
1. is_internal_error: true
2. apex_error_code: WWV_FLOW_FORM.UNHANDLED_ERROR
3. ora_sqlcode: -20999
4. ora_sqlerrm: ORA-20999: Required Web Source IN parameter "board_id" of type "URL Pattern" must have a value. ORA-06512: at "APEX_200100.WWV_FLOW_NATIVE_ITEM", line 2288 ORA-06512: at "APEX_200100.WWV_FLOW_EXEC_WEB_SRC", line 1209 ORA-06512: at "APEX_200100.WWV_FLOW_EXEC_WEB_SRC", line 2315 ORA-06512: at "APEX_200100.WWV_FLOW_EXEC_WEB_SRC", line 2223 ORA-06512: at "APEX_200100.WWV_FLOW_EXEC", line 2717 ORA-06512: at "APEX_200100.WWV_FLOW_EXEC", line 2421 ORA-06512: at "APEX_200100.WWV_FLOW_LOV", line 1488 ORA-06512: at "APEX_200100.WWV_FLOW_NATIVE_ITEM", line 2157 ORA-06512: at "APEX_200100.WWV_FLOW_NATIVE_ITEM", line 5720 ORA-06512: at "APEX_200100.WWV_FLOW_PLUGIN", line 1766 ORA-06512: at "APEX_200100.WWV_FLOW_PLUGIN", line 1888 ORA-06512: at "APEX_200100.WWV_FLOW_FORMS", line 1068
Any help would be appreciated.