4 Replies Latest reply on Jul 2, 2013 6:09 PM by INAMIK

    Dynamic Actions Issue on inserting new records

    INAMIK

      Hello,

       

      I'm using APEX 4.1, oracle 11g

       

      I have an application where we can create new patients.

       

      On the create page, i have a text box that the end user can enter the patiend id to get the patients information.

      The id number goes to a table to get first name, last name, dob etc then fills out the items on the page.

      From there the end user has the option to add comments about a patient, then click CREATE to create the record.

       

      The problem i'm having is, the fields that are populated from a dynamic action are not being inserted into the table, when they click create.

       

      I'm using dynamic actions to populate certain fields for a patient.

      I use an EXECUTE PL/SQL CODE to set the items.

       

      Example.

       

      begin

       

       

      select pat_id, first_nm ,last_nm,dob)

      into :P2_PAT_ID,:P2_FIRST_NM,:P2_LAST_NAME,:P2_DOB

      from patient_demographics

      where pat_id = :P2_PAT_ID_SEARCH;

       

      end;

       

      For PAGE ITEMS TO SUBMIT: i use P2_PAT_ID_SEARCH

       

      For PAGE ITEMS TO RETURN i use: P2_PAT_ID,P2_FIRST_NM,P2_LAST_NAME,P2_DOB

       

       

      When i run the search and find a patient, it populates the fields correctly.

      When i look at the items in the session, the values are correct for the page-items and session state.

       

      But when i create the record, i these fields are blank.

       

      The page items were item type DISPLAY ONLY

      I changed them to TEXT-FIELDS but disabled, and that didnt work.

       

      If i change them to TEXT-FIELDS and leave them editable it works.

      But i don't want the end user to edit these fields, i want the data to come from our demographics table.

       

      Any ideas on what could be causing this issue?