Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« Vroom Vroom... with the Infosys Automotive Solution | Main | Excel to App - a journey beckoning finance world to the future of technology? A view from the Oracle Analytics Cloud Consultants' Lenses »

Oracle Cloud Manufacturing integration with Project Costing.

Oracle Cloud is buzzing now days in ERP market. Most of the organization are looking for cloud transformation. However as the Oracle Cloud is evolving, still there are few functions, integrations are missing and not yet released with latest Oracle cloud R13 release. One of the major Project Portfolio Management sub module missing in Oracle Cloud R13 is Project Manufacturing.

As in Oracle EBS, Project Manufacturing play acute role to integrate Project Manufacturing process with Project Costing. Project manufacturing help to account and integrate Project related manufacturing cost to project costing, to gives complete picture of project cost across the sub-ledger which help for better decision making.

In most of the project based manufacturing organization, Project manufacturing is key sub module without it not possible to complete project manufacturing business process cycle. As Project manufacturing is not yet released by Oracle Cloud, so it's creating gap between manufacturing and project costing process. There is no integration to import project related manufacturing cost from SCM cloud to cloud project costing. Which is becoming an obstacle for project manufacturing organization to move on Oracle Cloud.

However there are some workaround available to bridge the gap between manufacturing and project costing process. We are going to explore below:

 

1.    Project Transaction Type:

Oracle Cloud allow to create Misc Issue to Project and Misc Receipt from Project transaction. This are standard process provided in Oracle Cloud even as Project Manufacturing is not available.

If it need to transfer a cost on Inventory item purchase to Project then can follow below process.

1.     Create Inventory PO

2.     Receive a PO

3.     Create Misc issue to transfer inventory PO cost to Project

4.     Run Cost accounting

5.     Transfer Cost to Project

Similarly you can perform Misc issue to Project to transfer cost to project for other business process.

We can use this workaround in scenario, where simple project manufacturing business process and less number of project manufacturing transactions get generated.

PJM_New01.jpg


2.   File Based Data Import (FBDI) :

In case of complex project manufacturing business process where the large number of project related manufacturing transaction gets generated, in such scenario it's tedious to keep track and perform manual transaction as "Misc Issue to Project" to transfer cost to Project. In this case FBDI is alternate option.

FBDI template feature helps to import bulk data from third-party system or other Oracle ERP applications or create new transaction data in Oracle Cloud. The FBDI template# Import Project Inventory Costs Imports inventory cost transactions from third-party applications or creates new project inventory cost transactions.

There can be following process to upload the manufacturing data using FBDI Template.

1.     Explore DFF to collect project details for project related manufacturing transaction.

2.     Create an OTBI Report to extract all the eligible project related costed manufacturing transaction, which are not already imported to project. Here Original Transaction Reference field form FBDI template can utilized. It can link with inventory transaction id to avoid duplication of records.

3.     Upload the project manufacturing transaction to FBDI template# Import Project Inventory Costs

4.     Import the FBDI using following scheduled process.

a.     Load Interface File for Import

b.     Import Costs

Interface Table# PJC_TXN_XFACE_STAGE_ALL

PJM_02v1.jpg


This solution can be automate using Web Services.

Summary:

            Oracle cloud SCM to Project costing integration provide the more clarity of project manufacturing cost. It help to bring project manufacturing cost, which gives the complete picture of project cost which helps to better cost tracking and management.


 


Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles