Miscellaneous
  • Register

Oracle Gold Partners, training schedule is listed here designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

Fusion Apps Linkedin  |  Like us on Facebook  |  Get notified for our new articles  |  Twitter  | Linkedin Page | YouTube

 

User Rating: 5 / 5

Star activeStar activeStar activeStar activeStar active
 
An article on basics of Descriptive flexfields, for beginners that follow http://getappstraining.blogspot.com


A training article on Descriptive flexfields, also refered as DFF


First some basic Question and answers, and then we will do screenshots detailing how flexfields are configured.

Question: What does DFF mean?
Answer: DFF is a mechanism that lets us create new fields in screens that are delivered by Oracle.

Question: Oh good, but 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. Or may be Oracle simply used a silly word to distinguish DFF from KFF(discussed in latter training lesson).

Question: Are these DFF's flexible?
Answer: A little flexible, for example, depending upon the value in a field, we can make  either Field1 or Field2  to appear in DFF.

Question: So we create new fields in existing screen, but why the need of doing so?
Answer: Oracle delivers a standard set of fields for each screen, but different customers have different needs, hence Oracle lets us create new fields to the screen.

Question: Are these new fields that get created as a result of DFF free text?
I mean, can end user enter any junk into the new fields that are added via DFF?
Answer: If you attach a value set to the field(at time of setup of dff), then field will no longer be free text. The entered value in the field will be validated, also a list of valid values will be provided in LOV.

Question : Will the values that get entered by the user in dff fields be updated to database?
Answer: Indeed, this happens because for each field that you create using DFF will be mapped to  a column in Oracle Applications.

Question: Can I create a DFF on any database column?
Answer: Not really. Oracle delivers a predefined list of columns for each table that are meant for DFF usage. Only those columns can be mapped to DFF segments. These columns are named similar to ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3 ETC. Usually Oracle provides upto 15 columns, but this number can vary. 

Question: Can I add hundreds of fields to a given screen?
Answer: This depends on the number of attribute columns in the table that screen uses. Also, those columns must be flagged as DFF enabled in DFF Registration screen. Don't need to worry much about this because all the ATTRIBUTE columns are by default flagged for their DFF usage.

Question: Hmmm, I can see that DFFs are related to table and columns...
Answer: Yes correct. Each DFF is mapped to one table. And also each segment(or call it field) is mapped to one of the attribute columns in that table.

Question: I want these fields to appear in screen only when certain conditions are met. Is it possible?
Answer: Yes, we have something known as Context Sensitive Descriptive Flexfields.

In Order to do this, we will follow the below steps(screenshots will follow) :-
1.    Navigate to the DFF Registration screen in Oracle Apps and query on Table AP_BANK_BRANCES. Now click on Reference Field
2.    Navigate to DFF Segments screen and query on the Title of the “Bank Branch” and Unfreeze the Flexfield and add segments as to Section "GLOBAL Data Elements" as shown in screenshots.

Here are the screenshots......The descriptions are embedded within the screenshots.

We are in "Bank Branches screen" below, that is available in Payables responsibility. We need to add a new field as below.
Image

Once having noted down the table, we try to find the Title of the DFF for that Table. We go to Flexfield/Register
Image

Here we pick the Title of the respective DFF
Image

Query on that DFF Title from Descriptive Flexfield Segment Screen
Image

Add a new segment under "Global Data Elements"
Image

The options for making mandatory or enabling validations for the new field.
Image

Once you finalize the changes, you will be prompted to Freeze the DFF definition. Click on OK
Image

Now, we see the fruits of our configuration
Image

Comments   

0 #1 Anil Passi 2006-11-15 00:00
hi raj, please refer to 4th screenshot in this article. You must have left the Display checkbox ON. It is checked by default...I had disabled it when preparing this article
Quote
0 #2 Anil Passi 2006-11-15 00:00
hi santosh,
If Oracle does not provide DFF,then do the following....
1. Create a custom screen with custom table.
2. Enable Special Menu in std oracle screen
3. Using Custom.pll or forms personalization , let the user navigate to custom screen to capture the values for additional fields.
Needle ss to say, the custom table will have a foreign key towards main Oracle Apps table
Quote
0 #3 Anil Passi 2006-11-15 00:00
hi raj, please refer to 4th screenshot in this article. You must have left the Display checkbox ON. It is checked by default...I had disabled it when preparing this article
Quote
0 #4 Anil Passi 2006-11-15 00:00
hi santosh,
If Oracle does not provide DFF,then do the following....
1. Create a custom screen with custom table.
2. Enable Special Menu in std oracle screen
3. Using Custom.pll or forms personalization , let the user navigate to custom screen to capture the values for additional fields.
Needle ss to say, the custom table will have a foreign key towards main Oracle Apps table
Quote
0 #5 Rekha 2006-11-18 00:00
If the Screen is based on a View i.e (OE_ORDER_HEADE RS_V), can you explain how to add DFF to the screen.

