Value Sets - Video

Defining KeyFlexfields - Video

Organization Hierarchy!

User and Responsibility Creation - Video

User and Responsibility Creation

Setting Up Profiles (Video) - CORE HRMS

Setting Up Profiles

Irecruitment Interview Question 2

What are the iRecruitment features accessible through the HA functionality?

The iRecruitment High Availability solution supports only iRecruitment Candidate functionality. You can maintain a basic job site that enables job seekers to apply for jobs and enter basic information such as their e-mail address, first name, and last name.

Can I remove the old data in iRecruitment?

Oracle iRecruitment provides the iRecruitment Purge Old Data process to remove the candidate and applicant data from the database. This process helps you meet any Data Protection statutory requirements in your country. You can select any deletion method from the various options and identify time criteria for deleting the inactive data.

Are there any processes that I should schedule to run regularly for iRecruitment?

You can schedule the Index Synchronization process to run regularly to update the indexes for job postings and resumes.

Profile options set for iRecruitment

IRC: Registration Business Group

IRC: Core Background Color

IRC: Default Country

IRC: Document Upload Count Limit

IRC: Installed

IRC: Internal Posting Days

IRC: Monthly Document Upload Count Limit

IRC: Visitor Homepage Function

IRC: Homepage Function

IRC: Candidate Permission Set

IRC: Registration Responsibility

How to restrict iRecruitment external visitors to access only responsibilities on the external server?

Set the Server Trust Level for the server to External, Set the Trust Level of the iRecruitment external responsibilities to External too.

Is SSHR a dependency for iRecruitment?

iRecruitment has no dependence on SSHR

Does iRecruitment support “Candidate Qualifying Questionnaires” where the candidate must answer vacancy-specific questions correctly prior to submitting an application?

iRecruitment currently does not support this function, For now this can be achieved by having a set of simple questions using flexfield to get those responses and a user hook to validate them as part of the apply process.

Do we track vacancy history?

iRecruitment does not track changes to the vacancy. If changes to a field are to be traced use the Audit capability in APPs.

What are the advantages to the HR or the recruiting group of using iRecruitment?

Oracle iRecruitment is a full-cycle recruitment solution. It automates every phase of the recruitment process. iRecruitment integrates with Oracle HRMS to manage the entire workforce lifecycle. Information that the two applications share simplifies your day-to-day administrative tasks. For example, after you hire an applicant, your administrative staff need not spend time filling our forms about the new hire. The employee’s assignment details are  already available.

Can I configure iRecruitment site according to my enterprise’s requirements?

Oracle iRecruitment is a highly extensible and configurable application that enables you to design a recruitment site that addresses your enterprise’s needs. You can configure data, content, labels, links, and logos to address the specific goals of your job site.

What are the reporting options available in Oracle iRecruitment?

iRecruitment provides you with business intelligence reports. These reports are called the iRecruitment Performance Management Viewer (PMV) reports. They help you to report on various measures of the recruitment process; for example, you can measure the time taken to fill a vacancy or the effectiveness of a recruitment source. These are supplied as standard with iRecruitment and need no further licenses. You also get a restricted license to HRMSi, and can view the Discoverer reports.

Can I create common job description for vacancies?

Yes. The Default Postings feature enables you to enter a set of values to use as a default whenever a particular business group, organization, job, or position is selected for a vacancy. For example, if you create a lot of similar job postings for administration jobs, then you could set up a default job posting to use whenever you select Administrator as the job for a vacancy.

Can I format job posting details?

You can use HTML tags to format the job posting details. For example, you can use HTML to define the bold and italic styles for your posting content.

How do applicants monitor the status of their applications?

Applicants can monitor the status of their job applications on their home page. They can view the current status of their application on their home page, for example, first interview, second interview, and so on.

Can I post job details on third party job sites?

If your enterprise has agreements to post your job advertisements with third party job sites, you can record information about these sites using the Recruiting Sites function. You can send a single job posting to multiple third party sites using the HR-XML output from iRecruitment.

Does iRecruitment support multi-lingual and multi- currency requirements?

Yes, iRecruitment supports multi-lingual and multi -currency requirements. You can configure the application to address specific local and cultural requirements.

Oracle HRMS Implementation Steps!!!

