Issue on Update of party status to 'I' for party type person
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);