Sunday, 16 August 2020

How to find out dff name in Oracle apps

How to find out dff name in Oracle apps

Hi friends, we are going to discuss about the how to find out dff name in Oracle apps. We will share the detail steps to find out the dff names in oracle apps. In oracle apps, DFF helps to store the additional informations. If we want to store some additional details in oracle form for which oracle has not provided any field then we can use the dff to create some additional fields in oracle forms and then application user can put the informations in these fields to store the additional informations in oracle apps. Oracle has provided the dff for most of the oracle standard forms. We can also create the custom dff too. To use the dff or to configure any dff in oracle forms , we first need to know the dff names. If we know the dff names then only we can configure or create that dff to store the additional inflammations in oracle apps. In this post , we will share the method to know the dff names for any oracle form. Please find below the complete details about how to find out dff name in Oracle apps.

Purpose of DFF in Oracle Apps

Dff in oracle apps , helps to store the additional inflammations in oracle apps, If we want to create some additional fields in oracle forms to store the additional informations , then we can use the dff to create these additional fields in oracle standard form. These dff fields inflammations stores in the Data base table and we can in the reports for later working.

For example , In oracle Payables Invoice Page , we want to create the DFF to create one additional field to store the Supplier Invoice Contact No. For this we need to find out the DFF names in oracle Payables Invoice Page and then configure this dff to create that Supplier Invoice Contact No. field.

Steps to find out dff name in Oracle apps

Here below is the details steps to find out dff name in Oracle apps

Step 1:- Here below is the Invoice Page , We want to create the DFF 'Supplier Invoice Contact No.' field in the Invoice header.
How to find out dff name in Oracle apps
How to find out dff name in Oracle apps


Step 2:- We want to create the DFF in the Invoice header. First we need to click on the any field in the invoice header and then need to go to the 'Help' Menu option.

Help => Diagnostics ==> Examine.


How to find out dff name in Oracle apps
How to find out dff name in Oracle apps


Step 3:- First of all , We need to know the Block name of the Invoice Header in which we want to create the new DFF.

In our case Block = INV_SUM_FOLDER

How to find out dff name in Oracle apps
How to find out dff name in Oracle apps

Step 4:- Once we know the block name , then again we need to click on the block field LOV to search the Descriptive Flex Field.
How to find out dff name in Oracle apps
How to find out dff name in Oracle apps


Step 5:- Here below , We need to find the Block Value '$DESCRIPTIVE_FLEXFIELDS'

How to find out dff name in Oracle apps
How to find out dff name in Oracle apps

Step 6:- After selecting the Block Value '$DESCRIPTIVE_FLEXFIELDS' , then we need to goto the second field and that is 'Field'. Here again we need to select the LOV for the field. It will show us all the dff available in the Oracle Payables Invoice page. 

In Oracle Apps Form , We can have more than one dff.

How to find out dff name in Oracle apps
How to find out dff name in Oracle apps

Step 7:- 
It will show us all the dff available in the Oracle Payables Invoice page. 

In Oracle Apps Form , We can have more than one dff.

Now we need to remember our Step 1, where we have found our block name for Invoice header in which we want to create the DFF. Here below we can see in the dff list of value i can see the block name ' INV_SUM_FOLDER'. 

We just need to select this dff and get the value as below.
How to find out dff name in Oracle apps
How to find out dff name in Oracle apps

Step 8:-  Information showing in the Value field is the actual DFF name. so this is all about finding the dff name in oracle apps.

DFF Name : Invoice (Payables)
But actually the DFF name is 'Invoice' only. Payables is the application name included in the dff name.

How to find out dff name in Oracle apps
How to find out dff name in Oracle apps

Step 9:- Now we need to goto the System administrator responsibility. 

Application ==> Flexfield==> Descriptive ==> Segments
How to find out dff name in Oracle apps
How to find out dff name in Oracle apps

Step 10:-  Here we can see our DFF. We can configure the DFF as per our requirement in oracle apps.

How to find out dff name in Oracle apps
How to find out dff name in Oracle apps




0 comments:

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *