{"id":794,"date":"2011-04-14T07:07:31","date_gmt":"2011-04-14T07:07:31","guid":{"rendered":"http:\/\/sendyoursmiles.com\/articles\/financials\/importing-blanket-purchase-agreementsbpa-2"},"modified":"2011-04-14T07:07:31","modified_gmt":"2011-04-14T07:07:31","slug":"importing-blanket-purchase-agreementsbpa-2","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2","title":{"rendered":"Importing Blanket Purchase Agreements(BPA)"},"content":{"rendered":"<p>In this article we will see what a Blanket Purchase Agreement is and how we can import them along with the price breaks.<\/p>\n<p><span style=\"text-decoration: underline;\">Overview of Blanket Purchase Agreements:<\/span><\/p>\n<p>You create blanket purchase agreements when you know the detail of the goods or services you plan to buy from a specific supplier in a period, but you do not yet know the detail of your delivery schedules. You can use blanket purchase agreements to specify negotiated prices for your items before actually purchasing them.<\/p>\n<p><span style=\"text-decoration: underline;\">Blanket Releases:<\/span><\/p>\n<p>You can issue a blanket release against a blanket purchase agreement to place the actual order (as long as the release is within the blanket agreement effectivity dates. If your purchase agreement has price breaks, the quantity entered on the release determines what break price is defaulted into the Price field.<\/p>\n<p><span style=\"text-decoration: underline;\">Import Process:<\/span><\/p>\n<p>The Purchasing Document Open Interface concurrent program was replaced by two new concurrent Programs &#8211; Import Price Catalogs and Import Standard Purchase Orders.<\/p>\n<p>Import Price Catalogs concurrent program is used to import Catalog Quotations, Standard Quotations, and Blanket Purchase Agreements.<\/p>\n<p>Import Standard Purchase Orders concurrent program is used to import Unapproved or Approved Standard Purchase Orders.<\/p>\n<p>You need to populate PO_HEADERS_INTERFACE and PO_LINES_INTERFACE to import header and line information into Purchasing. PO_LINES_INTERFACE table contains both line and shipment information, and imports data into both the PO_LINES and PO_LINE_LOCATIONS. The below are the additional columns that are required in PO_LINES_INTERFACE if you want to import price break information:<\/p>\n<p>LINE_NUM<\/p>\n<p>SHIPMENT_NUM<\/p>\n<p>QUANTITY<\/p>\n<p>UNIT_PRICE<\/p>\n<p>If you are importing price break information through catalog quotations, you can also, optionally, populate the following columns in the PO_LINES_INTERFACE table:<\/p>\n<p>MIN_ORDER_QUANTITY<\/p>\n<p>MAX_ORDER_QUANTITY<\/p>\n<p>Let&#8217;s take an example to better understand. Suppose you want to create a blanket with one line and two price breaks and the details for the price break are as below:<\/p>\n<p>1)quantity = 500, price = 10, effective date from &#8217;01-JAN-2006&#8242; to &#8217;31-JUN-2006&#8242;<\/p>\n<p>2)quantity = 500, price = 11, effective date from &#8217;01-JUL-2006&#8242; to &#8217;01-JAN-2007&#8242;<\/p>\n<p>&nbsp;<\/p>\n<p>To create the above the BPA, you would create ONE record in PO_HEADERS_INTERFACE and THREE records in PO_LINES_INTERFACE<\/p>\n<p>LINE1: It will have only the line information. LINE NUM would be 1.<\/p>\n<p>LINE2: For the first Price Break details but the LINE NUM will be the same as above i.e 1. SHIPMENT_NUM would be 1 and SHIPMENT_TYPE would be &#8216;PRICE BREAK&#8217;<\/p>\n<p>LINE3: For the second Price Break details but the LINE NUM will be the same as above i.e 1. SHIPMENT_NUM would be 2 and SHIPMENT_TYPE would be &#8216;PRICE BREAK&#8217;<\/p>\n<p>All the line-level records above must have the same INTERFACE_HEADER_ID.<\/p>\n<p>&nbsp;<\/p>\n<p>&#8211;Inserting Header Information<\/p>\n<pre>\n\ninsert into po_headers_interface\n(\ninterface_header_id,\naction,\norg_id,\ndocument_type_code,\nvendor_id,\nvendor_site_id,\neffective_date,\nexpiration_date,\nVendor_doc_num)\nvalues\n(\npo_headers_interface_s.nextval,\n'ORIGINAL',\n204,\n'BLANKET',\n21,\n41,\n'01-JAN-2006',\n'01-JAN-2007',\n'VENDOR04302006'\n);\n<\/pre>\n<p>&#8211;Inserting Line Information<\/p>\n<pre>\n\ninsert into po_lines_interface\n(\ninterface_line_id,\ninterface_header_id,\naction,\nitem,\nline_num,\nunit_price,\nunit_of_measure,\neffective_date,\nexpiration_date,\nship_to_organization_id,\nship_to_location_id,\nPRICE_BREAK_LOOKUP_CODE\n)\nvalues\n(\npo_lines_interface_s.nextval,\npo_headers_interface_s.currval,\n\u2018ORIGINAL\u2019,\n\u2018AS54888\u2032,\n1,\n20,\n\u2018Each\u2019,\n\u201901-JAN-2006\u2032,\n\u201901-JAN-2007\u2032,\n207,\n207,\n\u2018NON CUMULATIVE\u2019);\n<\/pre>\n<p>Note: Cumulative: Price breaks apply to the cumulative quantity on all release shipments for the item.<\/p>\n<p>Non\u2013cumulative: Price breaks apply to quantities on individual release shipments for the item.<\/p>\n<p>&nbsp;<\/p>\n<p>&#8211;Inserting First Price Break<\/p>\n<pre>\n\ninsert into po_lines_interface\n(\ninterface_line_id,\ninterface_header_id,\naction,\nitem,\nline_num,\nshipment_num,\nshipment_type,\nquantity,\nunit_price,\nunit_of_measure,\nship_to_organization_id,\nship_to_location_id,\neffective_date,\nxpiration_date)\nvalues\n(\npo_lines_interface_s.nextval,\npo_headers_interface_s.currval,\n\u2018ORIGINAL\u2019,\n\u2018AS54888\u2032,\n1,\n1,\n\u2018PRICE BREAK\u2019,\n500,\n10,\n\u2018Each\u2019,\n207,\n207,\n\u201901-JAN-2006\u2032,\n\u201930-JUN-2006\u2032\n);\n<\/pre>\n<p>&#8211;Inserting Second Price Break<\/p>\n<pre>\n\ninsert into po_lines_interface\n(\ninterface_line_id,\ninterface_header_id,\naction,\nitem,\nline_num,\nshipment_num,\nshipment_type,\nquantity,\nunit_price,\nunit_of_measure,\nship_to_organization_id,\nship_to_location_id,\neffective_date,\nexpiration_date)\nvalues\n(\npo_lines_interface_s.nextval,\npo_headers_interface_s.currval,\n'ORIGINAL',\n'AS54888',\n1,\n2,\n'PRICE BREAK',\n500,\n11,\n'Each',\n207,\n207,\n'01-JUL-2006',\n'01-JAN-2007'\n);\n<\/pre>\n<p>Final Step:<\/p>\n<p>Run Import Price Catalog Concurrent Program to create this Blanket Purchase Agreement.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article we will see what a Blanket Purchase Agreement is and how we can import them along with the price breaks. Overview of Blanket Purchase Agreements: You create blanket purchase agreements when you know the detail of the goods or services you plan to buy from a specific supplier in a period, but [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,12,38],"tags":[],"class_list":["post-794","post","type-post","status-publish","format-standard","hentry","category-articles","category-financials","category-purchasing"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>blanket purchase agreement oracle<\/title>\n<meta name=\"description\" content=\"In this article we will see what a Blanket Purchase Agreement (BPA) is and how we can import them along with the price breaks.\" \/>\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\/importing-blanket-purchase-agreementsbpa-2\" \/>\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\/importing-blanket-purchase-agreementsbpa-2#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"Importing Blanket Purchase Agreements(BPA)\",\"datePublished\":\"2011-04-14T07:07:31+00:00\",\"dateModified\":\"2011-04-14T07:07:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2\"},\"wordCount\":521,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"articleSection\":[\"Articles\",\"Financials\",\"Purchasing\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2\",\"url\":\"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2\",\"name\":\"blanket purchase agreement oracle\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"datePublished\":\"2011-04-14T07:07:31+00:00\",\"dateModified\":\"2011-04-14T07:07:31+00:00\",\"description\":\"In this article we will see what a Blanket Purchase Agreement (BPA) is and how we can import them along with the price breaks.\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importing Blanket Purchase Agreements(BPA)\"}]},{\"@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":"blanket purchase agreement oracle","description":"In this article we will see what a Blanket Purchase Agreement (BPA) is and how we can import them along with the price breaks.","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\/importing-blanket-purchase-agreementsbpa-2","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"Importing Blanket Purchase Agreements(BPA)","datePublished":"2011-04-14T07:07:31+00:00","dateModified":"2011-04-14T07:07:31+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2"},"wordCount":521,"commentCount":3,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"articleSection":["Articles","Financials","Purchasing"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2","url":"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2","name":"blanket purchase agreement oracle","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"datePublished":"2011-04-14T07:07:31+00:00","dateModified":"2011-04-14T07:07:31+00:00","description":"In this article we will see what a Blanket Purchase Agreement (BPA) is and how we can import them along with the price breaks.","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/articles\/importing-blanket-purchase-agreementsbpa-2#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Importing Blanket Purchase Agreements(BPA)"}]},{"@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\/794","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=794"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/794\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}