Skip to main content
Question

PO Change Order invoking an error - ORA-20110: Delivery type is not specified for the delivery address :P


HEAFINKD
Do Gooder (Customer)
Forum|alt.badge.img+1

I have a normal PO with no associated Shipment, 4 No Part Order Lines - overall single occur Delivery Address, ONE of the lines uses the default delivery address.  Change Order created to change the price, description, and wanted delivery date on 3 of the lines and a new line is added using same single occur address.

This PO was copied from another PO with pretty much the same information.

When attempting to Update the PO, the ORA-20110 error appears. I don’t see ANY field in Supplier or PO called Delivery Type.  WHAT AM I MISSING HERE??

2 replies

Piyal Perera
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 284 replies
  • June 13, 2024

Hi @HEAFINKD 

  Just a suggestion to check.

 


HEAFINKD
Do Gooder (Customer)
Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • 1 reply
  • June 13, 2024

Thanks Piyal!!!  I looked at that, but oddly, the error mentions Address ID = P (at least I think that is what it is referring to at the end) and that Supplier does NOT have an Address ID of P.  The associated Site address is Address ID = 1.  The associated Company does not have an Address ID = P.

NOTHING in the PO or the POCO refers to Address ID P.

I’ve never seen this error before.

I think it is interesting that it appears when trying to Update the PO from a Change Order - not at Release, or Register Arrival…

I’ll keep digging


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings