Tables List in Oracle HRMS

Oracle HRMS Table Name	Table Description
HR_ALL_ORGANIZATION_UNITS	Organization unit definitions.
HR_ALL_ORGANIZATION_UNITS_TL	Translated organization unit name definitions.
HR_ALL_POSITIONS_F	Position definition information.
HR_ALL_POSITIONS_F_TL	Translation table
HR_API_BATCH_MESSAGE_LINES	Results and messages generated during batch API processing.
HR_API_HOOKS	Lists the hook points which are available in each API module.
HR_API_HOOK_CALLS	Lists which extra logic, package procedures or formula, should be called from the API hook points.
HR_API_MODULES	Holds details of the business processes and row handlers.
HR_API_TRANSACTIONS	Kiosk processes in progress
HR_API_TRANSACTION_STEPS	Kiosk workflow data rows
HR_API_TRANSACTION_VALUES	Kiosk workflow data columns and values
HR_API_USER_HOOK_REPORTS	Used to hold HR_API_USER_HOOK error information if this exists otherwise no information is held.
HR_ASSIGNMENT_SETS	Formula definitions that identify sets of assignments.
HR_ASSIGNMENT_SET_AMENDMENTS	Identifies explicit include and exclude rules for an assignment set.
HR_ASSIGNMENT_SET_CRITERIA	Identifies individual criteria in the definition of an assignment set.
HR_ATH_ELIGIBLE_TBLS
HR_ATH_ENROLL_TBLS	This table contains ODBC connectivity information for the Authoria enrolled plans table(s).
HR_ATH_VARIABLEMAP	Variable mappings table for the Authoria Integration
HR_AUTHORIA_MAPPINGS	Authoria Mapping Information
HR_CALENDARS	Dated instances of a repeating pattern.
HR_CALENDAR_USAGES	Assignments of calendars to individual entities.
HR_CANVAS_PROPERTIES	Canvas properties for configurable forms
HR_COMMENTS	Central repository for comments.
HR_DE_LIABILITY_PREMIUMS_F	Holds Liability Insurance Providers Premium rates for the Organization
HR_DE_ORGANIZATION_LINKS	Holds extra information for Organizations links with External Orgs
HR_DE_SOC_INS_CONTR_LVLS_F	Holds German Social Insurance Contibution data
HR_DM_APPLICATION_GROUPS	Data Migrator locking ladder groups for applications.
HR_DM_COLUMN_DEFINITIONS	Column definitions for sequence range management
HR_DM_DATABASES	Table containing names of all databases within database farm
HR_DM_DT_DELETES	This table holds the information for the deletion of date tracked data.  This table is also used to hold participant data information of data that has been downloaded but not been uploaded.
HR_DM_EXP_IMPS	This table holds the data from various tables in the source database that will be moved to the destination database using the transportable tablespace for upload in the destination database
HR_DM_GROUPS	This table holds information about the groupings used in the data migration process.
HR_DM_HIERARCHIES	This entity will contain the relationships between tables.  The following relationship will be recorded:
HR_DM_LOADER_PARAMS	This entity contains the configuration data for the AOL loader files
HR_DM_LOADER_PHASE_ITEMS	This entity contains the migration specific configuration data for the AOL loader files.
HR_DM_MIGRATIONS	This table contains the data migration information. There is one row per migration in progress.
HR_DM_MIGRATION_RANGES	This table holds the allocated ranges for each slave process to process during each Download Application/Participant data phase of the migration.
HR_DM_MIGRATION_REQUESTS	This table holds the information about the request id of the issuing concurrent program.
HR_DM_PHASES	This table holds the information about each phase of the migration process.
HR_DM_PHASE_ITEMS	This table details the work to be undertaken for each phase of the Data Migrator.
HR_DM_PHASE_RULES	This table contains the rules governing which phases apply to which migrations.
HR_DM_RESOLVE_PKS	This entity contains the values of the primary key for both the source and destination database for each table for use by the TUPS package.
HR_DM_SEQUENCE_DEFINITIONS	Table containing Sequence Name information for the PER/PAY/DT/FF/OTA/SSP/GHR/HXT/BEN applications.
HR_DM_SEQUENCE_HISTORIES	Table containing sequence information from the different Fidelity databases. To be updated before any changes to sequences are made to enable sequence history tracking.
HR_DM_SEQUENCE_RANGES	Table containing Sequence Ranges for particular Sequence and Database.  This table can hold multiple Ranges for a given Sequence and Database.
HR_DM_TABLES	This entity contains a HRMS table listing that will be processed by the data migrator.
HR_DM_TABLE_GROUPINGS	This entity holds the information for the grouping of tables.
HR_DOCUMENT_EXTRA_INFO	Documents of Record Information
HR_DOCUMENT_TYPES	Document Types for Documents od Record
HR_DOCUMENT_TYPES_TL	Translated Document Types for Documents of Record
HR_DU_COLUMN_MAPPINGS	This table holds the relationship between the column name used in the source object (e.g. the spreadsheet column) and the output target (e.g. the Data Pump parameter name).
HR_DU_DESCRIPTORS	This table holds the descriptor details for each API to be uploaded.
HR_DU_ERRORS	This table holds details about errors encountered during processing of a batch by any of the Data Uploader modules.
HR_DU_MODULES	This table holds the details about each module which can be used for either input, process or output with in the data Uploader.
HR_DU_UPLOADS	This table holds the data relating to information uploaded from a single source file.
HR_DU_UPLOAD_HEADERS	This table holds the details for each API to be uploaded.
HR_DU_UPLOAD_LINES	This table holds the details for each item to be uploaded with an item spanning one or more rows
HR_EFC_ACTIONS	Contains one row for each time the EFC conversion process or delete _EFC table data process is run.
HR_EFC_CURRENCY_HISTORIES	Contains one row per NCU currency as defined in FND_CURRENCIES at the time of the EFC processing with details of the NCU.
HR_EFC_PROCESS_COMPONENTS	Holds one row for each processing script in each conversion processing run.
HR_EFC_ROUNDING_ERRORS	Holds one row for each time a rounding error adjustment has been made.
HR_EFC_WORKERS	Holds one row for each parallel worker instance of a processing component.
HR_EFC_WORKER_AUDITS	Holds one row for each HR_EFC_WORKER row per currency code processed for update scripts only.
HR_EXCEPTION_USAGES	Identifies usage of defined exceptions to a repeating pattern.
HR_FORM_CANVASES_B	Canvas definition for configurable forms
HR_FORM_CANVASES_TL	Translated canvas definitions for configurable forms.
HR_FORM_DATA_GROUPS_B	Form data group definition for configurable forms
HR_FORM_DATA_GROUPS_TL	Translated form data group definitions for configurable forms
HR_FORM_DATA_GROUP_ITEMS	Links items with data groups for configurable forms
HR_FORM_ITEMS_B	Definition of items available for configurable forms
HR_FORM_ITEMS_TL	Translated definitions of form items for configurable forms
HR_FORM_PROPERTIES	Configurable properties for configurable forms modules
HR_FORM_TAB_PAGES_B	Definition of form tab page for configurable forms
HR_FORM_TAB_PAGES_TL	Translated definition of form tab page for configurable forms
HR_FORM_TAB_STACKED_CANVASES	Definition of stacked canvas for tab pages in configurable forms
HR_FORM_TEMPLATES_B	Definition of template used by configurable forms
HR_FORM_TEMPLATES_TL	Translated template definition for use in configurable forms
HR_FORM_WINDOWS_B	Definition of windows for use in configurable forms
HR_FORM_WINDOWS_TL	Translated definition of windows for configurable form
HR_H2PI_ADDRESSES	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and  stores data related to addresses while data upload is in progress.
HR_H2PI_ASSIGNMENTS	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and  stores data related to assignments  while data upload is in progress.
HR_H2PI_BG_AND_GRE	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and  stores data related to bg_and_gre  while data upload is in progress.
HR_H2PI_CITY_TAX_RULES	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and  stores data related to us employees city tax rules  while data upload is in progress.
HR_H2PI_COST_ALLOCATIONS	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and  stores data related to cost allocations s while data upload is in progress.
HR_H2PI_COUNTY_TAX_RULES	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and  stores data related to us employee county tax rules  while data upload is in progress.
HR_H2PI_DATA_FEED_HIST	This table stores information about date feed history for Oracle HR to Oracle Payroll Interface (H2PI).
HR_H2PI_ELEMENT_ENTRIES	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and  stores data related to element entries  while data upload is in progress.
HR_H2PI_ELEMENT_ENTRY_VALUES
HR_H2PI_ELEMENT_LINKS
HR_H2PI_ELEMENT_NAMES
HR_H2PI_ELEMENT_TYPES
HR_H2PI_EMPLOYEES	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and  stores data related to employees while data upload is in progress.
HR_H2PI_FEDERAL_TAX_RULES
HR_H2PI_HR_ORGANIZATIONS
HR_H2PI_ID_MAPPING	This table stores information about ID mapping for Oracle HR to Oracle Payroll Interface (H2PI).
HR_H2PI_INPUT_VALUES
HR_H2PI_LOCATIONS	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and  stores data related to locations  while data upload is in progress.
HR_H2PI_MESSAGE_LINES	This table stores information about all the messages for Oracle HR to Oracle Payroll Interface (H2PI).
HR_H2PI_ORGANIZATION_CLASS
HR_H2PI_ORGANIZATION_INFO	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and  stores data related to  organization info while data upload is in progress.
HR_H2PI_ORG_PAYMENT_METHODS
HR_H2PI_PATCH_STATUS
HR_H2PI_PAYMENT_METHODS
HR_H2PI_PAYROLLS
HR_H2PI_PAY_BASES
HR_H2PI_PERIODS_OF_SERVICE
HR_H2PI_SALARIES
HR_H2PI_STATE_TAX_RULES
HR_H2PI_US_CITY_NAMES
HR_H2PI_US_MODIFIED_GEOCODES	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and  stores data related to  US midified geocodes while data upload is in progress.
HR_INCOMPATIBILITY_RULES	Incompatibility rules for navigation units.
HR_ITEM_CONTEXTS	Combinations table for the item context key flexfield ICX
HR_ITEM_PROPERTIES_B	Properties for form or template items used by configurable forms.
HR_ITEM_PROPERTIES_TL	Translatable properties of items for configurable forms
HR_JP_PARAMETERS	This table holds unique id for Japanese legislative specific data in order not to hard-code Multibyte characters in Japanese localization code objects.
HR_KI_EXT_APPLICATIONS	This table holds the details of the KI integration external applications
HR_KI_SESSIONS
HR_LAYOUTS	Information about an instance of a Self-Service User Interface configuration.
HR_LAYOUTS_TL	Translation table for HR_LAYOUTS.
HR_LAYOUT_COMPONENTS	Set of User Interface Components used within a configurable Self-Service layout.
HR_LAYOUT_COMP_DEFINITIONS	Definitions of the set of User Interface components that can be used within a configurable Self Service User Interface Layout.
HR_LAYOUT_COMP_PROMPTS	Set of prompt codes associated with a Configurable UI Layout Component
HR_LAYOUT_COMP_QUALIFIERS	Set of layout qualifiers which can be used to modify the rendering of a Self Service User Interface component.
HR_LAYOUT_COMP_QUAL_RULES	Set of rules that determine whether a Self Service User Interface component can use a particular layout qualifier.
HR_LEGISLATION_INSTALLATIONS	Status of each product/legislation combination installed
HR_LOCATIONS_ALL	Work location definitions.
HR_LOCATIONS_ALL_TL	Translated location codes and descriptions.
HR_LOCATION_EXTRA_INFO	Extra information for a location.
HR_LOCATION_INFO_TYPES	Types of extra information that may be held against a Location.
HR_NAME_FORMATS	Contains the format masks used to determine the displayed formats of personal names in Applications. Oracle will seed rows in this table which cannot be deleted, but can be modified by customers. Additional rows can be created.
HR_NAVIGATION_CONTEXT_RULES	Context specific rules for taskflow navigation.
HR_NAVIGATION_NODES	Taskflow node definitions.
HR_NAVIGATION_NODE_USAGES	Intersection table between HR_WORKFLOWS, HR_NAVIGATION_NODES and HR_NAVIGATION_PATHS.
HR_NAVIGATION_PATHS	Taskflow navigation path details.
HR_NAVIGATION_PATHS_TL
HR_NAVIGATION_UNITS	Information about potential navigation options in a taskflow.
HR_NAVIGATION_UNITS_TL	Translated fields for hr_navigation_units
HR_NAV_UNIT_GLOBAL_USAGES	Global variable usage by specific navigation unit.  (Form or block).
HR_ORGANIZATION_INFORMATION	Additional attributes of an organization, dependent on class or organization information type.
HR_ORGANIZATION_INFORMATIO_EFC	This is a copy of theHR_ORGANIZATION_INFORMATION  table which is populated by the EFC (Euro as Functional Currency) process.
HR_ORG_INFORMATION_TYPES	Information types that are used to add information for an organization.
HR_ORG_INFO_TYPES_BY_CLASS	Defines organization information types for specific organization classifications.
HR_PATTERNS	A repeating time pattern, eg a work pattern, SSP qualifying pattern or a resource schedule.
HR_PATTERN_BITS	A defined period of time used to construct a pattern.
HR_PATTERN_CONSTRUCTIONS	Decomposition of a repeating pattern into its individual 'bits' of time.
HR_PATTERN_EXCEPTIONS	An exception to a repeating pattern.
HR_PATTERN_PURPOSES	Potential purpose for the parent pattern, eg 'Work Pattern', 'Resource schedule', etc.
HR_PATTERN_PURPOSE_USAGES	Valid combinations of entities and pattern purposes.
HR_PTL_SUMMARY_DATA
HR_PUMP_BATCH_EXCEPTIONS	Holds data pump processing exception (error) information.
HR_PUMP_BATCH_HEADERS	Stores information on a batch to be loaded by the data pump.
HR_PUMP_BATCH_LINES	Each rows stores the information required to make an API call. OUT-parameter values are written back after the API call.
HR_PUMP_BATCH_LINE_USER_KEYS	User keys and their associated information is stored here on the creation of entities that require user keys.
HR_PUMP_DEFAULT_EXCEPTIONS	Lists API modules that do not conform to the API parameter defaulting rules.
HR_PUMP_MAPPING_PACKAGES	Lists PL/SQL packages that contain the parameter mapping functions used by data pump generated code. If module_package and module_name are both null then the mapping functions may be used by all APIs.
HR_PUMP_MODULE_PARAMETERS	Holds seeded information about API parameters for data pump code generation.
HR_PUMP_RANGES	Controls the parallelisation of the work when the data pump is running on multiprocessor platforms.
HR_PUMP_REQUESTS	Holds information on data pump concurrent requests currently running.
HR_QUESTIONNAIRES	Questionnaires used within SSHR.
HR_QUEST_ANSWERS	Answers for a questionnaire.
HR_QUEST_ANSWER_VALUES	Answer values for a questionnaire.
HR_QUEST_FIELDS	Fields of a questionnaire.
HR_SOFT_CODING_KEYFLEX	Legislation specific information for payrolls, organizations and assignments.
HR_SOURCE_FORM_TEMPLATES	Identities of templates which have been copied and the resulting copy. Helps distinguish seeded templates from copied ones.
HR_STU_EXCEPTIONS	Error conditions from the startup data process.
HR_STU_HISTORY	Versions of HRMS Startup data installed
HR_SUMMARY	HR_SUMMARY holds all data for the Generic Summary Process.
HR_SUMMARY_EFC	This is a copy of the HR_SUMMARY table which is populated by the EFC (Euro as Functional Currency) process.
HR_S_MAGNETIC_BLOCKS
HR_S_MAGNETIC_RECORDS
HR_S_US_CITY_GEOCODES
HR_S_US_CITY_NAMES	US cities and their VERTEX geocodes, used to validate US addresses.
HR_S_US_CITY_SCHOOL_DSTS
HR_S_US_CITY_TAX_INFO_F	Element definitions.
HR_S_US_COUNTY_TAX_INFO_F	Element definitions.
HR_S_US_FEDERAL_TAX_INFO_F	Element definitions.
HR_S_US_GARN_EXEMPTION_RULES_F
HR_S_US_GARN_FEE_RULES_F
HR_S_US_GARN_LIMIT_RULES_F
HR_S_US_STATE_TAX_INFO_F	Element definitions.
HR_S_US_ZIP_CODES	Valid zip code ranges for VERTEX cities, used to validate US addresses.
HR_S_VALID_DEPENDENT_TYPES	- Retrofitted
HR_S_WC_STATE_SURCHARGES	- Retrofitted
HR_TAB_PAGE_PROPERTIES_B	Properties of tab pages for configurable forms
HR_TAB_PAGE_PROPERTIES_TL	Translated properties of tab pages for configurable forms
HR_TEMPLATE_CANVASES_B	Definition of canvases on template for configurable forms
HR_TEMPLATE_DATA_GROUPS	Definition for data group on template for configurable forms
HR_TEMPLATE_ITEMS_B	Definition of items on template for configurable forms
HR_TEMPLATE_ITEM_CONTEXTS_B	Definition of items on a template for given context, for configurable forms
HR_TEMPLATE_ITEM_CONTEXT_PAGES	Information about which tab pages item belongs to for a specific context, on template for configurable form.
HR_TEMPLATE_ITEM_TAB_PAGES	Information about which tab pages item belongs to on template for configurable form.
HR_TEMPLATE_TAB_PAGES_B	Definition of tab page for template, for configurable forms
HR_TEMPLATE_WINDOWS_B	Definition of window for a template, for configurable forms
HR_TIPS	Help components used within SSHR.
HR_WINDOW_PROPERTIES_B	Properties of windows for configurable forms
HR_WINDOW_PROPERTIES_TL	Translated properties of windows for configurable forms
HR_WIP_LOCKS	Stores context lock for a transaction
HR_WIP_TRANSACTIONS	Stores the transaction information and state
HR_WORKFLOWS	Taskflows in Oracle HRMS.
HR_WORKING_PERSON_LISTS	Holds a list of people who constitute a user current list, used in the Line Manager Web pages
PER_ABSENCE_ATTENDANCES	Records of absence, or attendance for an employee.
PER_ABSENCE_ATTENDANCES_EFC	This is a copy of the PER_ABSENCE_ATTENDANCES  table which is populated by the EFC (Euro as Functional Currency) process.
PER_ABSENCE_ATTENDANCE_TYPES	User defined absence types.
PER_ABS_ATTENDANCE_REASONS	Valid absence reasons for an absence type.
PER_ABS_ATTENDANCE_TYPES_TL	Holds translated information for Absence Types
PER_ADDRESSES	Address information for people.
PER_ALL_ASSIGNMENTS_F	Employee and applicant assignment details.
PER_ALL_PEOPLE_F	DateTracked table holding personal information for employees, applicants and other people.
PER_ALL_POSITIONS	Dual-maintained position definition information.
PER_ALL_VACANCIES	Vacancies within a specific requisition.
PER_ANALYSIS_CRITERIA	Flexfield combination table for the personal analysis key flexfield.
PER_APPLICATIONS	Applications for employment.
PER_APPRAISALS	An  appraisal is a record of an evaluation of a person by others.
PER_APPRAISAL_TEMPLATES	The heading or grouping of appraisal questions.
PER_ASSESSMENTS	The grouping of a set of assessment elements.
PER_ASSESSMENT_GROUPS	Grouping of People for 360 reviews
PER_ASSESSMENT_TYPES	The definition of an assessment template
PER_ASSIGNMENT_BUDGET_VALUES_F	Budget values for an assignment.
PER_ASSIGNMENT_BUDGET_VALU_EFC	This is a copy of the PER_ASSIGNMENT_BUDGET_VALUES_F  table which is populated by the EFC (Euro as Functional Currency) process.
PER_ASSIGNMENT_EXTRA_INFO	Extra information for an assignment.
PER_ASSIGNMENT_EXTRA_INFO_EFC	This is a copy of the PER_ASSIGNMENT_EXTRA_INFO  table which is populated by the EFC (Euro as Functional Currency) process.
PER_ASSIGNMENT_INFO_TYPES	Types of extra information that may be held against an assignment.
PER_ASSIGNMENT_INFO_TYPES_TL	Translated types of extra information that may be held against an assignment.
PER_ASSIGNMENT_LIST	List of assignments that a secure user can access.
PER_ASSIGNMENT_STATUS_TYPES	Predefined and user defined assignment status types.
PER_ASSIGNMENT_STATUS_TYPES_TL	Predefined and user defined translated assignment status types.
PER_ASSIGN_PROPOSAL_ANSWERS	Web Candidate Offer Answers
PER_ASS_STATUS_TYPE_AMENDS	User amendments to predefined assignment status types.
PER_ASS_STATUS_TYPE_AMENDS_TL	Translated user amendments to predefined assignment status types.
PER_BF_BALANCE_AMOUNTS	Holds assignment level run amount and summary values for backfeed balances by payroll processing period
PER_BF_BALANCE_AMOUNTS_EFC
PER_BF_BALANCE_TYPES	Types of balances that can be held
PER_BF_BALANCE_TYPES_EFC
PER_BF_PAYMENT_DETAILS	Holds details of payments that have been processed by a 3rd party payroll provider, by assignment.
PER_BF_PAYMENT_DETAILS_EFC
PER_BF_PAYROLL_RUNS	Payrolls processed by 3rd party payroll provider.
PER_BF_PROCESSED_ASSIGNMENTS	Intersection table storing details of assignments that have been processed by a 3rd party payroll provider in each payroll run
PER_BOOKINGS	Event booking details.
PER_BUDGETS	Definitions of HR budgets.
PER_BUDGET_ELEMENTS	Combinations of organization, grade, job, and position used to define detailed budget values.
PER_BUDGET_VALUES	Planned HR budget values for specific budget elements.
PER_BUDGET_VALUES_EFC	This is a copy of the PER_BUDGET_VALUES  table which is populated by the EFC (Euro as Functional Currency) process.
PER_BUDGET_VERSIONS	Identifies specific versions of an HR budget.
PER_CAGR_APIS
PER_CAGR_APIS_TL
PER_CAGR_API_PARAMETERS
PER_CAGR_API_PARAMETERS_TL
PER_CAGR_COPY_LOG
PER_CAGR_ENTITLEMENTS
PER_CAGR_ENTITLEMENT_ITEMS
PER_CAGR_ENTITLEMENT_ITEMS_TL
PER_CAGR_ENTITLEMENT_LINES_F
PER_CAGR_ENTITLEMENT_RESULTS
PER_CAGR_GRADES	The reference collectively agreed grades for a Collective Agreement.
PER_CAGR_GRADES_DEF	Collective agreement grades key flexfield combinations table.
PER_CAGR_GRADE_STRUCTURES	The valid collectively agreed grade key flexfield structures for a particular collective agreement
PER_CAGR_LOG
PER_CAGR_REQUESTS
PER_CAGR_RETAINED_RIGHTS
PER_CALENDAR_ENTRIES	Calendar Entries
PER_CAL_ENTRY_GEO_LIST	Calendar Entry Geo Coverage Cache
PER_CAL_ENTRY_ORG_LIST	Calendar Entry Org Coverage Cache
PER_CAL_ENTRY_VALUES	Calendar Entry Values
PER_CAREER_PATHS	List of career paths for jobs.
PER_CAREER_PATH_ELEMENTS	Progression paths for specific jobs.
PER_CA_EE_REPORT_LINES
PER_CHECKLIST_ITEMS	Checklist information.
PER_COBRA_COVERAGE_BENEFITS_F	Details of a benefit that the employee accepts or rejects as part of their COBRA coverage.
PER_COBRA_COVERAGE_PERIODS	Holds coverage periods for COBRA qualifying events.
PER_COBRA_COVERAGE_STATUSES	Tracks the status of a COBRA enrollment.
PER_COBRA_COV_ENROLLMENTS	Enrollments for people who are eligible for continued benefit coverage under COBRA.
PER_COBRA_DEPENDENTS_F	Holds employee dependents coverage for a COBRA qualifying event.
PER_COBRA_QFYING_EVENTS_F	Events that have meaning in the context of COBRA coverage, e.g. Divorce, Termination, Death  etc.
PER_COLLECTIVE_AGREEMENTS	Collective agreement information.
PER_COMPETENCES	A competence is a definition of knowledge, skills, abilities or other charactaristics that a person may possess.
PER_COMPETENCES_TL	This table is used for language translations
PER_COMPETENCE_DEFINITIONS	COMPETENCES Key flexfield combinations table
PER_COMPETENCE_ELEMENTS	A competence element is used to record an individual competence and an evaluation rating.
PER_COMPETENCE_OUTCOMES	Competence outcomes
PER_COMP_ELEMENT_OUTCOMES	The outcomes achieved towards a given Competency .
PER_CONTACT_EXTRA_INFO_F	Extra information for a contact relationship.
PER_CONTACT_INFO_TYPES	Types of extra information that may be held against a contact relationship.
PER_CONTACT_INFO_TYPES_TL	Translated types of extra information that may be held against  a contact relationship.
PER_CONTACT_RELATIONSHIPS	Contacts and relationship details for dependents, beneficiaries, emergency contacts, parents etc.
PER_CONTRACTS_F	The details of a persons contract of employment
PER_CPN_DATA_UPGRADE	Used to log errors / warnings during the conversion of competences to a key flex structure.
PER_DEPLOYMENT_FACTORS	A factor affecting a person's capacity to be deployed within an organization.
PER_DISABILITIES_F	Hold Disability information for one person
PER_ELECTIONS	Holds election related information.
PER_ELECTION_CANDIDATES	Holds information of Election candidates.
PER_ELECTION_CONSTITUENCYS	This table holds information related to constituencies participating in the election.
PER_EMPDIR_ASSIGNMENTS
PER_EMPDIR_JOBS
PER_EMPDIR_LOCATIONS
PER_EMPDIR_LOCATIONS_TL
PER_EMPDIR_ORGANIZATIONS
PER_EMPDIR_PEOPLE
PER_EMPDIR_PHONES
PER_EMPDIR_POSITIONS
PER_ESTABLISHMENTS	This entity is used to maintain a list  of educational establishments e.g. schools, colleges, universities, etc.
PER_ESTABLISHMENT_ATTENDANCES	A record of educational establishments that a person is currently attending or has previously attended.
PER_EVENTS	Record of events such as interviews and appraisals for applicants and employees.
PER_FORM_FUNCTIONS	Navigation and person change information for the Enter Person information screens.
PER_GENERIC_REPORT_OUTPUT	Text lines for output by a generic report script, including: title, header, footer and body lines.
PER_GEN_HIERARCHY
PER_GEN_HIERARCHY_NODES
PER_GEN_HIERARCHY_VERSIONS
PER_GEN_HIER_NODE_TYPES
PER_GRADES	Grade definitions for a business group.
PER_GRADES_TL	Trnslated fields for per_grades
PER_GRADE_DEFINITIONS	Grade key flexfield combinations table.
PER_GRADE_SPINES_F	Stores the progression points for each grade scale.
PER_HEADCOUNT_PORTLET_TBL
PER_HTML_TOOLKIT_REC_TYPES	Default values for the HR html toolkit.
PER_IMAGES	Images for a designated row in a designated table.
PER_INFO_TYPE_SECURITY	Cross table between Responsibilty and Info_type tables, used to secure info types based on responsibility.
PER_JOBS	Jobs defined for a Business Group.
PER_JOBS_TL	Translated  columns for per_jobs
PER_JOB_DEFINITIONS	Job key flexfield combinations table.
PER_JOB_EVALUATIONS	Job evaluation details for specific jobs or positions.
PER_JOB_EXTRA_INFO	Extra information for a job.
PER_JOB_GROUPS	Holds Job Group Information. Each Job will be a member of a Job Group and a Job Group can optionally be within a business group.
PER_JOB_INFO_TYPES	Types of extra information that may be held against a job.
PER_JOB_REQUIREMENTS	Requirements for specific jobs or positions.  For example, skills, qualifications, experience, training.
PER_JP_ADDRESS_LOOKUPS	Lookups for Japanese Addresses
PER_JP_BANK_LOOKUPS	Lookups for Japanese Bank Branches
PER_JP_POSTAL_CODES	Lookups for Japanese postal codes and districts
PER_JP_SCHOOL_LOOKUPS	Lookups for Japanese Educational Institutions
PER_KR_ADDRESSES	KR specific
PER_KR_GRADES	KR specific
PER_KR_GRADE_AMOUNT_F	KR specific
PER_KR_G_POINTS	KR specific
PER_KR_G_POINT_AMOUNT_F	KR specific
PER_LETTER_GEN_STATUSES	Associations between letter types and possible status type changes.
PER_LETTER_REQUESTS	Requests for specific types of standard letter.
PER_LETTER_REQUEST_LINES	Details of individual letter requests.
PER_LETTER_TYPES	Letter types and auto-request definitions.
PER_MASS_MOVES	High level mass move definition.
PER_MEDICAL_ASSESSMENTS	Hold Medical Assessment information for one person
PER_MM_ASSIGNMENTS	PER_MM_ASSIGNMENTS holds assignments that were defined as part of a mass move.
PER_MM_JOB_REQUIREMENTS	PER_MM_JOB_REQUIREMENTS holds data related to transferring position requirements to a newly created position.
PER_MM_POSITIONS	PER_MM_POSITIONS holds positions that were defined as part of a mass move.
PER_MM_VALID_GRADES	PER_MM_VALID_GRADES holds valid grades that will be moved with a position during a mass move.
PER_NL_ABSENCE_ACTIONS	Dutch Specific Absence Actions
PER_NL_ABSENCE_CHANGES	Dutch Specific Absence Changes
PER_NL_ASG_SCL_UPGRADE	Records the Dutch Assignment SCL Context Information Migrated used by the Report
PER_NUMBER_GENERATION_CONTROLS	PER_NUMBER_GENERATION_CONTROLS holds the numbers that are automatically generated for a Business Group.
PER_OBJECTIVES	A target or goal which may be evaluated during an appraisal.
PER_ORGANIZATION_LIST	List of organizations that a secure user can access.
PER_ORGANIZATION_STRUCTURES	Organization hierarchy names.
PER_ORG_STRUCTURE_ELEMENTS	Organization hierarchy details showing parent-child reporting relationships between organizations.
PER_ORG_STRUCTURE_VERSIONS	Version control information for specific organization hierarchies.
PER_PARENT_SPINES	Details of pay scales, (previously known as parent spines).
PER_PARTICIPANTS	A person participating in an appraisal or assessment.
PER_PAY_BASES	Definitions of specific salary bases.
PER_PAY_PROPOSALS	Salary proposals and performance review information for employee assignments.
PER_PAY_PROPOSALS_EFC	This is a copy of the PER_PAY_PROPOSALS  table which is populated by the EFC (Euro as Functional Currency) process.
PER_PAY_PROPOSAL_COMPONENTS	Component details of a pay proposal for an employee assignment.
PER_PAY_PROPOSAL_COMPONENT_EFC	This is a copy of the PER_PAY_PROPOSAL_COMPONENT  table which is populated by the EFC (Euro as Functional Currency) process.
PER_PAY_PROPOSAL_COMPONENT_EFC
PER_PEOPLE_EXTRA_INFO	Extra information for a person.
PER_PEOPLE_INFO_TYPES	The table holds the definitions of extra information types that may be held against a person.
PER_PERFORMANCE_RATINGS	A single evaluation of an objective.
PER_PERFORMANCE_REVIEWS	Performance review information for employees.
PER_PERIODS_OF_PLACEMENT	Periods of placement details for a non-payrolled worker
PER_PERIODS_OF_SERVICE	Period of service details for an employee.
PER_PERIODS_OF_SERVICE_EFC	This is a copy of the PER_PERIODS_OF_SERVICE table which is populated by the EFC (Euro as Functional Currency) process.
PER_PERSON_ANALYSES	Special information types for a person.
PER_PERSON_DLVRY_METHODS	The communication delivery method for a person.
PER_PERSON_LIST	List of people that a secure user can access.
PER_PERSON_LIST_CHANGES	List of people that are to be added to current PER_PERSON_LIST.
PER_PERSON_LIST_CHG_ARCH	Archive table to hold content of PER_PERSON_LIST_CHANGES on upgrade.
PER_PERSON_TYPES	Person types visible to specific Business Groups.
PER_PERSON_TYPES_TL	Translated person types information.
PER_PERSON_TYPE_USAGES_F	Identifies the types a person may be.
PER_PHONES	PER_PHONES holds phone numbers for current and ex-employees, current and ex-applicants and employee contacts.
PER_POSITION_DEFINITIONS	Combinations of segments stored in the PER_POSTIONS table.
PER_POSITION_EXTRA_INFO	Extra information for a position.
PER_POSITION_INFO_TYPES	Types of extra information that may be held against a position.
PER_POSITION_LIST	List of positions that a secure user can access.
PER_POSITION_STRUCTURES	Position Hierarchy names.
PER_POS_STRUCTURE_ELEMENTS	Position hierarchy details showing parent-child reporting relationships between positions.
PER_POS_STRUCTURE_VERSIONS	Version control information for specific position hierarchies.
PER_PREVIOUS_EMPLOYERS
PER_PREVIOUS_JOBS	Used to store Previous Jobs
PER_PREVIOUS_JOB_EXTRA_INFO	Previous Jobs extra info
PER_PREVIOUS_JOB_INFO_TYPES	Used to store previous job info types
PER_PREVIOUS_JOB_USAGES	Used to store previous job Usages
PER_PREV_JOB_EXTRA_INFO	Previous Jobs extra info
PER_PREV_JOB_INFO_TYPES	Used to store previous job info types
PER_PROPOSAL_CATEGORY_MEMBERS	Web Offers profile categories of questions
PER_PROPOSAL_CATEGORY_TYPES	Generic web offer category definitions
PER_PROPOSAL_OFFER_PARAGRAPHS	Web Offer letter text
PER_PROPOSAL_QUESTIONS_ADV	Web Offer advanced questions
PER_PROPOSAL_QUESTION_MEMBERS	Web offer profile questions
PER_PROPOSAL_QUESTION_TYPES	Generic web offer questions
PER_PROPOSAL_TEMPLATES	- Retrofitted
PER_PTU_DFF_MAPPING_HEADERS	Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.
PER_PTU_DFF_MAPPING_LINES	Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.
PER_PTU_DFF_MIG_FAILED_PEOPLE	This table is used to store the details of the person records failed to migrate to PER_PERSON_TYPE_USAGES_F from PER_ALL_PEOPLE_F.
PER_QUALIFICATIONS	A record of educational qualification, certificates, licenses, etc that a person holds or is acquiring.
PER_QUALIFICATIONS_EFC	This is a copy of the PER_QUALIFICATIONS  table which is populated by the EFC (Euro as Functional Currency) process.
PER_QUALIFICATIONS_TL	Translated qualification details.
PER_QUALIFICATION_TYPES	Maintains the list of qualiification types that can be attained.
PER_QUALIFICATION_TYPES_TL	Maintains the list of qualiification type translations
PER_QUERY_CRITERIA	Used to store criteria to build up a query
PER_QUICKPAINT_INVOCATIONS	Identifies QuickPaint report runs.
PER_QUICKPAINT_RESULT_TEXT	Text description for the result of a single QuickPaint run.
PER_RATING_LEVELS	A rating scale step is a single point on a rating scale and is used to rate competences.
PER_RATING_LEVELS_TL	A rating scale step is a single point on a rating scale and is used to rate competences.
PER_RATING_SCALES	A scale used to rate compentencies.
PER_RATING_SCALES_TL	Translated rating scale name and description.
PER_RECRUITMENT_ACTIVITIES	Recruitment activities and costs.
PER_RECRUITMENT_ACTIVITIES_EFC	This is a copy of the PER_RECRUITMENT_ACTIVITIES  table which is populated by the EFC (Euro as Functional Currency) process.
PER_RECRUITMENT_ACTIVITY_FOR	Vacancies associated with a specific recruitment activity.
PER_REQUISITIONS	Vacancy requisition details.
PER_RI_DEPENDENCIES	Dependencies among Workbench tasks
PER_RI_REQUESTS	Concurrent requests for workbench componenets
PER_RI_SETUP_SUB_TASKS	Workbench setup sub-tasks
PER_RI_SETUP_SUB_TASKS_TL	TL table for PER_RI_SETUP_SUB_TASKS
PER_RI_SETUP_TASKS	Workbench Setup Tasks
PER_RI_SETUP_TASKS_TL	TL table for PER_RI_SETUP_TASKS table
PER_RI_VIEW_REPORTS	Stores data related to view reports for HRMS
PER_RI_VIEW_REPORTS_TL	Workbench View Reports Translation Table
PER_RI_WORKBENCH_ITEMS	Workbench items
PER_RI_WORKBENCH_ITEMS_TL	Translation table for Per_ri_workbench_items
PER_ROLES	Holds the different roles that a person performs.
PER_SALARY_SURVEYS	Market salary survey information.
PER_SALARY_SURVEY_LINES	Details for market salary surveys.
PER_SALARY_SURVEY_LINES_EFC	This is a copy of the PER_SALARY_SURVEY_LINES  table which is populated by the EFC (Euro as Functional Currency) process.
PER_SALARY_SURVEY_MAPPINGS	Mapping information for a salary survey line.
PER_SCHED_COBRA_PAYMENTS	Payment schedules for benefits provided by a COBRA coverage.
PER_SECONDARY_ASS_STATUSES	Secondary assignment statuses used for information and reporting.
PER_SECURITY_ORGANIZATIONS	List of organizations to include or exclude from security list
PER_SECURITY_PROFILES	Security profile definitions to restrict user access to specific HRMS records.
PER_SECURITY_USERS	List of users for a security profile whose access permissions will be stored in static lists duringSecurity List Maintenance.
PER_SEC_PROFILE_ASSIGNMENTS	Security profile assignments for User, Responsibility and Business Group.
PER_SHARED_TYPES	Holds 'type' and 'status' information.
PER_SHARED_TYPES_TL	Translated information for shared types.
PER_SPECIAL_INFO_TYPES	Special information types available to a Business Group.
PER_SPECIAL_INFO_TYPE_USAGES	Limits usage of special information types to specific windows.
PER_SPINAL_POINTS	List of progression points in a pay scale.
PER_SPINAL_POINT_PLACEMENTS_F	Details of assignment placements to a grade step and point.
PER_SPINAL_POINT_STEPS_F	Grade steps defined in a specific grade scale and their incremental order.
PER_STANDARD_HOLIDAYS	Statutory Holiday information.
PER_STARTUP_PERSON_TYPES_TL	Predefined list of translated person types.
PER_STD_HOLIDAY_ABSENCES	Records when Statutory Holidays are taken.
PER_SUBJECTS_TAKEN	Holds a record of a person's subject usages for a qualification
PER_SUBJECTS_TAKEN_TL	Translated grade_attained.
PER_SUCCESSION_PLANNING	The record of a person's proposed succession to a position.
PER_TIME_PERIODS	Time period definitions for payroll processing and HR budget calendars.
PER_TIME_PERIOD_RULES	Rules for time periods used by the system.
PER_TIME_PERIOD_SETS	Specific dates for a defined calendar.
PER_TIME_PERIOD_TYPES	Predefined list of valid period types for payroll and HR budget calendars.
PER_TIME_PERIOD_TYPES_TL	Predefined list of translated period types for payroll and HR budget calendars.
PER_US_INVAL_ADDRESSES	Temporary table used to hold invalid addresses.
PER_US_INVAL_LOCATIONS	Temporary table used to hold invalid location addresses.
PER_VALID_GRADES	Lists valid grades for jobs and positions.
PER_WORK_INCIDENTS	Holds information on Incidents that happen at work or en route to work, for example, an industrial accident
PER_WORK_INCIDENTS_EFC	This is a copy of the PER_WORK_INCIDENTS  table which is populated by the EFC (Euro as Functional Currency) process.
PER_ZA_AREAS_OF_ASSESSMENT	Table to store the Areas of assessment per NQF Assessment
PER_ZA_ASSESSMENTS	Table to store the NQF Assessment info for a person
PER_ZA_EMPLOYMENT_EQUITY	Temporary table for Employment Equity Reporting
PER_ZA_FORMAL_QUALIFICATIONS	Table to store additional NQF Qualification info for a person
PER_ZA_LEARNERSHIP_AGREEMENTS	Table to store the NQF learnership agreement info between a person and the organization
PER_ZA_QUALIFICATION_TYPES	Table to link qualification types (titles) to NQF qualification types
PER_ZA_TRAINING	Table to store NQF Training info for a person

Irecruitment Interview Question 1

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 type of user does iRecruitment support?

iRecruitment supports the following types of users:

Site visitor: 

A user who accesses the external web site but does not create an account.

Registered user: 

A user who registers on your web site and provides a minimum amount of personal information. When an external visitor registers in iRecruitment, iRecruitment creates an Oracle HRMS user with the e-mail address as the username.

Employee: 

A user who can apply to internal job postings, perform employee referral, and interview tasks. 

Manager or recruiter: 

A user who can access the entire functionality. Using iRecruitment, managers or recruiters can:

• Post and manage vacancies
• Process candidates and applicants
• Manage recruitment communication
• Create and manager offers
• Create and manage interviews

You must assign the iRecruitment Manager and iRecruitment Recruiter responsibilities to your managers or recruiters to enable them to access iRecruitment using their standard self-service login.

Agency user: 

An external person who belongs to a recruiting agency and accesses iRecruitment to conduct recruiting activities such as creating candidates and applying on behalf of candidates. You  assign the iRecruitment Agency responsibility to agency users to enable them to access iRecruitment.

Is a HR Professional User Interface delivered with iRecruitment?

You need Oracle HRMS to hold work structure information that is used in iRecruitment. An HR responsibility - iRecruitment HRMS Manager, is supplied to customers who do not have the complete Oracle HRMS application. Using this responsibility they can access all the HR functionality they require to run iRecruitment.