Following are the steps to implement Oracle HRMS,

-- Define Key Flexfields

-- Define Descriptive Flexfields

-- Define Business Group

-- Set required Profile Options

-- Define Location

-- Define Organization

-- Define Grades

-- Define Jobs

-- Define Positions

-- Set required Lookup values

-- Set person type and Assignments type as per requirement

-- Associate Special Informationa with your Responsibility

-- Register Extra Information and associate with your Responsibility

Reports in Oracle HRMS

Reports in Oracle HRMS

 
Absences Report

Assignment Status Report

Current and Projected Progression Point Values Report

Element Link Details Report

Employee Increment Results Report

Employee Movements Report

Employee Summary Report

Full Personal Details Report 

SetFull Applicant Details Report

Full Assignment Details Report

Full Person Details Report

Full Work Details Report

Job and Position Skills Matching Report

Organization Hierarchy Report

Position Hierarchy Report

Requisition Summary Report

Salary Review Report

Skills Matching Report

Staffing Budget Details Report

Terminations Report

Modules available in Oracle hrms

1. Human Resources

2. Payroll

3. Time & Labor

4. Learning Management

5. Tutor

6. Workflow 

7. Advanced Benefits

8. Self-Service Human Resources

9. iRecruitment

10. Incentive Compensation

11. Human Resources

12. Intelligence

Oracle HRMS Technical Interview Questions 2

How to make concurrent program end with warning?

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
ReqCompletion lRC;
//get handle on request completion object for reporting status
lRC = pCpContext.getReqCompletion();
lRC.setCompletion(ReqCompletion.WARNING, "WARNING");

How do you link a Host type concurrent program to Concurrent Manager?

 
 Assuming your executable script is LOADPO.prog, then use the commands below
cd $XXPO_TOP/bin
ln -s $FND_TOP/bin/fndcpesr $XXPO_TOP/bin/LOADPO

 How do you know if a specific Oracle patch has been applied in apps to your environment.

 
 Use table ad_bugs, in which column bug_number is the patch number.
SELECT bug_number
      ,to_char(creation_date, 'DD-MON-YYYY HH24MISS') dated
FROM   apps.ad_bugs
WHERE  bug_number = TRIM('&bug_number') ;

How do you send a particular Oracle Apps Workflow Activity/Function within a workflow process into background mode.

 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.

 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?

 
--a)if initiating the process using start_process, do the below
    wf_engine.threshold = -1;
    wf_engine.createprocess(l_itemtype
                           ,l_itemkey
                           ,'<YOUR PROCESS NAME>');
    wf_engine.startprocess(l_itemtype, l_itemkey)
--B) When initiating the workflow process through an event subscription, set the Execution Condition Phase to be equal to or above 100 for it to be executed by background process.

 On 10g, how will you use awr?

 By running below scripts. These are both the same scripts, but with differing parameters.
$ORACLE_HOME/rdbms/admin/awrrpt.sql
$ORACLE_HOME/rdbms/admin/awrrpti.sql
 

How will you configure Apache to run in Debug mode, specifically usefull when debugging iProcurement ( prior to 11.5.10).

 
 After 11.5.10, FND Logging  can be used for debugging Oracle iProcurement.
Prior to 11.5.10
 ----STEPS IN A NUTSHELL-----
cd $ORACLE_HOME/../iAS/Apache
vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/ssp_init.txt
    DebugOutput=/home/<<SID>>/ora9/iAS/Apache/Apache/logs/debug.log
    DebugLevel=5
    DebugSwitch=ON

vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/jserv.conf
    ApJServLogLevel debug

vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/jserv.properties
    log=true

 How will you add a new column to a List Of Values ( LOV ) in Oracle Applications Framework? Can this be done without customization?

 
 Yes, this can be done without customization, i.e. by using OA Framework Extension coupled with Personalization. Implement the following Steps -
a) Extend the VO ( View Object ), to implement the new SQL required to support the LOV.
b) Substitute the base VO, by using jpximport [ similar to as explained in Link ]
c) Personalize the LOV Region, by clicking on Add New Item. While adding the new Item, you will cross reference the newly added column to VO.



Important Tables in HRMS

1. per_all_people_f   This table will provide us the very basic information about the employee. The very data from the first screen we see when we open the ‘People -> Enter and Maintain’ form goes into this table.

