按照metalink上说明来操作的退货数量为1的时候可以退,超过1就报错:错误: 为接收输入的数量大于可用数量。要接收数量与已接收数量之和 3 大于订货量与超量接收允差之和 0.
下面 :QUANTITY , PRIMARY_QUANTITY 数量为1 的时候执行不会报错然后 请求都通过,事务处理也正常, 如果把数量大于1就报上面的错误,有大神碰到过吗,谢谢!!!
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,PRIMARY_QUANTITY,
UNIT_OF_MEASURE,
ITEM_ID,
EMPLOYEE_ID,
SHIPMENT_HEADER_ID,
SHIPMENT_LINE_ID,
RECEIPT_SOURCE_CODE,
VENDOR_ID,
FROM_ORGANIZATION_ID,
FROM_SUBINVENTORY,
FROM_LOCATOR_ID,
SOURCE_DOCUMENT_CODE,
PARENT_TRANSACTION_ID,
PO_HEADER_ID,
PO_LINE_ID,
PO_LINE_LOCATION_ID,
PO_DISTRIBUTION_ID,
DESTINATION_TYPE_CODE,
DELIVER_TO_PERSON_ID,
LOCATION_ID,
DELIVER_TO_LOCATION_ID,
VALIDATION_FLAG,
ORG_ID,
INSPECTION_STATUS_CODE
)
VALUES
(rcv_transactions_interface_s.nextval, --INTERFACE_TRANSACTION_ID
rcv_interface_groups_s.nextval, --GROUP_ID
SYSDATE, --LAST_UPDATE_DATE
0, --LAST_UPDATE_BY
SYSDATE, --CREATION_DATE
0, --CREATED_BY
0, --LAST_UPDATE_LOGIN
'RETURN TO RECEIVING', --TRANSACTION_TYPE
SYSDATE, --TRANSACTION_DATE
'PENDING', --PROCESSING_STATUS_CODE
'BATCH',--'BATCH', IMMEDIATE --PROCESSING_MODE_CODE
'PENDING', --TRANSACTION_STATUS_CODE
3, --QUANTITY --
3, --PRIMARY_QUANTITY
'fol, --UNIT_OF_MEASURE
21, --ITEM_ID
2002, --EMPLOYEE_ID
14845390, --SHIPMENT_HEADER_ID
17070301, --SHIPMENT_LINE_ID
'VENDOR', --RECEIPT_SOURCE_CODE
84, --VENDOR_ID
85, --FROM_ORGANIZATION_ID
'WPK’, --FROM_SUBINVENTORY
null, --FROM_LOCATOR_ID
'PO', --SOURCE_DOCUMENT_CODE
29364231 , --PARENT_TRANSACTION_ID XXXXXXX
11707651, --PO_HEADER_ID
11742983, --PO_LINE_ID
11743142, --PO_LINE_LOCATION_ID
11744225, --PO_DISTRIBUTION_ID
'INVENTORY', --DESTINATION_TYPE_CODE
null, --DELIVER_TO_PERSON_ID
null, --LOCATION_ID
null, --DELIVER_TO_LOCATION_ID
'N' , --VALIDATION_FLAG
85 , --ORG_ID_OPERATING_UNIT
'NOT INSPECTED'
);