On-Insert Trigger Raised Unhandled Exception ORA-29273

Login as sysadmin

Navigate: Profileà System.

Type % IRC: Geocode Host% in Profile and Press Find Button

 Clear Site Text Box. 

Save & Close.

Try again to add Location

FRM - 18108: Failed to load the following objects while Opening Forms in Form Builder

SOLUTION for FRM-18108: Failed to load the following objects.
 

Copy the  PLL libraries from resource folder to local PC (e.g. C:\DevSuiteHome\resource).
Copy APPSTAND.fmb from US folder to your local PC (e.g. C:\DevSuiteHome\resource).

Add C:\DevSuiteHome\resource in variable environment.

Note: Create resource folder if it is not existing.

 

How to Delete Grade Rate using API in Oracle HRMS

DECLARE
   CURSOR get_pay_details IS
     
   SELECT * FROM pay_grade_rules_f;
     
   l_effective_start_date         DATE                      := NULL;
   l_effective_end_date          DATE                      := NULL;
   l_grade_rule_id                  NUMBER               := NULL;
   l_object_version_number   NUMBER               := NULL;
   l_err_msg                          VARCHAR2 (500)  := NULL;
   l_rate_id                            NUMBER               := NULL;
  
BEGIN

Before deleting the grade I would recommend you to understanding the p_datetrack_delete_mode Control Parameter.

The p_datetract_update_mode control parameter enables one to define the type of DateTrack deletion     that has to be made. This parameter is mandatory and  must be set to one of the following said values:

     1. ZAP: ZAP mode Completely removes the grade rate from the database
     2. DELETE : DELETE mode Sets end date to effective date
     3. FUTURE_CHANGE : It removes all scheduled changes
     4. DELETE_NEXT_CHANGE: It removes next change


   FOR i IN get_pay_details
   LOOP
      BEGIN
         hr_grade_rate_value_api.delete_grade_rate_value (
            p_validate                => FALSE,
            p_effective_date          => SYSDATE,
            p_datetrack_delete_mode   => 'ZAP',      
            p_grade_rule_id           => i.grade_rule_id,
            p_object_version_number   => i.object_version_number,
            p_effective_start_date    => l_effective_start_date,
            p_effective_end_date      => l_effective_end_date
         );

         COMMIT;
         DBMS_OUTPUT.put_line (
                                   'Grate Rate has been Deleted: ' || i.grade_rule_id
                                 );
      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;

APP-PER-50022: Oracle Human Resources could not retrieve a value for the User Type profile option.

Step 1:

Application developer → Profiles

Set the System administrator access to visible and updateable

 Step 2:

System administrator  → Profiles → System

Search ‘HR:User Type‘ Profile option at Responsibility and site level as per below image.

 Press ‘F11’→ Type→ HR: USER TYPE→ press ‘Ctrl+F11’. 

Save and check your responsibility, error removed.

Checking operating system version: must be 5.0, 5.1, 5.2. Actual 6.1 Failed

Follow the below steps to solve this issue:

1. Copy the installation folder to your local harddesk.
2. Search the folder for oraparam.ini.    
3. Edit the file using notepad.
4. Add 6.1 to the below section.    
5. Save the file and start the installation again.

Unable To Install Oracle Workflow Builder On Windows

Oracle Workflow Builder Client has not been Certified yet to run on Windows 64bit.

To configure the compatibility mode for an application, just locate the installation directory.

    1. Navigate to the WF Builder installer (setup.exe) in the file system

  


 2. Right-Click on the “setup.exe” > then go to Properties

  


 3. Check Compatibility Mode and  Select “Windows XP (Service Pack 3)”

    4. Press OK Button
    5. Now restart the Installer for the Workflow Builder.

Query to get User name and related assigned responsibilities

select fu.user_name "User Name",
         frt.responsibility_name  "Responsibility Name"
 from fnd_user fu,
         fnd_user_resp_groups furg,
         fnd_responsibility_tl frt,
         fnd_application_tl fat
where fu.user_id = furg.user_id
   and frt.application_id = fat.application_id
   and furg.responsibility_application_id = frt.application_id
   and furg.responsibility_id = frt.responsibility_id
   and ltrim(rtrim(fu.user_name)) is not null
order by 1 asc nulls last;