{"id":4838,"date":"2014-04-20T20:38:19","date_gmt":"2014-04-20T20:38:19","guid":{"rendered":"http:\/\/erpschools.com\/?p=4838"},"modified":"2014-12-02T09:49:19","modified_gmt":"2014-12-02T09:49:19","slug":"api-gl_flexfields-_pkg-to-get-the-description-of-gl-account","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account","title":{"rendered":"API: GL_FLEXFIELDS _PKG to get the description of GL Account"},"content":{"rendered":"<p>API: GL_FLEXFIELDS _PKG to get the description of GL Account<\/p>\n<p>If you wish to display the account description, Oracle provides an API for that instead of hitting the Value Set tables for each of the segment. Below is an example of the same. <\/p>\n<p>Parameters:<br \/>\n1. Chart of Account id<br \/>\n2. Number of the Segment<br \/>\n3. Segment value for which you need the description<\/p>\n<p><code><br \/>\nSELECT gcc.code_combination_id,<br \/>\n  apps.gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,1,gcc.segment1) Segment1_desc,<br \/>\n  apps.gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,2,gcc.segment2) Segment2_desc,<br \/>\n  apps.gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,3,gcc.segment3) Segment3_desc,<br \/>\n  apps.gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,4,gcc.segment4) Segment4_desc,<br \/>\n  apps.gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,5,gcc.segment5) Segment5_desc<br \/>\nfrom gl_code_combinations gcc<br \/>\nwhere gcc.code_combination_id = 12854 -- code combination id<br \/>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>API: GL_FLEXFIELDS _PKG to get the description of GL Account If you wish to display the account description, Oracle provides an API for that instead of hitting the Value Set tables for each of the segment. Below is an example of the same. Parameters: 1. Chart of Account id 2. Number of the Segment 3. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[501],"tags":[248,249],"class_list":["post-4838","post","type-post","status-publish","format-standard","hentry","category-gl-api","tag-account-description","tag-gl_flexfields-_pkg"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>GL_FLEXFIELDS _PKG<\/title>\n<meta name=\"description\" content=\"GL_FLEXFIELDS _PKG can be used to get the description of a GL account. Sample query is provided.\" \/>\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\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"API: GL_FLEXFIELDS _PKG to get the description of GL Account\",\"datePublished\":\"2014-04-20T20:38:19+00:00\",\"dateModified\":\"2014-12-02T09:49:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account\"},\"wordCount\":72,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"keywords\":[\"Account Description\",\"GL_FLEXFIELDS _PKG\"],\"articleSection\":[\"GL API\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account\",\"url\":\"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account\",\"name\":\"GL_FLEXFIELDS _PKG\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"datePublished\":\"2014-04-20T20:38:19+00:00\",\"dateModified\":\"2014-12-02T09:49:19+00:00\",\"description\":\"GL_FLEXFIELDS _PKG can be used to get the description of a GL account. Sample query is provided.\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"API: GL_FLEXFIELDS _PKG to get the description of GL Account\"}]},{\"@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":"GL_FLEXFIELDS _PKG","description":"GL_FLEXFIELDS _PKG can be used to get the description of a GL account. Sample query is provided.","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\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"API: GL_FLEXFIELDS _PKG to get the description of GL Account","datePublished":"2014-04-20T20:38:19+00:00","dateModified":"2014-12-02T09:49:19+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account"},"wordCount":72,"commentCount":0,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"keywords":["Account Description","GL_FLEXFIELDS _PKG"],"articleSection":["GL API"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account","url":"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account","name":"GL_FLEXFIELDS _PKG","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"datePublished":"2014-04-20T20:38:19+00:00","dateModified":"2014-12-02T09:49:19+00:00","description":"GL_FLEXFIELDS _PKG can be used to get the description of a GL account. Sample query is provided.","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/api\/gl-api\/api-gl_flexfields-_pkg-to-get-the-description-of-gl-account#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"API: GL_FLEXFIELDS _PKG to get the description of GL Account"}]},{"@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\/4838","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=4838"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/4838\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=4838"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=4838"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=4838"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}