Oracle AOL

Oracle Applications : Steps for Creating New Operating Unit in a multi org set up.

Posted by Jiltin     Tags: 28 May, 2009    7,880 views    (2) Comment

Following are the steps to be performed while creating a new company setup.  Multi Org is already installed .  The below steps apply when new Operating unit needs to be added which will use same operating unit and same Set of Books. What is a set of books (11i) or Ledger (12R)? This is the logical entity (a company) reporting tax to the Government. This is mainly for the federal government or Union Government of the country. Operating Unit is basically a logical division or sub-division of Read Full Article (Click here)...

Categories : Oracle AOL, Oracle Applications Tags :

Oracle Applications : Descriptive Flexfields Overview and the SQL to find the Columns & Details.

Posted by Jiltin     Tags: , 18 May, 2009    3,409 views    (0) Comment

Descriptive Flexfields Descriptive flexfields let you satisfy different groups of users without having to reprogram your application, by letting you provide customizable “expansion space”? on your forms. For example, suppose you have a retail application that keeps track of customers. Your Customers form would normally include fields such as Name, Address, State, Customer Number, and so on. However, your form might not include extra fields to keep track of customer clothing size Read Full Article (Click here)...

Categories : Oracle AOL, Oracle Applications Tags : ,

Oracle Applications : Descriptive Flex Field FAQs

Posted by Jiltin     Tags: , 18 May, 2009    6,003 views    (1) Comment

Question: What does DFF mean? Answer: DFF is a mechanism that lets us create new fields in screens that are delivered by Oracle. Question: Can these new fields be added without modifying/customization of the screen?. Answer: Yes, certainly. Only some setup is needed, but no programmatic change is needed to setup DFF. Question: Why the word Descriptive in Name DFF? Answer: I think Oracle used this terminology because by means of setup…you are describing the structure of these new fields. Read Full Article (Click here)...

Categories : Oracle AOL, Oracle Applications Tags : ,

Oracle Applications: Submitting Concurrent Request Using FND_CONCURRENT.WAIT_FOR_REQUEST Sample Code

Posted by Jiltin     Tags: , 15 May, 2009    9,019 views    (0) Comment

When submitting concurrent requests using PL/SQL, it is often desired to have the parent process wait until all the child processes have completed before completing itself. The following describes the function used to accomplish this. Refer Metalink 1021956.6: The following describes how to submit concurrent requests using PL/SQL and have the parent request ‘wait’ until each of the child processes have completed before it completes. Use the FND_CONCURRENT.WAIT_FOR_REQUEST Read Full Article (Click here)...

Categories : 11i Scripts, Oracle AOL Tags : ,

Oracle Applications: Production to Development Refresh/Clone Parameter Change SQL Script.

Posted by Jiltin     Tags: , 12 May, 2009    2,901 views    (1) Comment

Big companies that follow Process oriented project management team, with multiple projects executed at phased manner, may face challenges during database refresh from production system to development or test systems. Many programs customized to connect to external systems such as lockbox servers, payment processing servers and other boundary server systems. After every refresh, it is imperative to change the development systems to point to null or Development external test servers instead Read Full Article (Click here)...

Categories : 11i Scripts, Oracle AOL, Oracle Applications, Scripts Oracle Tags : ,