{"id":4087,"date":"2024-10-30T15:29:48","date_gmt":"2024-10-30T09:59:48","guid":{"rendered":"https:\/\/blogs.infosys.com\/infosys-cobalt\/?p=4087"},"modified":"2024-10-30T15:30:22","modified_gmt":"2024-10-30T10:00:22","slug":"oracle-r12-consignment-consumption-linking-for-supplier-invoice-reconciliation","status":"publish","type":"post","link":"https:\/\/blogs.infosys.com\/infosys-cobalt\/cloud-analytics\/oracle-r12-consignment-consumption-linking-for-supplier-invoice-reconciliation.html","title":{"rendered":"Oracle R12 Consignment Consumption Linking for Supplier Invoice Reconciliation"},"content":{"rendered":"

The consignment process in Oracle EBS R12 is having a white space in linking consigned and consumption PO due to which suppliers find it difficult to raise invoices\/ do reconciliation against the correct consumption PO in the iSupplier portal or in other systems. Additionally, there is no separate PO number sequencing for consumption PO which makes it difficult for suppliers as they might use a different system for invoicing. Moreover, prices may change at the time of invoicing, and we need to adjust it in the PO in certain conditions. A custom logic needs to be added so that the consignment process in R12 can address this gap. This blog describes how a utility tool and reporting mechanism can be leveraged to tag consignment and consumption POs based on First Consignment-<tie to>-First-Consumption logic. This will help Buyers \/ Suppliers to reconcile Consumption and Consigned PO\u2019s.<\/p>\n

<\/p>\n

Business Consignment Current Process<\/strong><\/p>\n

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

Process\/ Data Flow<\/strong>
\nConsumption Consignee Linking Utility<\/strong><\/p>\n

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

Consignment and Consumption Report<\/strong><\/p>\n

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

Consigned and Consumption PO data would be exported by BI utility tool from the backend into Excel and placed over in a network location. This BI utility tool will run on user demand.<\/p>\n

Based on First Consignment-<tie to>-First-Consumption logic we are tagging Consignment PO with Consumption POs and listing on this report. This report helps in reconciling both Consumption and Consigned PO\u2019s, taking Supplier, Supplier Site, Item and Consigned and Consumption Organization Code into consideration.<\/p>\n

There are two concurrent programs – one to load the necessary data and the other to generate the report. The concurrent programs are designed in such a way to accommodate the ease of generating the report based on the input parameter given while submitting.<\/p>\n

<\/p>\n

PO Consumption Consignee Linking Utility<\/strong>
\nWhen the program is run, it loads all the data related to the consumption and consignment purchase orders and links both accordingly based on the FIFO basis considering the creation date of the transaction (for consignee it will be receipt deliver transaction date and consumption it is po shipment creation date). Once the data is obtained, it is stored in the custom staging table for further usage.<\/p>\n

<\/p>\n

Consignment and Consumption Report<\/strong>
\nWhen the program is run, it gathers the required data from the custom staging table based on the input parameters and generates the report. The report can be seen in the output once the program is successfully run.<\/p>\n

Consigned and Consumption PO data would be exported by BI utility tool from backend into excel and place it over some path. On user demand, BI utility tool will run. This report helps in reconciling both Consumption and Consigned PO\u2019s. We will tag consignment POs with Consumption POs on First-In-First-Out basis. Consignment PO and Consumption PO will be linked with the following:<\/p>\n

1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Item number<\/p>\n

2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Organization code<\/p>\n

3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Vendor Name<\/p>\n

4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Vendor site code<\/p>\n

5.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Consigned and Consumption Plant Code<\/p>\n

<\/p>\n

Input parameters<\/strong><\/p>\n

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

Output: Showing links between Consignment and Consumption PO<\/strong><\/p>\n

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

Below are the specific business needs that will be handled as part of this:<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Consigned PO receipt Quantity and Consumption PO Quantity will have same value.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Multiple Consigned and Consumption POs linkages.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Consigned PO Cancellations.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Partial Receipts.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Corrections in PO after receiving.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Return to Consigned or Return to Vendor.<\/p>\n

<\/p>\n

Conclusion<\/strong>
\nThe solution brought in the following business benefits by streamlining processes:<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Consignment-led procurement allows organization to optimize efficiency, cost savings.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 It automated the entire procurement cycle from purchase order, Inventory cycles, throughput till settlement with supplier.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Buyers become more productive by eliminating repetitive transactions.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Oracle iSupplier Portal lets you collaborate online with all your suppliers via a\u00a0web browser.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Helped related processes like VMI, other catalog purchases.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Business started using transactions like Sales Order issues, Backflush, Inter-organization transfers, Miscellaneous issues etc. in a more effective way.<\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 The solution is scalable and can be secured via custom profile for specific orgs.<\/p>\n","protected":false},"excerpt":{"rendered":"

The consignment process in Oracle EBS R12 is having a white space in linking […]<\/p>\n","protected":false},"author":716,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[11],"tags":[],"coauthors":[388],"class_list":["post-4087","post","type-post","status-publish","format-standard","hentry","category-cloud-analytics"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/posts\/4087","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/users\/716"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/comments?post=4087"}],"version-history":[{"count":4,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/posts\/4087\/revisions"}],"predecessor-version":[{"id":4128,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/posts\/4087\/revisions\/4128"}],"wp:attachment":[{"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/media?parent=4087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/categories?post=4087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/tags?post=4087"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/blogs.infosys.com\/infosys-cobalt\/wp-json\/wp\/v2\/coauthors?post=4087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}