Hi All,
How can we find the department details of a person in Oracle HRMS. Which table defines the departments and the link between employee and department.
Thank you
vamsi
vamsioracle
Last Activity: Nov 12 '09, 07:26 AM
Joined: Jun 21 '07
Location:
-
need Department details
-
Thanks Amit,
But this is registration of Discoverer report. But I want the reverse process. I have a report registered long time back. I have the report identifier with me, I want to see the registration detials.
Actual Problem is : We added a grand total column in the report. It is displayed in desktop version but not in viewer. When we did some research, we came to know that after some changes in the desktop version of... -
Discoverer Query
Hi
I have a disocoverer report registered in Apps. Now hw can i find out the detail of that report in apps.
I have navigated through application develoer --> application--> form function and searched for the report name (identifier in desktop version) in the user fucntion name. It shows there is no such record.
If i have the report name and identifier, how can trace the registered report details.... -
I tried that solution. ItLeave a comment:
-
Scheduling concurrent Program
HI All
I ahve a scheduled concurrent program in Apps. It runs every day early morning. I want to stop it on weekends (sat and Sun).
Is it possible to restrict a scheduled concurrent program, for 5 days of a week.
Vamsi -
Deleting BG_ABSENCE_DURATION
Hi
Can't we delete bg_absence_dura tion. It is throwing an error APP-PAY-06871.
I didn't get any information on this.
Vamsi -
Hi
The code is written such that,
we compare sysdate-duedate.
So if sysdate-duedate = 1 ---- it sends a mail to some one
if sysdate-duedate =2 ----- it send the other mail
So, i am confused, because if i dont send mail on sunday, then on monday, sysdate - due date will change and i may end up sending worng mails on the wrong days
vamsiLeave a comment:
-
Scheduled Concurrent Programs
Hi
Is there a table to find all the scheduled concurrent programs in Oracle Apps. Or is there a way to find this?
Vamsi -
Thanks a lot,
The due date is always the next day of the leave application. suppose if i apply leave today, the due date in the system will be tommorow
vamsiLeave a comment:
-
Hi
This is the object code of the fast formulas in oracle apps. I suppose we cannot compile this at the sql prompt.
vamsiLeave a comment:
-
What kind of a code is this?
Hi
could someone explain me what kind of a code is this.
...Code:CREATE OR REPLACE PACKAGE BODY APPS.FFP3613_01011951 AS /* Code generated by Oracle FastFormula - do not edit. Formula Name: BG_ABSENCE_DURATION */ PROCEDURE DD(V IN OUT NOCOPY DATE,I IN NUMBER,D IN DATE) IS BEGIN IF I=-2 OR I=0 THEN V:=D; END IF; END DD; PROCEDURE DN(V IN OUT NOCOPY NUMBER,I IN NUMBER,D
-
Need logic
Hi Folks
I have written a code to send emails from oracle. Below is the code. I have registered this is Apps and scheduled the concurrent program to run every day. Now i want implement logic, such that even though the concurrent program runs, it should not send email on Saturdays and Sundays.
The due date in the below code is always the next_day of the day I apply leave. It can be Saturday/Sunday. So my package is dependent... -
Adding Adjustment element
Hi all
I have done a setup for a new absence type. Now my client wants to add balance to the existing leave balance. So i created an element with the following details
Element Name: CTO leave adjustment
Category: Information
Input Values: Days and Date.
Now I added this element to the net calculation rules in the accrual plan.
Then I added this to the person, in assignment... -
sorry for posting it hereLeave a comment:
-
Adjustment element not working
Hi all
I have done a setup for a new absence type. Now my client wants to add balance to the existing leave balance. So i created an element with the following details
Element Name: CTO leave adjustment
Category: Information
Input Values: Days and Date.
Now I added this element to the net calculation rules in the accrual plan.
...Leave a comment:
-
Discoverer, Detailed aggregate data warning
Hi
How can I avoid this warning. "You are combining a Detail data with aggregate data"
vamsi -
HI Amit,
I checked with the DBA and found that the bg_absence duration formula is not used at all from a long time, in the instance i tried to make changes. Now when i made changes, it became invalid and we got this error app-pay-33681.
I will post the fast formula in my next post, i need to get it from the DBA.Leave a comment:
-
capturing user id
Hi
Is it possible to capture the user id who is logging into Apps and running the report.
I have a rdf. I want to capture the person running this report. I tried using fnd_profile.val ue(user_id), but it was giving an error.
Error: "fnd_profil e should be declared".
Vamsi -
Hi amit,
Bg_absence duration is the seeded fast formula that is used for business validations.
At the time of applying leave, we input the leave type, dates and the reason.
How ever the error subsided automatically without any change. This occurs occasionally. Any specific reason for this
vamsiLeave a comment:
-
Discoverer Problem
Hi all
I Have a Discoverer Report which displays the Employee loan details of loan. We have 10 types of loans. Now 3 loan types were deleted from the EUL.
Is it possible to retrieve back them now. The report just displays data corresponding to the remaining 7 loan types.
If yes how
thanks in advance
Vamsi
No activity results to display
Leave a comment: