Link Company Addresses to Address book in Oracle iStore R12 for B2B users

Oracle iStore does not provide the functionality to link company Addresses to Address Book for B2B users. There are few existing Enhancement Requests made on http://metalink.oracle.com to have this functionality. Here we will discuss how to provide solution to them, making company addresses available for B2B users in address book, with access.

The Address book in Oracle iStore display personal addresses for B2B users. To see a personal addresses in the address book, the user has to place an order first using the personal address becuase the address book takes the user’s information from a table which is updated when the user places an order.

When a B2B user registers, the address specified during registration is associated with the company. However when the user logs in, the address book shows only addresses associated with the user and not the company.

It is really nice to have feature for some customer to make end B2B users able access company addresses into Address book so that they modify the address when required.

There are people who search for solution of linking company addresses to Address book for B2B users. Document with ID – 208836.1 on http://metalink.oracle.com says that this functionality does not exist in Oracle iStore.

There are already Enhancement Requests ER #1357606, ER #1873173 on http://metalink.oracle.com for this functionality on Oracle iStore.

Here we will provide solution to implement that functionality to Oracle iStore. We required to change ibeCAddAddrBook.jsp file along with its template from iStore Administration -> Template Manager.

Then pull out Party Site Id into the ibeCAddAddrBook.jsp using LoadControlRec. We can use this Party Site Id to get exact Party Id that in turn we can use to get company Address List. Query the database table to get list of all Company Addresses. Here is some part of the code that would implement this functionality…

/*loadControlRec                       = new CartLoadControlRecord();
loadControlRec.defaultPreferences    = true;
loadControlRec.loadItems             = true;*/

//11.5.11 Setting new control record parameters
loadControlRec.setControl(ShoppingCartConstants.SHIPPABLE, true);
loadControlRec.setControl(ShoppingCartConstants.LINE_SHIPPING, true);
//what about default prefrences????
loadControlRec.setControl(ShoppingCartConstants.LOAD_ITEM, true);
loadControlRec.setControl(ShoppingCartConstants.HEADER_SHIPPING,true);
loadControlRec.setControl(ShoppingCartConstants.PRG,true);
loadControlRec.setControl(ShoppingCartConstants.DEFAULT_PREFERENCE, true);
………
………
………

Displaying all the personal addresses of the user along with this company addresses would make the user able to change the addresses from Address Book itself.

We can use this functionality as solution for the ER requests mentioned above.

For complete solution please mail us at support@ibizsoftinc.com