Table Registration in Oracle apps

Reg for Table

1. EXEC AD_DD.REGISTER_TABLE('PO','XXX_STUDENT','T',8,10,90);

Here

PO:- application short name

XXX_STUDENT is table name

T/V  table type or view type

8- next extend value

10 - Percent free storage parameter

90-percentage used storage parameter

Note: first 3 parameters are mandatory..

Reg for column

1.  EXEC AD_DD.REGISTER_COLUMN('PO','XXX_STUDENT_CHILD','SNO',1,'NUMBER',20,'N','Y');
2. EXEC AD_DD.REGISTER_COLUMN('PO','XXX_STUDENT_CHILD','SNAME',2,'VARCHAR2',20,'N','Y');

Here

PO:- application short name

XXX_STUDENT is table name

SNO     - column Name

1  - serial no of columns

NUMBER or VAR or DATE   - data type of column

20 -- size of column...if date means must 11 size only

N- Not Null values

Y - it translate in multi language used