Urgent: Category Set/ Category assignment to User
Posted: 28 July 2005 01:40 PM
Total Posts:  3
Joined  2005-06-23

Hello All,

I have a situation where category set/category needs to be assigned to an user so that at the time of creation of PR/PO he has access to the items belonging to that category/category set.

Plz Suggest.Any idea will be of great help.



S[color=green] Das[/color]

Posted: 05 August 2005 04:50 PM   [ # 1 ]
Total Posts:  6
Joined  2005-06-02

Is it for Core Purchasing or for iProcurment.

For iProcurment the solution is as follows.

Not sure if the functionality would work in a similar fashion for Core Purchasing also.

Using the Purchasing Super User responsibility navigate to the form Setup ->E-Catalog Admin -> Realms.

Here define a Realm with Component type as Category at the header level. Save the header and note down the Realm ID assigned by the system

At the compnents level you would get all the categories that you had defined. You could assign as many categories as required.

Save the records.

Go to System Admnistrator responsibility and open the form Users (if you need to restrict the set of category to a User) or responsibility (if this is meant for users with a particular responsibility).

Retrieve the User (for eg:OPERATIONS) and click on the “Securing Attributes” tab .

Here select the ICX_POR_REALM_ID securing attribute and enter the Realm_Id that you had noted down in the earlier setup step.

Again,Please note that this would work well with iProcurement.


Posted: 05 August 2005 08:52 PM   [ # 2 ]
Total Posts:  3
Joined  2005-06-09

HI as Deva said it will work in IP only and not in PO forms
attention you have to add 2 lines in User or in responsability form, the ICX_ is not enough
if needed I can research the second line
BR Richard

Posted: 08 May 2006 11:19 PM   [ # 3 ]
Total Posts:  2
Joined  2004-09-16

Applying Realms to Users and Responsibilities:
Security is applied at the responsibility level using the values obtained from individual users.

Security realms consist of either item sources or categories, but never both in the same realm. At the responsibility level, select whether to restrict access to categories, item sources, or both by selecting from the following securing attributes:

RT_CATEGORY_ID (for categories).
ICX_POR_ITEM_SOURCE_ID (for external item sources such as TPN Register).

At the user level you must choose the securing attribute ICX_POR_REALM_ID and supply the list of Realm IDs to which you are granting access to users. This list can contain both item source restricted realms and category restricted realms.

When a Internet Procurement 11i user chooses a function tied to a responsibility, a security check is performed to identify the securing
attributes tied to the responsibility. If item sources are being restricted, only the item sources in the realms assigned to the user are displayed to the

If the user has access to the internal catalog and searches for items, only those categories and relevant included items listed in the realms assigned to the user will be displayed. For example, assume that the user has access only to the ?pens? category. If the user searches for ?office supplies,? pens, pencils, rulers, and so on from multiple categories are returned. But the user will see only the items belonging to the ?pens? category.

Note that you can select only one component at a time for inclusion in the components list for the realm. You cannot exclude components.


Posted: 15 May 2007 09:12 PM   [ # 4 ]
Total Posts:  11
Joined  2007-03-17


If it is for core purchasing you can use category people to restrict the items.

I think this will definetely work.

Please post your comments.



Arun Reddy,
Oracle Apps Techno Functional Consultant,
Mindscape IT,Masherq Bank,Dubai
.(JavaScript must be enabled to view this email address).

Posted: 16 October 2007 06:21 AM   [ # 5 ]
Total Posts:  5
Joined  2007-10-02

assigning category people to a category set works fine but the only function available for category people in core purchasing is sales reports and doubt if while creating PO user would get all the access he wants.