Order Management - EBS (MOSC)

MOSC Banner

Both value and ID columns have been supplied for this attribute (Attribute:ship_to_org). ID column f

edited Jun 30, 2011 8:39PM in Order Management - EBS (MOSC) 4 commentsAnswered
Hey Guys,
I have order out in test instance, where it is stuck in Order interface table (OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL) with the error message has "Both value and ID columns have been supplied for this attribute (Attribute:ship_to_org). ID column for this attribute will be used while processing this order."

I am not sure what is wrong here, please assist me.
Thank you.

INSERT INTO oe_headers_iface_all
   (ORDER_SOURCE_ID, ORIG_SYS_DOCUMENT_REF, ORG_ID, ORDERED_DATE, SALES_CHANNEL_CODE, TAX_EXEMPT_FLAG, TAX_EXEMPT_REASON_CODE, FOB_POINT_CODE, CUSTOMER_PO_NUMBER, SOLD_TO_ORG_ID, SHIP_TO_ORG_ID, SHIP_TO_ADDRESS1, SHIP_TO_CITY, CONTEXT, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, OPERATION_CODE, ERROR_FLAG, ORDER_CATEGORY, XML_MESSAGE_ID)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center