On selection of a value from dynamic view as a prompt table , we usually face the following error .
An error has occurred which requires that this page be cancelled. (15,4) A previous error message has been displayed showing an error from which the component processor cannot recover.
one of the reason which causes this error is to have two or more table join in SqlText as system is dynamically added the condition of order by clause without alias the column properly and basically column ambiguity cause this error .
Solution :
1. create a view in SqlText
2. Use ExpandSqlBinds(FetchSQL(), );
&acad_career= XMD_PROG_PLAN_V.ACAD_CAREER.Value;
&START_DT = XMD_PROG_PLAN_V.FROMDATE.Value;
&END_DT= XMD_PROG_PLAN_V.END_DATE.Value;
&acad_group= XMD_PROG_PLAN_V.ACAD_GROUP.Value;
&lvl= XMD_PROG_PLAN_V.ACADEMIC_LEVEL.Value;
L_ADD_MAJOR_2.ACAD_PLAN.SqlText = ExpandSqlBinds(FetchSQL(SQL.L_PLAN_SQL), &START_DT, &END_DT, &acad_group, &acad_career, &lvl);
