Receipt import script with LCM

  Hello,

My company has LCM enabled and we are trying to automate the receipt creation process. I tried using the below script to insert receipt, but the Landed Cost Management process does not create the receipt. Can you please let me know what I'm missing ?

INSERT INTO RCV_HEADERS_INTERFACE

(

HEADER_INTERFACE_ID ,

GROUP_ID ,

PROCESSING_STATUS_CODE ,

RECEIPT_SOURCE_CODE ,

TRANSACTION_TYPE ,

LAST_UPDATE_DATE ,

LAST_UPDATED_BY ,

LAST_UPDATE_LOGIN ,

VENDOR_ID ,

EXPECTED_RECEIPT_DATE ,

VALIDATION_FLAG

)

SELECT

RCV_HEADERS_INTERFACE_S.NEXTVAL ,

RCV_INTERFACE_GROUPS_S.NEXTVAL ,

'PENDING' ,

'VENDOR' ,

'NEW' ,

SYSDATE ,

111,

0 ,

568,

SYSDATE ,

'Y'

FROM DUAL;

INSERT INTO RCV_TRANSACTIONS_INTERFACE