Than ks,
Rekha
Quote
0 #6 Rekha 2006-11-18 00:00
If the Screen is based on a View i.e (OE_ORDER_HEADE RS_V), can you explain how to add DFF to the screen.

Than ks,
Rekha
Quote
0 #7 kartikey 2006-11-21 00:00
hi Anil,
I m learning Oracle apps and i m very thankful for u r amazing study materials.I want to ask a simple question if any of oracle (which hv already made and implemented )form does not hv any DFF field then how will i create a option button on them and make it DFF.Second while creating a new form is there any special button for DFF.
I will be very thankful if u answerd my simple question
thank s
Quote
0 #8 Anil Passi 2006-11-21 00:00
Hi karthik

For the 1st qns, please see my response to Santosh.

For second question, you will need to register the DFF and its segments as Oracle does for the screens it delivers.
Next , in the when new form instance trigger, you must call the API to register DFF against the form being executed. I dont recollect name of that user exit/api. please let me know if you want me to dig that out...you can also read application developer guide which details the steps

thanks
anil
Quote
0 #9 kartikey 2006-11-21 00:00
hi Anil,
I m learning Oracle apps and i m very thankful for u r amazing study materials.I want to ask a simple question if any of oracle (which hv already made and implemented )form does not hv any DFF field then how will i create a option button on them and make it DFF.Second while creating a new form is there any special button for DFF.
I will be very thankful if u answerd my simple question
thank s
Quote
0 #10 Anil Passi 2006-11-21 00:00
Hi karthik

For the 1st qns, please see my response to Santosh.

For second question, you will need to register the DFF and its segments as Oracle does for the screens it delivers.
Next , in the when new form instance trigger, you must call the API to register DFF against the form being executed. I dont recollect name of that user exit/api. please let me know if you want me to dig that out...you can also read application developer guide which details the steps

thanks
anil
Quote
0 #11 Anil Passi 2006-11-22 00:00
You need to look at the columns underneath the DFF Title in Segment Definition screen.
If those columns are ATTRIBUTE1...15 ..30, then thats the one to use.

GLOBAL_ ATTRIBUTE1..15 are for localizations.
Quote
0 #12 kartik 2006-11-22 00:00
Hi Anil,
thanks for u r response but still i m not able to understand the step to add a DFF in a new form or on some existing form of apps.
Please can u describe them a bit more bcoz as i told u i m new in this.
i will be very thankful if u can answer mean while i will try to find out in developer guide but it will be great if u can tell me bcoz u r way of explaining is superb..
thanks
Quote
0 #13 Anil Passi 2006-11-22 00:00
You need to look at the columns underneath the DFF Title in Segment Definition screen.
If those columns are ATTRIBUTE1...15 ..30, then thats the one to use.

GLOBAL_ ATTRIBUTE1..15 are for localizations.
Quote
0 #14 kartik 2006-11-22 00:00
Hi Anil,
thanks for u r response but still i m not able to understand the step to add a DFF in a new form or on some existing form of apps.
Please can u describe them a bit more bcoz as i told u i m new in this.
i will be very thankful if u can answer mean while i will try to find out in developer guide but it will be great if u can tell me bcoz u r way of explaining is superb..
thanks
Quote
0 #15 Anil Passi 2006-12-05 00:00
Hi Mrunalini,

T hanks for your generous comments. Indeed it is an ocean, and I am publishing my swimming experiences through this website. The more I swim, the more this ocean expands, leaving much more to be covered.

Tha nks,
Anil Passi
Quote
0 #16 Mrunalini 2006-12-05 00:00
Hello Anil,
You might have heard this n number of times, but here it goes again.
Your site is amazing !!!!
Oracle apps is an ocean to me and in your site information on this site is packed in precise content. This saves a lot of time and energy.
Thank you so much .
Mrunalini
Quote
0 #17 Anil Passi 2006-12-05 00:00
Hi Mrunalini,

T hanks for your generous comments. Indeed it is an ocean, and I am publishing my swimming experiences through this website. The more I swim, the more this ocean expands, leaving much more to be covered.

Tha nks,
Anil Passi
Quote
0 #18 Mrunalini 2006-12-05 00:00
Hello Anil,
You might have heard this n number of times, but here it goes again.
Your site is amazing !!!!
Oracle apps is an ocean to me and in your site information on this site is packed in precise content. This saves a lot of time and energy.
Thank you so much .
Mrunalini
Quote
0 #19 artur bakhtriger 2007-01-18 00:00
Another Great one

Thanks Anil !!!!!!

