Thursday, October 17, 2013

Oracle iProcurement REALM (11i)




Oracle iProcurement REALM is nothing but a definition of Rules. You can group Item categories under a REALM and attach the REALM at user or responsibility level using Securing attribute ICX_POR_REALM_ID.

Information on the implementation guide is enough to understand this feature.

Below are the ones that are not mentioned in the document.

1. REALM are effective only for Catalog items, Non catalog items will not get restricted by the REALM.
2. You need to bring the Item categories to define it in REALM screen through
E-Catalot Admin --> Loader Values. This submits a concurrent program which will load the Item categories which can be used in the REALM screen.

Back with a Bang....

It has been almost a year since I wrote my last blog...

Please watch my space for more posts soon on Financials.  You can always suggest me a topic on what you are looking for.

Thanks to the followers of my blog.


Thursday, November 15, 2012

Know applcust.txt

The $APPL_TOP/admin/applcust.txt file should be used to register your customization and being used as a reference while applying patches.

There are two ways of doing a customization

Customization by Extension (CBE)
Customization by Modification (CBM)

Customization by Extension (CBE) is nothing but doing customizations to copies of the original Oracle applications files.
Customization by Modification (CBM) is doing the customizations directly in the Oracle applciations files. It is difficult to maintain

There is a format to be followed while registering your customization

# <Sprd>  <Src Dir>  <Src Fname>  <Dprd> <Dest Dir> <Dest Fname>

It is easier to understand the format with an example.Consider that the file $AR_TOP/forms/US/ARXSUVAT.fmb has been modified in the method CBE as $XXAR_TOP/forms/US/XXARXSUVAT.fmb

<Sprd> is nothing but the Standard product abbreviation. In simple meaning the Sprd is taken using the format $<Sprd>_TOP.
<Src Dir> is always whatever after $<Sprd>_TOP, in our case it is forms/US
<Src Fname> is the exact file name.
<Dprd> is your custom top where you have your customized/modified file.
<Dest Dir> is the directory structure after $<Dprd>_TOP
<Dest Fname> is the name of your custom file.

So in our example case, the format of the entry will be as follows
# ar  forms/US    ARXSUVAT.fmb   xxar    forms/US    XXARXSUVAT.fmb

If you have customized your file in the CBM method, then you can leave the last three entries as blank (as below)

# ar  forms/US    ARXSUVAT.fmb

The applcust.txt is replaced by Register Flagged Files Tool in R12. Register Flagged Files tool can be accessed through Oracle Applications Manager (OAM) responsibility in R12.

Interesting Features of OAF RUI - R12.1

Below are the profile options introduced as part of R12.1 which give rich User Interface experience to the end users.

FND: Disable Configurable Home
Determines whether the Configurable Home page is enabled or disabled. Valid values are:
  • True - Disables the Configurable Home page.
  • False - Enables the Configurable Home page.
Default Value : False as Site Level

FND: Disable Navigator and Favorites Rich Menu
Determines whether the Navigator and Favorites Pull-down Menus feature is enabled or disabled. Valid values are:
  • True - Disables the Navigator and Favorites Pull-down menus.
  • False - Enables the Navigator and Favorites Pull-down menus.
Default Value : False as Site Level

FND: Disable Look Ahead LOV


Determines whether the Look Ahead LOV feature is enabled or disabled at the Site or Application level. Valid values include:
  • false - Look Ahead LOV feature is enabled.
  • true - Look Ahead LOV is disabled.
Default Value : False as Site Level


When Set to False, the system suggests the values as you type.

FND: Disable Inline Attachments


Determines whether the Inline Attachments feature is enabled or disabled at the Site or Application level. Valid values include:
  • false - Inline Attachments is enabled.
  • true - Inline Attachments is disabled.
Default Value : False as Site Level
This option eliminates the navigation between pages. As shown in the screenshot, the attachment can be added through a pop up like page, also through the similar pop up page it can be viewed.

Saturday, October 6, 2012

Oracle iStore - Copy Sales Order to User Cart

In Oracle OTN forum, one user has posted the below interesting requirement on Oracle iStore module.

How to copy a Sales Order to a Shopping cart?

The user was expecting something like copy cart feature provided by Oracle iStore. Because the Sales order has configured item that user is planning to order in different times and they are not ready to use shopping list feature as they are not sure for which sales order they are going to repeat the order.

So below were my suggestion to the user for customization,

User have Sales Order number with him. Through Sales order, the corresponding Quote Number/Quote Header Id can be obtained.

ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID is nothing but OE_ORDER_HEADERS_ALL.SOURCE_DOCUMENT_ID.


We have oracle provided API to copy quote ASP_QUOTE_PUB.COPY_QUOTE. This API can be used to create a new quote from the existing quote.

So the new quote/cart is created for the user, but the quote/cart is getting saved in to the saved cart and not becoming the active cart.

For a user, to get a active cart there should be a row in the table IBE_ACTIVE_QUOTES_ALL table with reference to the particular quote_header_id in the table ASO_QUOTE_HEADERS_ALL.


IBE_ACTIVE_QUOTES_ALL is used to store the current active cart of a user. 
The user is identified by party_id and cust_account_id referring HZ_PARTIES and the active cart is identified by the quote_header_id referring ASO_QUOTE_HEADERS_ALL. This is an org striped table. Primary key is a combination of party_id, cust_account_id and org_id 

So suggested the user to insert a record in the IBE_ACTIVE_QUOTES_ALL table with reference to the quote created through the ASO api. Once this is done, User was able to see the created cart as active cart in the customer UI.

I will soon share the full API 

Here is the link the forum thread  

Journeyer in OTN Forums

Glad to share this with the blog readers.....

Became a Journeyer in Oracle Technology Forum :)

Here is my profile at OTN

I have been contributing for this OTN forum for more than a year now. I use Solution beacon instance to work out issues posted by the users.

My main focus areas in OTN are Oracle iStore, Procurement, Financials and OA Framework related questions.

Sunday, September 9, 2012

How to restrict the user from forwarding the approval notifications to other users?

Login as admin
2. Click System administrator --> Oracle Application Manager --> workflow
5. Clcik on Notification Mailers --> Edit --> Advanced --> Email Servers
6. click "edit"
7. Uncheck "Allow Forwarded Response" which will restrict the user to respond by e-mail to an e-mail notification that has been forwarded from another role.