1 Reply Latest reply on Mar 15, 2018 5:02 PM by pedrolozanog

    How to create a PO standard with one line and two shipments to different organizations?

    Carlos Patila

      I need to create a PO standard  with a line and two or more shipments to different organizations and locations using Open Interface ...

       

      Is it possible?

       

      /********APPS.PO_HEADERS_INTERFACE********/
      Insert into APPS.PO_HEADERS_INTERFACE
         (INTERFACE_HEADER_ID, BATCH_ID, INTERFACE_SOURCE_CODE, PROCESS_CODE, ACTION, 
          DOCUMENT_TYPE_CODE, CURRENCY_CODE, AGENT_ID, VENDOR_ID, VENDOR_SITE_ID, 
          SHIP_TO_LOCATION, SHIP_TO_LOCATION_ID, BILL_TO_LOCATION, BILL_TO_LOCATION_ID, COMMENTS, 
          CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, STYLE_ID)
       Values
         (733655, 733655, 'PO', 'PENDING', 'ORIGINAL', 
          'STANDARD', 'MXN', 2363, 49, 5600, 
          'CEDIS PONIENTE', 373134, 'CEDIS PONIENTE', 373134, 'Cedis001', 
          TO_DATE('03/05/2018 18:01:13', 'MM/DD/YYYY HH24:MI:SS'), 1694, TO_DATE('03/05/2018 18:01:13', 'MM/DD/YYYY HH24:MI:SS'), 1694, 1);
      
      
      /********APPS.PO_LINES_INTERFACE********/
      Insert into APPS.PO_LINES_INTERFACE
         (INTERFACE_LINE_ID, INTERFACE_HEADER_ID, LINE_NUM, ITEM_ID, UNIT_OF_MEASURE, 
          QUANTITY, NEED_BY_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, 
          CREATED_BY, NOTE_TO_RECEIVER, LINE_LOC_POPULATED_FLAG)
       Values
         (1305466, 733655, 1, 7382, 'TONELADA', 
          10, TO_DATE('02/21/2018 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('03/05/2018 18:01:13', 'MM/DD/YYYY HH24:MI:SS'), 1694, TO_DATE('03/05/2018 18:01:13', 'MM/DD/YYYY HH24:MI:SS'), 
          1694, 'PruebaCedis20180305', 'Y');
      
      
      
      /********APPS.PO_LINE_LOCATIONS_INTERFACE********/
      Insert into APPS.PO_LINE_LOCATIONS_INTERFACE
         (INTERFACE_LINE_LOCATION_ID, INTERFACE_HEADER_ID, INTERFACE_LINE_ID, SHIPMENT_TYPE, SHIPMENT_NUM, 
          SHIP_TO_ORGANIZATION_CODE, SHIP_TO_LOCATION, NEED_BY_DATE, NOTE_TO_RECEIVER, QUANTITY, 
          CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
       Values
         (1070865, 733655, 1305466, 'STANDARD', 1, 
          'CSP', 'CUMBRES SAN PATRICIO', TO_DATE('02/21/0018 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PruebaCedis20180305', 0.2822, 
          TO_DATE('03/05/2018 18:01:16', 'MM/DD/YYYY HH24:MI:SS'), 1694, TO_DATE('03/05/2018 18:01:16', 'MM/DD/YYYY HH24:MI:SS'), 1694);
      
      Insert into APPS.PO_LINE_LOCATIONS_INTERFACE
         (INTERFACE_LINE_LOCATION_ID, INTERFACE_HEADER_ID, INTERFACE_LINE_ID, SHIPMENT_TYPE, SHIPMENT_NUM, 
          SHIP_TO_ORGANIZATION_CODE, SHIP_TO_LOCATION, NEED_BY_DATE, NOTE_TO_RECEIVER, QUANTITY, 
          CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
       Values
         (1070866, 733655, 1305466, 'STANDARD', 2, 
          'CSA', 'CUMBRES SAN AGUSTIN', TO_DATE('02/21/0018 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PruebaCedis20180305', 0.592, 
          TO_DATE('03/05/2018 18:01:16', 'MM/DD/YYYY HH24:MI:SS'), 1694, TO_DATE('03/05/2018 18:01:16', 'MM/DD/YYYY HH24:MI:SS'), 1694);
      
      Insert into APPS.PO_LINE_LOCATIONS_INTERFACE
         (INTERFACE_LINE_LOCATION_ID, INTERFACE_HEADER_ID, INTERFACE_LINE_ID, SHIPMENT_TYPE, SHIPMENT_NUM, 
          SHIP_TO_ORGANIZATION_CODE, SHIP_TO_LOCATION, NEED_BY_DATE, NOTE_TO_RECEIVER, QUANTITY, 
          CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
       Values
         (1070867, 733655, 1305466, 'STANDARD', 3, 
          'CSP', 'CUMBRES SAN PATRICIO', TO_DATE('02/21/0018 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PruebaCedis20180305', 0.9749, 
          TO_DATE('03/05/2018 18:01:16', 'MM/DD/YYYY HH24:MI:SS'), 1694, TO_DATE('03/05/2018 18:01:16', 'MM/DD/YYYY HH24:MI:SS'), 1694);
      
      Insert into APPS.PO_LINE_LOCATIONS_INTERFACE
         (INTERFACE_LINE_LOCATION_ID, INTERFACE_HEADER_ID, INTERFACE_LINE_ID, SHIPMENT_TYPE, SHIPMENT_NUM, 
          SHIP_TO_ORGANIZATION_CODE, SHIP_TO_LOCATION, NEED_BY_DATE, NOTE_TO_RECEIVER, QUANTITY, 
          CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
       Values
         (1070868, 733655, 1305466, 'STANDARD', 4, 
          'ARI', 'SAMSARA', TO_DATE('02/21/0018 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PruebaCedis20180305', 1.39, 
          TO_DATE('03/05/2018 18:01:16', 'MM/DD/YYYY HH24:MI:SS'), 1694, TO_DATE('03/05/2018 18:01:16', 'MM/DD/YYYY HH24:MI:SS'), 1694);
      
      Insert into APPS.PO_LINE_LOCATIONS_INTERFACE
         (INTERFACE_LINE_LOCATION_ID, INTERFACE_HEADER_ID, INTERFACE_LINE_ID, SHIPMENT_TYPE, SHIPMENT_NUM, 
          SHIP_TO_ORGANIZATION_CODE, SHIP_TO_LOCATION, NEED_BY_DATE, NOTE_TO_RECEIVER, QUANTITY, 
          CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
       Values
         (1070869, 733655, 1305466, 'STANDARD', 5, 
          'MVA', 'MONTENOVA', TO_DATE('02/21/0018 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PruebaCedis20180305', 2.7899, 
          TO_DATE('03/05/2018 18:01:16', 'MM/DD/YYYY HH24:MI:SS'), 1694, TO_DATE('03/05/2018 18:01:16', 'MM/DD/YYYY HH24:MI:SS'), 1694);
      
      
      Insert into APPS.PO_LINE_LOCATIONS_INTERFACE
         (INTERFACE_LINE_LOCATION_ID, INTERFACE_HEADER_ID, INTERFACE_LINE_ID, SHIPMENT_TYPE, SHIPMENT_NUM, 
          SHIP_TO_ORGANIZATION_CODE, SHIP_TO_LOCATION, NEED_BY_DATE, NOTE_TO_RECEIVER, QUANTITY, 
          CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
       Values
         (1070870, 733655, 1305466, 'STANDARD', 6, 
          'SMA', 'SANTA MARIA', TO_DATE('02/21/0018 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PruebaCedis20180305', 3.971, 
          TO_DATE('03/05/2018 18:01:16', 'MM/DD/YYYY HH24:MI:SS'), 1694, TO_DATE('03/05/2018 18:01:16', 'MM/DD/YYYY HH24:MI:SS'), 1694);
      

       

      The PO is generated but in the shipping organization the same value that is inserted at the header level is displayed