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)
Self Service - Enter Contacts gives an error [message #646632] Wed, 06 January 2016 02:00 Go to next message
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,



Re: Self Service - Enter Contacts gives an error [message #646633 is a reply to message #646632] Wed, 06 January 2016 02:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Self Service - Enter Contacts gives an error [message #646637 is a reply to message #646632] Wed, 06 January 2016 02:45 Go to previous messageGo to next message
John Watson
Messages: 8922
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,
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
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.
Re: Self Service - Enter Contacts gives an error [message #646642 is a reply to message #646637] Wed, 06 January 2016 03:57 Go to previous messageGo to next message
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
Re: Self Service - Enter Contacts gives an error [message #646643 is a reply to message #646642] Wed, 06 January 2016 04:26 Go to previous messageGo to next message
John Watson
Messages: 8922
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:
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:
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>



Re: Self Service - Enter Contacts gives an error [message #646696 is a reply to message #646643] Thu, 07 January 2016 00:21 Go to previous messageGo to next message
Alien
Messages: 289
Registered: June 1999
Senior Member
Hi,

you can check MOS note: 1936154.1. Maybe it is relevant in your case.
Re: Self Service - Enter Contacts gives an error [message #646698 is a reply to message #646696] Thu, 07 January 2016 00:40 Go to previous messageGo to next message
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
Re: Self Service - Enter Contacts gives an error [message #646700 is a reply to message #646698] Thu, 07 January 2016 01:03 Go to previous messageGo to next message
Alien
Messages: 289
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
Re: Self Service - Enter Contacts gives an error [message #646703 is a reply to message #646700] Thu, 07 January 2016 01:09 Go to previous message
oracle2013
Messages: 15
Registered: July 2013
Location: Hyderabad
Junior Member

Dear,

Thanks for your reply.If you find any doc.Please let me know.
Previous Topic: Single Invoice for Multiple Vendors
Next Topic: Concurrent Manager Error
Goto Forum:
  


Current Time: Fri Mar 29 08:50:50 CDT 2024