Configuring ODI for GOP

This chapter discusses setting up the ODI web service for Global Order Promising.

This chapter covers the following topics:

Setting Up ODI Web Service for GOP

To set up the ODI web service

  1. In ODI Studio, navigate to E1APSProject, Common, Packages.

  2. Run the CREATEWORKREPTABLES and SYNCHRONIZE XML scenarios and verify their completion.

  3. Navigate to E1APSProject, Variables and set the Default value for the #PVV_OP_WSURL variable.

    The default value should be the full URL for the deployed GOP web service. For example:

    http://slc60036sems.us.oracle.com:7038/OrderPromising-OrderPromisingProject-context- root/OrderPromisingServicePort?WSDL

  4. Navigate to E1APSProject, Common, Packages, and regenerate the LOADPARAMETERSDATATOWORKREPPKG scenario.

  5. In the Master Repository Database Schema, enter a value for Work Repository Schema Name and run the following query:

    CREATE OR REPLACE SYNONYM WR_DVM for <Work Repository Schema Name>.WR_DVM;
ddATE

  6. In the External Database Schema, run the following query:

    CREATE OR REPLACE VIEW E1BASE_NONPLANUOM_V AS
select "ITEM_CODE","UOM" from (SELECT BASE_ITEMCODE.ITEMCODE_DATA as item_code,BASE_ITEM.SHIPPINGUOM as UOM from BASE_ITEM ,BASE_ITEMCODE where BASE_ITEM.ITEMPK=BASE_ITEMCODE.ITEMFK
                UNION
                SELECT BASE_ITEMCODE.ITEMCODE_DATA as item_code,BASE_ITEM.VOLUMEUOM as UOM from BASE_ITEM ,BASE_ITEMCODE where BASE_ITEM.ITEMPK=BASE_ITEMCODE.ITEMFK
                UNION
                SELECT BASE_ITEMCODE.ITEMCODE_DATA as item_code,BASE_ITEM.WEIGHTUOM as UOM from BASE_ITEM ,BASE_ITEMCODE where BASE_ITEM.ITEMPK=BASE_ITEMCODE.ITEMFK
                UNION
                SELECT BASE_ITEMCODE.ITEMCODE_DATA as item_code,BASE_ITEMUOM.TOUOM as UOM from BASE_ITEMUOM ,BASE_ITEMCODE where BASE_ITEMUOM.ITEMUOMPK=BASE_ITEMCODE.ITEMUOMFK);

  7. In the Work Repository Schema, enter a value for External Database Schema Name and run the following query:

    CREATE OR REPLACE SYNONYM WR_E1BASE_NONPLANUOM FOR <External Database Schema>.E1BASE_NONPLANUOM_V;

In steps 6 and 7, the External Database Schema Name should be the same name as the external database schema you previously created.

Additional Information: For additional information, see Configuring External Databases.