{"id":4533,"date":"2014-01-28T12:34:00","date_gmt":"2014-01-28T07:04:00","guid":{"rendered":"http:\/\/erpschools.com\/?p=4533"},"modified":"2014-12-02T07:56:06","modified_gmt":"2014-12-02T07:56:06","slug":"table-suffixes-oracle-apps_all_tl_f_v_vl_s_a","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a","title":{"rendered":"Table Suffixes in Oracle Apps"},"content":{"rendered":"

Table Suffixes:<\/span><\/p>\n

You have lot of tables ending with different suffixes in Oracle Apps database. Did you ever wonder what these denote? Listed below are the different table suffixes and what they mean.<\/p>\n

_ALL: Table ending with _ALL means it stores data related to multiple organizations. Such tables definitely will have a column called org_id which specifies to which org the record belongs to.<\/p>\n

_TL: Table ending with _TL is a Translation Table. Such tables have a column called language<\/p>\n

_B: Tables ending _B are the base tables<\/p>\n

_VL: Tables ending with _VL are Views built upon multi language or translation tables. In other words such views combine base table data with translation table data. If you wish to see the data related to a one particular language, you should set the language using USERENV(\u2018LANG\u2019).<\/p>\n

_V: Tables ending with _V are views<\/p>\n

_S: Tables ending with _S are Sequences<\/p>\n

_A, _Avn, _ACn: Tables ending with _A, _Avn, _ACn are audit tables.<\/p>\n

_F: Tables in which data is tracked with two date columns (Effective_start_Date, Effective_end_date). These tables are primarily used in HRMS and payroll modules.<\/p>\n

_DFV \/_KFV: DFF\/KFF view created on the base table. This is the best way to get the concatenated value of DFF\/KFF.
\nAlso using this table the values can be queried based on the DFF\/KFF name and not attributes column.<\/p>\n","protected":false},"excerpt":{"rendered":"

Table Suffixes: You have lot of tables ending with different suffixes in Oracle Apps database. Did you ever wonder what these denote? Listed below are the different table suffixes and what they mean. _ALL: Table ending with _ALL means it stores data related to multiple organizations. Such tables definitely will have a column called org_id […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[88,3],"tags":[184],"class_list":["post-4533","post","type-post","status-publish","format-standard","hentry","category-apps-beginners","category-articles","tag-table-suffixes"],"yoast_head":"\nTable Suffixes in Oracle Apps _ALL _TL _F _V _VL _S _A<\/title>\n<meta name=\"description\" content=\"Table Suffixes in Oracle Apps _ALL _TL _F _V _VL _S _A\" \/>\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\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a\" \/>\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\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"Table Suffixes in Oracle Apps\",\"datePublished\":\"2014-01-28T07:04:00+00:00\",\"dateModified\":\"2014-12-02T07:56:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a\"},\"wordCount\":237,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"keywords\":[\"Table Suffixes\"],\"articleSection\":[\"Apps Beginners\",\"Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a\",\"url\":\"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a\",\"name\":\"Table Suffixes in Oracle Apps _ALL _TL _F _V _VL _S _A\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"datePublished\":\"2014-01-28T07:04:00+00:00\",\"dateModified\":\"2014-12-02T07:56:06+00:00\",\"description\":\"Table Suffixes in Oracle Apps _ALL _TL _F _V _VL _S _A\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Table Suffixes in Oracle Apps\"}]},{\"@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":"Table Suffixes in Oracle Apps _ALL _TL _F _V _VL _S _A","description":"Table Suffixes in Oracle Apps _ALL _TL _F _V _VL _S _A","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\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"Table Suffixes in Oracle Apps","datePublished":"2014-01-28T07:04:00+00:00","dateModified":"2014-12-02T07:56:06+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a"},"wordCount":237,"commentCount":1,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"keywords":["Table Suffixes"],"articleSection":["Apps Beginners","Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a","url":"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a","name":"Table Suffixes in Oracle Apps _ALL _TL _F _V _VL _S _A","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"datePublished":"2014-01-28T07:04:00+00:00","dateModified":"2014-12-02T07:56:06+00:00","description":"Table Suffixes in Oracle Apps _ALL _TL _F _V _VL _S _A","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/articles\/table-suffixes-oracle-apps_all_tl_f_v_vl_s_a#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Table Suffixes in Oracle Apps"}]},{"@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\/4533","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=4533"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/4533\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=4533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=4533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=4533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}