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

Home » Applications » Oracle Fusion Apps & E-Business Suite » Self Service - Enter Contacts gives an error (ERP 12.2.4 11.2.0.3 datbase,linux 5.7)

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

Self Service - Enter Contacts gives an error [message #646632]

Wed, 06 January 2016 02:00

oracle2013
Messages: 15
Registered: July 2013
Location: Hyderabad

Junior Member

Dears,

I am hitting Error when adding new contact from personal information as the below.Please check and give me exact solutions.

ORA-20001: ORA-06512: at "APPS.HR_UTILITY", line 939 ORA-06512: at "APPS.HR_PROCESS_CONTACT_SS", line 9259 ORA-06512: at line 1

Thanks in Advance,

Report message to a moderator

Re: Self Service - Enter Contacts gives an error [message #646633 is a reply to message #646632]

Wed, 06 January 2016 02:08

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

Senior Member
Account Moderator

Exact solution is "what is at line 9259 of APPS.HR_PROCESS_CONTACT_SS"?

Also exact solution implies remove all WHEN OTHERS from your code.

Report message to a moderator

Re: Self Service - Enter Contacts gives an error [message #646637 is a reply to message #646632]

Wed, 06 January 2016 02:45

John Watson
Messages: 8974
Registered: January 2010
Location: Global Village

Senior Member

You can't edit supplied EBS code.
I always start by looking at the Electronic Technical Reference, etrm.oracle.com. Search there, and you will find that the APPS.HR_UTILITY package includes this code,

Code: [Select all] [Show/ hide]

937   procedure raise_error is
938   begin
939     raise_application_error (hr_utility.hr_error_number, hr_utility.get_message);
940 --    app_exception.raise_exception;
941   end raise_error;

and that this is the relevant code from APPS.HR_PROCESS_CONTACT_SS

Code: [Select all] [Show/ hide]

9255    IF p_applicant_number <> hr_api.g_varchar2
9256    THEN
9257             l_rec_changed := TRUE;
9258             goto finish;
9259    END IF;

I would find out how the procedure is being called, and run it from SQL*Plus with the same parameter values. If you aren't familiar with this, you'll need to talk to your EBS implementation consultants, because they probably set up something incorrectly.

Report message to a moderator

Re: Self Service - Enter Contacts gives an error [message #646642 is a reply to message #646637]

Wed, 06 January 2016 03:57

oracle2013
Messages: 15
Registered: July 2013
Location: Hyderabad

Junior Member

Dears,

Can you please confirm me is this issue related to technical or developer.

Thanks

Report message to a moderator

Re: Self Service - Enter Contacts gives an error [message #646643 is a reply to message #646642]

Wed, 06 January 2016 04:26

John Watson
Messages: 8974
Registered: January 2010
Location: Global Village

Senior Member

What I will confirm is that you need to do some work Smile

Look at the code I posted for you, particularly this:

Code: [Select all] [Show/ hide]

IF p_applicant_number <> hr_api.g_varchar2

and think about your data. Consider data types. Do you think that code is expecting numbers or strings? What problems might be occuring? Here's an example:

Code: [Select all] [Show/ hide]

orclz>
orclz> set serverout on
orclz> begin
  2  if 1 <> '2' then dbms_output.put_line('ok');
  3  end if;
  4  end;
  5  /
ok

PL/SQL procedure successfully completed.

orclz> begin
  2  if 1 <> 'a' then dbms_output.put_line('ok');
  3  end if;
  4  end;
  5  /
begin
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 2


orclz>

Report message to a moderator

Re: Self Service - Enter Contacts gives an error [message #646696 is a reply to message #646643]

Thu, 07 January 2016 00:21

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

you can check MOS note: 1936154.1. Maybe it is relevant in your case.

Report message to a moderator

Re: Self Service - Enter Contacts gives an error [message #646698 is a reply to message #646696]

Thu, 07 January 2016 00:40

oracle2013
Messages: 15
Registered: July 2013
Location: Hyderabad

Junior Member

Dear Alien,

Thanks for your reply.The document which you provided a patch 19568474 it is for India legislation.So can I use the same patch for Saudi legislation? also my ERP version is 12.2.4.Please reply me.

Thanks in advance,
Hidayath

Report message to a moderator

Re: Self Service - Enter Contacts gives an error [message #646700 is a reply to message #646698]

Thu, 07 January 2016 01:03

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

My bad, I missed your version. The patch is only for 12.1. I don't think it will work for Saudi legislation. But you can contact Oracle Support, and ask them.

Regards,

Arian

Report message to a moderator

Re: Self Service - Enter Contacts gives an error [message #646703 is a reply to message #646700]

Thu, 07 January 2016 01:09

oracle2013
Messages: 15
Registered: July 2013
Location: Hyderabad

Junior Member

Dear,

Thanks for your reply.If you find any doc.Please let me know.

Report message to a moderator

Previous Topic:	Single Invoice for Multiple Vendors
Next Topic:	Concurrent Manager Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 10 20:11:43 CDT 2025