Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

Miscellaneous
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 3 / 5

Star ActiveStar ActiveStar ActiveStar InactiveStar Inactive
 

An article on Context Sensitive Descriptive Flexfields, for beginners that follow http://getappstraining.blogspot.com


A training article on Context Sensitive Descriptive flexfields.
IMPORTANT:- You must read Basics Flexfield article . This article is an extension to the work that we did for a simple flexfields.


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

Question: I want these Flex fields to appear in screen only when certain conditions are met. Is it possible?
Answer: Yes, you can. Lets take an Example. You have a "Bank Branch" screen where you enter the Bank names and their branches . There is a field named Branch Type in that screen. You wish to show & capture following new fields:-
a. Banks Country of Origin Field ( regardless of bank branch type, we must show this new field). As we configured in earlier training chapter.
b. If user entered a value of SWIFT in Branch type, then display a new DFF segment "SWIFT Partner field".
c. If Branch type CHIPS is selected by the user, then display a DFF segment "Chip ID" field.


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, and ensure that “BANK_BRANCH_TYPE” field can be used as a context switch. In our case we add this field as a 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 in screenshot below. Register the BANK_BRANCH_TYPE field as a reference item.
3. Create the contexts for each possible value of Bank Branch Type field(for which you want conditional display of fields)....

Hmmmm not clear yet, see the the screenshots and you will surely understand......

Find out the table name for Bank Branch screen, this will enable us to find the DFF that is available for Bank Branch 

Regardless of the Branch Type, we need to enable a new field named "Banks Country of Origin".

For Type SWIFT, enab;e a new field named SWIFT Partner

For Branch Typr CHIP, enable a new field using DFF for CHIP Id

Given that our DFF will be sensitive to what we enter in Bank Branch, we must find out name of the field(not the display name). This can be done by using examine as shown
Image

We can see that internal name of the Branch Type is "BANK_BRANCH_TYPE". We need to ensure that a DFF can be made sensitive to the value in BANK_BRANCH_TYPE

We now find that field name is BANK_BRANCH_TYPE

Our DFF fields will b sensitive to the value entered in Branch Type.

This is called context sensitve flexfield.

Lets navigate to DFF registration screen, and using the table name, we query DFF for AP_BANK_BRANCHES.

Alternately you can query using DFF title too.

Query theDFF definitip as is delivered by Orac;e. Oracle comes pre-defined with DFF Registration for most of the screens

Now that the title of the DFF is "Bank Branch". We require this title in DFF Segment screen, where we will define the fields/segments.

Now lets add BANK_BRANCH_TYPE as a REFERENCE Field, by clicking on Button Reference

Now we need to define the new fields(segments). This screen is accessed via menu /Descriptive/Segments . In this screen, lets make BANK_BRANCH_TYPE as the context/reference. This means that DFF will become sensitive to values in Branch Type field

IMPORTANT: If your requirement is not to have any conditiional logic, then no need for all the "Reference Field" blaaa. All you need to do is to add your segment to Global Data Elements.


Image

 

Leave the value set blank, as this is just a demo. Incase you wanted this field to be validated, then you must enter a velue set.

Now create a record for CHPS context. Once created, we add a segment CHP id and map this field to ATTRIBUTE11

 

 

 

Similarly define a field for SWIFT partner. But remember we display this only when user select SWIFT, in the branch type field.

In section'context field valiues' enter & create a record for code'SWIFT", then click on segment button & define the segment for SWIFT partner company

 

No we have finished the setup, and lets Freeze the DFF definition by checking the checkbox named " Freeze the Flexfioeld definition. Now we can Test.

 

When the user selects Type=SWIFT, we see the relevant SWIFT field appear in Flexfield window

Modify the record such that the Branch type is having a value of SWIFT.

You will then see "SWIFT Partner Company" field.

Remember, Banks Country was in " Global Data Segment", hence that field appeara regardless of Branch Type Value.
When user selects Type=CHIPS, we see CHIP Id field appearing in Flexfield window.

Now Modify the record such that the Branch type is having a value of CHIPS

You will then see "CHIP Id" field. However SWIFT Partner Field has disappeared, and rightly so.

Remember, Banks Country was in "Global Data Segment", hence that field appeara regardless ofBranch Type Value.

Here we now see that value entered in DFF field gets stored in the database column,
Image


Anil Passi

Comments   