2. per_all_assignments_f   This table will store all the information which is been entered in the employee assignment form.

3. per_addresses    This table will store all the information which is been entered in the employee address form.

4. per_pay_proposals     This table will store all the information which is been entered in the employee salary form.

5. per_person_types_tl     This table is used to find the type of the employee. This table is linked with the per_all_people_f with the person_type_id to find out the type of person.

6. per_jobs_tl    This table will contain the various types of JOBS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct job name from the employee.

7. per_grades_tl    This table will contain the various types of GRADES in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct grade name from the employee.

8. hr_locations_all    This table will contain the various LOCATIONS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct location name from the employee.

9. pay_all_payrolls_f    This table will contain the various types of PAYROLLS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct payroll name from the employee.

10. per_pay_bases    This table will contain the various types of PAY BASES in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct pay basis name from the employee.

11. per_assignment_status_types_tl    This table will contain the various types of assignment types in oracle. The assignment types generally would be ‘Active Assignment’ etc.. This table is been linked with the per_all_assignments_f table to retrieve the correct job name from the employee.

12. per_person_type_usages_f    This table will store the correct person type of the particluar employee. We should never depend on the person type present in the per_all_people_f table. Instead we need to link the person_id with this table and get the correct person type.

Key Flexfields (KFFs) in HRMS

 
=>Job KFF, 

=>Grade KFF, 

=>People Group KFF, 

=>Position KFF, 

=> Cost Allocation KFF, 

=> Competence KFF

What are Date Track Tables? 

Every update in the Table, we will save the change in the form of a Record to provide the facility to find the information at any point of time.
These tables are post fixed by _F

What are secured Views?

 
The Views which do not have the _all to be said as secured views.
Per_all_people_F
per_people_f
per_all_assignemtns_f
per_assignments_f
pay_all_payrolls_F
per_payrolls_f

The differece between both secured views and non secured views is 

 
1.Secured views display information only for the current period
2.Unsecured views is used to get the information from the entire rows

APIs in HRMS

 
API are used in HR to insert the data into the Base tables. As its very secured system, the user does nothave the facility to copy the data directly into the Base tables.When we write the inbound interfaces / use WebAdI, the systems will use the APIs to store the data into system.The API are published by oracle with number of parameters.The different types of parameters are IN / INOUT / OUT.Of these parameters few are mandatory, with out which the process wont complete.Generally when we use API we give data for  Object Version Number, Effective Date, P_Validate
HR_EMOYEE_api ex hr_employee_api.create_employee
hr_PERSON_api
hr_organization_api 

Ex: hr_organization_api.create_organization
hr_applicant_apI
hr_assignment_api

 

What are the reports which you have done in HR?
HR PAYROLL COSTING 

 
This report is used to display the information about the employees, the assignements which were given to the employees along with the payroll details including the Hours Paid, Salary, NI, Pension, Car Allowances and Other Allowances.
p_datetrack_update_mode, p_datetrack_delete_mode in HRMS API

Understanding the p_datetrack_update_mode Control Parameter in HRMS API

 
The p_datetract_update_mode control parameter enables you to define the type of DateTrack change to be made. This mandatory parameter must be set to one of the values as mentioned below
UPDATE - Keep history of existing information
CORRECTION - Correct existing information
UPDATE_OVERRIDE - Replace all scheduled changes
UPDATE_CHANGE_INSERT - Insert this change before next scheduled change
 

Understanding the p_datetrack_delete_mode Control Parameter

The p_datetract_update_mode control parameter enables you to define the type of DateTrack deletion to be made. This mandatory parameter must be set to one of the following values
ZAP - Completely remove from the database
DELETE - Set end date to effective date
FUTURE_CHANGE - Remove all scheduled changes
DELETE_NEXT_CHANGE - Remove next change

Core HRMS Interview Questions 1

What are basic setups of oracle HRMS?

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.

What are the differences between 11i and R12 HRMS

