Friday, December 6, 2013

Product images adding in istore setup,employee creation/import, Finding reg id for b2b



How to add images to istore product:

For adding product Images in the istore we have to setup following .
1)      Our application user needs the employee role /or assign one employee to you user.


=================================================================
Employee creation:
Navigation: => Human Resource vision entrprice->people->enter and maintain ->
Enter first and last name with action and DOB and save it.
Employee import process:
CRM Resource manager, Vision Process -->Maintain Resource ->Import resource
Search/or select employee name from LOV and import it.
Add your employee to Application Users “Person” field.

Profile
IBE: Use Add Item Bin

Used to enable the add to cart button in product and item.

How to find the register id of customer / organization:
Navigation: Receivable manager à customer standard à Query with customer name

Here select party number (It is a party Id).

Changing request help page LOV in istore

Navigation :=> Quoting Sales manager -> setup-> Quick Codes

Query with
ASO_SALESREP_ASSISTANCE_REASON

Thursday, December 5, 2013

Custom classpath entry in R12


1)  orion-application.xml

               Path: $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/



<library path="<custom_TOP path>/java/classes" />


2) ojspCompile.properties


        Path: $INST_TOP/appl/admin

  


 <custom_top path >/java/classes

Wednesday, December 4, 2013

Oracle iStore Catalogs are Not Displaying Prices after Patch

11.5.10/12: Oracle iStore Catalogs are Not Displaying Prices after Patch:8875985 (11i) or
Patch:9592589 (R12) [ID 1203984.1]
select owner, type_name,instantiable from all_types where type_name='NUMBERTABLE';
SELECT OBJECT_NAME, OBJECT_TYPE, OWNER, STATUS FROM DBA_OBJECTS
WHERE OBJECT_NAME='NUMBERTABLE';
create or replace type NUMBERTABLE as table of NUMBER;

Check………………..