Techie....me

Long time no see...

I am glad that am getting good visitors for my page and more encouraging comments.

Thanks to all.

I am slowly moving to technical side with my current assignment where I have got lot of assignment in Forms.

I am getting familiar with Forms Personalizations and Customizations, so thought of sharing few challenges I have faced during this assignment.

Oracle Fusion - Documents Link

This is my post regarding Oracle Fusion in this blog, here is the link to Oracle Fusion Applications documentation.

http://docs.oracle.com/cd/E15586_01/index.htm

There are numerous training available for Oracle Partners network (OPN) on Fusion Moudles.

Oracle Applications Upgrade - Data Model Comparison Report

The EBS data model comparison report provides the database object definition changes between two EBS releases to help users to preview the database object definition changes before upgrading their instances from one release to another and understand the impact of the database object changes that may affect the customization or business flows.

Users can select a product and navigate the database object definition differences for each supported database object type.


Please access the metalink note 1290886.1 and get the report downloaded to your PC / Desktop.

The Data Model Comparison Report is available for the below upgrades.

Release 11.5.9 to Release 12.1.3
Release 11.5.10.2 to Release 12.1.3

Release 12.0.4 to Release 12.1.3
Release 12.0.6 to Release 12.1.3

Release 12.1.1 to Release 12.1.3
Release 12.1.2 to Release 12.1.3

12.1.3 - New Delivery Options

In 12.1.3, there is a new feature called 'Delivery options' for the concurrent
program submission.

The output file/report of a concurrent program can be mailed to one or more email ids thorugh this option.

But the below set up is required to make this feature work.

FND: SMTP Host - Set the SMTP Host name at the Site level.
FND: SMTP Port - Set the SMTP Port Number at the Site level.

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.

Oracle iStore - 'How To?' Part 2

Q6. Query to get the Item details associated to a Section.

Select unique (description),
ORDERABLE_ON_WEB_FLAG,
WEB_STATUS
From MTL_SYSTEM_ITEMS_B where inventory_item_id in (select inventory_item_id from IBE_DSP_SECTION_ITEMS where section_id = &Section_Id)

Q7. The Item is not appearing in the iStore UI, What are the parameters to be checked?

Check the Item Web Status and Orderable on web flag in the Item master for the Item that is not appearing in the iStore UI.The Web Status should be “Published” and The Orderable on the Web flag should be enabled.

Q8. Query to get all the Items listed in the minisite.

Select distinct (inventory_item_id), description from mtl_system_items_b
Where inventory_item_id in (select mini_site_section_item_id
From IBE_DSP_MSITE_SCT_ITEMS where mini_site_id = &Minisite_Id);

Q9. Query to get all the Items assigned to a particular section

Select distinct (inventory_item_id), description from mtl_system_items_b
Where inventory_item_id in (select inventory_item_id
From IBE_DSP_SECTION_ITEMS where section_id = 10022);

Q10. How to clear client Side cookies?

Browser: IE (Internet Explorer)

In the Menu, navigate to Tools --> Internet Options --> Click on Delete Cookies and Delete Files options.


Browser: Mozilla Firefox

In the Menu, navigate to Tools --> Options --> Privacy --> Cookies -->Show Cookies --> Remove All Cookies
Tools --> Options -->Privacy --> Private Data --> Clear Now

FND_UNSUCCESSFUL_LOGINS

When ever an unsuccessful attempt was made to login to the application, a record gets inserted in to the table FND_UNSUCCESSFUL_LOGINS.