Oracle 11i	Oracle 12
The Legal Entity, the Set of Books and the Operating Unit… all of these were defined using the Organizations form typically through the HRMS or Inventory responsibilities.	the Legal Entity, the Primary Ledger and Operating Unit are all defined using the the Accounting Setup Manager.
the Bank Accounts are defined at the Operating Unit level.	Bank Accounts are defined at Legal Entity Level which can be accessed by multiple Operating Units.
there are only 6 validation types viz. Dependent, Independent, None, Pair, Special and Table	there are 2 additional validation types called ‘Translatable Independent’ and ‘Translatable Dependent’
Reporting Currencies -MRC Reporting set	Reporting Currency of books
Database Version in 11i (11.5.9 & 11.5.10) was 9i Rel 2	Release 12 its 10g R2 (10.2.0.2)

What are 2 modes of date track in Oracle APPS?

There are two Date Track modes are as follow:

·         Update

·         Correction

Difference between correction/update

· If you choose Update, Oracle HRMS changes the record as from your effective date, but preserves the previous information. 

· If you choose Correction, Oracle HRMS overrides the previous information with your new changes. The start and end dates of the snapshot you have corrected remain the same.

What is the use of Date Track?

1) It is used to maintain the record history by creating a new record when the date track mode is UPDATE and override on the existing record when the Data track mode is CORRECTION.

2) The value of the Data Track record depends on the date.

3) Tables ending with _F are date track tables.

4) To control data tracked rows, every Date Track table must include Effective_start_date & Effective_end_date.

5) The Effective_Start_Date indicates when the record inserted.

6) The Effective_End_Date indicates when the record updated or deleted.

Types of flexfield’s and Types

There are around twelve KFFs in Oracle HRMS; out of which six are mandatory for a successful Core-HR implementation. The mandatory KFFs are:

• Job
• Position
• Grade
• People Group
• Cost Allocation
• Competency

Apart from the mandatory ones, there are a few optional KFFs present in the Oracle HRMS. Like:

• Personal Analysis
• Collectively Agreed Grades Flex field
• Soft Coded Key Flex field
• Bank Details Key Flex Field
• Training Resources
• Item Contexts Flex Field.

Mandatory flexfield’s for BG

The mandatory KFFs are:

• Job
• Position
• Grade
• People Group
• Cost Allocation
• Competency

Difference between KFF and DFF

Key Flexfield	Descriptive Flexfield
A Key Flexfield as the name suggest is a key building block of a module and is required for defining the structure of objects of that module e.g. The Account Structure, Item Structure etc.	A descriptive Flexfield as the name suggests helps more in describing an object (like a transaction or screen) more than the available fields on that screen
Key Flexfield captures mandatory business information like company department, account etc.	Descriptive Flexfield captures additional business information like name of the company’s MD etc.
KFF is Mandatory	DFF is optional
KFF displays like text item	DFF displays like []
KFF’s data are stored in the segments	DFF’s data are stored in the attributes
30 segment columns are reserved for KFF’s data	15 attribute columns are reserved for the DFF’s data.

Core HRMS Interview Questions 2

Difference between Value Sets and Look Ups

Difference 1

Value sets can be attached to parameters of a concurrent program, whereas Lookups can't.

Difference 2

Certain types of Lookups are maintainable by the users too, for example HR Users will maintain "Ethnic Minority" lookups. Value Sets are almost never maintained by end users, with the exception of GL Flexfield codes. Value sets are usually maintained by System Administrators.

Difference 3

Value sets can contain values that are a result of an SQL Statement.

Hence it is possible to make Value Set list of values dynamic.

On the contrary, Lookup Codes are Static list of values.

What are Look Ups

A LOOKUP is a specific list of values which can be set by a user. LOOKUPS have a 'type' and are either:

Access levels of Lookups and differences

· USER (where the user can add/amend/delete items)

· EXTENSIBLE (where the user can add or amend his own items, but cannot change any of the 'seeded' values)

· SYSTEM (where the user cannot do anything to the 'seeded' values)

LOOKUPs are used directly by forms in the system.

Global HRMS Manager > Other Definitions > Application Utilities Lookups.

Number of segments and attributes at flexfield’s

KFF	DFF
Segments	Attributes
30	20

What is a Business Group

A BG is the largest unit representing the enterprise as a whole. A BG is the highest level of the structure and is an organization that represents the consolidated enterprise, a major division, or an operation company and has no accounting impact.

