{"id":1350,"date":"2011-04-17T11:38:26","date_gmt":"2011-04-17T06:08:26","guid":{"rendered":"http:\/\/sendyoursmiles.com\/articles\/sub-functions-in-oracle-application"},"modified":"2011-04-17T11:38:26","modified_gmt":"2011-04-17T06:08:26","slug":"sub-functions-in-oracle-application","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application","title":{"rendered":"Sub Functions In Oracle Applications"},"content":{"rendered":"

Oracle apps sub functions Overview:<\/strong><\/p>\n

There are two types of functions: form functions, and non-form functions. For clarity, we refer to a form function as a form, and a non-form function as a sub\u00a0function, even though both are just instances of functions in the database.<\/p>\n

Oracle Applications aggregates several related business functions into a single form. But all users should not have access to every business function in a form; Oracle Applications provides the ability to identify pieces of applications logic as subfunctions. When part of an application’s functionality is identified as a sub\u00a0functions, it can be secured (i.e., included or excluded from a responsibility).<\/p>\n

 <\/p>\n

Sub function (Non-Form Function):<\/strong><\/p>\n

A non-form function (sub function) is a securable subset of a form’s functionality. Sub functions are frequently associated with buttons or other graphical elements on forms. For example, when a sub function is created for a button in a form and if the created sub function is added to the particular responsibility, then only the corresponding button will be enabled in that responsibility, otherwise (if the created sub function is not added to responsibility) the button is disabled, even if the main function is added to that responsibility, and the user will not be able to access the button.<\/p>\n

The user can access the main function but not the sub function, if the sub function is not added to the responsibility, which means we can provide security to the part of the form functionality, using the function security mechanism through the sub function.<\/p>\n

\"\"<\/p>\n

Diagrammatic illustration of the sub functions<\/p>\n

 <\/p>\n

Steps to implement a Sub function in a form:<\/span><\/p>\n

1: Open Template.fmb using Oracle form builder, save it with another name(XX_SUB_FUNC.fmb) and give the module name as “XX_SUB_FUNC”.<\/p>\n

\"\"<\/p>\n

2: Delete the following:<\/span><\/p>\n

“BLOCKNAME” from Canvas and Data Block<\/p>\n

“DETAILBLOCK” from Data Block<\/p>\n

“BLOCKNAME” from Window.<\/p>\n

\"\"<\/p>\n

\"\"\/<\/p>\n

3: Create window (XX_SUB_WIN), apply subclass information as “WINDOW” and give the title.<\/p>\n

\"\"\/<\/p>\n

4: Give this window name in PRE-FORM trigger (Form Level) and also in APP_CUSTOM body from Program_Unit (in place of window name).<\/p>\n

\"\"<\/p>\n

Give this window name in PRE-FORM trigger (Form Level) As Shown below<\/p>\n

 <\/p>\n

\"\"<\/p>\n

Give this window name in APP_CUSTOM (PACKAGE BODY) as below<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

5: Create New Canvas<\/p>\n

\"\"\/<\/p>\n

6: Now create a new Data block (EMP) using Wizard or Manual, apply subclass information to the block as “BLOCK” and also apply subclass information to the items as “TEXT_ITEM”.<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Click on Finish…………..until finish<\/p>\n

7: Give the Subclass information for Block (EMP) As BLOCK<\/p>\n

\"\"<\/p>\n

8: Create a Button(EXIT) in Canvas and write your required functionality code in when button pressed trigger.<\/p>\n

\"\"<\/p>\n

9: Give the Subclass information for ITEM (EMPNO) as TEXT_ITEM<\/p>\n

\"\"<\/p>\n

10: Finally move your form from our Local Machine to CUSTOM_TOP using WINSCP or any of your local tools.<\/p>\n

\"\"<\/p>\n

11: Compile the Form using “f60gen”<\/p>\n

In the UNIX environment, type the following command:<\/p>\n

f60gen XX_SUB_FUNC.fmb apps\/apps<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

12: Connect to Oracle Applications:<\/p>\n

1. Create a Form (Navigation: Application Developer->Application-> Form)<\/p>\n

Here give the following details and save the details.<\/p>\n

Form =>XX_SUB_FUNC (.fmx )
\nApplication => xxmz Custom(Custom TOP Application)
\nUser Form Name=>Give any name<\/p>\n

\"\"<\/p>\n

2. Create a function (Navigation: Application->function)<\/p>\n

Here give the following details:<\/p>\n

Description Tab:<\/p>\n

Function name: Any Name (XX_SUB_FUNC_FUNC)<\/p>\n

User Function Name: Any Name (XX_SUB_FUNC_FUNC)<\/p>\n

\"\"<\/p>\n

Properties Tab:<\/p>\n

Type: Form<\/p>\n

Maintenance Mode Support: None<\/p>\n

Context Dependence: Responsibility<\/p>\n

\"\"<\/p>\n

Form Tab:<\/p>\n

 <\/p>\n

Attach User Form Name:XX_SUB_FUNC<\/p>\n

 <\/p>\n

\"\"<\/p>\n

Create Sub Function (XX_SUB_FUNC_FUNC1) below the main function<\/p>\n

(Navigation: Application Developer=>Application=>Function)<\/p>\n

Give the User Function Name: XX_SUB_FUNC_FUNC: EXIT (User function name: button name)<\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

Properties Tab:<\/p>\n

 <\/p>\n

Type: Sub function<\/p>\n

Maintenance Mode Support: None<\/p>\n

Context Dependence: Responsibility<\/p>\n

\"\"<\/p>\n

13: Once again Switch to Form builder open the user form and go to Form Level Trigger<\/p>\n

“WHEN_NEW_FORM_INSTANCE” and incorporate the function<\/p>\n

\"\"<\/p>\n

14: Write the Function ( Function name=>fnd_function.test) As<\/p>\n

Script:<\/p>\n

if fnd_function.test(‘XX_SUB_FUNC_FUNC1′)then
\nset_item_property(’emp.exit’,ENABLED<PROPERTY_TRUE):
\nelse
\nset_item_property(’emp.exit’,ENABLED,PROPERTY_FALSE);
\nEND IF;<\/p>\n

\"\"<\/p>\n

15: Save it and move the form to custom top using WINSCP like tools and compile the form again<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

16: Switch to Oracle application:<\/p>\n

Switch to Menu<\/p>\n

(Navigation: Application Developer=>Application=>Menu)<\/p>\n

Attach Main function to the Custom TOP menu<\/p>\n

User function name: XX_SUB_FUNC_FUNC<\/p>\n

\"\"<\/p>\n

Switch to Custom Application Responsibility (XXMZ CUSTOM)<\/p>\n

\"\"<\/p>\n

Execute the Function (Click on the Function name)<\/p>\n

(Function name=>sub functions)<\/p>\n

\"\"<\/p>\n

The button will be disabled (because the sub function is added for the button and sub function is not added to the custom menu)<\/p>\n

\"\"<\/p>\n

Switch to Application Developer Responsibility<\/p>\n

\"\"<\/p>\n

Attach Sub function to the Custom TOP menu without giving prompt.<\/p>\n

User sub function name: XX_SUB_FUNC_FUNC: EXIT<\/p>\n

\"\"<\/p>\n

Again Switch Custom Application Responsibility(XXMZ CUSTOM)<\/p>\n

\"\"<\/p>\n

Click on Function name (sub functions)<\/p>\n

\"\"<\/p>\n

The button will be enabled (because the sub function is added to the button and also to the custom menu)<\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle apps sub functions Overview: There are two types of functions: form functions, and non-form functions. For clarity, we refer to a form function as a form, and a non-form function as a sub\u00a0function, even though both are just instances of functions in the database. Oracle Applications aggregates several related business functions into a single […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-1350","post","type-post","status-publish","format-standard","hentry","category-forms"],"yoast_head":"\noracle apps sub functions<\/title>\n<meta name=\"description\" content=\"Two types of functions: form functions, and non-form functions. refereed to a form function as a form, and a non-form function as sub function\" \/>\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\/forms\/sub-functions-in-oracle-application\" \/>\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\/forms\/sub-functions-in-oracle-application#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"Sub Functions In Oracle Applications\",\"datePublished\":\"2011-04-17T06:08:26+00:00\",\"dateModified\":\"2011-04-17T06:08:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application\"},\"wordCount\":854,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1136_SubFunction1.png\",\"articleSection\":[\"Forms\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application\",\"url\":\"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application\",\"name\":\"oracle apps sub functions\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#primaryimage\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1136_SubFunction1.png\",\"datePublished\":\"2011-04-17T06:08:26+00:00\",\"dateModified\":\"2011-04-17T06:08:26+00:00\",\"description\":\"Two types of functions: form functions, and non-form functions. refereed to a form function as a form, and a non-form function as sub function\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#primaryimage\",\"url\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1136_SubFunction1.png\",\"contentUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1136_SubFunction1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sub Functions In Oracle Applications\"}]},{\"@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 sub functions","description":"Two types of functions: form functions, and non-form functions. refereed to a form function as a form, and a non-form function as sub function","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\/forms\/sub-functions-in-oracle-application","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"Sub Functions In Oracle Applications","datePublished":"2011-04-17T06:08:26+00:00","dateModified":"2011-04-17T06:08:26+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application"},"wordCount":854,"commentCount":0,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"image":{"@id":"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1136_SubFunction1.png","articleSection":["Forms"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application","url":"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application","name":"oracle apps sub functions","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"primaryImageOfPage":{"@id":"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#primaryimage"},"image":{"@id":"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1136_SubFunction1.png","datePublished":"2011-04-17T06:08:26+00:00","dateModified":"2011-04-17T06:08:26+00:00","description":"Two types of functions: form functions, and non-form functions. refereed to a form function as a form, and a non-form function as sub function","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#primaryimage","url":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1136_SubFunction1.png","contentUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1136_SubFunction1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/forms\/sub-functions-in-oracle-application#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Sub Functions In Oracle Applications"}]},{"@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\/1350","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=1350"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/1350\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=1350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=1350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=1350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}