Reporting - EBS (MOSC)

MOSC Banner

Unable to see the LOV for the column in Custom Integrator

Hi,

I have created a Custom Integrator for a Custom table.

Then Added a POPLIST for one of the column using the following command.

UPDATE bne_interface_cols_b
SET val_id_col = 'USER_NAME',
val_mean_col = 'USER_NAME',
val_type = 'TABLE',
lov_type = 'POPLIST',
val_obj_name = 'FND_USER',
val_addl_w_c = '(START_DATE > SYSDATE) AND (END_DATE < SYSDATE OR END_DATE IS NULL)'
WHERE interface_col_name = 'USER_NAME'
AND application_id = 101
AND interface_code = 'GCM_CUSTOM_IMPORT_3_INTF'

When I tried to create document to load the data, I am not able to see the POPLIST which I have attaced to the column (USER_NAME in my custom table also).

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