Hi experts,

When trying to enter 'Extra Details of Service'
UK HRMS Manager --> Assignment --> Others --> Extra Details of service.

Get the following error :

APP-PER-51938: The system find the program unit being
called. This could be because the application API
pre-processor has not been ran. Contact your system
administrator quoting the following details: Error ORA-06508
in API module PQP_ASSIGNMENT_ATTRIBUTE_F at hook After Update.

Reason: the PAY_DYT_ASSIGNMENT_ATTRIB_PKG package is invalid and unable to compile it.

Taken ususal route raised TAR, usual story we are going in circles.

wanted to your expert opinion.

Did you encounter this issue or hear about this issue in passing.

Would appreciate your help.

thanks and regards
Sudhir
p.s: loosing the will to be in oracle consutling:-(( after they released version 12

Chin up old boy!! No point getting down about it! t least you have Extra Details of Service and Rates History over there in Blighty!

Any way, are you able to get SQL access to the system? I.E. Apps access? It may be worth trying to compile the package yourself to see if you can interpret the Compilation error... Something like ALTER PACKAGE PAY_DYT_ASSIGNMENT_ATTRIB_PKG COMPILE; Should do it... Is this happening in test instance?

Also might be worth querying teh ALL_OBJECTS view where the Status is not VALID and the Object type is like PACKAGE... This will let you know all the invalid packages on the DB... It might help... It has been known...

Any way, I hope this does help you some what!
Gav

Sudhir,

I think I have seen similar errors when I implemented user hooks years ago. I think the standard package ends up calling custom package and mismatch in parameter list. As Gavin says, find the invalid package and try compiling it. There are a couple of standard API's to maintain hooks: hr_api_hook_call_api, hr_api_user_hooks_utility.

Logically following the error message you could think that if you created hook, std package was patched, then you need to re-run pre-processor. Or knowing Oracle, error actually has nothing to do with hooks, just some patches are inconsistent.

Regards
Ian

Hi Gav and Ian,

Thanks for the inputs,i have done what you suggested and still the package was invalid.

However, when DBA compile the package using the script for the
.../applmgr/R12appl/pqp/12.0.0/patch/115/sql


SQL> @./pqpdtpkg.pkh
SQL> @./pqpdtpkg.pkb

it got compiled.

issue resolved..happy man again.

Thanks for the help guys.

Gav: send me your e-mail,i will get in touch.

Cheers
Sudhir