ERPstuff - Oracle EBS Community

Hi Denish,

I saw your package..

Your package is below 200 lines, still you are getting error at line 1244. Please explain this if you are using it somewhere.

You should not use these many paramters to call any package, try to get the assignment_id as a parameter and find out other parameter ...

Well!! Then I would suggest to search this on oracle metalink to check if there are some patches associated with upgradation of r12.1.2 from 12.1.1 which would have trigerred this..

I have not still used 12.1.2, may be there is a changed functionality there. I am planning to upgrade one of my ...

Hi,

What is the value set for profile option FND: Minimum Search Characters at Site level?

Hi Surya,

Please let us know what is your exact requirement.

Thanks!!

Sorry for typo..

It should be TYPE= 'PACKAGE BODY'

Hi Kallice,

Alternatively, you can find this out with simple sql query that will look something like

select * from all_source
where text like %api%.

You can apply more filters or modify this to get more fine tuned output, for eg, if you are looking for APIs used in package or something, yyou ...

Hi Denish,

I think you are getting this error because you are supplying null value to segemnt 1. To resolve this error you may uncheck the 'required' check box for this segment in the Assignments DFF from application developer responsibility.

Please let me know what you get.

Thanks!!

Hi Fayyaz,

You cannot modify that seeded report. But you can definitely create a customized report to add additional fields.

You can base your report on archiver results after payroll to generate payslips.

Please let me know if any.

Thanks!!

Hi,

You can use XML publisher to generate Oracle seeded report in pdf and xls format if you need.
If you are new to XML publisher, I would suggest to use any good tutorial on the same availbale on iternet.

You dont manipulate the source code of seeded reports in this, hence Oracle keeps o giving ...

Hi All,

Lets make this forum really informative and active on internet. Post more and more questions and share information so that everyone may benefit from that.

HRMS/Payroll is such a vast and happening area, but could hardly find any long discussions going on here.

Common folks!!

Thanks

Hi,

If the issue still exists, can you please upload the output of HRMS11i script available on metalink?

I have seen that this issue is caused by some of the patches in RUP5 released by Oracle.

Thanks!!

Hi Muzamil,

I would suggest to check that you have the right object_version_number. You also need to check that your assignment is not linked to a person (and position if set) who's start and end dates do not completely include that of the assignment.

Best of luck!!

Hi

PL SQL Cache is feature of Oracle 11g. Please go through the following link. I think, it is best explained here.

http://www.oracle.com/technology/oramag ... plsql.html

Thanks,
Saurabh

Hi,

It is basically for accounting purpose at organizational level.

Thanks,
Saurabh

Hi,

I guess effective date of this record is date tracked and there is some other active record as of sysdate. Please check it on these grounds.

If not then please elaborate your question.

Thanks,
Saurabh