Register table and Columns to AOL

To register the table and columns in AOL the navigation is: 

There is no way to register table and columns in AOL via front end.

To register table and column in AOL you can use the below API called ad.dd package.

First create a table and grants to apps and create synonyms that table after that.

1.register table:-

Syntax and Example : 

 ad.dd_register_table('application short name',
                                   'table name',
                                   'table or view or synonym',
                                    'size'
                                    ,unused space'
                                    ,'used space');
COMMIT
/

2. Register columns :-

Syntax and Example :

ad.dd_register_column('application_short_name',
                                      'table_name',
                                      'index of the column',
                                      'column_name',
                                      'size',
                                       N,
                                       Y);

COMMIT
/

3. Check registered table and Columns :- 

A. You can use the below queries to check the registered columns :-

  select table_id  --into p_table_id
    from  fnd_tables
    where 1=1--application_id = p_apps_id
      and table_name = 'TABLE_NAME';

select * 
from fnd_columns 
where table_id = p_table_id;

Or

B.navigate to the below tab :-

Open Appliaction Developer---> Appliaction--->Database--->table.(In table mention the table name(which you want to query), user table name,columns,user column name).