artur .
Quote
0 #20 artur bakhtriger 2007-01-18 00:00
Another Great one

Thanks Anil !!!!!!

artur .
Quote
0 #21 artur bakhtriger 2007-01-18 00:00
Another Great one

Thanks Anil !!!!!!

artur .
Quote
0 #22 artur bakhtriger 2007-01-18 00:00
Another Great one

Thanks Anil !!!!!!

artur .
Quote
0 #23 Anil Passi 2007-01-26 00:00
.
.
.
Hi Ram
You can do this by creating a profile option. The context of the DFF will be profile option itself. Hence in DFF Reference field, you need to enter :$PROFILES$.XXW HICH_SEG_TO_DIS PLAY Next, you can define the context fields for each possible value of the profile option. For that specific user, you will define the context showing selective fields. Needless to say, you need to assign the profile option to that user, matching their context code. Hope this is clear, or else I am happy to explain with example.

THanks
Anil passi
Quote
0 #24 Ramakrishna Kandula 2007-01-26 00:00
Hello Sir,

I am just six months old in this field and i just want clarify one doubt.

How can hide some segments of DFFs depending on login user.

to be more specific if OPERATIONS user logs on then some segments shud appear for that user.
where as for other users they shud appear.

I wud appreciate if u can send me the reply asap.

thanx in advance.
Quote
0 #25 Ramakrishna 2007-01-27 00:00
Thanks for ur help anil.

Your site is really informative for beginners.
Quote
0 #26 Anil Passi 2007-02-05 00:00
.
.
.
Hi Rajitha,

I think this is like a infinite loop, because Oracle is trying to leave the record, each time you navigate out of the DFF Field[because it is the last field-as you said]

I suggest you try the below:-
1. Find out the Block Property Navigation Style for that block. Is that set to Next Record?
2. If above is Yes, then in CUSTOM.pll, handle the event WHEN-NEW-FORM-I NSTANCE for that GL Form. In this event, use set_block_prope rty to change the NAVIGATION_STYL E to SAME RECORD.

Let me know if that works. The idea is that, this will retain the navigation to current block, hence WHEN-VALIDATE-R ECORD will not fire in tabbing out of the DFF field.


THa nks,
Quote
0 #27 rajitha 2007-02-06 00:00
Hi Anil,

Thanks for ur help. i let you know if any doubts.

Than ks!

Rajitha
Quote
0 #28 Arunima 2007-03-12 00:00
Hi Anil,
Was wondering, Programmaticall y(CUSTOM.pll), is it possible at all to make some segments of a DFF Displayed but not UPDATEABLE/INSE RTABLE as we can do for KEY flex fields using( fnd_key_flex.up date_definition ) ? If not then could you please suggest any work around. One of the segments in my DFF is calculated and displayed depending on the Context value. Regards,
Arunima
Quote
0 #29 Anil Passi 2007-04-17 00:00
Hi Sumit

please see my response to Karthik in comments section, the comment was made 11/22/2006 at 21:40

Thanks ,
Anil
Quote
0 #30 Sumit 2007-04-17 00:00
Hi Anil,

First of all, many thanks to you for all this material that you have posted on this site. I have a question, not sure if you have answered it earlier: How to add a new dff to a standard form. Say I have already defined and registered the table and the dff. How to specify the location of dff on the form also?
Quote
0 #31 Shiril 2007-05-02 00:00
Hi Anil,

I learn a lot from ur blog... in last couple of weeks......plea se try to make few more slides on oracle finicals....as i am fresher so it is very.. tuff to understand through oracle supplied user mannual...
Reg rds,
Shiril Dubey
Quote
0 #32 Shiril 2007-05-02 00:00
Hi Anil,

I learn a lot from ur blog... in last couple of weeks......plea se try to make few more slides on oracle finicals....as i am fresher so it is very.. tuff to understand through oracle supplied user mannual...
Reg rds,
Shiril Dubey
Quote
0 #33 Anil Passi 2007-05-29 00:00
Hi Vardhan

Inst ead of putting too much logic into valuesets, I suggest you use forms personalization to validate this in When Validate Record.

I am against using form field references in value sets because those DFFs then do not work in Self Service OA Framework [if they reference D2k fields]


Al so, Supplier screen has been re-written in R12 using OAFwk, Hence it is better to not to have any form field references with the value sets of Suppler screen in 11i
Thanks
An il Passi
Quote
0 #34 Vardhan 2007-05-29 00:00
Thanks Anil. I tried to personalize Segments Summary (Vendors) form, but I was unable to do that. It would be great help if you could explain this more. Which form I need to personalize and how to do it.


Thanks ,
Vardhan
Quote
0 #35 Madhavi 2007-06-22 00:00
Hi Anil,

