Oracle Inbound 850 Customer PO’s with Multiple Documents – Odd failure

0 pts.
Tags:
ERP
Oracle
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?
ASKED: June 8, 2005  3:49 PM
UPDATED: June 22, 2011  1:33 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Grrrrrrr8
    Hi I am looking for some document which helps me in doing the setup to consume the EDI 850 format. Could you please provide any such documents. My email id is kasi.prasad@gmail.com Thanks a lot in advance, Prasad
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following