Iam doing Puchase Order Interface
I dont know how to validate the DESTINATION_ORG_ID value of Po_disitributions_interface with the supplier/Vendor
most of the times iam getting this error
Error: Destination Organization (Value = XXX) is not a valid organization.
Plese let me know how to validate DESTINATION_ORG_ID for a supplier/Vendor In Interface table
My Oracle Applications Version
Thanks in advance
Manoj kumar Areti
As per my thinking , Destination Organizatin should be exists with given operating OU.
you can check with :
select organization_id from org_organization_definitions where operating_unit = :p_operating_unit.
Also, refer following MOS DOC: Bug 4526423 : GET PO_PDOI_INVALID_DEST_ORG WHILE IMPORTING STANDARD PURCHASE ORDERS
I have checked what you said
My destination_organization_id exists in the org_organization_definitions table for the select operating_unit
But my problem is
Po's are created for some vendor with some destination_organization_id say xxx but when i change the
vendor and the same destination_organization_id xxx its not Creating a PO and showing the error
destination_organization_id is not valid
that is why i want to know the relation ship between the destination_organization_id and the Vendor