Receivables - EBS (MOSC)

MOSC Banner

Issue on Update of party status to 'I' for party type person

edited Feb 5, 2016 5:32AM in Receivables - EBS (MOSC) 1 commentAnswered

Hi ,

We want to update the party status to 'I' for party type Person .For this we are suing the API -HZ_PARTY_V2PUB.update_person but we are getting the error as " Value for status must be a value defined in lookup type REGISTRY_STATUS. "

Below is the sample code we are using :-

SELECT   PARTY_ID,object_version_number,STATUS
        FROM   hz_parties
       WHERE   1=1
       AND PARTY_ID = 156041
       AND PARTY_TYPE ='PERSON'
       AND status ='A';

PARTY_ID               object_version_number           Status
156041                    1                                              A


----------------------------

DECLARE
    p_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;

    x_profile_id NUMBER;
    x_return_status VARCHAR2(2000);

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