Configuring VCP

To facilitate the integration, certain one-time setup steps and configurations must be performed to the Oracle EBS planning server.

Additional Information: For additional information, see the Oracle Value Chain Planning Implementation Guide.

This chapter covers the following topics:

Setting Up the Oracle EBS Planning Server

To set up the Oracle EBS planning server for this integration

  1. Log in with the Advanced Planning Administrator responsibility.

  2. Create the Oracle VCP Partition by completing the following steps:

    1. Run the concurrent process Create VCP Partitions.

    2. Set the plan partition count to 0.

    3. Set the instance count to 1.

  3. Create the Oracle VCP Planning instance by completing the following steps:

    1. Navigate to Admin, Instances.

    2. Set the instance type to Others.

    3. Ensure that the Enable ATP option is not selected.

    Note: Planners must be set up in Oracle EBS and given the appropriate permissions.

  4. Set the following integration profile parameters:

    Parameter Default Value
    MSC: E1 Concatenation Character +

  5. In the Parameters.txt file, set the Source_Instance parameter to the Oracle VCP Planning instance you created.

    Additional Information: For additional information, see User-Maintained Data.

  6. Navigate to Application Developer, Flexfield, Descriptive, Segments.

  7. Enable the descriptive flex field to have the collection name.

  8. In the Application field, enter Advanced Supply Chain Planning and in the Title field, enter MSC_APPS_INSTANCES.

  9. Click Segments.

  10. In the Segments form, make the following entries:

    Number Name Column
    1 Collection Name ATTRIBUTE15
    11 Data Path ATTRIBUTE13
    12 Control File Path ATTRIBUTE12

  11. Click Save.

  12. Navigate to Admin, Instances.

  13. In the Instances form, complete the following fields:

    Field Description
    Collection Name The name of the ERP instance.
    Data Path The directory on the server that hosts the VCP application server, where the VCP concurrent program locates the DemHistory.dat file.

    • In a shared directory configuration, this directory corresponds to APSInputDir.

    • In a non-shared directory configuration, this directory corresponds to APSInputDir.

      Important: Ensure that files can be copied to this directory.
    Control File Path The directory on the server that hosts the VCP application server. This directory contains the T_SRC_SALES_TMPL.ctl control file that loads DemHistory.dat. This is typically in APPL_TOP for msc in the sub- directory msc/12.0.0/patch/115/import.

  14. Navigate to Advanced Supply Chain Planner, Collections, JD Edwards EnterpriseOne or PeopleSoft, Collect Planning Data.

  15. Run the Collections program.

  16. To view data in the Collections Workbench, select the category set collected from the ERP system.

  17. Click Save.

  18. To retain released data, set the value of the MSC: Retain Released Data to Yes.

Profile Parameters

The following profile parameters are used by the JDE E1 integration:

Profile Parameter Description Default Value Data Type
MSC: E1 APS FC URL URL for the web service used to Launch ODI scenarios from collections program   String
MSC: E1 APS ODI URL URL for the web service used to Launch ODI scenarios from collections program   String
MSC: E1 Concatenation Character Delimiter character in the generated flat files from JDE + Character
MSC: E1APS_BATCH_SIZE Transaction batch size used in Legacy Collections 1000 Integer
MSC: E1APS_DEM_END_DATE_I N_MONTHS End date offset in months from the current date used for Demantra Price List collections   Integer
MSC: E1APS_DEM_START_DATE _IN_MONTHS Start date offset in months from the current date used for Demantra Price List collections   Integer
MSC: E1APS_DEM_WF_TIME_OU T Timeout value for Demantra Workflow in seconds   Integer
MSC: E1APS_NO_OF_WORKERS Number of workers for Legacy Collections concurrent program 3 Integer
MSC: E1APS_TIME_OUT Timeout value in minutes for Legacy collections pre- processor and ODS Load programs 180 Integer
MSC: E1APS_WS_TIME_OUT Timeout value in seconds for ODI web service   Integer
MSC: E1_DBLINK Database link to ODI Work repository from the apps schema   String