4 avg. rating (80% score) - 1 votes
If you are an expert in Oracle HRMS then this is for you. Let us know if you looking for a job change? Then do not worry, we’ve a right answer for your job interview preparation. If you are preparing for Oracle HRMS job interview then go through Wisdomjobs interview questions and answers page. Oracle HRMS is Human Resource Management System which is considered to be the major one in Oracle Business Suite. It deals with the HR department and works on the recruitment and other non technical work. Candidates with MBA degree with HR specialization are eligible for this job. Good knowledge on the HR concepts are must to crack the job. Below are the Oracle HRMS interview questions and answers which makes you comfortable to face the interviews:
Element entry is to define element yet here enter that is Earning element or deduction element then calculate net pay.
In oracle HRMS there are so many modules like Core HR, Payroll, Self Service HR, Oracle learning management, iRecruitment, Time and Labour, Compensation Work bench, Oracle Advanced Benefits, Performance Management System etc., Core HR and System Administrator are the Heart of Oracle HRMS.
All basic set ups will do in Core HR with the help of System Administrator.
In system administrator we will create all the Users and Responsibilities, Flex fields, Profile values etc., In core HR we will create Organizations, Locations, Jobs, Positions, Grades, Organization Hierarchy, position Hierarchy, We will create all the employees also. These are the Basic setups in HRMS.
List types are:
Date Track modes are:
Core flexfields are:
Yes we can name certain DFF’s and their location.
Costing types are:
Costing: Recording the costs of an assignment for accounting or reporting purposes. Using Oracle Payroll, you can calculate and transfer costing information to your general ledger and into systems for project management or labor distribution.
Termination Rules of an Element:
Elements are nothing but the components of the salary.
Eg. Basic, HRA, TA, BONUS, Loans etc., There are 2 types of Processing
POXCON is an immediate concurrent program. It receives pipe signal from the application when a request is made for approval/reservations/receipts.
You may use URL filtering within Apache.
In order to make a responsibility accessible from an external web tier, you must setprofile option Responsibility Trust Level at responsibility level to External. Onlythose responsibilities that have this profile option against them will beaccessible from ExternalMiddle tiers.
If this profile option is set to a value of external against a server, then it signifies thatthe specific mid-tier is External i.e. it will be exposed to the www. In other words this server isnot within the firewall of your client. The idea behind this profile option is to flag such middle-tierso that special restrictions can be applied against its security, which means a very restricted setof responsibilities will be available from such Middle-Tier.
No, “Gather Schema Statistics” has no parameters for SYS schema. Please usedbms_job.
If your Oracle Applications instance is on 10g, then you can decide to run stats forSYS schema. This can be done by exec dbms_stats.gather_schema_stats(‘SYS’);Alternately using commanddbms_stats.gather_schema_stats(‘SYS’,cascade=>TRUE,degree=>20);I will prefer the former with default values.If you wish to delete the stats for SYS use exec dbms_stats.delete_schema_stats(‘SYS’);You can schedule a dbms_job for running stats for SYS schema.
This really depends upon how many periods are regularly reported upon, how many periods are left open etc. You can then decide to partition on period_name, or period ranges, oron the status of the GL Period.
Yes, Oracle does support partitioning of tables in Oracle Applications. There are several implementations that partition on GL_BALANCES. However your client must buy licenses to if they desire to partition tables. To avoid the cost of licensing you may suggest the clients may decide to permanently close their older GL Periods, such that historical records canbe archived. Note: Before running the archival process the second time, you must clear down the archive table GL_ARCHIVE_BALANCES (donâ€™t forget to export archive data to a tape).
The official stance is that RBO is no longer supported by 10g.
Question 23. You Have Just Created Two Concurrent Programs Namely “xx Po Prog1” & “xx Poprog2”. Now You Wish To Create A Menu For Concurrent Request Submission Such That Only These Two Concurrent Programs Are Visible From That Run Request Menu. Please Explain The Steps To Implement This?
You can not implement interactive messages, i.e. a message will give multiple options for Response. The best you can get from Forms Personalization to do is popup up Message with OK option.
“Run Reports”. And why not, the Form Function for this screen has a parameter towhich we pass name of the “Request Group”, hence securing the list of Concurrent Programsthat are visible in “Run Request” Form. Just so that you know, there are over 600 form functionsfor “Run Reports”
FNDLOAD can not be used in the scenario. You can use migrator available in “OracleiSetup” Responsibility
You will need to initialize the global variables first using fnd_global.initialize
v_session_id INTEGER := userenv(‘sessionid’) ;
SESSION_ID => v_session_id
,USER_ID => <your user id from fnd_user.user_id>|
,RESP_ID => <You may use Examine from the screen PROFILE/RESP_ID>
,RESP_APPL_ID => <You may use Examine from the screen PROFILE/RESP_APPL_ID>
,SECURITY_GROUP_ID => 0
,SITE_ID => NULL
,LOGIN_ID => 3115003–Any number here
,CONC_LOGIN_ID => NULL
,PROG_APPL_ID => NULL
,CONC_PROGRAM_ID => NULL
,CONC_REQUEST_ID => NULL
,CONC_PRIORITY_REQUEST => NULL
Optionally you may use fnd_global.apps_initialize, which internally calls fnd_global.initialize
fnd_global.apps_initialize(user_id => :user_id,
resp_id => :resp_id,
resp_appl_id => :resp_appl_id,
security_group_id => :security_group_id,
server_id => :server_id);
Yes, this can be done without customization, i.e. by using OA Framework Extension coupled with Personalization.
Implement the following Steps :-
After 11.5.10, FND Logging can be used for debugging Oracle iProcurement.
Prior to 11.5.10
—-STEPS IN A NUTSHELL—–
By running below scripts. These are both the same scripts, but with differing parameters.
Question 32. What Are The Various Ways To Kick-off A Workflow You Can Either Use Wf_engine.start_process Or You Can Attach A Runnable Process Such Ghat It Subscribes To A Workflow Event.when Starting (kicking Off) An Oracle Workflow Process, How Do You Ensure That It Happens In A Background Mode?
wf_engine.threshold := -1;
,'<YOUR PROCESS NAME>’);
If cost of the workflow activity is greater than 50, then the workflow activity will be processed in background mode only, and it won’t be processed in online mode.
Use table ad_bugs, in which column bug_number is the patch number.
,to_char(creation_date, ‘DD-MON-YYYY HH24:MI:SS’) dated
WHERE bug_number = TRIM(‘&bug_number’) ;
Assuming your executable script is LOADPO.prog, then use the commands below
ln -s $FND_TOP/bin/fndcpesr $XXPO_TOP/bin/LOADPO
If the concurrent program is of type PL/SQL, you can assign a value of 1 to the “retcode” OUT Parameter.
For a Java Concurrent program, use the code similar to below
//get handle on request completion object for reporting status
lRC = pCpContext.getReqCompletion();
You can extend the AM in jDeveloper, but it doesn’t work( at least it didn’t work in 11.5.9).
You will need to do the below steps:
The idea here is to delete the cache. Next time when you logon to Oracle Apps Self Service, the Framework will rebuild the css file if found missing for your browser.
Generally speaking, the tabs on a OA Framework page are nothing but the SubMenus. By entering menu exclusion against the responsibility, you can remove the tab from self service page.
In self service, you wish to change the background color and the foreground text of the OA
Oracle ships a file named server.xml with each bc4j package. You will need to ftp that file alongside other bc4j objects(VO’s, EO’s, AM, Classes etc).
Opening the server.xml will load the complete package starting from AM(application module). This is a mandatory step when building Extensions to framework.
In the options field of the concurrent program you can enter something similar to below.
-cp <your custom lib pathused by Java Conc Prog> :/home/xxvisiondev/XXDEVDB/comn/java/appsborg. zip:/home/xxvisiondev/XXDEVDB/comn/java
Document manger runs within the concurrent manager in Oracle Applications. When an application uses a Document Manager, it sends a pipe signal which is picked up by the document manager.
There are two mechanisms by which to trace the document manager
This profile should only generate debugs when set at Site level(I think, as I have only tried site), because Document Manager runs in a different session.
This can be done by setting profile option “Initialization SQL Statement – Custom” against your username before reproducing the issue. The value of this profile will be set so as to enable trace using event 10046, level 12.
Oracle HRMS Related Tutorials
|HR Management Tutorial||Oracle 10g Tutorial|
|Oracle 9i Tutorial||Oracle 8i Tutorial|
|SAP HR Tutorial||Oracle 11g Tutorial|
Oracle HRMS Related Interview Questions
|HR Management Interview Questions||Oracle 10g Interview Questions|
|Oracle 9i Interview Questions||Oracle 8i Interview Questions|
|SAP HR Interview Questions||Oracle 11g Interview Questions|
|Recruitment Interview Questions||Oracle apps Interview Questions|
|Oracle Apps ERP Interview Questions||Oracle 7.3 Interview Questions|
|Oracle Access Manager Interview Questions||HR Interview Questions|
|Oracle Hyperion Planning Interview Questions||Oracle Apps Functional Interview Questions|
|Oracle Apps DBA Interview Questions|
Installing, Upgrading, And Managing Change
Database Diagnosability And Failure Repair
Backup And Recovery
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.