{"id":4547,"date":"2014-02-18T15:44:46","date_gmt":"2014-02-18T10:14:46","guid":{"rendered":"http:\/\/erpschools.com\/?p=4547"},"modified":"2014-02-18T15:44:46","modified_gmt":"2014-02-18T10:14:46","slug":"inventory-on-hand-quantity-interface","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface","title":{"rendered":"Inventory On-hand quantity Interface"},"content":{"rendered":"

Interface Program:<\/span><\/p>\n

Launch the Transaction Manager through Interface Manager or explicitly call the API \u2013 INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS () to launch a dedicated transaction worker to process them.<\/p>\n

The Transaction Manager picks up the rows to process based on the LOCK_FLAG, TRANSACTION_MODE, and PROCESS_FLAG. Only records with TRANSACTION_MODE of 3, LOCK_FLAG of \u20192\u2032, and PROCESS_FLAG of \u20191\u2032 will be picked up by the Transaction Manager and assigned to a Transaction Worker. If a record fails to process completely, then PROCESS_FLAG will be set to \u20193\u2032 and ERROR_CODE and ERROR_EXPLANATION will be populated with the cause for the error.<\/p>\n

Base Tables:<\/span><\/p>\n

MTL_ON_HAND_QUANTITIES
\nMTL_LOT_NUMBERS
\nMTL_SERIAL_NUMBERS<\/p>\n

Validations:<\/span><\/p>\n

Validate organization_id
\nCheck if item is assigned to organization
\nValidate disposition_id
\nCheck if the item for the org is lot controlled before inserting into the Lots interface table.
\nCheck if the item for the org is serial controlled before inserting into Serial interface table.
\nCheck if inventory already exists for that item in that org and for a lot.
\nValidate organization_id, organization_code.
\nValidate inventory item id.
\nTransaction period must be open.<\/p>\n

Interface tables:<\/span><\/p>\n

MTL_TRANSACTIONS_INTERFACE
\nMTL_MTL_TRANSACTION_LOTS_INTERFACE (If the item is Lot controlled)
\nMTL_SERIAL_NUMBERS_INTERFACE (If the item is Serial controlled)<\/p>\n

MTL_TRANSACTIONS_INTERFACE:<\/span><\/p>\n

TRANSACTION_SOURCE_NAME (ANY USER DEFINED VALUE),
\nTRANSACTION_HEADER_ID (MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL)
\nTRANSACTION_INTERFACE_ID (MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL \u2013 If item is lot or serial controlled, use this field to link to mtl_transactions_interface otherwise leave it as NULL),
\nTRANSACTION_DATE,
\nTRANSACTION_TYPE_ID,
\nPROCESS_FLAG (1 = Yet to be processed, 2 = Processed, 3= Error)
\nTRANSACTION_MODE (2 = Concurrent \u2013 to launch a dedicated transaction worker to explicitly process a set of transactions. 3 = Background \u2013 will be picked up by transaction manager polling process and assigned to transaction worker. These will not be picked up until the transaction manager is running)
\nSOURCE_CODE,
\nSOURCE_HEADER_ID,
\nSOURCE_LINE_ID (Details about the source like Order Entry etc for tracking purposes)
\nITEM_SEGMENT1,
\nTRANSACTION_QTY,
\nTRANSACTION_UOM,
\nSUBINVENTORY_CODE,
\nORGANIZATION_ID,
\nLOC_SEGMENT1.
\nTRANSACTION_SOURCE_ID<\/p>\n

Source Type Foreign Key Reference
\nAccount GL_CODE_COMBINATIONS.CODE_COMBINATION_ID
\nAccount Alias MTL_GENERIC_DISPOSITIONS.DISPOSITION_ID
\nJob or schedule WIP_ENTITIES.WIP_ENTITY_ID
\nSales Order MTL_SALES_ORDERS.SALES_ORDER_ID<\/p>\n

MTL_TRANSACTION_LOTS_INTERFACE:<\/span>
\nTRANSACTION_INTERFACE_ID,
\nLOT_NUMBER,
\nLOT_EXPIRATION_DATE,
\nTRANSACTION_QUANTITY,
\nSERIAL_TRANSACTION_TEMP_ID (This is required for items under both lot and serial control to identify child records in mtl_serial_numbers_interface)<\/p>\n

MTL_SERIAL_NUMBERS_INTERFACE:<\/span>
\nTRANSACTION_INTERFACE_ID,
\nFM_SERIAL_NUMBER,
\nTO_SERIAL_NUMBER,
\nVENDOR_SERIAL_NUMBER<\/p>\n

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

Interface Program: Launch the Transaction Manager through Interface Manager or explicitly call the API \u2013 INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS () to launch a dedicated transaction worker to process them. The Transaction Manager picks up the rows to process based on the LOCK_FLAG, TRANSACTION_MODE, and PROCESS_FLAG. Only records with TRANSACTION_MODE of 3, LOCK_FLAG of \u20192\u2032, and PROCESS_FLAG of \u20191\u2032 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-4547","post","type-post","status-publish","format-standard","hentry","category-interface"],"yoast_head":"\ninventory on hand quantity interface<\/title>\n<meta name=\"description\" content=\"inventory on hand quantity interface\" \/>\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\/interface\/inventory-on-hand-quantity-interface\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"Inventory On-hand quantity Interface\",\"datePublished\":\"2014-02-18T10:14:46+00:00\",\"dateModified\":\"2014-02-18T10:14:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface\"},\"wordCount\":449,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"articleSection\":[\"Interface\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface\",\"url\":\"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface\",\"name\":\"inventory on hand quantity interface\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"datePublished\":\"2014-02-18T10:14:46+00:00\",\"dateModified\":\"2014-02-18T10:14:46+00:00\",\"description\":\"inventory on hand quantity interface\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Inventory On-hand quantity Interface\"}]},{\"@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":"inventory on hand quantity interface","description":"inventory on hand quantity interface","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\/interface\/inventory-on-hand-quantity-interface","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"Inventory On-hand quantity Interface","datePublished":"2014-02-18T10:14:46+00:00","dateModified":"2014-02-18T10:14:46+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface"},"wordCount":449,"commentCount":0,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"articleSection":["Interface"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface","url":"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface","name":"inventory on hand quantity interface","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"datePublished":"2014-02-18T10:14:46+00:00","dateModified":"2014-02-18T10:14:46+00:00","description":"inventory on hand quantity interface","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/interface\/inventory-on-hand-quantity-interface#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Inventory On-hand quantity Interface"}]},{"@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\/4547","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=4547"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/4547\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=4547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=4547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=4547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}