0 #1 Christopher Joseph 2006-11-01 00:00
Thanks a lot Anil!!
This article was really useful.
Keep on going with http://getappstraining.blogspot.com
Its really one of its kind...
Quote
0 #2 Christopher Joseph 2006-11-01 00:00
Thanks a lot Anil!!
This article was really useful.
Keep on going with http://getappstraining.blogspot.com
Its really one of its kind...
Quote
0 #3 Anil Passi 2006-11-15 00:00
Hey Chris,
Thanks, I will keep working on getappstraining surely..

Che ers
Anil
Quote
0 #4 Anil Passi 2006-11-15 00:00
Hey Chris,
Thanks, I will keep working on getappstraining surely..

Che ers
Anil
Quote
0 #5 Anil Passi 2007-01-11 00:00
.
.
.
Hi User,
I usually never write about menu path navigation. To access any screen, all you need to do is, when inside a responsibility, on keyboard hit, Control L.

By Control L, all the existing screen name will be and you can search using %Branch%

Tha nks,
Anil Passi
Quote
0 #6 User 2007-01-11 00:00
Hi Anil,
The way you explain the things, is very simple and easy to understand. I appreciate your work.
One thing I thought to ask you. You navigated to Bank Branches window in the process of DFF Registration process. Can you please let me know what exactly is the navigation to flow for that Bank Branches? Not only, how can we know the navigation flow in general also. for example transactions, invoices, receipts or sites etc., I think it would be very useful, if u can explain how can we follow the navigation flow, for any particular window.

Than ks!
Quote
0 #7 Anil Passi 2007-01-11 00:00
.
.
.
Hi User,
I usually never write about menu path navigation. To access any screen, all you need to do is, when inside a responsibility, on keyboard hit, Control L.

By Control L, all the existing screen name will be and you can search using %Branch%

Tha nks,
Anil Passi
Quote
0 #8 User 2007-01-11 00:00
Hi Anil,
The way you explain the things, is very simple and easy to understand. I appreciate your work.
One thing I thought to ask you. You navigated to Bank Branches window in the process of DFF Registration process. Can you please let me know what exactly is the navigation to flow for that Bank Branches? Not only, how can we know the navigation flow in general also. for example transactions, invoices, receipts or sites etc., I think it would be very useful, if u can explain how can we follow the navigation flow, for any particular window.

Than ks!
Quote
0 #9 Anil Passi 2007-01-12 00:00
.
.
Hi User,

Ctrl+L is for finding out the screen name[not responsibility, i think you did a typo].

Anywa y, the only other way of knowing navigation path is by reading Oracle Manuals/impleme ntation guide.

Thank s,
Anil Passi
Quote
0 #10 User 2007-01-12 00:00
Anil,

I tried following your reply. You made it much simple! Just out of anxiety, is there any other way, other than Ctrl+L in finding the appropriate responsibility and then reaching to the specified path from the menu?

Thank you!
Quote
0 #11 Anil Passi 2007-01-12 00:00
.
.
Hi User,

Ctrl+L is for finding out the screen name[not responsibility, i think you did a typo].

Anywa y, the only other way of knowing navigation path is by reading Oracle Manuals/impleme ntation guide.

Thank s,
Anil Passi
Quote
0 #12 User 2007-01-12 00:00
Anil,

I tried following your reply. You made it much simple! Just out of anxiety, is there any other way, other than Ctrl+L in finding the appropriate responsibility and then reaching to the specified path from the menu?

Thank you!
Quote
0 #13 Swen 2007-01-22 00:00
Good article, keep going
Quote
0 #14 Swen 2007-01-22 00:00
Good article, keep going
Quote
0 #15 artur bakhtriger 2007-01-31 00:00
Anil, I am strugled to implement po_requsions_li ne dff on iProcurement
they a simle global DFF
I enable Flex: (ReqLineDescFle x) and expect to see them but they not displayed on non-catalog request. Any idea what can I check . Thanks a lot.
Quote
0 #16 Anil Passi 2007-02-02 00:00
Hello Artur,

Many thanks for coming back to share your experience.

Regards,
Anil Passi
Quote
0 #17 Anil Passi 2007-02-21 00:00
Hi Sara

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

This outlines a solution to your requirement, whereby you can create a profile option and set that at responsibility level. The context of your DFF will be the profile option itself.