I started using using ur valuable site.
i tried to dod the descriptive flexfields as per your instructions.
but finally there wl not be any change in my form.for Test Bank there will not be any attributes.but i followed all ur steps.

Thank s
Quote
0 #36 Anil Passi 2007-06-22 00:00
Hi Madhavi

Emai l me the screenshot of DFF and also that of the screen where you expect to see that DFF

Thanks
anil
Quote
0 #37 raivin 2007-07-06 12:27
hi anil,
ur material hs really been excellent and informative for beginners like me..
thanx..
i ve a specific doubt..
i ve made two purchasing responsibilitie s..
and i ve made DFFs in requisition forms of one of them..
nw i want those DFFs to default to iprocurement responsibility. .
so my doubt is: how do i default the DFFs of one of the purchasing responsibility i ve defined?
coz i m nt gettin d DFFs in iprocurement,wh ich shows that iproc framework is taking the purchasing responsibility where DFFs ve nt been defined..
plz help me with this ASAP..

thanx,
Quote
0 #38 Anil Passi 2007-07-06 21:09
Hi Raivin

You haven't mentioned how you made the DFF enabled for one responsibility and disabled for the other.

Anyway, coming to iProcurement, you can include the DFF by using OA Framework Personalization . See the Framework Personalization note on Metalink, as it contains examples.

Than ks,
Anil Passi
Quote
0 #39 Hariom 2007-07-10 12:16
Hi Anil,
Could you please tell that how can we make any DFF segment as 'Read Only'.
I am trying it to do with FND_DESCR_FLEX. UPDATE_DEFINITI ON(BLOCK=>†™block_nameâ €™,
FIELD=> ’field_n ame’,ENA BLED=>’& #123;Y|N}à ¢â‚¬â„¢,READ_ON LY=>’ 23;Y|N}â⠂¬â„¢) but what value we have to pass in parameter for 'FIELD'. whether it will be descriptive Flexifield name or Attribute name which is referenced by segment of DFF. And one more thing where we have to use this FND_DESCR_FLEX. UPDATE_DEFINITI ON in Form's block lever trigger or in Custom.pll?
Please help me to solve this problem. Thanks in advance.
Have a nice time.

Regards
Hariom.
Quote
0 #40 APassi 2007-07-10 20:10
Hi Hariom

For DFF, I think FND_DESCR_FLEX. UPDATE_DEFINITI ON works at DFF level only.
Hence the field is the name of the field, which pops the segments when cursor moves into that field.

Example...
fn d_descr_flex.up date_definition (
BLOCK=>'IVOIC E_HEADER',
FIEL D=>'INV_FLEX',
READ_ONLY=>'Y') ;

Thanks,
Anil
Quote
0 #41 Aniket Mahajan 2007-08-31 14:36
Hi Anil

Indeed a great site.

Aniket
Quote
0 #42 Lakshman Kalisetti 2007-10-10 23:29
Hi Anil,

I need your expert guidence in implementing address validation in Oracle R12 HRMS form "PERACADR.fmb"
In this form person address is captured using the standard DFF "Personal Address Information".

This DFF is context sensitive. Address Type is the reference field.

In case of address types US and CAN, I need to have our customized validation on the segments like City, State, Country, Zip Code.

All the segments are attached with oracle supplied value sets.

In our case, while populating the list of values for all the above four segments, we need to consider the remaining three segments.
Based on those three segments we need to do some validations and populate the list with valid data only.

I tried below steps to implement this...

1. Create new value sets based on our custom tables and assign them to all four segments.

2. Write Key-Listval trigger on all the four segments with following code...
a) call our custom procedures to populate the custom tables with valid values
b) populate the LOV using list_values

But after implementing the above changes, we identified that none of our triggers on DFF segments are getting executed.

We tried some other possiblities also, but could not make it.

Could you please provide us your expert guidence on this.

Your earliest reply would be highly appreciated.

T hanks in advance,
Lakshm an K
Quote
0 #43 Anil Passi 2007-10-11 05:45
Hi Lakshman

It is not clear if you attempted to modify the standard form?

You must not do that.

Coming back to your requirement, you can use Forms Personalization or CUSTOM.pll to include additional validations. Perhaps WHEN-VALIDATE-R ECORD fires, where you perform cross field validation.
Pse udo Example could be
------------ --------
if attribute_conte xt='CA' then
if attribute4 between 1000 and 9999 and attribute5 like 'XXX%' then
fnd_message....
raise form_trigger_fa ilure
end if
end if


Thanks,
Anil Passi
Quote
0 #44 Ramesha 2007-10-16 12:09
Hi Anil,

I am a functional guy and not much aware of the tables etc at this point in time. However, i tried to follow the steps above to find / register a DFF for service contracts. Detailed steps are as below:

