{"id":1795,"date":"2011-04-17T13:28:28","date_gmt":"2011-04-17T07:58:28","guid":{"rendered":"http:\/\/sendyoursmiles.com\/articles\/descriptive-flexfields"},"modified":"2011-04-17T13:28:28","modified_gmt":"2011-04-17T07:58:28","slug":"descriptive-flexfields","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields","title":{"rendered":"Descriptive Flexfields"},"content":{"rendered":"

Overview of Flexfields:<\/span><\/p>\n

A flexfield is a field made up of sub\u2013fields, or segments. There are two types of flexfields: key flexfields and descriptive flexfields.<\/p>\n

Key Flexfields:<\/span><\/p>\n

A Key flexfield is a field made up of segments, where each segment has both a value and a meaning, which appears on your form as a normal text field with an appropriate prompt.<\/p>\n

One example of a key flexfield is the Accounting Flexfield. This flexfield can always be customized to have as many segments as needed like Company, Department,\u00a0Cost center, Account etc.<\/p>\n

Descriptive flexfields:<\/span><\/p>\n

Descriptive flexfields 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 flexfields can be context sensitive, where the information your application stores depends on other values your users enter in other parts of the form.<\/p>\n

A descriptive flexfield appears on a form as a single\u2013character, unnamed field enclosed in Square Brackets [ ]. Each field or segment in a descriptive flexfield has a prompt and can have a set of valid values<\/p>\n

Descriptive Flexfield Concepts:<\/span><\/p>\n

Descriptive flexfields have two different types of segments, global and context\u2013sensitive.<\/p>\n

A global segment is a segment that always appears in the descriptive flexfield pop\u2013up window.<\/p>\n

A context\u2013sensitive segment is a segment that may or may not appear depending upon what other information is present in your form.<\/p>\n

A descriptive flexfield can get context information from either a field somewhere on the form, or from a special field (a context field) inside the descriptive flexfield pop\u2013up window. If the descriptive flexfield derives the context information from a form field (either displayed or hidden from users), that field is called a reference field for the descriptive flexfield.<\/p>\n

A descriptive flexfield uses columns that are added on to a database table. A descriptive flexfield requires one column for each possible segment and one additional column in which to store structure information (that is, the context value). The descriptive flexfield columns are usually named ATTRIBUTEn where n is a number.<\/p>\n

For example, if you have a descriptive flexfield on an Order Entry (Header) form, it populates the Structure column with the context field and the columns ATTRIBUTEn with the flexfield segments of the table OE_ORDER_HEADERS_ALL.<\/p>\n

Example of enabling DFF:<\/p>\n

Goal: Enable DFF in Sales Order form in Order Management
\nNavigation: Go to “Order management super User, Vision Operations”\u00a0responsibility >\u00a0Orders, Returns >> Sales Orders<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Enable the DFF at right bottom screen.<\/p>\n

To know the name of the DFF in a particular form do the following<\/p>\n

Navigation: Help Menu >> Diagnostics >> Examine<\/p>\n

Select Block Name as $DESCRIPTIVE_FLEXFIELD$<\/p>\n

Field as ORDER.DF<\/p>\n

Value will be populated and it will be the title of your DFF.<\/p>\n

Title: Additional Header Information (Order Management)<\/p>\n

Order management in the brackets represent the Application in which this DFF is registered.<\/p>\n

\"\"<\/p>\n

To enable this<\/p>\n

Navigation: Go to Application Developer >> Flexfield >> Descriptive >> Segments<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Query the DFF<\/p>\n

Press F11 and enter<\/p>\n

Title: Additional Header Information<\/p>\n

Application: Order Management<\/p>\n

\"\"<\/p>\n

Press CTL + F11 to query the record<\/p>\n

\"\"<\/p>\n

Click on Segments<\/p>\n

Enter the following information<\/p>\n

Number: 5<\/p>\n

Name: Erp Schools Demo<\/p>\n

Window Prompt: Erp Schools Demo<\/p>\n

Column: ATTRIBUTE11<\/p>\n

Save the record (CTL + S)<\/p>\n

\"\"<\/p>\n

Press OK<\/p>\n

You can assign any value set if you want, its optional so I am just leaving it as blank<\/p>\n

Now check the “Freeze Flexfield Definition” Checkbox<\/p>\n

\"\"<\/p>\n

Press OK<\/p>\n

Now Click Compile button<\/p>\n

\"\"<\/p>\n

Press OK<\/p>\n

\"\"<\/p>\n

You will see the confirmation as shown above.<\/p>\n

Now to go to Order management super User, Vision Operations” and open the Sales order Form and click on DFF box.<\/p>\n

\"\"<\/p>\n

You can hide the context field by un checking the Displayed Check Box in Context Field<\/p>\n

\"\"<\/p>\n

To Make any changes you have to uncheck the “Freeze Flexfield Definition” Checkbox<\/p>\n

\"\"<\/p>\n

Press OK<\/p>\n

Now uncheck the Displayed Box in Context Field area as shown<\/p>\n

\"\"<\/p>\n

Save your Record<\/p>\n

Check the “Freeze Flexfield Definition” Checkbox<\/p>\n

\"\"<\/p>\n

Press OK<\/p>\n

Press Compile Button<\/p>\n

\"\"<\/p>\n

Press OK<\/p>\n

\"\"<\/p>\n

“Flexfield View Generator” concurrent program will be submitted. To see the status of the program go to View Menu on top >> Requests >> Find<\/p>\n

\"\"<\/p>\n

Once you see the status as completed you can go to Order Management and check for your changes<\/p>\n

\"\"<\/p>\n

Now you should be able to hide the Context.<\/p>\n","protected":false},"excerpt":{"rendered":"

Overview of Flexfields: A flexfield is a field made up of sub\u2013fields, or segments. There are two types of flexfields: key flexfields and descriptive flexfields. Key Flexfields: A Key flexfield is a field made up of segments, where each segment has both a value and a meaning, which appears on your form as a normal […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,8],"tags":[],"class_list":["post-1795","post","type-post","status-publish","format-standard","hentry","category-articles","category-sysadmin-and-aol"],"yoast_head":"\noracle apps Descriptive Flexfields<\/title>\n<meta name=\"description\" content=\"A flexfield is a field made up of sub\u2013fields, or segments. There are two types of flexfields: key flexfields (kff)and descriptive flexfields(dff).\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prudhvi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"Descriptive Flexfields\",\"datePublished\":\"2011-04-17T07:58:28+00:00\",\"dateModified\":\"2011-04-17T07:58:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields\"},\"wordCount\":731,\"commentCount\":17,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1327_Descriptive1.jpg\",\"articleSection\":[\"Articles\",\"Sysadmin and AOL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields\",\"url\":\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields\",\"name\":\"oracle apps Descriptive Flexfields\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#primaryimage\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1327_Descriptive1.jpg\",\"datePublished\":\"2011-04-17T07:58:28+00:00\",\"dateModified\":\"2011-04-17T07:58:28+00:00\",\"description\":\"A flexfield is a field made up of sub\u2013fields, or segments. There are two types of flexfields: key flexfields (kff)and descriptive flexfields(dff).\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#primaryimage\",\"url\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1327_Descriptive1.jpg\",\"contentUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1327_Descriptive1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Descriptive Flexfields\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/erpschools.com\/erps\/#website\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"name\":\"erpSchools\",\"description\":\"Oracle Apps\",\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/erpschools.com\/erps\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\",\"name\":\"erpSchools\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"width\":250,\"height\":60,\"caption\":\"erpSchools\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/facebook.com\/erpschools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\",\"name\":\"Prudhvi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"caption\":\"Prudhvi\"},\"sameAs\":[\"http:\/\/www.erpschools.com\"],\"url\":\"https:\/\/erpschools.com\/erps\/author\/prudhvi\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"oracle apps Descriptive Flexfields","description":"A flexfield is a field made up of sub\u2013fields, or segments. There are two types of flexfields: key flexfields (kff)and descriptive flexfields(dff).","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"Descriptive Flexfields","datePublished":"2011-04-17T07:58:28+00:00","dateModified":"2011-04-17T07:58:28+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields"},"wordCount":731,"commentCount":17,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"image":{"@id":"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1327_Descriptive1.jpg","articleSection":["Articles","Sysadmin and AOL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields","url":"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields","name":"oracle apps Descriptive Flexfields","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"primaryImageOfPage":{"@id":"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#primaryimage"},"image":{"@id":"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1327_Descriptive1.jpg","datePublished":"2011-04-17T07:58:28+00:00","dateModified":"2011-04-17T07:58:28+00:00","description":"A flexfield is a field made up of sub\u2013fields, or segments. There are two types of flexfields: key flexfields (kff)and descriptive flexfields(dff).","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#primaryimage","url":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1327_Descriptive1.jpg","contentUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1327_Descriptive1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/articles\/descriptive-flexfields#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Descriptive Flexfields"}]},{"@type":"WebSite","@id":"https:\/\/erpschools.com\/erps\/#website","url":"https:\/\/erpschools.com\/erps\/","name":"erpSchools","description":"Oracle Apps","publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/erpschools.com\/erps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/erpschools.com\/erps\/#organization","name":"erpSchools","url":"https:\/\/erpschools.com\/erps\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","width":250,"height":60,"caption":"erpSchools"},"image":{"@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/erpschools"]},{"@type":"Person","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512","name":"Prudhvi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","caption":"Prudhvi"},"sameAs":["http:\/\/www.erpschools.com"],"url":"https:\/\/erpschools.com\/erps\/author\/prudhvi"}]}},"_links":{"self":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/1795","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/comments?post=1795"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/1795\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=1795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=1795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=1795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}