Oracle Apps Techo-Functional

Tuesday, 16 July 2013

How to Find the Lookup Both Functional and Technical level



Lookups are an approach of creating a configurable “list of values” in E-Business Suite. The main purpose of a lookup is to keep programs flexible and easier to configure.
Finding the Lookups in back end

Select * from Fnd_Lookup_Values;
For example my lookups is 'XXTC_MODEL_ATTRIBUTES'

Select Application_Id, Meaning,Lookup_Type  From Fnd_Lookup_Values where Lookup_Type      ='XXTC_MODEL_ATTRIBUTES';

Now you can find the this lookups comes under in which module
Take application id , query the below query 

SELECT   application_name,  Application_Short_Name,  FAN.application_id
FROM   Fnd_Application FAN,   Fnd_Application_Tl FAT
              WHERE  FAN.application_id   = 401 AND FAN.Application_Id = FAT.Application_Id
ORDER BY   FAN.application_id;
Now you can get Your lookups comes under in which module .
Now you can log on EBS .
Goto particular Module Responsibility 

 

  Then click the Lookups

 

Then query your lookups name in type field ,then you find the lookups details and meaning,if you want update or changes means please update and save it




Wednesday, 10 July 2013

How To Creating The Flex Field - Descriptive Flex Field



Descriptive Flex Field:

Descriptive flex fields lets you add additional fields to the form in order to track additional information needed by the business that would not be captured by the standard form. Descriptive flex fields(DFF) can be context sensitive, where the information your application stores depends on other values your users enter in other parts of the form.
Descriptive flex fields(DFF) define field as Attributes level whether it will be Custom table or standard base   table
ATTRIBUTE 1 to ATTRIBUTE15 and ATTRIBUTE_CATEGORY are the normal field used for Descriptive flex fields(DFF) 

Example, I have described below how to create the Descriptive flex field for MTL_systems_item oracle base table.

Creating the Descriptive Flex field columns for Brand (GL)
Login Oracle E-business
Navigate the Application Developer ->Flex Field -> Descriptive -> Segments 

Navigation - Descriptive Flex Field 
    Click to open the Segments window
 
DFF Segment Window

Click Find icon Menu Bar, Query the Inventory under the title of Items

Once Open the Descriptive Flex field Segment for the Application of inventory.
After then uncheck “Freeze flex field Definition



Press the segment button; it will be list out all Assigned Attributes,then click the new button, to enter the new attribute name and column label it will list out which are the attributes columns are unassigned or free.



Assign the DFF - Attribute column

List out Free DFF Attributes


If you want add Value Set for that Descriptive Flex field attributes means update in value set window or otherwise leave it. Save your work






After then enable the check out “Freeze flex field Definition”. After save, it will show compiling flex field definition and show success compiled




Then you can check whether your DFF added successful or not