Oracle Apps Quick Reference

This BLOG might be helpful for oracle application beginners and technical developers. The BLOG post’s screen shots & source codes may distinguish from versions. If the code/steps fail please check with oracle guides or meta-links.

Tuesday, March 22, 2011

How to find the backend SQL query from Self Service / OAF pages in Oracle Applications?

Update the following Profile Option Values to Yes at User level. FND: Diagnostics Personalize Self-Service Defn (For an Example) Sup...

Thursday, March 17, 2011

Error: Element Not Found

In R12 applications, few BUTTONs maynot be performed well. (on self service pages.) Line XXXX Char X Error: Element not found. Code: 0 ...

How to restrict a user to one inventory organization?

Navigation Inventory > Setup > Organization > Organization Access Defining Organization Access You can specify which organiz...

Wednesday, March 16, 2011

How to get the Distinct Values in TABLE Value set?

Method 1 Create the VIEW based on DISTINCT values; use the VIEW for creates the VALUESET. Method 2 Paste the QUERY in TABLE field with...

Friday, March 11, 2011

FRM-40831: Truncation Occurred: value too long for field XXXXX

FRM-40831: Truncation Occurred: value too long for field XXXXX Cause: 1. Form field length and database column length may not be same. ...

View web version

About Me

Sankar Balu: Chennai, Tamil Nadu, India

View my complete profile

Powered by Blogger.