Monday, May 19, 2014

Table registration script for Oracle Applications

Below scripts help you to registering the custom table with Oracle Application using AD_DD package, to develop Descriptive flexi fields or Web ADI, or OAF Personalization’s, etc.,  on custom table the table must be registered with Oracle applications

The API AD_DD package validates the table schema then it will insert one record in FND_TABLES for each table and one record in FND_COLUMNS for each columns

After you run the script you can verify your table is registered or not by running a select query on FND_TABLES and FND_COLUMNS tables.

DECLARE

 

 lv_table_name        VARCHAR2(100)  :='&Table_name';--'XXPO_EMP_INT';

 lv_application       VARCHAR2(10)   :='&_table_apps_name';--'XXZZPAY'  ;

 

BEGIN

 

  AD_DD.REGISTER_TABLE(p_appl_short_name  => lv_application

                      ,p_tab_name         => lv_table_name

                      ,p_tab_type         => 'T');

 

  COMMIT;

 

  FOR  i IN (SELECT table_name

                   ,column_name

                   ,column_id

                   ,data_type

                   ,data_length

                   ,nullable

                   ,'N' translate

             FROM  dba_tab_columns

             WHERE table_name=lv_table_name)  LOOP

 

    ad_dd.register_column (p_appl_short_name    => lv_application

                          ,p_tab_name           => i.table_name

                          ,p_col_name           => i.column_name

                          ,p_col_seq            => i.column_id

                          ,p_col_type           => i.data_type

                          ,p_col_width          => i.data_length

                          ,p_nullable           => i.nullable

                          ,p_translate          => i.translate);

 

  END LOOP;

  COMMIT;

END;

IF you like this article, please comment or follow the blog.

Monday, May 5, 2014

How to enable tracing for WEBADI

It’s very difficult track, and sees what went wrong when working on Web ADI either it is custom layout or it is custom integrators.

1)      First below 3 profile options need to be set

BNE Server Log Filename              : BneLogger.log (make sure it doesn't exist and if it does, delete it)
BNE Server Log Level                      : TRACE
BNE Server Log Path                       : free to choose, enter your own path

If you want to debug, track development errors then you must set below

BNE Server Log Filename              : BneLogger.log (This value is default, don’t change)
BNE Server Log Level                      : Statement
BNE Server Log Path                       : Normally /tmp value exists, if you want to change you can change your own.

2)      Bounce/restart Apache

3)      Create your document

If you have already created menu, and separate function for the document open function, and create some records and try to upload till you replicate the issues.

4)      Now it view to log file, You can refer other post Easy way to   Oracle Web ADI View Log, clear log

5)      Once you have done your work, just change your profile value  BNE Server Log Level : INFORMATION “ level to avoid the growth of the BNELogger.Log

Please post your comments, if you like it