A) Via ROI Create a ASN [ship,ship] for a quantity =3 on STANDARD PURCHASE ORDER Create via ROI an Advanced Shipment Notice ASN number F-ASN-PO-17646-3
for Standard Purchase Order Number 17646 (PO_HEADER_ID=97981) on Vendor =F_Supplier of 3 items in destination organization V1
1) Insert following Data:
. 1 record in RCV_HEADERS_INTERFACE
RECEIPT_SOURCE_CODE = VENDOR
ASN_TYPE = ASN
TRANSACTION_TYPE= NEW
AUTO_TRANSACT_CODE = SHIP
SHIPMENT_NUM = F-ASN-PO-17646-3
. 1 record in RCV_TRANSACTIONS_INTERFACE
TRANSACTION_TYPE = SHIP
AUTO_TRANSACT_CODE = SHIP
RECEIPT_SOURCE_CODE = VENDOR
QUANTITY = 3
Use the insert script of Document 225233.1 to create ASN shipment number
'F-ASN-PO-17646-3' SHIPMENT_NUM with quantity shipped=3
for Standard PO 17646 - Line 1 - Shipment line 1
INSERT INTO RCV_HEADERS_INTERFACE
(HEADER_INTERFACE_ID,
GROUP_ID,
PROCESSING_STATUS_CODE,
RECEIPT_SOURCE_CODE,
ASN_TYPE,
TRANSACTION_TYPE,
AUTO_TRANSACT_CODE,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CREATION_DATE,
CREATED_BY,
SHIPMENT_NUM,
VENDOR_ID,
SHIP_TO_ORGANIZATION_ID,
SHIPPED_DATE,
EXPECTED_RECEIPT_DATE,
EMPLOYEE_ID,
ORG_ID,
VALIDATION_FLAG
)
VALUES
(rcv_headers_interface_s.nextval , --Header_Interface_Id
rcv_interface_groups_s.nextval, --Group_Id
'PENDING', --Processing_Status_Code
'VENDOR', --Receipt_Source_Code
'ASN', --ASN_TYPE
'NEW', --Transaction_Type
'SHIP', --Auto_Transact_Code
SYSDATE, --Last_Update_Date
0, --Last_Updated_By
0, --Last_Update_Login
SYSDATE, --Creation_Date
0, --Created_By
'F-ASN-PO-17646-3', --SHIPMENT_NUM
7927, --Vendor_Id
204, -- SHIP_TO_ORGANIZATION_ID
SYSDATE, --SHIPPED_DATE
SYSDATE+1, --Expected_Receipt_Date
13706, --Employee_Id
204, --Operating_Unit_Id
'Y' --Validation_Flag
);
INSERT INTO RCV_TRANSACTIONS_INTERFACE
(INTERFACE_TRANSACTION_ID,
GROUP_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
TRANSACTION_TYPE,
TRANSACTION_DATE,
PROCESSING_STATUS_CODE,
PROCESSING_MODE_CODE,
TRANSACTION_STATUS_CODE,
QUANTITY,
UNIT_OF_MEASURE,
ITEM_ID,
AUTO_TRANSACT_CODE,
RECEIPT_SOURCE_CODE,
SOURCE_DOCUMENT_CODE,
DOCUMENT_NUM,
DOCUMENT_LINE_NUM,
SHIP_TO_LOCATION_ID,
TO_ORGANIZATION_ID,
HEADER_INTERFACE_ID,
ORG_ID,
VALIDATION_FLAG
)
SELECT
rcv_transactions_interface_s.nextval, --Interface_Transaction_id
rcv_interface_groups_s.currval, --Group_id
SYSDATE, --Last_update_date
0, --Last_updated_by
SYSDATE, --Creation_date
0, --Created_by
0, --Last_update_login
'SHIP', --TRANSACTION_TYPE_SHIP
SYSDATE, --TRANSACTION_DATE
'PENDING', --PROCESSING_STATUS_CODE
'BATCH', --PROCESSING_MODE_CODE
'PENDING', --TRANSACTION_STATUS_CODE
3, --QUANTITY
'Each', --UNIT_OF_MEASURE
26816, --ITEM_ID
'SHIP', --AUTO_TRANSACT_CODE
'VENDOR',