Unable to retrieve report data using Dynamic Action in Oracle APEX
I have two tables: Application (PK: Application_ID) and App_support_domain (column: team_name, FK: Application_ID referencing Application table)
I am trying to display the data present in the Application table based on the selection of team names.
I have created a LOV popup (P2_NEW) to select the team name. 
After selecting the team name I want to show the application data in the form of a report, so I have created a dynamic action that will show the body region which has the application data.
But the SQL query that I have written does not return any data. I think it is not taking the P3_NEW LOV value and displaying the application data.
Please let me know if you need more info/clarification. Could you please take a look and help me out?
A "show" dynamic action will not resubmit the report. Add 2 actions to the dynamic action. One to refresh and an 2nd one to show. That will force the report to to refresh. Make sure you put P2_NEW in the "Page Items to submit" for the report.
- Transpose Hierarchical Table based on leaf nodes with nodes as first column
- Comparisons using EXTRACT YEAR not working
- Oracle Analytics - partitions and ordering of sql queries
- Selecting a sequence NEXTVAL for multiple rows
- Oracle procedure error: Expected UDT got CHAR
- Transform Travel Table - SQL
- Get lowercase letters from Oracle 10g columns
- pull access denied for container-registry.oracle.com/database/enterprise
- USE database_name command alternative for Oracle
- How to return columns from dynamic SQL in Python console
- How to determine if and which index is being used in oracle
- How to raise Oracle PL/SQL exceptions from Python
- sql extraction of identification numbers
- Oracle Database: Find Missing Indexes for Performance tuning
- difference between 'natural full outer join' and 'full outer join'
- SQL query giving error msg not enough values
- Unique Constraint violation
- Oracle APEX Dynamic Action call to package throwing error "ORA-06550: line 11, column 19: PLS-00302: component 'GET_EMP_INFO' must be declared"
- ORA-00001: uniqueness constraint violated
- Unable to set CLASSPATH with confluent CLI : java.sql.SQLException: No suitable driver found for jdbc:oracle:thin
- In an oracle RAC setup, can a single transaction be assured to be executed on a single node?
- Django: how to see the SQL query when running tests?
- Multiple Passwords for Multiple Schemas in single connection
- Get the resultset of any SQL cursor as XML with column names as attribute without using XSLT in Oracle
- Get UDT type name inside of its body in Oracle 19c
- Oracle regexp_replace
- Extracting data from an Oracle DB on python. Facing issues with the multibyte characters
- Setting report column to YES or NO based on date - Oracle SQL
- SQL script called from Jenkins Pipeline does not output error or correct exit code
- Oracle SQL Insert Trigger to Handle Duplicate Contacts and Update Owner Field