OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » hrms error (r12)

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

hrms error [message #410320]

Fri, 26 June 2009 03:54

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.

Report message to a moderator

Re: hrms error [message #410390 is a reply to message #410320]

Fri, 26 June 2009 14:55

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

Re: hrms error [message #410563 is a reply to message #410390]

Sun, 28 June 2009 22:52

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

Report message to a moderator

Re: hrms error [message #410578 is a reply to message #410563]

Mon, 29 June 2009 02:04

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

Re: hrms error [message #410581 is a reply to message #410578]

Mon, 29 June 2009 02:21

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

Report message to a moderator

Re: hrms error [message #410588 is a reply to message #410581]

Mon, 29 June 2009 02:39

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

Re: hrms error [message #410604 is a reply to message #410588]

Mon, 29 June 2009 04:08

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 1331 times)

Report message to a moderator

Re: hrms error [message #410607 is a reply to message #410604]

Mon, 29 June 2009 04:16

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

Re: hrms error [message #410611 is a reply to message #410607]

Mon, 29 June 2009 04:28

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 1783 times)

Report message to a moderator

Re: hrms error [message #411384 is a reply to message #410320]

Fri, 03 July 2009 05:43

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

Report message to a moderator

Re: hrms error [message #411388 is a reply to message #410320]

Fri, 03 July 2009 06:00

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

Report message to a moderator

Re: hrms error [message #411390 is a reply to message #411388]

Fri, 03 July 2009 06:08

monikabhakuni
Messages: 110
Registered: September 2008
Location: India

Senior Member

Yeah i know that api has been completed and is working fine now..
Smile

Report message to a moderator

Previous Topic:	Where is R12 document for PO interface
Next Topic:	hrms table information needed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 20:44:51 CDT 2024