1. Navigation: Service Contracts Manager, Vision Communications -> Launch Contracts.

2. I went into the Header and found that there is a provision for a DFF. Went to Help->Record History and found that the table name is OKS_AUTH_HEADER S_V.

3. When I go back to DFF registry form, I dont get this table name at all.

Questions :

a. Is the DFF registry, restricted to only base tables. If so, then how come the DFF provisioning is available.

b. In this case, how do I make the DFF active at the header level of the contracts.

Kin dly help me by clarifying the same.

Thanks,
Ramesha
Quote
0 #45 Ramesha 2007-10-17 06:44
Hi Anil,

I found the solution for the above question that I myself raised. The issue here is that Oracle Service Contracts rely on Oracle Core Contracts. In other words, Oracle Core Contracts (OKC) is the foundation for Oracle Service Contracts (OKS).

This means that Service Contracts uses the basic features of Core Contracts for various aspects like Headers, Lines and sublines.

In my above question, I am trying to register a DFF for contracts header. So this should have been pointing to OKC Headers but I was trying to search for OKS tables.

To correct the same, I have used the OKC_K_HEADERS_B table and now I am able to register and use the DFF.

Anyways thanks a lot as this site provides me with thought provoking stuff and I will keep visiting.

Rega rds,
Ramesha
Quote
0 #46 jith 2007-10-20 08:49
Anil,
I am proud of you!
You are teaching apps for world for free while ppl around the world get 50000 rs to teach anything..
You are very good and kind hearted! You are doing a service for apps community, may god bless you man!

Regards,
Jith endra :)
Quote
0 #47 sanjay desai 2007-10-20 10:50
Hi Anil

First very very thanks for useful information to novice.

I am a new person in apps so i request you to solve my simple queries .

(1) what is difference between ATTRIBUTE column & GLOBAL_ATTRIBUT E column in a table?
(2) If i want to define more DFF than ATTRIBUTE column in a table then what we should do ?

Thanks in advance
sanjay
Quote
0 #48 Anil Passi 2007-10-20 15:11
Hi Sanjay

1. Global_Attribut esNN are used by Oracle for localizations. Hence you must not use this at customer site for defining new Flexfields.
2. You have two options
a. Create a flexfield within Flexfield Segment. I think there is a note on metalink.
b. Create a custom screen that is based on custom table. In the custom table you will have a column that references the primary key of the main table upon which standard screen is based. This custom screen can then be integrated using forms personalization or CUSTOM.pll

Tha nks,
Anil Passi
Quote
0 #49 Venu Gopal Bhagavatula 2007-11-19 12:27
Dear Anil,

I understand that Gloabal_Attribu te1 to 15 are used for Localizations. Is there any predefined purpose for Global_Attribut e16 to 30 or can they be used as any normal Attribute column.

Thanks ,
Venu
Quote
0 #50 Ramstein 2007-11-19 17:02
Hi Anil,
Can you guide me as to how to create a profile option with a small example. the sql validation text is very confusing and not understandable for the standard profile options
Thanks,
ram
Quote
0 #51 S.kumar 2007-11-22 19:10
Hi Anil,

I created a Line Level DFF in Order management.I want to make the DFF Read Only.
I saw the reply given by you above.But I have a doubt in case of Field(second parameter)
in the FND_DESCR_FLEX. UPDATE_DEFINITI ON(
/* Arguments that specify the flexfield location */
BLOCK=>'LINE',
FIELD=>'WHAT NEEDS TO BE PASSED',
/* Other optional parameters */
READ_ONLY=>'Y' )

Thanks for the help
S.Kumar
Quote
0 #52 Anil Passi 2007-11-22 19:39
Hi S Kumar

You need to pass the name of the field that is visible in the form.
Once you navigate into that field, a popup appears.

In most cases, name of this field is DESC_FLEX
Howev er, you can use examine to find the name of the DescriptiveFlex form field.

Thanks,
Anil Passi
Quote
0 #53 Dhiman 2007-11-27 00:37
Hi Anil,

Is there any way to make a segment of a DFF read-only?
FND_ DESCR_FLEX.UPDA TE_DEFINITION will not serve the purpose certainly,
as this works as DFF level.And the workaround like restricting the values
in the LOV is not feasible because once user saves, WHO columns will be updated.

Pleas e suggest.

Thank s & Regards,
Dhiman Debnath.
Quote
0 #54 Maheshyogi 2007-11-27 14:14
Hi Anil,

Why the 'Metro Satus' segment is not checked for 'Display' in Personal address Information DFF of style India? What are the impacts if we check the 'Display' box? Will it effect any customization pertaining to payroll? Pls help me.

Thanks and Regards
Mahesh
Quote
0 #55 Thulasee Ram 2007-11-30 10:16
Hi Anil,

