Friday 6 September 2013

How to enable record history in Oracle custom form

Step1 :

The below is the Oracle  custom form, When we click on record history getting error as record history is not available here


Step 2 :

Alter the custom table by adding who columns.

alter table
      XXXXXXXXXXXXXXXXXX
add   (CREATION_DATE        DATE,
       CREATED_BY           NUMBER,
       LAST_UPDATE_LOGIN    NUMBER,
       LAST_UPDATED_BY      NUMBER,
       LAST_UPDATE_DATE     DATE
       )

Step 3 : Go to the forms builder and select the FMB.



             Then click on Data Block and Refresh  

Step 4 :  Select the new added Who columns
               

 Step 5 : 

Select PRE-INSET and PRE-UPDATE triggers and then  add

FND_STANDARD.SET_WHO;

Setp 6 :

 Compile the FMX and here you go :)




         

            
              

 

No comments:

Post a Comment