Category Archives: oracle apps

Environment Sourcing of Oracle apps in Windows

As most of the DBA’s prefer Linux Environment for Oracle apps. However some due to other support may go to windows. So as a developer perspective they have to navigate to different application which are called as tops for example $AU_TOP. However in windows to access this we have to do a step called Environment Sourcing in windows command to access the top.

So in order to do it. First we have to find out the environment variable file which will be installed during Installation and configuration time.

cd E:\test\testappl
envshell.cmd

Now once invoked the “envshell.cmd” code then we will be able to access the Application top.

Now try to go to AU_TOP by giving the below command

E:\test\testappl>cd %AU_TOP%

E:\test\testappl>cd %FND_TOP%

Thank you

 

FRM-92120 Registry.dat is missing

We have changed the IP address of the servers and then we checked in the server the forms was working. But when we checked in the system it was not working. We got a error as shown in the below screenshot.

After I checked the below steps helped me

Step : 1 Clearing Java cache:
Go to Control Panel |Java | General Tab | Temporary Internet Files > Settings…. > Delete Files… A popup with two item should be checked (Applications and Applets and Trace and Logfiles).  Leave the items selected and click OK.

Step : 2 Clearing IE cache:
Go to Tools | Internet Options > in the General tab under Browsing history, select Delete… and delete Temporary Internet files, Cookies and History.

 

App-Pay-33238: Error PTO_CARRY_OVER_FF Opening Absence Form – system cannot calculate accruals for this date because the employee’s payroll did not exist

As we this error in with our  and when I checked in oracle support I got this document number Doc ID 418621.1

 

When attempting to access the absence screen the following error occurs as per the below screenshot

Error:
APP-PAY-33238 An error has occurred in a user defined
function at line 65 of the formula PTO_PAYROLL_CARRYOVER.
The error text associated with the function call is: The
system cannot calculate accruals for this date because the
employee’s payroll did not exist for the full accrual term…

Please correct the problem with the function call, or
contact your system administrator or support representative.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:

Responsibility: XX HRMS Manager
1. People > Enter and maintain > Other Button
2. Choose the absence option

Cause

The payroll period needs to be extended. This is explained in the error message shown.

Solution

To implement the solution, please execute the following steps:

1. Go into a HRMS responsibility.

2. Navigate to Payroll > Description.

3. Extend the value in the number of years field as shown in the below screenshot.

4. Retest the issue.

5. Migrate the solution as appropriate to other environments.

 

Salary Management rollback the proposed Salary

To rollback the proposed salary which has been uploaded by webadi in Salary Management we have to use API to delete the uploaded Records.

So first query the records that has been uploaded in the backend by the below Query

select * from per_pay_proposals where change_date = :p_date;

Once you are sure to remove the records use the below

DECLARE
CURSOR fetch_det
IS
SELECT   *
FROM   per_pay_proposals
WHERE   TRUNC (change_date) = trunc(sysdate-73);

l_salary_warning   BOOLEAN;
l_err_msg          VARCHAR2 (500);
BEGIN
FOR i IN fetch_det
LOOP
BEGIN
hr_maintain_proposal_api.delete_salary_proposal (
p_pay_proposal_id         => i.pay_proposal_id,
p_business_group_id       => i.business_group_id,
p_object_version_number   => i.object_version_number,
p_validate                => FALSE,
p_salary_warning          => l_salary_warning
);
COMMIT;
DBMS_OUTPUT.put_line (
‘Proposal has been Deleted: ‘ || i.pay_proposal_id
);

COMMIT;
EXCEPTION
WHEN OTHERS
THEN
l_err_msg := SQLERRM;
DBMS_OUTPUT.put_line (‘Inner Exception: ‘ || l_err_msg);
END;
END LOOP;
EXCEPTION
WHEN OTHERS
THEN
l_err_msg := SQLERRM
DBMS_OUTPUT.put_line (‘Main Exception: ‘ || l_err_msg);
END;

Adding Sequence in Receipt Number in Oracle Applications by Form Personalization

As we have a good advantage in using oracle apps forms that is easy to customize. I had a requirement to create a sequence number in Receipt number on receivables. So I have followed the below steps while customizing I came through a error by which the seeded functionality was overriding. However i have resolved it, check the below steps for more Information.

Step 1 : Create a function or a package with Sequence Number

As I have created a function and my below sql statement will give the sequence number.

select xxhw_Invoice_status.gen_receipt_sequence_number from dual

Step 2 : Note the Block and the Field that we are going to customize.

Step 3 : Go the Personalize form and add the rules as shown in the screenshot.

Step 4 : After adding the rules and condition add the action as shown in the below screenshot

From the above screenshot the sequence will be added to the value of the

 

Delete/End Date Element Entry – HRMS APIs

Below is the script for Deleting Element Entry in HRMS

declare

ld_effective_start_date      date;
ld_effective_end_date       date;
lb_delete_warning             boolean;
ln_element_entry_id          number;
ln_object_version_number number;
ln_assin_id                          number;

lc_element_name       pay_element_types_f.element_name%type := ‘Clothing For Official Mission’;
— lc_emp_num             varchar2(6) := ‘005746’;

cursor c is   select pee.element_entry_id
,pee.object_version_number
,paf.assignment_id
from per_all_people_f        per
,per_all_assignments_f   paf
,pay_element_entries_f   pee
,pay_element_types_f_tl  petl
,pay_element_types_f     pet
where 1=1– per.employee_number = lc_emp_num
and trunc(sysdate) between per.effective_start_date and per.effective_end_date
and paf.person_id       = per.person_id
and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
and pee.assignment_id   = paf.assignment_id
and pee.element_type_id = pet.element_type_id
and trunc(sysdate) between pee.effective_start_date and pee.effective_end_date
and petl.element_name   = lc_element_name
and petl.language       = ‘US’
and pet.element_type_id = petl.element_type_id;

begin

/* Date Track modes
DELETE             >> end date element entry
DELETE_NEXT_CHANGE >> delete next changes
FUTURE_CHANGE      >> delete future changes
ZAP                >> completely remove element entry from the database
*/
for i in c loop

dbms_output.put_line(‘Values are element_entry_id’||i.element_entry_id||’ assignment_id ‘||i.assignment_id);
pay_element_entry_api.delete_element_entry
(p_validate                     => false
,p_datetrack_delete_mode        => ‘DELETE’
,p_effective_date               => trunc(sysdate-17)
,p_element_entry_id             => i.element_entry_id
,p_object_version_number        => i.object_version_number
,p_effective_start_date         => ld_effective_start_date
,p_effective_end_date           => ld_effective_end_date
,p_delete_warning               => lb_delete_warning
) ;
commit;

end loop;
exception
when others then
dbms_output.put_line(‘Error: ‘||sqlerrm);
rollback;
end;

How can an element be deleted or end dated in Oracle HRMS Payroll

HOW TO DO??

The element may be deleted if the element has never been processed.

1) Purge the links for may have been created for the element.

How to delete Element Links Procedure

2) if the element has been assigned to an employee, purge it from the employee’s element entries.

How to delete Element Entries Procedure

To purge the links

  •  Navigate: Total Compensation   > Element Link.
  •  Query the element.
    Select the red X icon.
  •  Select Purge.
  •  Save.

To delete or end date an element:

  •  Navigate: Total Compensation  >  Element Description.
  •  Query your element.
  •  Select the red X icon.

Leave a comment for any query.

 

Source

Query to find the Concurrent Program attached to Responsibility

Below is Query to find the Concurrent Program that has been attached to Responsibility.

SELECT frt.responsibility_name, frg.request_group_name,
frgu.request_unit_type,frgu.request_unit_id,
fcpt.user_concurrent_program_name
FROM fnd_Responsibility fr, fnd_responsibility_tl frt,
fnd_request_groups frg, fnd_request_group_units frgu,
fnd_concurrent_programs_tl fcpt
WHERE frt.responsibility_id = fr.responsibility_id
AND frg.request_group_id = fr.request_group_id
AND frgu.request_group_id = frg.request_group_id
AND fcpt.concurrent_program_id = frgu.request_unit_id
AND frt.LANGUAGE = USERENV(‘LANG’)
AND fcpt.LANGUAGE = USERENV(‘LANG’)
AND fcpt.user_concurrent_program_name = :conc_prg_name
ORDER BY 1,2,3,4

Scheduling Failed. Unable to find a calendar date

As I got this Error while placing a Sales order I just searched and got thsi Document from Oracle (Doc ID 1265873.1) As Mentioned I have Setup the Workday Calendar and then when I checked the Issue was resolved.

Below is the solution provided by Oracle

Set up the Workday Calendar.

The Workday Calendar must be setup correctly and rebuilt any time modifications are made to the Calendar.

Navigation paths: Bill of Materials/Setup/Calendars
OR
Inventory/Setup/Organization/Calendars

Once you have made your modifications, you need to rebuild the calendar by selecting the special option on the top tool bar. On the drop down list, click ‘Build’.

Then run data collections to collect this information, then try to schedule the order.

If this still fails then review Note 563072.1 – ‘Unable To Find A Calendar Date’ While Scheduling a Sales Order
— this details other errors in setup that can cause this issue to occur.

Changing Referral Instance link in Irecruitment

Sometimes when we refer a job to our friend and when we feel that it is a wrong instance we can change it by using the below profile option

IRC: External Framework Agent

Most of the changes in the Irec Module will be in Profile Options for any changes.

Thank you..