Technical Interview Questions and Answers :: Oracle Apps HRMS
Home > Technical Interview Q&A > Oracle Apps HRMS > Q & A
Accenture (161)
Adobe (2)
Alcatel-Lucent (1)
Broadcom Ltd (1)
Wipro (86)
Virtusa (220)
IBM (35)
Aricent (47)
Tech Mahindra (13)
TCS (171)
Capgemini (33)
iGate (162)
Syntel Inc. (175)
AT&T (1)
Cisco (107)
Sapient (72)
Sopra Steria (138)
Societe Generale (75)
Goldman Sachs (5)
TCS NQT (7)
Huawei (11)
Wipro NLTH (36)
Paytm (67)
# C (123)
# C++ (187)
# DBMS (143)
# Soft. Engineering (77)
# Python (4)
# Finite Automata (6)
# SQL (108)
# Java (66)
# .NET (112)
# WebMethod (166)
# EDI (40)
# Informatica (94)
# Oracle Apps HRMS (106)
# Operating System (91)
# Data Structure (72)
# PHP (1)
# Unica (0)
# Oracle Apex (0)
# HR Question in TR (122)
# Networking (62)
# Hadoop (2)
# HTML (1)
# Oracle PLSQL (31)
# DPDK (Data Plane Development Kit) (40)
# Programming Qs. in TR (14)
- Define a request group, lets say with name "XX_PO_PROGS"
- Add these two concurrent programs to the request group "XX_PO_PROGS"
- Define a new Form Function that is attached to Form "Run Reports"
- In the parameter field of Form Function screen, enter REQUEST_GROUP_CODE="XX_PO_PROGS"REQUEST_GROUP_APPL_SHORT_NAME="XXPO" TITLE="XXPO:XX_PO_PROGS".
- Attach this form function to the desired menu.
61 / 106
|
|
|
Answer:
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.
Please Login First :
62 / 106
|
|
|
Answer:
Rule Based Optimization (RBO) is no longer supported in Oracle 10g.
Please Login First :
63 / 106
|
|
|
Answer:
Yes, Oracle does support partitioning of tables in Oracle Applications. There are several implementations that partition on GL_BALANCES. However clients 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 can be 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).
Please Login First :
64 / 106
|
|
|
Answer:
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, or on the status of the GL Period.
Please Login First :
65 / 106
|
|
|
Answer:
If your Oracle Applications instance is on 10g, then you can decide to run stats for SYS schema. This can be done by exec dbms_stats.gather_schema_stats('SYS');
Alternately using command dbms_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.
Alternately using command dbms_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.
Please Login First :
66 / 106
|
|
|
Answer:
No we can not use Concurrent program "Gather Schema Statics:". Instead we can your "usedbms_job".
Note: "Gather Schema Statistics" has no parameters for SYS schema.
Please Login First :
67 / 106
|
|
|
Answer:
GL_IMPORT_REFERENCES
Please Login First :
68 / 106
|
|
|
Answer:
If this profile option is set to a value of external against a server, then it signifies that the specific mid-tier is External i.e. it will be exposed to the www.
In other words this server is not within the firewall of your client. The idea behind this profile option is to flag such middle-tier so that special restrictions can be applied against its security, which means a very restricted set of responsibilities will be available from such Middle-Tier.
Please Login First :
69 / 106
|
|
|
Answer:
In order to make a responsibility accessible from an external web tier, you must set profile option "Responsibility Trust Level" at responsibility level to "External". Only those responsibilities that have this profile option against them will be accessible from External Middle tiers.
Please Login First :
70 / 106
|
|
|
Answer:
Please Login First :