Procurement - EBS (MOSC)

MOSC Banner

Updating a Supplier D-U-N-S Number

Hi,

I'm looking for an API that updates supplier's organization D-U-N-S Number (which corresponds to the AR.HZ_ORGANIZATION_PROFILES table). Does anyone know of an API to update a supplier's organization D-U-N-S Number (which is not the DUNS number for vendor sites)?

The HZ_PARTY_V2PUB.UPDATE_ORGANIZATION API seems to work. However, it doesn't behave exactly the way a front end update behaves. When adding the number for the first time on the front end, a new row is created. When updating the number on the front end, the corresponding row in AR.HZ_ORGANIZATION_PROFILES is simply updated. When using the HZ_PARTY_V2PUB.UPDATE_ORGANIZATION API to update the number, a new row is always added to ar.hz_organization_profiles, which is not ideal.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center