Can I migrate legacy data into iRecruitment?

Yes. You can migrate data such as candidate information and vacancy details to the iRecruitment system. You can also import other data such as qualifications and competencies. To load your legacy data to the Oracle database, use Application Programming Interfaces (APIs).

What are the security features of Oracle iRecruitment?

You can define user profiles, security profiles, responsibilities, and menu structures to control who uses iRecruitment. You can create security profiles to control manager access to vacancy information. Managers can set up vacancy security to define who has access to vacancy details.

Do we define users for iRecruitment candidates?

When an external site visitor registers in iRecruitment, an Oracle HRMS user is automatically created using the visitor's e-mail address as the username. The iRecruitment External Candidate responsibility is assigned to the user.

Can I use personalization options in iRecruitment?

Yes. Since iRecruitment uses the standard OA Framework, you can use all of the personalization options. To enable administration-level personalizations you need to set the profile options that are available for personalization as required:

• Personalize Self–Service Defn
• Disable Self–Service Personal

Can I modify flexfields that are available on the iRecruitment web pages?

You can use Personlization Framework, a component of the Oracle Applications (OA) Framework technology to customize pages and flexfields. You can restrict the display of the whole flexfield, or certain segments of a flexfield.

Can I configure the existing notifications in iRecruitment?

A number of predefined notifications are supplied with iRecruitment. For example, candidates can receive notifications about matching jobs and new vacancies. Managers can receive notifications about the status of the vacancy that they have created. They get a vacancy approval notification if the vacancy is approved. You can use the Application Developer responsibility and the Messages window to edit the contents of the notification messages.

