Question

Oracle Inbound 850 Customer PO's with Multiple Documents - Odd failure

Oracle, ERP, Oracle Financials, Order Management, Procurement, SQL

Ok, I know I might be sotgunning here, but so far I canna find even a glimmer of an answer to this.

Oracle Apps 11.5.9
Oracle eCommerce Gateway
Inbound EDI 850 Customer PO's

I'm developing this process for a client, and I'm in the middle of testing my solution. Everything works fine when an 850 file contains a single PO from a single customer. It also works with two PO's from different customers.

Ok, so I go to test with 2 PO's from one customer, and a third PO from another customer.

The first two PO's are identical except for the Customer PO Number; that I've changed.

When I run the Oracle process to bring the orders into the OrderImport tables, one or the other of the first two orders doesn't have either an ORG_ID, SOLD_TO_ORG_ID, or a SHIP_TO_ORG_ID, despite their existence in the other order.

It's not consistent as to which of the two orders fails, but one always does.

Anyone with any ideas?

It sounds to me like you are violating a constraint, unique or primary key, that is causing one of the inserts to fail. I would check the definition (DDL) of the table in question.