top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

can we register the table with Application Interface (API) in Oracle Apps?

+3 votes
424 views
can we register the table with Application Interface (API) in Oracle Apps?
posted Nov 10, 2015 by Vidhya Sagar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

We can also register the Table using Application DBA Data Definitions (AD-DD) Package from the Back End. You can also use the AD_DD API to delete the registrations of tables and columns from Oracle Application Object Library tables. To alter a registration you should first delete the registration and then reregister the table or column. You should delete the column registration first, then the table registration.

procedure register_table(p_appl_short_name in varchar2,
p_tab_name in varchar2, p_tab_type in varchar2,
p_next_extent in number default 512, p_pct_free in number default 10,
p_pct_used in number default 70);

Procedure register_column (p_appl_short_name in varchar2,
p_tab_name in varchar2, p_col_name in varchar2,
p_col_seq in number, p_col_type in varchar2,
p_col_width in number, p_nullable in varchar2,
p_translate in varchar2, p_precision in number default null,
p_scale in number default null);

procedure delete_table (p_appl_short_name in varchar2, p_tab_name in varchar2);

procedure delete_column (p_appl_short_name in varchar2,
p_tab_name in varchar2, p_col_name in varchar2);
SQL> ed

Wrote file afiedt.buf

1 BEGIN
2 AD_DD.REGISTER_TABLE(‘PPR’ , ‘PLAN_PARTS’ , ‘T’);
3* END;
SQL> /

PL/SQL Procedure Succesfully Completed.

SQL> ed

Note : Table can be registered from Front End by Application Developer
or Back End by Database Administrator.

answer Nov 12, 2015 by Manikandan J
...