Home » Applications » Oracle Fusion Apps & E-Business Suite » hrms error (r12)
hrms error [message #410320] Fri, 26 June 2009 03:54 Go to next message
monikabhakuni
Messages: 110
Registered: September 2008
Location: India
Senior Member
While running a package through concurrent program i am getting this error. Can you please guide me that where i am going wrong.

Error: The HR Object is Invalid.

Cause: The HR object which is attempted to be locked is inconsistent with the corresponding object in the HR schema.

I have checked the object version number and effective date
tehy both are fine.
Re: hrms error [message #410390 is a reply to message #410320] Fri, 26 June 2009 14:55 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Which package?
Is your concurrent program having an executable as "Stored Procedure"?
What is the signature of the procedure?
What are the values you are passing as the parameters to the concurrent program?

By
Vamsi
Re: hrms error [message #410563 is a reply to message #410390] Sun, 28 June 2009 22:52 Go to previous messageGo to next message
monikabhakuni
Messages: 110
Registered: September 2008
Location: India
Senior Member
that is a custom package.
yeah the executable of the program is 'Stored Procedure'
i am not passing any parameters in this package
Re: hrms error [message #410578 is a reply to message #410563] Mon, 29 June 2009 02:04 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
When you expect answer from others, you also have to answer all the questions asked by them.
Quote:
What is the signature of the procedure?

Anyway, have a look at the chapter "PL/SQL APIs for Concurrent Processing" in Oracle Applications Developer's Guide. I suspect that, you haven't defined the signature correctly with errbuf and retcode.

By
Vamsi
Re: hrms error [message #410581 is a reply to message #410578] Mon, 29 June 2009 02:21 Go to previous messageGo to next message
monikabhakuni
Messages: 110
Registered: September 2008
Location: India
Senior Member
no that is correct only i am passing errcode and errbuf as output parameteres..'
that thing is working
Re: hrms error [message #410588 is a reply to message #410581] Mon, 29 June 2009 02:39 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Quote:
Error: The HR Object is Invalid.

Cause: The HR object which is attempted to be locked is inconsistent with the corresponding object in the HR schema.
This looks some db specific issue.
Post the log of the request.
Did you get any clue in the sql trace of this request?

By
Vamsi
Re: hrms error [message #410604 is a reply to message #410588] Mon, 29 June 2009 04:08 Go to previous messageGo to next message
monikabhakuni
Messages: 110
Registered: September 2008
Location: India
Senior Member
this is the log file.
I hve checkde the object version numebr still i am getting this error.
I dont have any clue that why this error is coming.
  • Attachment: l913577.req
    (Size: 1.45KB, Downloaded 200 times)
Re: hrms error [message #410607 is a reply to message #410604] Mon, 29 June 2009 04:16 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Which are the standard HRMS API's you are using in your custom package?
Have you checked the Metalink? I could see lot of Notes related to this error.

By
Vamsi
Re: hrms error [message #410611 is a reply to message #410607] Mon, 29 June 2009 04:28 Go to previous messageGo to next message
monikabhakuni
Messages: 110
Registered: September 2008
Location: India
Senior Member
hi,
I have attached my code... with this mail..
i odnt hve username/pwd for metalink
  • Attachment: package.txt
    (Size: 15.14KB, Downloaded 421 times)
Re: hrms error [message #411384 is a reply to message #410320] Fri, 03 July 2009 05:43 Go to previous messageGo to next message
kecd_deepak
Messages: 52
Registered: December 2007
Member
Hi,
This is due to incorrect Object_version_number.

Please provide correct Object_version_number.

Thanks
Dpk
Re: hrms error [message #411388 is a reply to message #410320] Fri, 03 July 2009 06:00 Go to previous messageGo to next message
kecd_deepak
Messages: 52
Registered: December 2007
Member
Hi..

Hey what are you doing.........in your code...
What about your Approach.......


=> No log messages......

=> l_object_version_number : you are using same variable twice....

first u populate it with object_version_number from per_all_assignments_f
and then u overrite it with object_version_number from per_all_people_f.

Please provide bject_version_number selected from per_all_assignments_f to the API.

This cause the ERROR.

use this

SELECT assignment_id
,MAX(object_version_number)
INTO lv_assignment_id
,lv_assg_obj_ver_num
FROM per_all_assignments_f
WHERE 1=1
AND person_id = lv_person_id
GROUP BY assignment_id;


Thanks
dpk
Re: hrms error [message #411390 is a reply to message #411388] Fri, 03 July 2009 06:08 Go to previous message
monikabhakuni
Messages: 110
Registered: September 2008
Location: India
Senior Member
Yeah i know that api has been completed and is working fine now..
Smile
Previous Topic: Where is R12 document for PO interface
Next Topic: hrms table information needed
Goto Forum:
  


Current Time: Sun Dec 04 18:31:55 CST 2016

Total time taken to generate the page: 0.13462 seconds