Represent a legislative grouping (typically a country where the enterprise has a fair number of employees).
Serves as a container for the organizations in the enterprise.
    Enable grouping and managing data in accordance with the legislative rules and reporting requirement of a single country.

Difference between Job and Position

Job is general one, whereas Position is specific term to its role and responsibilities.

JOB: MANAGER (generic term), SOFTWARE DEVELOPER

POSITION:  Finance Manager, HR Manager, Junior SOFTWARE ENGINEER, (this is position which is specific to the role to be played.

How to create EIT and SIT

SIT

Switch Responsibility to ‘Human Resources, Vision Enterprises’

Double click on ‘Security’

Click on ‘Information Types’

Create your own ‘Information Types’ under your ‘Responsibility Name’.

EIT

Switch Responsibility to ‘Human Resources, Vision Enterprises’

Double click on ‘Other Definitions’

Click on ‘Special Information Types’

Difference between FTE (Future Time Equivalent) and Headcount

Head count is the number of physical people, human bodies for a given position.

FTE- Full Time Equivalent is the number of hours spent per week for a given position.

Eg: 1 fte, 2 head count means one full time position where 2 different people work in. if a week is 40 hours, then you have for example Mr X doing 20 hours on that position, and Misses Y an other 20 hours.

Full-time equivalent (FTE) is a way to measure a worker's involvement in a project, or a student's enrollment at an educational institution. An FTE of 1.0 means that the person is equivalent to a full-time worker, while an FTE of 0.5 signals that the worker is only half-time.

Can we delete the employee record

Yes we can delete the employee record

People >> Delete Personal Records

What are the important profile options required to set while implementing Core HR

HR:User Type = HR User

This is necessary to allow the Inventory responsibility to complete the organization setup. Setting the profile to a value of 'User' as opposed to 'Payroll & User' will restrict the Inventory user from accessing any Payroll information if Oracle Payroll is installed.

HR: Business Group = {the users Business Group name}

This points the responsibility to the appropriate Business Group. When multiple Business Groups are defined, you must associate each responsibility with one and only one Business Group. A responsibility cannot see organization data from more than one Business Group.

MO: Operating Unit = {the users Operating Unit name}

Used primarily in a multiorg environment. This points the responsibility to the appropriate Operating Unit. Set the site level to the desired default operating unit. If there is more than 1 Operating Unit Defined, this profile option must be set at the responsibility level for each responsibility.

What is Date Tracking and what are the options available at date tracking when changing a record

1) It is used to maintain the record history by creating a new record when the date track mode is UPDATE and override on the existing record when the Data track mode is CORRECTION.

2) The value of the Data Track record depends on the date.

3) Tables ending with _F are date track tables.

4) To control data tracked rows, every Date Track table must include Effective_start_date & Effective_end_date.

5) The Effective_Start_Date indicates when the record inserted.

6) The Effective_End_Date indicates when the record updated or deleted.

What are 2 modes of date track in Oracle APPS?

There are two Date Track modes are as follow:

·         Update

·         Correction

Difference between correction/update

·         If you choose Update, Oracle HRMS changes the record as from your effective date, but preserves the previous information.

·         If you choose Correction, Oracle HRMS overrides the previous information with your new changes. The start and end dates of the snapshot you have corrected remain the same.

Why Job group?

Job groups allow you to (as you say) set up a different Key Flex for the job name.

This is useful for secondary jobs (like Fire Marshal etc.)

A Job Group enables you to group jobs for specific purposes. You can:

* Specify job groups for project billing rates and for transfer price calculation purposes.

* Associate a Billing Job Group with each project for rate determination and invoice line formatting.

An HR Job Group is automatically seeded for each business group. All jobs defined in that business group are automatically in the HR job group. You can create additional job groups for project purposes, and associate any job within the same business group with the new job groups.

How many responsibilities can we set to a user?

We can set up many responsibilities a user

What is a responsibility?

In an Oracle environment, a responsibility is a defined user right, similar to the word privilege in some other settings. Responsibilities are generally set by the system administrator, and typically specify: what applications a user may access; what transactions a user may perform; and what data the user may perform the transaction on. In her book Oracle E-Business Suite 11i: Implementing core financial applications, Susan Foster explains: "For example, the accounting manager may have full access to Oracle General Ledger, while the accounting clerk may only have access to the Oracle General Ledger journal entry transactions."

