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

CURSOR fetch_det
FROM   per_pay_proposals
WHERE   TRUNC (change_date) = trunc(sysdate-73);

l_salary_warning   BOOLEAN;
l_err_msg          VARCHAR2 (500);
FOR i IN fetch_det
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
DBMS_OUTPUT.put_line (
‘Proposal has been Deleted: ‘ || i.pay_proposal_id

l_err_msg := SQLERRM;
DBMS_OUTPUT.put_line (‘Inner Exception: ‘ || l_err_msg);
l_err_msg := SQLERRM
DBMS_OUTPUT.put_line (‘Main Exception: ‘ || l_err_msg);

Why are you not using an application in your language?

Good Post…

Going GNU

Last week, listened a conversation between two of my friends, Khaleel and Navin.

Khaleel is contributing to Mozilla community by doing localization. i.e translating the strings on the user interface of Mozilla products like firefox in Tamil. Navin is a tech guy, who likes to read Tamil anywhere.

localization க்கான பட முடிவு

image source –

“Hi Navin, Do you know that the firefox in your mobile and computer can be converted to Tamil?” Khaleel Asked.

“Yes dude. I have heard about it. Tried few times. But, the tamil interface gave me some issues. So reverted back to English UI”. Navin replied.

khaleel Khaleel

“Oh. Is it? It is just a habital issue. You are so used to English. I never faced any issues on using Tamil interface. What are the issues you faced?” Khaleel asked.

“New words to learn. All the new words make me to feel very unfriendly.” This is Navin.

“Yes. We…

View original post 732 more words

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


Oracle BI Uploading RPD in 12c

In the previous version we are having provision to upload the RPD in the server whereas in 12c we have to upload rpd via command line

Below is the syntax of the datamodel command


uploadrpd -I <RPDname> [-W <RPDpwd>] -SI <service_instance> -U <cred_username> [-P <cred_password>] [-S <hostname>] [-N <port_number>] [-SSL] [-H]

I specifies the name of the repository that you want to upload.
W is the repository’s password. If you do not supply the password, then you will be prompted for the password when the command is run. For security purposes, Oracle recommends that you include a password in the command only if you are using automated scripting to run the command.
SI specifies the name of the service instance.
U specifies a valid user’s name to be used for Oracle BI EE authentication.
P specifies the password corresponding to the user’s name that you specified for U. If you do not supply the password, then you will be prompted for the password when the command is run. For security purposes, Oracle recommends that you include a password in the command only if you are using automated scripting to run the command.
S specifies the Oracle BI EE host name. Only include this option when you are running the command from a client installation.
N specifies the Oracle BI EE port number. Only include this option when you are running the command from a client installation.
SSL specifies to use SSL to connect to the WebLogic Server to run the command. Only include this option when you are running the command from a client installation.
H displays the usage information and exits the command.


Below is the screenshot and example of my RPD in server.



Beautify your terminal with screenFetch which is a Info tool

I have recently installed opensuse 42.2 gnome and making some changes. The changes were more about visual so I changed default theme as red arc theme and vivacious Icon theme then I changed color schemes in terminal and while searching I came accross this screenfetch.

Below is the screenshot



How to uninstall linux from windows in dual boot

First download bootsect.exe into the Download directory.

press the windows key, type cmd.exe and on the result (The command prompt) start it as an “Administrator” by right clicking on the cmd icon, and select Run as Administrator.

In the new cmd.exe window, cd to your download directory. for example cd C:\Users\Lalu Patel\Downloads. _assuming your user name is “Lalu Patel”.

Then enter this command. bootsect.exe /nt60 ALL /force /mbr. Restart your system to see that, Windows is automatically loading without grub.

Then in Windows

  1. Open the Control Panel (All Items view), and click on the Administrative Tools icon. then close the Control Panel window
  2. Click on Computer Management in Administrative Tools, then close the Administrative Tools window.
  3. In the left pane under Storage, click on Disk Management. see this.
  4. Select the the partition with unknown type. it is the Ubuntu partition. Right Click -> Delete partition.
  5. Now the former Ubuntu partition becomes an unallocated space.
  6. Select the left partition of the new unallocated space.
  7. Right click on the partition -> click on Extend Volume.
  8. Click on the Next button.
  9. Type in how many MB (1 GB = 1024 MB) you want to use from the unallocated space to extend the selected partition (step 5) into, then click on the Next button.see this.

    Note: If you want to use all of the unallocated space to extend into, then type in the maximum available space shown for the unallocated space.

  10. Click on the Finish button. You’re done.

Source: bootsect, disk management

Delete/End Date Element Entry – HRMS APIs

Below is the script for Deleting Element Entry in HRMS


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
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;


/* 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);
(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
) ;

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

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


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.



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,
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 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

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.