How we can get a reporting attributes/valu es defined in descriptive flexfields (say in receivables customer information (DFF) in FSG? Is it possible? If so could please tell me how this can be done?
Quote
0 #56 Deedee 2007-11-30 22:48
Hello Anil,

i am new to oracle apps and i am trying to create a DFF than would default a particular value(1). After choosing a number valueset, i choose a default value but When i open the form, the value does not show. i also want the DFF to be updatable by the user if his requirements change.

i have tried to check online and i keep seeing things like "populateRowWit hDFFDefaultValu es API in oracle.apps.fnd .framework.OAFl exUtils". I dont know what that means and how to go about it.

Please can u kindly help me out. I would appreciate screen shots too.
Quote
0 #57 Thulasee Ram 2007-12-04 12:25
Hi Anil,

Is there a way to get DFF information defined at subledger level/customer information level to GL i.e when we post the batches GL that has been transferred from GL?
Quote
0 #58 Dhiman 2007-12-27 01:08
Hi Anil,

is there any way to increase the size of DFF display screen so that no need to scroll down to see the newly added segment.

Any pointer to this will be of great help.

Thanks & Regards,
Dhiman
Quote
0 #59 Vive 2008-01-09 11:20
Hi Anil,

I have 2 issues while working on DFF
1.How to make a DFF mandatory for a group of users only.
2.In receipts form in PO, I need to get the quantity of an item to be saved onto the DFF(attribute4) .

Regards,
Viv ek
Quote
0 #60 Anil Passi 2008-01-09 11:24
Vivek

You need to create a context sensitive flexfield.
The context of this flexfield will be a profile option.

You can grant this profile option specific set of values, for a given group of users.

Have a look at www.google.com/search?q=site:apps2fusion.com+smart-descriptive-flexfieldsl

Thanks
Anil Passi
Quote
0 #61 Abhishek Parihar 2008-01-12 04:57
Hi Anil,

As a SCM functional consultant-

1. What are the variable parameters(like DFF) for customization/a pps extn in oracle apps for me? Screenshots will be of great help.

2. I will have to prepare/use MD50 docs for apps extension. How can I update my skill on that?

3. I will have to prepare TE-20(functiona l part) so how can I make myself strong in that? Whether MD-50 & TE-20 docs of other projects will help or is there any other way also?

An early reply would be of great help.

Best regards,

Abhis hek
Quote
0 #62 Rinku 2008-01-25 09:36
Hi Sir,

I need to make my form DFF read only when person make query on form and the result which come in form as well as in DFF can not be updatable.

Tha nks,
Rin
Quote
0 #63 ramarao kothapalli 2008-02-01 17:27
Hi Anil,
Please let me know the procedure to add dff's in custom form.
Give me any suggestions from u r side.
Quote
0 #64 Sachin Nanekar 2008-02-14 03:52
I am new to Oracle Apps.
Quote
0 #65 kancharla 2008-02-18 22:50
Hi anil, your site is so informative for beginners like me so please help me how to attach a lookup to a flex field.thanks
Quote
0 #66 Avi 2008-02-20 14:33
Hi Anil,

We have used all 15 ATTRIBUTES for the Order Management - Header Additional Information.
Is there any solution if I need to add another ATTRIBUTE?

Rea lly approeciate.
Th ank you!
Avi
Quote
0 #67 Anil Passi 2008-02-20 14:57
You have two options

1. You can create a FlexField within Flexfield, i.e. reference a Key Flex within one of the segments of DFF
The unique id of KFF will eb stored in attribute column

2. You can create a custom screen on custom table, and zoom to that screen by enabling Tools Menu.
This can be done using forms personalization . the custom table will contain reference to unique key of main screen [i.e. order header id]


Thanks
An il
Quote
0 #68 Avi 2008-02-20 16:07
Hi Anil,

I had no idea about this site. GOD BLESS YOU!!!

I am very clear about option # 2.
However I am not very sure about option # 1.

Say on Order Management Additional Header Information I have 15 ATTRIBUTES.
Use d them All. How can I add another ATTRIBUTE16.
Ar e you saying to utilize a KFF ATTRIBUTE and use it instead of DFF?
Can you please provide just a bit more specifics / details.

Thank you so much!
Avi
Quote
0 #69 Shine 2008-02-22 05:26
hi anil,
i have two applications - appA and appB. I have registered a DFF under appA with the name tabB_DFF for the table tabB and added attribs 1 to 14. Later on I realised that the DFF should belong to appB. I need to use the same DFF name also. How can i undo my previous registration . Please help
thanks in advance..
Quote
0 #70 Valeria 2008-05-01 15:36
Hello Anil,
I have a need to add a field or edit current field ( Description or Fax ) and provide it a LOV in the Define User Form. I do not see any DFF field
for this table so edit a current field is my only option but I am not sure how to enable LOV for it. Please advise
Quote
0 #71 Anil Passi 2008-05-01 16:52
Hi Tuan

There is no DFF in user screen.
Please create a user level profile option
That will give you an LOV too.
Thanks,
An il
Quote
0 #72 Rajesh Kumar 2008-08-25 03:24
Hi anil
I hv gone through your article as well comments & answers by you.

I hv one query: I am using one flexfileds at Order Header "Additional Header Information". IN this we have Commision & commsion agent name that goes into col Attribute1 & attribute 3 of OE_ORDER_LINES_ ALL. Now we want that if user enter comm% then we want to make Comm agent fields mandatory. If he enter comm agent name then comm% field manadaorty.
i tried this through form personalization . but not able to do this .
Kindly advise where to right the logic into form personalization for flexfield
Thank s in advance
Regards
RAjesh
Quote
0 #73 Hi Anil 2008-10-03 09:18
Hi Anil

is it possible to overiding dff fileds lables at run time using custom.pll

Tha nks & Regards
venu
Quote
0 #74 Swetha_gks 2008-12-18 15:04
Hi Anil,

I need some help on DFF on receipts header block.

1. I want to make this DFF mandatory. Users shouldn't be able to navigate to lines form without entering the value in this DFF.
2. Once the users come to lines form and check the line, the value entered on headers DFF should be copied to lines DFF.

I would like to do this using custom.pll. Can you please help me.

Thanks in advance,
Swetha
Quote
0 #75 Anil- 2008-12-18 16:54
Hi Swetha

For 1
Make the DFF Segments Mandatory in DFF Segment Definition Screen, for Header DFF.

For 2
See if WHEN-CREATE-REC ORD is being trapped in CUSTOM.pll or Forms Personalization
There, simply copy the value from HEADERBLOCK.ATT RIBUTE1 to LINEBLOCK.ATTRI BUTE1

Thanks,
Anil Passi
Quote
0 #76 Anand Ramaswamy 2008-12-26 08:03
Hi Anil,
I am a regular visitor of your site and get lot of knowledge. Thanks for all your help so far. I wanted to know how to handle an attribute in a DFF using personalization . For example I have 3 attributes in a DFF, say Name, Age and DOB. How do I refer one particular field in personalization screen, if I want to set any property for one of these attributes, how do I refer them.
Under normal cases, we refer a field as "blockName.fiel dName", but in case of DFF, how do we set property for a particular attribute, in this example if i want to set ENABLED=FALSE for DOB, how do i handle it?

Thanks
Ana nd
Quote
0 #77 GANGA RAJU AENIKE 2009-01-16 12:15
hi All,
Please help in this
Thanks in Advance.
Quote
0 #78 Asharma 2009-04-08 07:10
Hi Anil

We want to default a DFF segment value(Segment of a Context sensitive DFF) based on a custom profile option.Can you plz guide me on how to do this?



Thanks
Asharma
Quote
0 #79 Rishi 2009-07-16 12:09
Hi Anil,

It's a good thread about FP's and pll's.

My issue is, I tried in actions of FP using block.attribute update_allowed/ enterable as FALSE.But it's not working out.
Can you please give any solution for this.
Thanks in advance.

Thank s,
Rishi
Quote
0 #80 smyggymba 2009-07-16 15:56
Can I make a DFF mandatory and optional based on the order type field?
Quote
0 #81 Murugesh 2009-10-29 02:46
Hi Anil,

can you please advise me how to enable the Additional Assignment Details in the My Information Function Of the Employee Service. And also can you let me know whether it is possible to update additional assignement detail of the Employee through Manager Self Service

Thanks & Regards
R.MURUG ESH
Quote
0 #82 Premalbhai 2009-11-16 06:05
Hi Anil
I need yr advice in Personalization .
I want to User to Fill up Value in DFF and that same value should be reterive on the Main Form.
How can i achieve this
awaiting yr reply
Premal
Quote
0 #83 syed hussain 2010-01-15 04:39
Hi Anil,

I have learnt many things from your site i used to watch your replies and try to implement those.

I am stuck with some requirement in POXPOEPO.fmb i.e. Purchase Order form (EBS 11.5.10.2), i need small information for the below.

I have a requirment in which i have to copy the Need_By(at line level) value to the DFF attribute1 at line level, i have tried through form personalization but i have not yet succeeded.

Cou ld you please help me on this.
:o
Quote
0 #84 sheetal mittal 2010-03-11 03:37
Hi Anil,

I am haivng a doubt in OAF.

will the DFF segment values are stored in database . If yes then how it can be achieved
Quote
0 #85 kafajy 2010-04-19 08:03
Anyway, coming to iProcurement, you can include the DFF by using OA Framework Personalization . See the Framework Personalization note on Metalink, as it contains examples
Quote
0 #86 Pan 2010-06-23 21:09
I am having issues in separating DFF's on R12 Customer screen ( HTML) by Operating units . It used to work in Oracle Forms but not working in HTML form .

Need this desperately

Please help

-P
Quote
0 #87 Vincent 2010-09-14 09:51
Hi Anil,

I implemented a Context Sensitive Descriptive Flexfields and it works perfect when I create a record. However, is it possible to let this flexfield also account for
old records? Is my assumption right that the trigger of the appearance of the flexfield is when the user choses a value in the context field?

Regards ,
Vincent
Quote
0 #88 Kadir Ard?ç 2010-09-16 03:11
Hi, i added a dff to a custom form but whenever i opened the form dff window popups directly how can i avoid this behavior i want it to open when i clicked dff field only.

Thanks for you help,
Kadir
Quote
0 #89 abi 2010-11-23 17:29
Hi I need to add a DFF for Labor schedule screen .. Psp_schedules table has attribute1 to attribute10 .. but the form does not have a DFF.. Can we do it ?
Quote
0 #90 Amal 2011-02-10 17:09
Hi Sir,

What the Different between Additional, Further.... Information DFF Title and what are the used of them.
I am using Further Employer information DFF and I add New Context Code value Please let me know if any required steps Should be take in the application for define new Context Code value.
I need some segments to be locked from the End used (Read only) should that be done through from Form Personalization and how to do it.
I want to Display value from the Window in DFF before saving the Records for Example I add new entries in Previous Employment window I want to display the Start Date and the end Date in Further Information Segments but note may be the end used not yet Save the records.

Regar ds,
Amal Dawood
Quote
0 #91 JT 2011-03-11 07:34
Hi Anil

I would really appreciate your help. We urgently need to enhance existing FSG reports, to include DFF values.

We are hoping to :-
a) have the DFFs output in an FSG report,
b) Run the FSG having selected the output type as XML
c) Then post-process the XML output with XML publisher to satisfy our Users' reporting needs.

