Value Chain Planning Provider Reference Guide
Contents
1. support oracle com epmos faces DocumentDisplay id 8888 13 2 15 Value Chain Planning Provider Reference Guide Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http www oracle com pls topic lookup ctx acc amp id docacc 16 Legal Notices Oracle Primavera Value Chain Planning Provider Reference Guide Copyright 2013 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing If this is software or related documentation that is delivered to the U S Government or anyone licensing it on behalf of the U S Gove2. ITEM_ID Item ID ITEM_NAME Item Name ITEM NUMBER Item Number ITEM TYPE The type that uniquely identifies the resource ln Parent Item Number Value Chain Planning Provider Reference Guide ItemAssignment Description The itemAssignment object is used to track the demand and supply of the items that are performing various tasks Field ITEM ASSIGNME Description The unique identifier of the assignment NT ITEM ID The unique identifier the resource ITEM NUMBER The name that uniquely identifies the resource IAS_SOURCE_VC P_ID VCP P6 Resource Assignment ID PROJECT_ID The unique identifier of the associated project TASK_ID The unique identifier of the associated activity PARENT TASK D The unique identifier of the task ITEM SELECTIO N ITEM NAME The name that uniquely identifies the resource ITEM TYPE The type that uniquely identifies the resource VCP INVENTORY Pagi ga _ORGNAME VCP Resource Assignment Inventory Organization Name VCP Resource Assignment Selection YES NO ITEM_SELECTIO N_CODE VCP Resource Assignment Selection Code PLANNED_UNITS Planned units of this resource assignments SUGGESTED_DU E DATE DEMAND_PEGGE D_AVL_DATE The unique identifier of the associated ParentTask DEMAND_PEGGED_AVL_DATE DEMAND_PEGGE D_ORDER_TYPE DEMAND_PEGGED_ORDER_TYPE DEMAND_PEGGE D_ORDER_NUMB ER DEMAND_PEGGED_ORDER
3. affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services 17
4. ORACLE PRIMAVERA Value Chain Planning Provider Reference Guide Release 14 2 September 2014 Contents OVEMMIEW ni is 5 Flow Types Supported in the VCP Provider ueuesesssenseennnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnsnnnnnnn 5 Value Chain Planning BUSINESS ODJECES aNG GG NGANGA N NANANG NGANGA NYA 7 A AA AA A 7 INS AA 8 Parent aSK oreson a T E 9 Pro E EE E eek dolida 10 Taka 10 For Morelhformations aa natant dente 11 Where to Get Documentation uussssssssensesnsnnnnnnnnennnnnnnnnnnnnnnnnnnnnsnnnnnnnsnnnnnnnsnnnnnnnsnnnnnnnsnnnnnnssnnnnnnnen 11 Where to Get Training Re er ee rear 14 Where to Get SUPPO aaa ANA Aa 15 Documentation Accessibility uuueessssnsnensnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnsnnnnnnnsnnnnnnnsnnnnnnnannnn 16 Legal NOW PPP P A 17 Overview The VCP Provider Reference Guide provides a comprehensive listing of all business objects and associated fields available with the VCP provider delivered for Primavera Gateway Review the list of supported business objects to determine the data that needs to be supported for integration in Primavera Gateway To view these business objects in the Primavera Gateway user interface ensure that you have installed the VCP provider and then log in to Gateway and select the Data Dictionary menu Primavera Gateway supports data integration between Oracle Value Chain Planning and P6 EPPM applications In This Section Flow T
5. _NUMBER Value Chain Planning Business Objects Field D_ORDER_NUMB ER SUPPLY_PEGGE Description The pegged order number of the supply SUPPLY_ORDER _TYPE The order type of the supply For example On Hand Work Order Planner Order SUPPLY_ORDER _NUMBER The order number of the supply SUPPLY_ORDER _DATE The date on which the supply order is placed or planned to be placed For purchase orders this is the PO creation date SUPPLY_START_ DATE SUPPLY_ACTUAL _START_DATE The date on which the supply is planned to be started The date on which the supply actually started SUPPLY_SHIP_D ATE The date on which the supply order is planned to ship This applies to inter organization shipments SUPPLY_DOCK_ DATE The date on which a supply order arrives atthe receiving dock This applies to purchase orders and inter organization shipments SUPPLY_DUE_D ATE The date on which the supply was due SUPPLY_UPDAT ED_ARRIVAL_DA TE This is the arrival date on supplies as updated by Oracle Transportation management SUPPLY_ITEM_ID SUPPLY_ITEM_N AME The VCP Item Id of the supply item The name of the supply item SUPPLY_ORGANI ZATION The organization corresponding to the supply SUPPLY_QUANTI TY The quantity of the supply planned by VCP in response to the demand SUPPLY_PROJE CT_ID The Project number of the supply This is based on t
6. ccess by project participants Each team member can then view or print those portions that specifically relate to his or her role in the organization Throughout this documentation the Security Guidance icon ry helps you to quickly identify security related content to consider during the installation and configuration process Where to Get Training To access comprehensive training for all Primavera products go to http education oracle com 14 For More Information Oracle Learning Library The Oracle Learning Library OLL provides online learning content covering Primavera products Content includes videos tutorials articles demos step by step instructions to accomplish specific tasks and self paced interactive learning modules To access the learning library s Primavera content go to http www oracle com goto oll Where to Get Support If you have a question about using Oracle products that you or your network administrator cannot resolve with information in the documentation or help click http support oracle com This page provides the latest information on contacting Oracle Global Customer Support knowledge articles and the support renewals process For more information about working with Support visit https support oracle com epmos faces DocumentDisplay id 888813 2 to view Support Tools amp Tips Access to Oracle Support Oracle customers have access to electronic support through My Oracle Suppo
7. he project number of the demand that the supply pegs to ParentTask Description The ParentTask object is used to store the Work Breakdown Structure WBS information Value Chain Planning Provider Reference Guide Field Description TASK_ID Task ID TASK_NUMBER Task Number PARENT_TASK_ID ParentTask element parent TASK_NAME PROJECT_ID ParentTask Name Project ID of the associated project PARENTTASK_SOURCE_VC P_ID VCP P6 corresponding source ParentTask ID Description A project is atemporary endeavor undertaken to create a unique product service or result Field Description PROJECT_ID VCP project ID PROJECT_NUMBER VCP P6 project number PROJECT_SOURCE_VCP_ D VCP P6 project ID Description A Task is a unit of work performed during the course of a project Field TASK_ID Description The activity ID in VCP PROJECT_NUMBER The project ID in VCP for this activity PARENT_TASK_ID ParentTask element parent TASK_NAME TaskName TASK_SOURCE_VCP_ID VCP P6 activity ID EARLIEST_ASSIGNMENT_D ATE VCP earliest assignment date LATEST_ASSIGNMENT_DA TE VCP latest assignment date For More Information In This Section Where to Get Documentation uusnm44nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn nn 11 Where to Get Training ern ae 14 Where to Get Support zen ee een 15 Documentat
8. instructions on how to setup the integration environment between Oracle E Business Suite and P6 Enterprise Project Portfolio Management in Primavera Gateway The Primavera Gateway network administrator database administrator and the administrator for the third party system should read this guide Connecting Value Chain Planning and P6 EPPM Configuring Gateway for Single Sign On Gateway Licensing Information User Manual Provides instructions on how to setup the integration environment between Oracle Value Chain Planning and P6 Enterprise Project Portfolio Management in Primavera Gateway The Primavera Gateway network administrator database administrator and the administrator for the third party system should read this guide Provides instructions on how to configure Oracle Access Manager OAM and then enable Single Sign On for Primavera Gateway The Primavera Gateway network administrator database administrator should read this guide Lists licensing information of all third party software that is used or associated with the Oracle software program Tested Configurations Lists the configurations that have been tested and verified to work with Primavera Gateway The Primavera Gateway network administrator database administrator and the administrator for the third party or ERP system should read this guide Distributing Information to the Team You can copy the online documentation to a network drive for a
9. ion Accessibility a n 16 Where to Get Documentation Complete documentation libraries for Primavera Gateway releases are available on the Oracle Technology Network OTN at http www oracle com technetwork documentation default 1923957 html From this location you can either view libraries online or download them to have local copies We recommend viewing them from OTN to ensure you always access the latest versions including critical corrections and enhancements Primavera Gateway is configured to access its help system on OTN However you can also install a local version when you install the software The documentation assumes a standard setup of the product with full access rights to all features and functions The following table describes the core documents available for Primavera Gateway and lists the recommended readers by role Title Description Gateway Help Describes how to work with Primavera Gateway and provides information to help users accomplish tasks All users should read the Help Gateway Developer s Provides information on how third party systems such as Guide enterprise resource management ERP and enterprise asset management EAM systems can create their own providers in order to integrate with Primavera products Developers of third party providers that integrate with Primavera products via Primavera Gateway should read this book Gateway Customization Provides information on how to customi
10. rack Provides instructions on how to setup the integration environment for Oracle Instantis EnterpriseTrack in Primavera Gateway The Primavera Gateway network administrator database administrator and the administrator for the third party system should read this guide Connecting Prime and P6 EPPM Provides instructions on how to setup the integration environment between Oracle Primavera Prime and P6 Enterprise Project Portfolio Management in Primavera Gateway The Primavera Gateway network administrator database administrator and the administrator for the third party system should read this guide Connecting Unifier and P6 Enterprise Project Portfolio Management Provides instructions on how to setup the integration environment between Oracle Primavera Unifier and P6 Enterprise Project Portfolio Management in Primavera Gateway The Primavera Gateway network administrator database administrator and the administrator for the third party system should read this guide Migrating P6 Master Data Between Distinct Environments Provides instructions on how to setup the integration environment between distinct P6 deployments to transfer P6 data in Primavera Gateway The Primavera Gateway network administrator database administrator and the administrator should read this guide 13 Value Chain Planning Provider Reference Guide Title Suite and P6 EPPM Connecting E Business Description Provides
11. rd party systems such as enterprise resource management ERP and enterprise asset management EAM systems The Primavera Gateway network administrator database administrator and the administrator for the third party or ERP system should read this guide Gateway Upgrade Guide Provides a sequence of procedures that must be completed to upgrade to a new version of Primavera Gateway The Primavera Gateway network administrator database administrator and the administrator for the third party or ERP system should read this guide Gateway Performance and Sizing Guide Provides hardware and software requirements for deploying Primavera Gateway The Primavera Gateway network administrator database administrator and the administrator for the third party or ERP system should read this guide 12 For More Information Title Gateway Security Guide Description Provides guidelines on establishing a highly secure environment for all Primavera Gateway environments The Primavera Gateway network administrator database administrator and the administrator for the third party or ERP system should read this guide Gateway API Programmer s Guide Provides instructions on how to access and use Primavera Gateway REST APIs The Primavera Gateway network administrator database administrator and Primavera Gateway users having the Gateway Developer role should read this guide Connecting with Instantis Enterprise T
12. rnment the following notice is applicable U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its
13. rt For information visit http www oracle com us support contact 068555 html or visit http www oracle com us corporate accessibility support index html if you are hearing impaired Using Primavera s Support Resource Centers Primavera s Support Resource Center provides links to important support and product information Primavera s Product Information Centers PICs organize documents found on My Oracle Support MOS providing quick access to product and version specific information such as important knowledge documents Release Value Propositions and Oracle University training PICs also offer documentation on Lifetime Management from planning to installs upgrades and maintenance Visit https support oracle com epmos faces DocumentDisplay id 1486951 1 to access links to all of the current PICs PICs also provide access to gt Communities are moderated by Oracle providing a place for collaboration among industry peers to share best practices gt News from our development and strategy groups gt Education contains a list of available Primavera product trainings through Oracle University The Oracle Advisor Webcast program brings interactive expertise straight to the desktop using Oracle Web Conferencing technology This capability brings you and Oracle experts together to access information about support services products technologies best practices and more For more information about working with Support visit https
14. ypes Supported in the VCP Provider cccccooononccccnnoccncnnnnnoncccncnonancnananancnnnos 5 Flow Types Supported in the VCP Provider Primavera Gateway supports the following basic flow types gt Import Project Data Define project data flows to import project data from VCP to P6 EPPM application gt Export Project Data Define project data flows to export project data from P6 EPPM application to Oracle VCP application Value Chain Planning Business Objects The following Value Chain Planning business objects are available in the Data Dictionary menu of the Gateway user interface Select a specific business object to review a detailed list of fields supported for that business object Business Object Description Proiect A project is a temporary endeavor undertaken to create a unique product service or result Task A Task is a unit of work performed during the course of a project ParentTask VCP Provider Work Breakdown Structure object Item VCP Material Items across all projects ItemAssignme VCP Item Assignments track the demand and supply of the items that nt are performing various tasks The following section lists fields available in each business object In This Section o 7 llemAssignmeNnt das 8 Parents armonia AA 9 Pro iii iii 10 A E e 10 Description The item object is used to store material items across all projects Field Description
15. ze an existing Guide third party integration Developers interested in customizing existing third party 11 Value Chain Planning Provider Reference Guide Title Description providers that integrate with Primavera products via Primavera Gateway should read this book Gateway Provider Provides a list of the business objects available for each Reference Guide supported provider Developers of third party providers that integrate with Primavera products via Primavera Gateway should read this book EBS Provider Reference Guide Provides a list of the business objects available for the EBS provider Developers of third party providers that integrate with Primavera products via Primavera Gateway should read this book VCP Provider Reference Guide Provides a list of the business objects available for the VCP provider Developers of third party providers that integrate with Primavera products via Primavera Gateway should read this book Manual Deployment Guide Provides information on how to manually install and configure Primavera Gateway The Primavera Gateway network administrator database administrator and the administrator for the third party or ERP system should read this guide Gateway Installation and Configuration Guide Provides information on how to install and configure Primavera Gateway Primavera Gateway is a product that facilitates integrations with Primavera products and thi
Download Pdf Manuals
Related Search