OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » CREATE

Home » Applications » Oracle Fusion Apps & E-Business Suite » CREATE_PHONE API

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CREATE_PHONE API [message #472982]

Wed, 25 August 2010 03:26

johannd
Messages: 2
Registered: August 2010
Location: Johannesburg

Junior Member

I have created a procedure to create a phone number in using the CREATE_PHONE API

HR_PHONE_API.CREATE_PHONE(p_date_from =>sysdate, p_phone_type => 'W1',
p_phone_number => '0113866000',
p_parent_id => a.person_id,
p_effective_date => sysdate,
P_phone_id => l_phone_id,
p_object_version_number => l_object_version_number ) ;

but when I execute the procedure I get the error
"ORA-20001: Value for parent id was not found in parent table.
ORA-06512: at "APPS.HR_PHONE_API", line 273
ORA-06512: at "APPS.NHLS_UPDATE_PERSON", line 72
ORA-06512: at line 5" what is the cause of this error and how to correct it

Report message to a moderator

Re: CREATE_PHONE API [message #472983 is a reply to message #472982]

Wed, 25 August 2010 03:28

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

ORA-20001

This is a custom error, that is an error programmed in your application code.
This is NOT an Oracle error.
Ask the application developer the reason.

Regards
Michel

Report message to a moderator