Order Management - EBS (MOSC)

MOSC Banner

Order Import - Checking/Creating Ship_to address

edited Oct 4, 2011 5:11AM in Order Management - EBS (MOSC) 8 commentsAnswered
 Hello,

  Does anyone know what the order import checks to determine if an address exists, prior to creating it,  using the oe_customer_info_iface_all table.

  Here is our situation.  We have code in place that checks  Data we have coming in from a source with  ,     Address information,  such as Company name,  Address1, Address2,  City ,  State , Zip.

  We are wanting our process to check to see if the   ship to address exists for a particular Customer.   If we dont find that it does exist from our query,  then we populate the oe_customer_info_iface_all  table .  Then we run Order Import.     If the address does exist,  we dont populate this table.  We just get the location_id  and use it to build our  Order.

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