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)
How to assign NULL to item_catalog_group_id in mtl_system_items_b [message #574412] Thu, 10 January 2013 02:36 Go to next message
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
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 Go to previous message
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.
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:
  


Current Time: Thu Mar 28 17:20:51 CDT 2024