How to set up the pages for user and agency in iRecruitment?

• Create a contact in Enter and Maintain screen
• Create Agency Responsibility
• Create end user
• Assign Agency responsibility and Contact to the user

Can I use iRecruitment to meet country-specific recruitment requirements?

Yes. iRecruitment supports localization level personalization. You can use this feature to meet legislative or country-specific recruitment requirements. For example, you can hide the gender field in the Enter Applicant Details page at the localization level to conform to the legal requirements of a specific country.


Does iRecruitment support the approval process for vacancies and job offers?

Yes. You can set up an approval process to route vacancies and offers to appropriate managers for approval.


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.


How do I ensure that the offer letters follow our enterprise branding and HR policy standards?

You can use offer letter templates or standard descriptions to create offer letters for your business group, organization, jobs, or positions.


How does iRecruitment help my enterprise work with agencies to manage the recruitment process?

Enterprises can use agencies functionality to manage a range of recruitment activities. Agencies can register their candidates with iRecruitment and apply for jobs on their behalf. Enterprises can process agency candidates to fill job openings or hand over the complete placement process to an agency.


Is the candidate data secure when the enterprise works with multiple agencies using iRecruitment?

Yes. Agencies can view data only of their candidates and cannot access details of candidates who are self-registered or from other agencies. For example, agencies can view details of the candidates that they themselves registered or candidates associated with their agencies by managers.


