This discussion is archived
1 Reply Latest reply: Dec 4, 2012 2:01 AM by Tauceef RSS

Error in Tabular form after validation execution

Tauceef Journeyer
Currently Being Moderated
Hello Everyone,

I have a tabular form created using wizard.

I also have a validation defined on a item of the same page, when that validation gets fired(shows error)

my tabular form is showing error:
report error:
User-Defined Exception
I have disabled all the validations created for the tabular form, also I have MRU for the tabular form as said by Patric in the below post:

Validation on Tabular Form Fail with "User-Defined Exception"

when I debug my page, it showing this error:
          show report
          determine column headings
          activate sort
          parse query as: TAF
          ...Execute Statement: select NULL "ID_DISPLAY", to_number(:"P207_SERVICE_CLASS") "SERVICE_CLASS", NULL "SERVICE_TYPE", NULL "DESCRIPTION", NULL "COST_TYPE2", NULL "SERVICE_P.A", to_number(:"G_MID") "STR_ID", NULL "DATE_CREATED", NULL "DATE_MODIFIED", NULL "USER_CREATED", NULL "USER_MODIFIED", NULL "FIX_AMOUNT", NULL "SERVICING_COMPANY", NULL "ROLE_OF_SERVICE_PROVIDER", NULL "SENIORITY", NULL "LOCATION", NULL "TAF_DEFAULT", NULL "ADJUSTED", NULL "FROM_DATE", NULL "UNTIL_DATE", NULL "COST_TYPE", NULL "ID", NULL "APEX$ROWID" from dual union all select "ID_DISPLAY", "SERVICE_CLASS", "SERVICE_TYPE", "DESCRIPTION", "COST_TYPE2", "SERVICE_P.A", "STR_ID", "DATE_CREATED", "DATE_MODIFIED", "USER_CREATED", "USER_MODIFIED", "FIX_AMOUNT", "SERVICING_COMPANY", "ROLE_OF_SERVICE_PROVIDER", "SENIORITY", "LOCATION", "TAF_DEFAULT", "ADJUSTED", "FROM_DATE", "UNTIL_DATE", "COST_TYPE", "ID", "APEX$ROWID" from (select "ID", "ID_DISPLAY", "SERVICE_CLASS", "SERVICE_TYPE", "DESCRIPTION", "COST_TYPE2", "SERVICE_P.A", "STR_ID", "DATE_CREATED", "DATE_MODIFIED", "USER_CREATED", "USER_MODIFIED", "FIX_AMOUNT", "SERVICING_COMPANY", "LOCATION", "FROM_DATE", "UNTIL_DATE", "COST_TYPE", "ROLE_OF_SERVICE_PROVIDER", "SENIORITY", "TAF_DEFAULT", "ADJUSTED", "ROWID" "APEX$ROWID" from ( select "ID", "ID" ID_DISPLAY, "SERVICE_CLASS", "SERVICE_TYPE", "DESCRIPTION", "COST_TYPE2", "SERVICE_P.A", "STR_ID", "DATE_CREATED", "DATE_MODIFIED", "USER_CREATED", "USER_MODIFIED", "FIX_AMOUNT", "SERVICING_COMPANY", "LOCATION", "FROM_DATE", "UNTIL_DATE", "COST_TYPE", "ROLE_OF_SERVICE_PROVIDER", "SENIORITY", "TAF_DEFAULT", "ADJUSTED" from "TAF"."TAB_BI_INDIVIDUAL_FEE" where SERVICE_TYPE = :P207_SERVICE_TYPE and SERVICING_COMPANY = :P207_SERVICING_COMPANY and STR_ID = :G_MID and COST_TYPE = :P207_COST_TYPE and ("ROLE_OF_SERVICE_PROVIDER" is not null or "SENIORITY" is not null or "TAF_DEFAULT" is not null or "ADJUSTED" is not null)) APEX$RPTSRC order by 2, 23)

                Rename quoted bind "P207_SERVICE_CLASS" to "p$_quoted_bind_1"
          Rename quoted bind "G_MID" to "p$_quoted_bind_2"
          print column headings
          rows loop: 10 row(s)      
          ...Execute Statement: begin begin SELECT SERVICING_COMPANY_NAME d,SERVICING_COMPANY_ID r bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value FROM CRM_SERVICING_V WHERE mandate_id = :G_MID; end; end;
          ...Execute Statement: begin begin select NAME d, ID r bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value from CRM_ROLE_V order by 1; end; end;
          ...Execute Statement: begin begin select NAME d, ID r bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value from CRM_SENIORITY_V order by 1; end; end;
          ...Execute Statement: begin begin select NAME d, ID r bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value from CRM_COUNTRY_V order by 1; end; end;     
          ...Execute Statement: begin begin SELECT SERVICING_COMPANY_NAME d,SERVICING_COMPANY_ID r bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value FROM CRM_SERVICING_V WHERE mandate_id = :G_MID; end; end;
          ...Execute Statement: begin begin select NAME d, ID r bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value from CRM_ROLE_V order by 1; end; end;
          ...Execute Statement: begin begin select NAME d, ID r bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value from CRM_SENIORITY_V order by 1; end; end;     
          ...Execute Statement: begin begin select NAME d, ID r bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value from CRM_COUNTRY_V order by 1; end; end;
          report error: User-Defined Exception
not able to get anything from this also.

How to resolve this?


Apex Version: 4.1.1.00.23
Oracle DB: 11gR2

Regards,
Tauceef

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points