Home » Applications » Oracle Fusion Apps & E-Business Suite » Order Import Open interface issue (ONT,11i)
Order Import Open interface issue [message #340181] Mon, 11 August 2008 17:28 Go to next message
raavi
Messages: 1
Registered: August 2008
Junior Member
Hi All,
oe_headers_iface_all, oe_lines_iface_all tables contain data but whenever i run the Standard order import open interface program
it is not uploading the data into base tables and even it is not generating any error messages in log file or output file.
but in output file simply it is giving "NO ORDER TO PROCESS".
PLEASE CAN ANYBODY HELP ME OUT.
Re: Order Import Open interface issue [message #340450 is a reply to message #340181] Wed, 13 August 2008 00:07 Go to previous message
sivee
Messages: 6
Registered: August 2008
Junior Member
hi,
check with mandotary column you passing to oe_headers_iface_all and oe_lines_iface_all...and try to do some important validations neccessary..

INSERT INTO OE_HEADERS_IFACE_ALL
(ORIG_SYS_DOCUMENT_REF
,ORDER_SOURCE
,ORDER_SOURCE_ID
,ORDER_TYPE_ID
,PRICE_LIST_ID
,PRICE_LIST
,SALESREP_ID
,SALESREP
,PAYMENT_TERM_ID
,PAYMENT_TERM
,SOLD_TO_ORG_ID
,SHIP_FROM_ORG_ID
,SHIP_FROM_ORG
,SHIP_TO_ORG_ID
,SHIP_TO_ORG
,INVOICE_TO_ORG_ID
,INVOICE_TO_ORG
,CUSTOMER_NAME
,CUSTOMER_NUMBER
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,REQUEST_DATE
,BATCH_ID
)........

INSERT INTO OE_LINES_IFACE_ALL(ORIG_SYS_DOCUMENT_REF
,ORDER_SOURCE_ID
,LINE_NUMBER
,INVENTORY_ITEM_ID
--,INVENTORY_ITEM
,ORDERED_QUANTITY
,ORDER_QUANTITY_UOM
,SHIP_FROM_ORG_ID
--,SHIP_FROM_ORG
,SOLD_TO_ORG_ID
--,SOLD_TO_ORG
,INVOICE_TO_ORG_ID
--,INVOICE_TO_ORG
,PRICE_LIST
,PRICE_LIST_ID
,UNIT_SELLING_PRICE
,CALCULATE_PRICE_FLAG
,PAYMENT_TERM_ID
,PAYMENT_TERM
,SALESREP_ID
--,SALESREP
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,REQUEST_ID
,REQUEST_DATE
,ORIG_SYS_LINE_REF
)........


with regards,
siva
Previous Topic: procure to pay video
Next Topic: Reinstalling ERP Oracle Application
Goto Forum:
  


Current Time: Fri Dec 09 15:40:45 CST 2016

Total time taken to generate the page: 0.24527 seconds