EBS Customizations (MOSC)

MOSC Banner

EGO_ITEM_PUB not working

edited Mar 3, 2019 10:35AM in EBS Customizations (MOSC) 1 commentAnswered

HI Guys,

When I am running following code from Oracle Applications, its not working but within PL/SQL, it works fine:

--select * from fnd_user where upper(user_name) like '%ALI%S%';

DECLARE

   l_item_tbl_typ                               ego_item_pub.item_tbl_type;

   x_item_tbl_typ                               ego_item_pub.item_tbl_type;

   x_return_status                              VARCHAR2 (100);

   x_msg_count                                  NUMBER;

   x_message_list                               error_handler.error_tbl_type;

BEGIN

   fnd_global.apps_initialize (20081--21752

                            , 51886

                             , 401

                             );

   l_item_tbl_typ (1).transaction_type := ego_item_pub.g_ttype_update;

   l_item_tbl_typ (1).inventory_item_id := 960614;

   l_item_tbl_typ (1).organization_id := 172;

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