Oracle ADF Delete action delete all the rows in the table

We found an issue, which delete all the rows in the DB table , though we need to delete only one record. We delete using PL/SQL.

We found this is due to we define the PL/SQL input parameter name same as delete table column name. Then we rename the proc to change the email parameter as p_email. Presentation

FUNCTION DELETE_INTERVIEW_ROWS (email IN VARCHAR2)

RETURN VARCHAR2 AS

wk_message varchar2(100);

    BEGIN

        DELETE FROM  INTERVIEW interv
        WHERE interv.EMAIL = email;

        wk_message := 'Success';
        commit;

        return wk_message;

        EXCEPTION
            WHEN OTHERS THEN
            wk_message := 'Not Success';
            return wk_message;

    END;

----------------------------------------------
SOLUTION

FUNCTION DELETE_INTERVIEW_ROWS (p_email IN VARCHAR2)

RETURN VARCHAR2 AS

wk_message varchar2(100);

    BEGIN


        DELETE FROM  INTERVIEW interv
        WHERE interv.EMAIL = p_email;

        wk_message := 'Success';
        commit;

        return wk_message;

        EXCEPTION
            WHEN OTHERS THEN
            wk_message := 'Not Success';
            return wk_message;

    END;
----------------------------------------------

Oracle ADF Table row selection button not get current row

When click on ADF table button on a row not show the current row details in the popup

In this case table selection listener over write and make current property execute in the bean method.
We found the the cause for this issue is the queryListner. We removed below property and found the solution.

queryListener="#{bindings.InterviewVOQuery.processQuery}"

Update - 2017.03.02
------------------------

I have found a solution for this. By removing the QueryListner we are disabling the filler functionality. Therefore we need to set popup content delivery to 'immediate' and partialTrigger the table.

Please follow the below link.
https://blogs.oracle.com/shay/entry/popup_details_for_a_table_reco

Update - 2017.03.14
------------------------
However with above solution we are loosing the filterable feature. Therefore we found the perfect
solution in below blog.

http://dstas.blogspot.com/2010/08/column-button-in-read-only-table-edit.html

ADF Button action listener is not working

>First we need to segregate the issue. For an example, let's say you try to save form data and "Save" button action listener not working.

> Just put the "immediate"  property value to the button. Immediate property submit the form data without consider any Exceptions. In ADF some exceptions, specially required = "true"  exceptions hide behind the components. So we can find out this issue due to any exceptions.

ADF Application Module started but not loading

This is due to JAVA_HOME not exist. However after set the java home correct path in Environment variable and change the java home path in Model and ViewController via IDE,

Then rename the Default domain.