Can I validate the email addresses candidates supply when they register?

You can set up a business event to send an e-mail to candidates when they register, instructing them to reply to the e-mail to confirm that their e-mail address is correct. This enables you to confirm if the candidates have supplied valid e-mail addresses. You can then use Application Programmatic Interfaces (APIs) to delete records of candidates who do not respond within a certain time period.


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.


What is High Availability?

When you shut down the iRecruitment instance to carry out maintenance tasks, your job site is not available for candidates to search and apply for jobs. You can use the iRecruitment High Availability functionality to set up an alternate or high availability instance to make the basic candidate job site available. This functionality enables you to switch between the two instances to continuously support the candidate job site.

Payroll Interview Questions 3

List of some Important Tables in HRMS

• Per_all_people_F,
• per_person_types,
• per_person_type_usages,
• per_addresses,
• Per_all_assignments_f,
• per_jobs,
• per_job_Definitions,
• per_grades,
• per_grade_definitions,
• hr_all_positions,
• hr_all_position_definitions,
• hr_all_locations,
• pay_all_payrolls_F,
• pay_element_entries_F,
• pay_elements_links_F,

What is the difference between both SECURED VIEWS and NON SECURED VIEWS?

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

Define APIs and use in Oracle HRMS?

API’s are used in HR to insert the data into the Base tables. As it’s very secured system, the user does not have 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, without which the process won’t complete. Generally 