Than ks,
Anil
Quote
0 #18 Sara 2007-02-21 00:00
Hi Anil,

your site is really good and informative.

We have a requirement where we need to restrict descriptive flex field based on organization.

That is we have a custom form in which we have a descriptive flex field to capture some additional information regarding beneficiary tax id.This form has been shared with different payables responsiblity.T he requirement is we need this descriptive flex field to populate for certain Oraganization alone and not for the rest.Currently the descriptive flex field is populating for all the responsibility. Please provide some suggestion.
Quote
0 #19 Jaideep Valani 2007-03-20 00:00
hi anil ,i am unable to get what the reference field is for ,i mean why we need to go to reference fields,plz explain i am a beginner
thanks
jai
Quote
0 #20 Anil Passi 2007-03-24 00:00
Hi
reference field is the field on which DFF context is sensitive.

L ets take an example
If your reference field is ORDER_TYPE

t hen, lets say you have two possible values
DIRECT ORDER, COMMISSION ORDER

In this case, you will define two different codes beneath global data elements, namely
DIRECT ORDER
COMMISSI ON ORDER

Next you will define the fields/attribut es for each of this context

Than ks,
Quote
0 #21 Anil PAssi 2007-04-04 00:00
If you use a bind variable referencing the D2k form field, then such form field will not exist in OA Fwk Screen, hence the message.

You can ignore this provided:-
1. Its just a warning, and it lets you proceed
AND
2 . You have no intention to use OA Fwk couterpart of this screen

When you eventually move to OA Fwk for this functionality, then this DFF can be revisited.

T hanks,
Anil Passi
Quote
0 #22 Prasad 2007-04-05 00:00
Never mind .. I got it finally.. it was my mistake.. I had checked the displayed box. :) thanks to you again... I got it by following your example again from scratch but this that i didnt use my brain ( act smart) and followed it blindly. :)
Quote
0 #23 Rasi 2007-06-05 00:00
Hi,
How do you make the flexfield window pop-up as soon as a user tabs out of type field after typing SHIPs or SWIFT.
Quote
0 #24 Arnab 2007-08-14 04:37
Hi Anil
This is the most lucid and clear description of Context Sensitive DFFs I have seen. Please keep up your amazing contribution to the field of Oracle Apps. Three cheers :)
Warm Regards,
Arnab
Quote
0 #25 sujoy 2007-09-25 14:27
how do i find the dff name if the record history is not available for a particular form????
Quote
0 #26 Anil Passi 2007-09-25 14:46
You can use examine to figure that out.
Have a look at the image below


Thanks,
Anil Passi
Quote
0 #27 Thulasee Ram 2007-12-04 10:41
Hi Anil,

Can we generate the values in FSG Report with DFF Values?
Usually we generate FSG based on the account code combinations in GL(Values given in Key flex field.......). Suppose,there is a DFF at customer information level. From inventory/OM, the sales a/c, COGS A/C etc... will come to GL and based on that we can generate FSG. But at the customer level if there are values given in DFF and those will be related to any particular segment value of the Key flex field (say to a segment - Project)....... .when we prepare FSG that information can be captured in FSG. If it so could please explain me how that can done?

Thanks and Regards,
Thulas ee
Quote
0 #28 mmmm 2007-12-07 14:41
Hi Anil
I created a flexfiled in the customer site bill_to so the user can specifier if
the invoice for that customer will be e-mail or mail or not print, but know I like to
and I put those in attribute20 in table Hz_cust_site_us es_all, how can I make the autoinvoice
put that attibute20 in global_attribut e20 in ar_customer_trx _all for the same site.
Thank you
Quote
0 #29 Joel 2008-01-18 17:04
Hi Anil,
I'm trying to define a context sensitive descriptive flexfield and referencing the session user. Would I use in the reference field?

Thanks in advance
Quote
0 #30 Joel 2008-01-18 17:09
Forget the last message I wrote it wrong.

Hi Anil,
I'm trying to define a context sensitive descriptive flexfield and referencing the session user org id. Would I use $PROFILE$.ORG_I D in the reference field?

Thanks in advance
Joel
Quote
0 #31 Anoop Dangui 2008-03-12 12:37
Hi Anil,

Can you please help me to find the audit table for flex field which keep the record for all the changes done to the flex field vlaues. Does some setup need to be done for this to be implemented.

