Reporting - EBS (MOSC)

MOSC Banner

Create a LOV in WebADI using an API Issue

Create a LOV in WebADI using an API       

Using the below API for the same.  

DECLARE

a NUMBER;

BEGIN

BNE_INTEGRATOR_UTILS.CREATE_TABLE_LOV                                  

      (P_APPLICATION_ID       => 101,                                      

      P_INTERFACE_CODE       => 'GL_INTERFACE_120',                           

       P_INTERFACE_COL_NAME   => 'ATTRIBUTE7',                               

       P_ID_COL               => 'VENDOR_NAME',

       P_MEAN_COL             => 'VENDOR_NAME',   

       P_DESC_COL             => 'VENDOR_NAME',                                     

        P_TABLE                => 'AP_SUPPLIERS',                            

       P_ADDL_W_C             => null,               

       P_WINDOW_CAPTION       => 'SUPPLIER',

       P_WINDOW_WIDTH         => 400,                                      

       P_WINDOW_HEIGHT        => 300,                                      

       P_TABLE_BLOCK_SIZE     => 10,                                       

       P_TABLE_SORT_ORDER     => 'ascending',                              

       P_USER_ID              => 2);   

       EXCEPTION

       WHEN OTHERS THEN

       dbms_output.put_line(SQLERRM);

       END;

   But the LOV is getting populated with Blank values

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center