To register the table and columns in AOL the navigation is: Open Appliaction Developer---> Appliaction--->Database--->table.(In table mention the table name(which you want to register), user table name,columns,user column name).
The table & columns which you are going to register should be present in your module specific schema.
sandeep Wrote: To register the table and columns in AOL the navigation is: Open Appliaction Developer---> Appliaction--->Database--->table.(In table mention the table name(which you want to register), user table name,columns,user column name).
The table & columns which you are going to register should be present in your module specific schema.
No Sandeep we cant register a table or its column like that. the window you hav mentioned doesnt allow us to enter nething. we can just see all the registered tables and their columns here.
one way which i know to register a table and their columns is thru backend .
Sandeep is right. When you are registering a table or view to AOl, it first be present in your module specific schema. And you should register those table from backened too using AD_DD package if you are using flexfield or alerts on youir tables.
After creating table and registering them from backend, you have to register those table and columns to AOL . Go to application developer responsibility. press CTRL+L it will show all function under that responsibility. Choose register table Enter all information.
After creating table and registering it through back-end using AD_DD package, we are able to view the table defination from application developer responsibility. Navigation: Application>Database>Table.
However we are not allowed to register Table/View/Sequence from front-end screen using Application Developer responsibility.
--i want to register table --- first we have to decide which schema we have to register po-ap-ar login to any schema create table emp(empno number,ename varchar2); login to apps schema create synonym emps for emp; use api to register tableand each column
While register table and column in aol we can use ad.dd package. First create a table and grants to apps and create synonyms that table after that 1.register table:
ad.dd_register_table('po','item','T',10,10,90);
PO:application short name; Item:table name; T: table or view or synonym 10:size 10:unused space; 90:used space;
then register columns. ad.dd_register_column('application_short_name','table_name','index of the column','column_name','size',n,y);
All I have seen is perfect it is called as registeration of table through API You can register a table using inbuild packages like ad_dd.register_table and ad_dd.register_column ex. ad_dd.register_table('appln short name','table name','transaction/seeded') it would be ad_dd.register_table('SQLGL','test_table','T')