My requirement: I need to generate an outbound interface for all the delta changes of the fnd_flex_values of the GL flex field. So when i run my program it will fetch me the old and the new values of the flex segment which was changed. Could you please help to identify the table which stores the old value. Will be really helpful if you could provide any import.
Quote
0 #32 Anil Passi 2008-03-12 12:40
Hi Anoop

The tables are
FND_FLEX_VALUE S
FND_FLEX_VALU ES_TL

You may enable auditing on these tables.

Altern ately,create custom triggers, but it is not advisable to create DB triggers in Oracle Apps

Thanks
An il
Quote
0 #33 NM 2008-09-25 17:41
Hi Anil,
I have changed the existing DFF to context sensitive dff and need to change existing programs to accomodate these changes.
What information do I need to include?
Here are the details---


Th e part of original code is (THIS CODE WAS WRITTEN WHEN ATTRIBUTES WERE NOT CONTEXT SENSITIVE)---

select attribute4, trim(substr(att ribute5,10,14)) , trim(sustr(attr ibute5,124,15)) ,vendor_site_id , vendor_id
into v_team1, v_team2, v_team3, v_vendor_site_i d, v_vendor_id
fro m ap_invoices_all
where invoice_id = r_c_invoice_id;

The DFF details are:

Applicati on: Payables Title: Invoice
Context Prompt: US INV
Segments - Attributes1 to Attributes9

I have FLEX_VALUE_SET_ ID for each of the segment in the FND_DESCR_FLEX_ COL_USAGE_VL table.
ex: attribute1's flex_value_set_ id = 100001



WHAT CHANGES DO I NEED TO MAKE SO THE ABOVE CODE IS NOW REFRENCING TO CONTEXT SENSITIVE DFF?

Thanks,
N ileh
Quote
0 #34 Matt N. 2008-12-10 23:27
Anil, I was able to set up a context sensitive flexfield on the hr job form using your examples. The attribute column I used in the per_jobs table already contained many correct values prior to making it context sensitive. Unfortunately they will not display. I can see the correct value by querying the attribute column in the table but within the application the flexfield shows as blank. It will show if I use the value set and pick the same value and save it. Is there a way to make these existing values show without having to re-select them?

Thanks,
Matt
Quote
0 #35 sudeep 2009-08-27 01:34
Hi,
I need help in resolving an issue in DFF population on Custom Forms in Oracle Apps.

We have Tab pages like Accounts, Orders, Contracts.
On each tab page we have DDF related to each tab page Accounts, Orders, Contracts.
So once i click the Orders DFF its populating the DFF Data properly.But when i move to next tab page and Click Account's DFF, its populating both the DFF one after teh other i.e Accounts's DFF and then Order's DFF.
How do i avoid this situation. My block is based on only one view which calls multiple table for Accounts, Orders and Contracts.
I tried using FND_DESCR_FLEX. UPDATE_DEFINITI ON to diable the Orders DFF's when Accounts DFF is fired. But it makes the Orders DFf Disabled permanetly.
How to avaiod this situation.
Aapr eciate if anyone can guide me.

regards
Su deep
Quote
0 #36 Ash Manukyan 2010-05-02 21:10
Hi Anil, thanks a lot for all. Im big fun of your blog.
I have a problem with DFF. I want to populate an attribute with a value when user selects a subinventory. When I populate the field (attributeX) and user clicks the DFF, the popup does not upload my value. I tried also to populate Desc_flex field with a value but didn't work.
Any idea?
thanks
Quote
0 #37 Pan 2010-06-23 21:21
How to define DFF on R12 Customer form by Operating units
written by Pan , June 23, 2010
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 #38 thiru 2010-11-17 01:08
Hi Anil,
I need an help. Could you please advice how to enable the dff using the custom table. I have enable the dff, but unable to make those entered values to be stored in the custom table.
Ex. Assume that DFF name in XX_DFF and it is based on the custom table XX_TABLE which is having the column's Attribute1,Attr ibute2...
Pleas e guide me steps to follow to make the values stored in the custom table.

Thanks,
Thiru.
Quote
0 #39 Jennifer 2011-11-24 01:05
Hi Anil,

Can you please tell me how to populate the Bank Name field in the XX_BANK_DETAILS screen when the Bank Number is entered?

Thank you very much for your help.

Regards,
Jennifer
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
        1
  2  3  4  5  6  7  8
  9101112131415
16171819202122
23242526272829
3031     

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner