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 |
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 |
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
|
|
|
Goto Forum:
Current Time: Wed Dec 04 23:55:05 CST 2024
|