Home » Applications » Oracle Fusion Apps & E-Business Suite » ISO Receiving (PO,12.1.3)
ISO Receiving [message #595958] Mon, 16 September 2013 10:41
jaganerp@gmail.com
Messages: 63
Registered: April 2008
Member
Hi All,

I am trying to do ISO Receiving, but it's not happenig with me, always i am getting experting Organization doesnot meet. " Error in Shipment Header Information (in RCV_HEADERS_INTERFACE)

Column Name In Error FROM_ORGANIZATION_ID

Error Message Error: The FROM_ORGANIZATION_ID
specified is invalid. The value
specified (119) does not match
the expected value (114). "
below script i am using to insert the data into interface tables.Any one can please help me it's very urgent for me, thanks in advance to all.

INSERT INTO RCV_HEADERS_INTERFACE
(HEADER_INTERFACE_ID,
GROUP_ID,
PROCESSING_STATUS_CODE,
RECEIPT_SOURCE_CODE,
TRANSACTION_TYPE,
--AUTO_TRANSACT_CODE, --- new cod
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CREATION_DATE,
CREATED_BY,
SHIPMENT_NUM,
SHIP_TO_ORGANIZATION_ID,
EXPECTED_RECEIPT_DATE,
SHIPPED_DATE,
EMPLOYEE_ID,
VALIDATION_FLAG,
org_id
)
VALUES
(rcv_headers_interface_s.nextval , --HEADER_INTERFACE_ID
rcv_interface_groups_s.nextval, --GROUP_ID
'PENDING', --PROCESSING_STATUS_CODE
'INTERNAL ORDER', --RECEIPT_SOURCE_CODE
'NEW', --TRANSACTION_TYPE
--'DELIVER', --AUTO_TRANSACT_CODE ---new code
SYSDATE, --LAST_UPDATE_DATE
10439, --LAST_UPDATE_BY
10439, --LAST_UPDATE_LOGIN
SYSDATE, --CREATION_DATE
10439, --CREATED_BY
'4668797', --SHIPMENT_NUM == Delivery_id 4668784
119, --SHIP_TO_ORGANIZATION_ID
SYSDATE+1, --EXPECTED_RECEIPT_DATE
SYSDATE, --SHIPPED_DATE
11779, --EMPLOYEE_ID
'Y' ,--VALIDATION_FLAG
101--org_id
);
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,
INTERFACE_SOURCE_CODE,
ITEM_ID,
EMPLOYEE_ID,
AUTO_TRANSACT_CODE,
SHIPMENT_HEADER_ID,
SHIPMENT_LINE_ID,
SHIP_TO_LOCATION_ID,
RECEIPT_SOURCE_CODE,
from_organization_id,
TO_ORGANIZATION_ID,
SOURCE_DOCUMENT_CODE,
REQUISITION_LINE_ID,
REQ_DISTRIBUTION_ID,
DESTINATION_TYPE_CODE,
DELIVER_TO_PERSON_ID,
LOCATION_ID,
DELIVER_TO_LOCATION_ID,
SUBINVENTORY,
SHIPMENT_NUM,
EXPECTED_RECEIPT_DATE,
SHIPPED_DATE,
HEADER_INTERFACE_ID,
VALIDATION_FLAG,
--ROUTING_HEADER_ID,
--ROUTING_STEP_ID,
--DESTINATION_CONTEXT,
--OE_ORDER_HEADER_ID,
--OE_ORDER_LINE_ID
ORG_ID
)
VALUES
( rcv_transactions_interface_s.nextval, -- INTERFACE_TRANSACTION_ID
rcv_interface_groups_s.currval, --GROUP_ID
SYSDATE, --LAST_UPDATE_DATE
10439, --LAST_UPDATED_BY
SYSDATE, --CREATION_DATE
10439, --CREATED_BY
10439, --LAST_UPDATE_LOGIN
'RECEIVE', --TRANSACTION_TYPE
SYSDATE, --TRANSACTION_DATE
'PENDING', --PROCESSING_STATUS_CODE
'BATCH', --PROCESSING_MODE_CODE --'BATCH'
'PENDING', --TRANSACTION_STATUS_CODE
2, --QUANTITY
'Each', --UNIT_OF_MEASURE
'RCV', --INTERFACE_SOURCE_CODE
134, --ITEM_ID
11779, --EMPLOYEE_ID
'DELIVER', --AUTO_TRANSACT_CODE
8496859, --SHIPMENT_HEADER_ID
8604664, --SHIPMENT_LINE_ID
161,--119, --SHIP_TO_LOCATION_ID
'INTERNAL ORDER', --RECEIPT_SOURCE_CODE
119, --TO_ORGANIZATION_ID
114,---from_organization_id
'REQ', --SOURCE_DOCUMENT_CODE
1355331, --REQUISITION_LINE_ID
1181844, --REQ_DISTRIBUTION_ID
'INVENTORY', --DESTINATION_TYPE_CODE
11779, --DELIVER_TO_PERSON_ID
161, --LOCATION_ID
161, --DELIVER_TO_LOCATION_ID
'FNSHED GDS', --SUBINVENTORY
'4668797', --SHIPMENT_NUM
SYSDATE+1, --EXPECTED_RECEIPT_DATE,
SYSDATE, --SHIPPED_DATE
rcv_headers_interface_s.currval, --HEADER_INTERFACE_ID
'Y',--VALIDATION_FLAG
--3, --routing_header_id
--1,--routing_step_id
--'INVENTORY', --destination_context
--1128926,--order_header_id
--1135200----order_line_id
101---org_id
);

INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE
( TRANSACTION_INTERFACE_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
LOT_NUMBER,
TRANSACTION_QUANTITY,
PRIMARY_QUANTITY,
SERIAL_TRANSACTION_TEMP_ID,
PRODUCT_CODE,
PRODUCT_TRANSACTION_ID
)
VALUES
( MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL,--TRANSACTION_INTERFACE_ID
SYSDATE, --LAST_UPDATE_DATE
10439, --LAST_UPDATED_BY
SYSDATE, --CREATION_DATE
10439, --CREATED_BY
10439, --LAST_UPDATE_LOGIN
'L061162', --LOT_NUMBER
2, --TRANSACTION_QUANTITY
2, --PRIMARY_QUANTITY
MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL, --SERIAL_TRANSACTION_TEMP_ID
'RCV', --PRODUCT_CODE
RCV_TRANSACTIONS_INTERFACE_S.CURRVAL --PRODUCT_TRANSACTION_ID
);
INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE
( TRANSACTION_INTERFACE_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
FM_SERIAL_NUMBER,
TO_SERIAL_NUMBER,
PRODUCT_CODE,
PRODUCT_TRANSACTION_ID)
VALUES
(MTL_MATERIAL_TRANSACTIONS_S.CURRVAL,--TRANSACTION_INTERFACE_ID
SYSDATE, --LAST_UPDATE_DATE
10439, --LAST_UPDATED_BY
SYSDATE, --CREATION_DATE
10439, --CREATED_BY
10439, --LAST_UPDATE_LOGIN
'TEST-128566_1', --FM_SERIAL_NUMBER
'TEST-128566_1', --TO_SERIAL_NUMBER
'RCV', --PRODUCT_CODE
RCV_TRANSACTIONS_INTERFACE_S.CURRVAL --PRODUCT_TRANSACTION_ID
);

Previous Topic: Oracle application testing suite issue regarding open script
Next Topic: Sql loader error
Goto Forum:
  


Current Time: Thu Mar 28 08:31:52 CDT 2024