when we use API we give data FOR : Object Version Number, Effective Date, P_Validate

HR_EMOYEE_api 

Example: hr_employee_api.create_employee

hr_organization_api 

Example: hr_organization_api.create_organization

hr_assignment_api

What are processing types of element?

Elements are nothing but the components of the salary.

For Example: Basic Salary, House Allowance, Transport Earning, Bonus, Loan Recovery etc.

There are 2 types of Processing

1. Recurring: if an entry of this element applies in every period until the entry is ended

2. Non Recurring: if an entry applies in one pay period only.

What are termination roles of an element?

Termination Rules of an Element:

a).Actual Termination:  For a nonrecurring element, select Actual Termination if you want the entries to close down at the end of the pay period in which the employee leaves.

b).Final Close: if you want the entries to stay open beyond the employee's leaving date so that you can continue to pay the employee.

c).The Last Standard Process date defaults to the last day of the pay period in which the employee is terminated, but you can set it to a later period when you terminate an employee.

What is costing?

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.

Can you call PL/SQL Package functions from within a Fast Formula?

Yes you can

How do we do this?

There is a Define Function screen in HR. In this screen you will register the PL/SQL as “External Function”.

Can we want to pass a parameter PAYROLL_ID to this external PL/SQL Function, how do we do it?

The “Define Function” screen has a button named “Context Usage”. This button opens up a window in which you can register the parameters.

