Oracle Application dicussion and support forum

Registering a table in Oracle Applications 11i Ebusiness suite to be used in Alerts and Flexfields

Flexfields and Oracle Alert are the only features or products that require the custom tables to be registered in Oracle Applications (Application Object Library) before they can be used. Custom application tables can be registered by using the AD_DD PL/SQL Package. If you are planning to use custom tables either in Alerts or in Flexfields, they need to be registered. The following methods describe how you can register the tables.

• ADD_DD.REGISTER_TABLE

ad_dd.register_table ('Application short name', 'EMAIL_TEMPLATES', 'T');

• ADD_DD.REGISTER_COLUMN

ad_dd.register_column (‘Application short name’,
‘EMAIL_TEMPLATES’,
‘EMAIL_TEMPLATE_ID’,–Column
1,–Sequence
‘number’,–type
4,–width
‘N’,
‘N’
);

• Register all the columns one by one . Now you can use these custom table in your flex field definitions and in Oracle Alerts