Wednesday, January 15, 2014

How to Register Table in Oracle Apps?



How to Register Table in Oracle Apps


         Step 1:-   Create table in Apps Schema.
                
                         Create Table XXC05_TEST_TAB(ID NUMBER(6), FNAME VARCHAR2(20));    

        Setp 2:- Execute below code.

             A)- EXECUTE AD_DD.REGISTER_TABLE('SQLGL','XXC05_TEST_TABLE','T',8,10,90);

             B)- EXECUTE AD_DD.REGISTER_COLUMN('SQLGL','XXC05_TEST_TABLE','ID',1,'NUMBER'V,6,'N','N');


             C)- EXECUTE                    AD_DD.REGISTER_COLUMN('SQLGL','XXC05_TEST_TABLE','FNAME',2,'VARCHAR2',20,'N','N');


     Now See In Front End

       Application Developer -> Database -> Table

     Query in Table XXC05_TEST_TAB;


No comments:

Post a Comment