Thursday, April 14, 2011

XML Bursting exceptions java.io.FileNotFoundException and Debugging

java.io.FileNotFoundException: (No such file or directory)  error fix.

Debugging error.
  1. Check if template used "xdo://AR.XXXXX_TEMPLATE.en.00/?getSource=true" in bursiting has territory assigned. If there is, then change 00 to en(United States)/your corresponding territory.
  2. Check if the name of template in the control file is same as template name
  3. Check the xml grouping defined in the control file select
  4. Check if you have Temporary directory set under Administration Tab --> General.

Tuesday, April 5, 2011

Alert in Oracle Forms for User Response


Step1:

Define alert in forms.



Step2:

Use below code to raise alert.
DECLARE
   al_id       alert;
   al_button   NUMBER;
BEGIN
   al_id := FIND_ALERT ('TEST_ALERT');
   al_button := SHOW_ALERT (al_id);

   IF al_button = alert_button1
   THEN                                          -- Alert_button1 value is OK
      --<<--Your Condition-->>
      NULL;
   ELSIF al_button = alert_button2
   THEN
                                         -- Alert_button1 value is Cancel
      --<<--Your Condition-->>
      RAISE form_trigger_failure;
   END IF;
END;