OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » How to assign NULL to item_catalog_group_id in mtl_system_items

Home » Applications » Oracle Fusion Apps & E-Business Suite » How to assign NULL to item_catalog_group_id in mtl_system_items_b (EBS 12.1.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to assign NULL to item_catalog_group_id in mtl_system_items_b [message #574412]

Thu, 10 January 2013 02:36

knsreedevi
Messages: 25
Registered: May 2012
Location: Bangalore

Junior Member

Hi All,

I have an item which has the catalog information, i.e. not null item_catalog_group_id already in place.
Now the requirement is to remove this information and make it NULL.
But not able to achieve this using the ego_item_pub.process_items API.

Can anyone provide some pointers.

Regards,
Sreedevi

Report message to a moderator

Re: How to assign NULL to item_catalog_group_id in mtl_system_items_b [message #574416 is a reply to message #574412]

Thu, 10 January 2013 03:43

knsreedevi
Messages: 25
Registered: May 2012
Location: Bangalore

Junior Member

I see the below assignment in the ego_item_pub package spec
G_INTF_NULL_NUM CONSTANT NUMBER := 999000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000;

But after using G_INTF_NULL_NUM also the catalog information is not removed.
The version we currently using is EGOPITMS.pls 120.21.12010000.6.

Report message to a moderator

Previous Topic:	Adding printer in Oracle EBS R12
Next Topic:	Huge Difference between Balance as per General Ledger & Balance as per Bank Statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 20 13:23:39 CST 2025