How do you debug a Fast Formula?

You can create a message variable in Fast Formula.

This message variable must also be registered as a Formula Result ( In “Formula Result Rule” window).

What are the various levels where you can Set up Payroll Costing Accounts? Which levels take the highest precedence?

Element Entry => Highest

Assignment => Second Highest

Organization => Third Highest

Element Link => Fourth Highest

Payroll => Fifth Highest

Technically speaking, how do you know from tables that an Employee has been terminated?

(a) The Person_Type_ID in PER_PERSON_TYPE_USAGES_F will correspond to System Person Type EX_EMP

(b) A record gets created in table PER_PERIODS_OF_SERVICE with Actual_Termination_date being not null

How can you make Employee Number generation Automated based on business rule etc?

Use Fast Formula.

What is the difference between per_people_f and per_all_people_f?

 PER_PEOPLE_F is a secured view on top of PER_ALL_PEOPLE_F. The secure view uses an API hr_security.show_person. This API internally checks for an entry in table PER_PERSON_LIST for the logged in person’s security profile. A concurrent program named “Security List Maintainence program” will insert records in PER_PERSON_LIST.

If you do personalization at both FUNCTION level and Responsibility level, which personalization has higher precedence?

Responsibility level. Responsibility level will override FUNCTION level personalization’s.

Say you have done a lot of Personalization’s to Self Service Screens. But all these Personalization’s were done in DEVELOPMENT environment. How will you migrate these personalization’s to PRODUCTION environment?

Before 11.5.7…Use AKLOAD

This is a java program given by Oracle. This is the only way you can script it.

In DEV you will do AKLOAD DOWNLOAD ( & other parameters)

In PRD you will do AKLOAD UPLOAD ( & other parameters)

On or after 11.5.10 Use responsibility “Functional Administrator”, then click

on Personalization Tab, and then click on Import/Export.

Next select the documents to be exported.

Go to the UNIX box and tar the personalization’s into a .tar file.

On the Production environment unzip this tar file in location as entered in profile “FND: Personalization Document Root Path”.