Clearly, this all hangs on getting the DFF values to be picked up by the FSG in the first place.

I seem to have added the required DFFs to the appropriate table, but the values are not picked up when running the FSG.

Do you know a) can we use DFFs successfully in FSGs?
b) If so - how do we go about it?

We would be most grateful of any help you can provide.

Thank you in advance.

Regar ds

JT
Quote
0 #92 chi 2011-03-18 14:19
can u pls send screen shot of HRMS dff to my box very urgent pls.
Quote
0 #93 Deepesh Aravandekar 2011-03-23 12:29
Hi Sir,

I just wanted to know that what are the sources for global_attribut e2, global_attribut e3 and global_attribut e15 from ra_customer_trx _all in oracle R12.

Please reply....

Than ks in advance.....

R egards,
Deepesh A
Quote
0 #94 Ananda 2011-09-14 08:34
Hi Anil and All
I have a req.......In Invoice Entry form...at line level.......bas ed on the expenditure type, the DFF field should be mandatory...... .

For ex: if expenditure_typ e is Entertainment, then some DFF fields are mandatory...... and if expenditure_typ e is accomdations then some DFF fields are mandatory.....
Is it possible...thro ugh form personalization ......plz explain me the steps....

Than ks,
Anand
Quote
0 #95 Attribute Update 2011-09-16 06:59
?????????

???? am looking for an API?to update the ra_customer_trx _All attribute9 column.

do we have any api to update the attribute columns in base tables please help me.


Thanks
Ra vi kumar.N
Quote
0 #96 Pritesh 2012-02-18 09:36
I have enabled 2 requisition Distribution DFF without any valuesets ....and by using context profile option sucessfully displayed it to required self service responsibilitie s...while defining dff I have enabled required flag...my problem is the system prompts the user to fill these fields only if user visits the split line allocation page explecitly.

An d not if does not remind him if he bypasses the page & he can sucessfully submit the requisition.
Ho w can this be resolved
Quote
0 #97 Meron 2012-03-05 09:32
Hi

Plz give me information how i can make the added(A+B) value of of 2 DFF's value of the 3rd DFF............ .......thank you
Quote

Add comment


Security code
Refresh

Search Trainings


Enquire For Training

Related Items

LOGIN

About Apps2Fusion

Apps2Fusion are passionate about training. Trainnig is our core business and we have been doing this for many many years. We thrive to meet expectations of our trainees. We work hard to ensure trainees get the right courses sold to them, with advise for their career paths. We have helped many consultants in past with training & mentoring and  we have helped them achieve great heights. We could help you as well. Get in touch with us.