What is a Menu

A menu is a hierarchical arrangement of application functions (forms) that displays in the Navigate window. Menus can also point to non-form functions (subfunctions) that do not display in the Navigate window, but that define the range of application functionality available for a responsibility. Each responsibility is associated with a menu.

What is a Function

A function is a part of an application’s functionality that is registered under a unique name for the purpose of assigning it to, or excluding it from, a responsibility.

Types of positions and difference between position types

Positions are used to define employee roles within Oracle Human Resources.position is a specific occurrence of one job, fixed within one organization,Positions are independent of the employees

A position will need to be defined for every unique combination of:

• Job
• Organization
• Reporting To Position Hierarchy
• Valid Grades (Valid Grades to which incumbents are assigned)
• Position Requirements (Required qualifications or valid experience)
• Position Evaluation (Evaluation information and overall evaluation score for the Position)
• Position Key Flex Field (Name Field components, such as Position Title, Position ID or other client defined keys)
• Position Successor
• Probation Periods (To define the length of the Probation Period for incumbents holding this position)

Advantages:

• Position definition with no override attributes, ensures derivation from the position.  It is more accurate because the definition focuses on the position and is not affected by the employee in the position
• Position attributes change less often than employee movement.  When the position attributes change, the system automatically updates incumbent records with the new value.

Types of Positions

Pooled:  This approach is very good for organizations where groups of people are doing the same work (many employees assigned to one position), have the same reporting relationship (predominate in manufacturing and transportation industries).  This approach allows multiple people to occupy a single position that has the same attributes and reporting relationship.

 Shared: This approach supports the ability to assign employees to several part-time positions.  This approach is becoming more common.  In some companies, an employee works part-time (20 hours) in one department and then part-time in another department.  In essence the company divides the employee and distributes the cost across the two departments.  The company benefits from only having to pay benefits to one person.
 
Single Incumbent: This approach is usually used for positions, which are managerial or at least static.  This approach is usually needed for those positions, which will have spending authority levels, and defined succession planning.  This approach assumes on position per person

Oracle HRMS Technical Interview Questions 1

How will you migrate Oracle General Ledger Currencies and Sets of Books Definitions fromone environment to another without reKeying? Will you use FNDLOAD?

FNDLOAD can not be used in the scenario. You can use migrator available in "OracleiSetup" Responsibility

This is a very tough one, almost impossible to answer, but yet I will ask. Which Formin Oracle Applications has most number of Form Functions?

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


Which responsibility do you need to extract Self Service Personalizations?

Functional Administrator

Can you list any one single limitation of Forms Personalization feature that was delivered with 11.5.10

 
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.


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?

a) Define a request group, lets say with name "XX_PO_PROGS"
b) Add these two concurrent programs to the request group "XX_PO_PROGS"
 c) Define a new Form Function that is attached to Form "Run Reports"
d) In the parameter field of Form Function screen, enterREQUEST_GROUP_CODE="XX_PO_PROGS"REQUEST_GROUP_APPL_SHORT_NAME="XXPO" TITLE="XXPO:XX_PO_PROGS"
 e) Attach this form function to the desired menu.


Does Oracle 10g support rule based optimization?

The official stance is that RBO is no longer supported by 10g.


Does oracle support partitioning of tables in Oracle Apps?

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).


What will be your partitioning strategy on GL_BALANCES? Your views please?

 
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.


Does Oracle support running of gather stats on SYS schema in Oracle Apps?

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.


Can you use concurrent program "Gather Schema Statistics" to gather stats on sys schema in oracle apps?

 
No, "Gather Schema Statistics" has no parameters for SYS schema. Please usedbms_job.


Which table is used to provide drill down from Oracle GL into sub-ledger?

 
GL_IMPORT_REFERENCES


What is the significance of profile option Node Trust Level in Oracle Apps.

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.


What is the significance of profile option Responsibility Trust Level.
 

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.


What else can you suggest to restrict the access to screens from external web tiers?

You may use URL filtering within Apache.


What is the role of Document Manager in Oracle Purchasing?
 

POXCON is an immediate concurrent program. It receives pipe signal from theapplication when a request is made for approval/reservations/receipts.