Skip to main content
Question

Error into Incoming customer order ORA-20124:

  • Aug 11, 2022 12:48 PM UTC
  • 4 replies
  • 387 views

Ivanoman
Sidekick (Customer)
Forum|alt.badge.img+5

I’m trying to confin an order received via EDI and I get the below error message.
Apparently I’ve all the information, Sales Part Cross Reference and so on,
Thank you for your suggestions.
 

 

4 replies

Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • Aug 11, 2022 1:26 PM UTC

Hi @Ivanoman 

did you checked the prices in the xml file? IFS expects a base price for a line to create a customer order.


Ivanoman
Sidekick (Customer)
Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • Aug 11, 2022 1:58 PM UTC

Hi Thanks for your answer.
The EDI is not containing any price as IFS should look at the customer.
We correctly receive EDI for Other customer and the price into the XML file is not present


AkilaR
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • Aug 12, 2022 4:14 AM UTC

Hi @Ivanoman,

Normally this error comes when there is no Sales Part record available for the ordered part in supply site. Since it is creating a Customer Order in supply site you need to have a Sales Part for the part used in Ordered Site PO. 

If the part is available check if it has all required information (Base Price, Sales Part basic data) which needed to create the Customer Order in supply site.

Regards,

Akila


Ivanoman
Sidekick (Customer)
Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • Aug 12, 2022 6:50 AM UTC

Hi @AkilaR ,
The sales part is present and also the base price and the price list.