Setting up of this profile is mandatory or else Oracle Framework wouldn’t know where to search for the files to be imported.

How many types of payrolls are there? 

Payroll Period Types Periods per Year

Year 1

Semi-Year 2

Quarter 4

Bi-Month 6

Calendar Month 12

Lunar Month 13

Semi-Month 24

Bi-Week 26

Week 52

Value Sets Interview Questions

What is a valueset?

Value Set as the name specifies refers to a set of values. These vales can be used to validate the values entered in a felx-field segment, concurrent program parameters and report parameters.


Why do we need value sets?

You do not always want a user to enter junk free text into all the fields. Hence, Oracle Apps uses value set to validate that correct data is being entered in the fields in screen.


Is value set attached to all the fields that require validations?

A big NO


Then where lies the usage of value sets?

Broadly speaking, value sets are attached to segments in Flexfields. You can argue that value sets are also attached to parameters of concurrent program(but in reality oracle treats parameters as Descriptive Flexfields)


When to define Values for Value Sets

• After you register your Flexfields & report parameters, if you are using independent or dependent value sets, you can enter values into each corresponding value set using the Segment Values form.
• Values for the Value Sets, we are defining will be kept in the Oracle Application Object Library tables.

What are the main details entered in the valueset?

• Name
• List Type
• Security Type
• Format Type
• Maximum size
• Precision
• Validation type

What are different list types?

• Pop-List : When the number of items is between 1-10
• List of Values : When the number of items is between 10-100
• Long List of Values : When the number of items is more then 200

What are different security types?

• No Securtiy: No security is enabled for the value set
• Hierarchical Security: Security rule applied to the parent is automatically applied to the child values
• Non-Hierarchical Security: Security rule applied to the parent is not applied to the child values

How many Format Types the value set have?

• Character
• Number
• Time
• Standard Date, Standard Date Time
• Date, Date Time

How many Character Formatting Options have for value set?

 Numbers Only (0–9)

• We cannot prevent users from entering a value that contains the radix character.
• Cannot be used in Translatable Independent and Translatable Dependent value sets.

Uppercase Only

• Here also we cannot use in Translatable Independent and Translatable Dependent value sets.

 Right–justify and Zero–fill Numbers

• If you have selected Numbers Only (0–9) flag, then it wont allow you to affect this flag.
• We are recommended to use this in Accounting Flex fields.

Minimum and Maximum Value Range

• Your Minimum/maximum value may not be longer than the maximum size you specify for this value set.
• Once you specify a range of values, you cannot define a new valid value that falls outside this range.
• The Minimum Value and Maximum Value fields can therefore allow you to create a value set with a validation type of None.

What are different validation types?
Or
Different types of Value sets?


Validation Type: Refers to the type of validation applied when values are entered for the fields associated with the value set.

• None : The values entered is not validated against any pre-defined set of values , the values is only validated against the format type specified.
• Independent : The value entered is validated against a pre-defined set of values
• Dependent : The value is validated against a set of values which depend on an independent value set .
• Special: values set uses a flex field itself.
• Pair : two flex fields together specify a range of valid values.
• Translatable independent : input must exist on previously defined list
• of values; translated values can be used.
• Translatable dependent : input is checked against a subset of values
• based on a prior values; translated value can be used.

Payroll Interview Questions 2

What are Reversal and Retry?

Reversal can be used to correct run results for one assignment after post-run actions have already occurred. Retry is for correcting mistakes after a payroll process finishes.

Which elements you link openly in Payroll?

Worker’s Compensation and Vertex (Vertex is a third party software to calculate US Canadian taxes) using Quantum files. (It is part of Vertex software which will be updated as and when the tax and legal rules are changed by the US/Canadian Government. So we keep getting the Vertex patches to bring Quantum files with the up to date tax rules and conditions)

What is Consolidation Set, Element Set & Assignment Set?

Consolidation Set: A grouping of payroll runs within the same time period for which one can schedule reporting, costing, and post-run processing.

Element Set: Grouping of all individual elements into one set.

Suppose you want to define a special type of payment and make this available only to employees who work at a particular location. In Oracle HRMS you use a compensation element to represent the payment. You define the business rule as a link between the element and the specific location. Then when you assign employees to the location, they automatically become eligible for the payment.

Assignment Set: Grouping of assignments for retro pay is generally referred to as Assignment Set.

What are Fast Formulas?

Fast formulas are pseudo codes used in the payroll for validating the entry values, assignment sets and element sets.

Post Payroll Process

Three concurrent processes will run in the Post-Payroll process, viz.

1. Pre-payment Process

2. Costing Process &

3. Transfer to GL Process

What do you mean by Garnishments?

Third Party payments is also known as Wage Attachments, Wage Garnishments and Court orders in different localizations. 3rd party payments are deductions from earnings incurred by Court debts or fines. For example, payment of maintenance, child support or other legally incurred obligations.

What is BACS, NACHA?

BACS: Banks Automated Clearing System. This is the UK system for making direct deposit payments to employees.

NACHA: National Automated Clearing House Association. This is the US system for making direct deposit payments to employees.

Does Oracle Payroll enable you to run part payrolls?

Yes, Oracle Payroll enables you to run part payrolls. This is useful in each of the following circumstances where you do not want to process a payroll for the entire organization.

Calculating Pay for an Individual Employee

If an employee leaves the company before the end of a payroll period, you will need to calculate the individual pay entitlement. You may also want to calculate individual pay to check the details for an employee before starting a payroll run for all employees.

Can you verify that a payroll run has completed successfully?

On completion of a payroll run you will need to verify that the run completed successfully. You can display run messages and view latest balances and assignment level results. You may also need to have relevant information grouped by topic in report format so that you can review the outcome of processing.

Can you make adjustments after a payroll run has completed?

Oracle Payroll enables you to make each of the following types of adjustment when a payroll run has completed.

• Addition of late entries that were not included in the initial run
• Corrections to details that were wrongly entered in the initial run
• Retrospective distribution of current payments to the period in which they were earned

When you have made these corrections and modifications you can then run the payroll again. However, you do not need to rerun the entire payroll. Oracle Payroll will only reprocess those items that were incorrect in the initial run.

Can you produce payment and costing information from a completed payroll run?

Oracle Payroll enables you to use the results of a payroll run to allocate payments to your employees, and to provide costing information.

Ensuring that Employees are paid by the Correct Payment Method

When a payroll run has completed you need to pay each employee according to the payment methods that you have specified. You may also need to override the predefined payment methods where employees are receiving special payments such as bonuses, which may not be paid by the usual methods of payment.

Ensuring that Costing Information can be provided

On completion of a payroll run you may need to distribute the associated costs across particular cost centres. Oracle supports this using the Cost Analysis module.

Can you run payroll processes and reports multi-lingually?

Payroll processes and reports are always submitted and always run in the local language only. This means that US and UK payroll reports can only be run in English.

Can you verify that payments have been made?

Yes. Oracle Payroll is fully integrated with Oracle Cash Management. This enables you to use Oracle Cash Management to verify that payments have been cashed. Reconciliation can be applied to payroll checks (cheques) and third party checks. You can identify which checks have been cleared and the date on which they were cleared. You can also view a reconciliation report which shows if voided checks appear to have been cashed.