How to enable a DFF?

To enable DFF switch responsibility to Application DeveloperFlexfield à Descriptive à SegmentsSupply the title and query the form. Uncheck the checkbox called FREEZE FLEXFIELD DEFINISION and click on Segments button. Describe the fields you want to display in DFF in the below form.In the above form Value Set button is to create a new value set if...

Read More

How to find the DFF Name

Go to Help in Menu Bar -->Diagnostic --> ExamineEnter Oracle Password: APPSBlock Name: $Descriptive Flexfields (Change the field like this)Field: PPRS FLEX (OR)Go to Help in Menu Bar --> Record HistoryPO_HEADERS_V is the view name and the corresponding table name is PO_HEADERS_ALLGo to Application DeveloperFlex Field --> Descriptive -->...

Read More

Descriptive Flex Field - DFF

--------------Flexfield are made up with Attribute columns or Segment columns which are more flexible than the normal fields.We have two types of flexfields1) DFF (Descriptive Flex Field)2) KFF (Key Flex Field)DFF: DFF are used to capture the additional or extra Business information of the organization. DFF are used to add extra accounts, these are...

Read More

Multi Organization

The ability to define multiple organizations and the relationships among them within a single installation of Oracle Applications is called multi organization. Multi Organization is the future used to store the data of multiple organizations in a single Database.The main components of the multi organization are1) Business Group (BG)2) Legacy Entity3)...

Read More

Profiles

Profiles are used to determine the behavior of Oracle Application Forms and Programs. The registration information of all the users will be stored in FND_PROFILES_OPTION table. The dictionary of all the Profile Options is maintained by AOL module. To set the values of the Profile Options, we use System Administrator Module. Profile Options are used...

Read More

Form Development Libraries

To enable the end user to operate the Forms user friendly we need to standardize the Forms. To design or develop the form with Applications Standards, Package provided a Standard Form called APPSTAND.fmbAPPSTAND.fmb: is a collection of the entire standard object Groups used in the Oracle Applications. Form should inherit the following object Group...

Read More

Display the Message Boxes in the Forms

1)Create the Message in Application Developer2)Run the Concurrent Program called "Generate Messages" by passing language code and as well as application name3)Call the message from form triggers by using FND_MESSAGE API's.beginFND_MESSAGE.SET_NAME ('PO', 'NEW MESSAGE');fnd_message.show();e...

Read More

Calling SRS Window from Menu

1)Create the Function for the User form name called "Run Reports" 2)Attach the Function to the menu. 3)Attach the menu to the responsibility so that user can call the form from the me...

Read More

Attach the Request group to the SRS Function

1)Create the Request group in System administrator by specifying the request group code Copy the Request group name application short name request group code 2)Goto the Appllication developer create the fucntion for the user form name called " Run Reports"3)Pass the follwoing Parameters while creation of the function.REQUEST_GROUP_CODE="CUSTOMERCODE1"...

Read More

Hiding the forms and Menus at Responsibility level

1)Open the Responsibility Form attach the menu2)By default we will get all the forms and as well we menus will be displayed.3)Select the Tab called Menu Exclusions Tab Select the type = Function to hide the funtion. select the type = Menu name to hide the me...

Read More

Passing Parameters at the time of creating Functions

1)Develop the form2)Register the form3)Create Two functions for the same form. first function without parameters second function is with parameter called 'QUERY_0NLY="YES" 'enter the paraneter in the field called Parameter fie...

Read More

SubMenu Creations

1)Copy the Functions whatever we would like to define as submenu delete from the main menu.2)Create new menu and attach the functions whatever we have copied.3)Copy the menu whatever we have created attach to the main menu by selecting the field called subme...

Read More

Attach the LOV to the form

1)Define the Record Group Either Static Values or By using the Query 2)Create LOV and attach the Record Group 3)Attach the LOV to field in the property called list of Valu...

Read More

Implementation of WHO Columns in forms

1)Select All the WHO Columns in the Datablock2)define following Two Triggers at DataBlock level1)Pre-Insert 2)Pre-Update3)Call the following API from both the Triggers FND_STANDARD.SET_WHO():Standard Libraries Contains all these API's.we can download all these Libraries from Resource folder in AU_TOP.APPDAYPK : It will Support for All CAlendar and...

Read More

Attach Calendar in forms

1)Select the Field properties and select the property called List of Values : ENABLE_LIST_LAMP 2)Goto the Item level Trigger called KEY-LIST-VAL trigger call the following API CAlendar.Show...

Read More

Master Detaild Form Development

)Develop the from by using TEMPLETE.fmb 2)Develop the Master Block and create the fields. 3)Attach the Property classes and other customization steps. 4)Create Detail Datablock by selecting the Detail columns after selecting the columns select the next button 5)Uncheck the check box called Auto join Datablocks select the button called Create Relationship...

Read More

Implement Radio Buttons

1)Define the Radio Buttons2)Under Same Group3)Attach following Properties1)SubClass Information = Radio Button2)Label =Whatever the Name we would like to display3)Radio Button Value =whatever value we want to insert into Column4)Goto Object Navigator Select Radio Group Proiperties5)Attach following Properties1)SubClass Information = Radio Group 2)Initial...

Read More

Implement Check Boxes

1)Define the check Box in the Canvas2)Attach following Property Classes 1)SubClass Information = CheckBox 2)Enter Value when Checked = whatever value we want to insert into Column 3)Enter Value when UnChecked = whatever value we want to insert into Column 4)Initial Value = Default Value 5)Label =Whatever the Name...

Read More

Manual form Development

1)Open the TEMPLETE.fmb 2)Delete Canvas,Window,Datablock 3)Create New Canvas,Window attach Property classes 4)Create New Datablock select Manuval Development 5)Goto Properties of Datablcok 1)SubClass Information = Block 2)Query Data SourceName = TableName 3)Query Data SourceColumns = Select Colunmns and Datatypes 6)Goto Canvas Define the...

Read More

Form Development Process

1)We Will download the TEMPLETE.fmb from AU_TOP\Resource Folder Application Utilities2)Open with Forms6i builder and delete the existing window(BLOCKNAME) create a new window(Say Sample_Window). Open the property palette of window(Sample_Window) and set Subclass information=WINDOW(property class).Delete the existing canvas(BLOCK NAME). create a new...

Read More

Form Development - Setups

We should do a setup before starting development of FORMS in EBS-11i1) Goto Start menu = Run option=> Enter "RegEdit" Press Ok2) Select HKEY_LOCAL_MECHINE =>SOFTWARE=>ORACLE3) Select FORMS60_PATH =>Right click=>modify4) Existing path will be there enter Semocolon5) Give the following Path => OkD:\oracle\prodappl\au\11.5.0\resource...

Read More

PO Setup Supplier Creation

...

Read More

PO Setup Buyer Creation

...

Read More

PO Setups - Item Creation

...

Read More

Report Registration With Parameters

...

Read More