Oracle iStore - 'How To?' Part 3

Q11. How do I find the iStore patch set level?

Select patch_level, status from fnd_product_installations where patch_level like ‘%IBE%’

Status = ‘I’ means Installed, ‘S’ means Shared Install, ‘N’ means Not installed

Q12. How do I find the ASO (Oracle Order Capture) patch set level?

Select patch_level, status from fnd_product_installations where patch_level like ‘%ASO%’

Status = ‘I’ means Installed, ‘S’ means Shared Install, ‘N’ means Not installed

Q13. How to find particular Java Class file version?

Issue the below UNIX command to get the version of the file.
Strings –a | grep ‘Header’
For (e.g.)

Q14. How to enable Debug for Oracle iStore?

Set the below profiles:
IBE: Enable Debug to Yes at User level
ASO: Enable Debug to Yes at User level
OM: Debug level to 5 at user level
OM: Debug log Directory at Site level.
The value for the OM: Debug log Directory should be from any one of the value from the below query
Select value from v$parameter where name like 'utl_file_dir'

Q15. How to I get the generated Java and PL/SQL debug log ?

The PL/SQL log is generated under the directory mentioned in the profile OM: Debug log Directory.
The Java log is generated under the directory [ The java log will be in Mid-Tier/App Node]
$LOG_HOME/ora/10.1.3/j2ee/oacore
ls -ltr IBE*.log
The log file name will have the username part of it.