Interview Questions.

Q1. What Are List Types?

List kinds are:

List of Values

Long listing of Values

Pop listing

Q2. How To Restrict The Users To See The Payroll Data Employee Wise, They Only Can Setup The Basic Elements And Pay Bonuses But Cannot See The Gross Salaries Of Employees?

Define taskflow in your screen

Define the Profile scurity for his worker

Q3. What Are Six Validation Types?

Validation kinds:

Dependent

Independent

None

Pair

Special

Table

Q4. Which Table Is Used To Provide Drill Down From Oracle Gl Into Sub-ledger?

GL_IMPORT_REFERENCES

Q5. What Is The Role Of Document Manager In Oracle Purchasing?

POXCON is a direct concurrent program. It gets pipe signal from the utility whilst a request is made for approval/reservations/receipts.

Q6. You Have Written A Java Concurrent Program In Oracle Apps. You Want To Modify The Classpath Such That New Class Classpath Is Effective Just For This Program?

 In the options area of the concurrent software you could enter some thing just like under.

-cp <your custom lib pathused by Java Conc Prog> :/domestic/xxvisiondev/XXDEVDB/comn/java/appsborg. Zip:/home/xxvisiondev/XXDEVDB/comn/java

Q7. Can You Do Fnd_request.Submit_request From Sql Plus In Oracle?

 You will want to initialize the global variables first using fnd_global.Initialize

DECLARE

v_session_id INTEGER := userenv(‘sessionid’) ;

BEGIN

fnd_global.Initialize

(

SESSION_ID        =>    v_session_id

,USER_ID                =>    <your user id from fnd_user.User_id>zero

,SITE_ID                =>    NULL

,LOGIN_ID               =>    3115003–Any quantity right here

,CONC_LOGIN_ID          =>    NULL

,PROG_APPL_ID           =>    NULL

,CONC_PROGRAM_ID        =>    NULL

,CONC_REQUEST_ID        =>    NULL

,CONC_PRIORITY_REQUEST  =>    NULL

) ;

devote ;

END ;

/

Optionally you can use fnd_global.Apps_initialize, which internally calls fnd_global.Initialize

  fnd_global.Apps_initialize(user_id => :user_id,

resp_id => :resp_id,

resp_appl_id => :resp_appl_id,

security_group_id => :security_group_id,

server_id => :server_id);

Q8. In Oa Framework Self-carrier Screen, You Wish To Disable A Tab. How Will You Do It?

Generally talking, the tabs on a OA Framework page are nothing but the SubMenus. By entering menu exclusion towards the obligation, you can get rid of the tab from self provider page.

In self carrier, you wish to trade the history color and the foreground text of the OA

Q9. How Will You Configure Apache To Run In Debug Mode, Specifically Usefull When Debugging Iprocurement ( Prior To eleven.5.10)?

After 11.5.10, FND Logging  can be used for debugging Oracle iProcurement.

Prior to eleven.5.10

 —-STEPS IN A NUTSHELL—–

cd $ORACLE_HOME/../iAS/Apache

vi $ORACLE_HOME/../iAS/Apache/Jserv/and many others/ssp_init.Txt

DebugOutput=/home/<<SID>>/ora9/iAS/Apache/Apache/logs/debug.Log

DebugLevel=5

DebugSwitch=ON

vi $ORACLE_HOME/../iAS/Apache/Jserv/and so forth/jserv.Conf

ApJServLogLevel debug

vi $ORACLE_HOME/../iAS/Apache/Jserv/and so on/jserv.Properties

log=real

Q10. How Do You Send A Particular Oracle Apps Workflow Activity/feature Within A Workflow Process Into Background Mode?

If price of the workflow interest is more than 50, then the workflow interest could be processed in historical past mode most effective, and it received’t be processed in on line mode.

Q11. Can We Name Certain Dffs (description Flexfiled) And Their Location?

Yes we are able to name sure DFF’s and their place.

Q12. What Else Can You Suggest To Restrict The Access To Screens From External Web Tiers?

You may use URL filtering inside Apache.

Q13. What Are Core Flexfield?

Core flexfields are:

Job

Position

Grade

Competency

Q14. 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.Whilst Starting (kicking Off

 if beginning the method using start_process, do the underneath

               wf_engine.Threshold := -1;

               wf_engine.Createprocess(l_itemtype

               ,l_itemkey

               ,'<YOUR PROCESS NAME>’);

                wf_engine.Startprocess(l_itemtype, l_itemkey)

When beginning the workflow system thru an event subscription, set the Execution Condition Phase to be equal to or above a hundred for it to be executed via historical past system.

Q15. What Is The Significance Of Profile Option Responsibility Trust Level?

In order to make a duty on hand from an external web tier, you must setprofile alternative Responsibility Trust Level at responsibility degree to External. Onlythose responsibilities which have this profile option in opposition to them will beaccessible from ExternalMiddle tiers.

Q16. What Is Element Entry? What Is The Purpose Of Element Entry?

Element access is to outline detail yet here enter this is Earning detail or deduction detail then calculate internet pay.

Q17. How Do You Know If A Specific Oracle Patch Has Been Applied In Apps To Your Environment?

Use desk ad_bugs, wherein column bug_number is the patch variety.

SELECT bug_number

,to_char(creation_date, ‘DD-MON-YYYY HH24:MI:SS’) dated

FROM   apps.Ad_bugs

WHERE  bug_number = TRIM(‘&bug_number’) ;

Q18. 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 will be done with out customization, i.E. By means of using OA Framework Extension coupled with Personalization.

Implement the following Steps :-

Extend the VO ( View Object ), to implement the new SQL required to assist the LOV.

Substitute the base VO, by way of the usage of jpximport [ similar to as explained in LINK ]

Personalize the LOV Region, by way of clicking on Add New Item. While including the brand new Item, you'll move reference the newly delivered column to VO.

Q19. What Is The Significance Of Profile Option Node Trust Level In Oracle Apps?

If this profile alternative is set to a cost of outside against a server, then it indicates thatthe precise mid-tier is External i.E. It will be exposed to the www. In different phrases this server isnot in the firewall of your purchaser. The idea at the back of this profile alternative is to flag such middle-tierso that unique restrictions may be implemented against its security, which me a completely constrained setof obligations can be to be had from such Middle-Tier.

Q20. What Will Be Your Partitioning Strategy On Gl_balances? Your Views Please?

This certainly relies upon upon what number of periods are regularly reported upon, how many intervals are left open and so on. You can then determine to partition on period_name, or length levels, oron the status of the GL Period.

Q21. How Do You Link A Host Type Concurrent Program To Concurrent Manager?

Assuming your executable script is LOADPO.Prog, then use the commands under

cd $XXPO_TOP/bin

ln -s $FND_TOP/bin/fndcpesr $XXPO_TOP/bin/LOADPO

Q22. How To Debug A Document Manager In Oracle Apps?

Document manger runs in the concurrent manager in Oracle Applications.  When an utility uses a Document Manager, it sends a pipe sign that is picked up by using the file manager.

There are  mechanisms through which to trace the record supervisor

Set the debugging on by using the use of profile alternative

STEP @Set profile option “Concurrent:Debug Flags” to TCTM1

This profile have to handiest generate debugs whilst set at Site level(I think, as I even have only attempted website), because Document Manager runs     in a extraordinary session.

STEP @Bounce the Document Managers

STEP @Retry the Workflow to generate debugs.

STEP @Reset profile option “Concurrent:Debug Flags” to clean

STEP @have a have a look at debug information in table fnd_concurrent_debug_info

Enable tracing for the document managers

This can be accomplished via setting profile choice “Initialization SQL Statement – Custom” towards your username earlier than reproducing the issue. The fee of this profile will be set for you to enable trace the usage of occasion 10046, level 12.

Q23. What Is Costing?

Costing: Recording the expenses of an mission for accounting or reporting functions. Using Oracle Payroll, you could calculate and trfer costing records in your widespread ledger and into systems for project management or labor distribution.

Q24. How To Make Concurrent Program End With Warning?

If the concurrent application is of kind PL/SQL, you can assign a fee of 1 to the “retcode” OUT Parameter.

For a Java Concurrent program, use the code similar to below

ReqCompletion lRC;

//get manage on request finishing touch item for reporting status

lRC = pCpContext.GetReqCompletion();

lRC.SetCompletion(ReqCompletion.WARNING, “WARNING”);

Q25. What Are Costing Types?

Costing kinds are:

Fixed costed

Costed

Distributed

Q26. Which Responsibility Do You Need To Extract Self Service Personalizations?

Functional Administrator.

Q27. How Will You Migrate Oracle General Ledger Currencies And Sets Of Books Definitions From One Environment To Another Without Rekeying? Will You Use Fndload?

FNDLOAD cannot be used within the situation. You can use migrator to be had in “OracleiSetup” Responsibility

Q28. Does Oracle 10g Support Rule Based Optimization?

The reputable stance is that RBO is now not supported by using 10g.

Q29. Does Oracle Support Partitioning Of Tables In Oracle Apps?

Yes, Oracle does aid partitioning of tables in Oracle Applications. There are numerous implementations that partition on GL_BALANCES. However your purchaser need to buy licenses to in the event that they preference to partition tables. To keep away from the fee of licensing you can recommend the clients might also determine to permanently close their older GL Periods, such that historical facts canbe archived. Note: Before walking the archival process the second one time, you must clean down the archive table GL_ARCHIVE_BALANCES (don’t forget to export archive statistics to a tape).

Q30. Does Oracle Support Running Of Gather States On Sys Schema In Oracle Apps?

If your Oracle Applications instance is on 10g, then you could determine to run stats forSYS schema. This may be performed by using exec dbms_stats.Gather_schema_stats(‘SYS’);Alternately the use of commanddbms_stats.Gather_schema_stats(‘SYS’,cascade=>TRUE,diploma=>20);I will pick the former with default values.If you desire to delete the stats for SYS use exec dbms_stats.Delete_schema_stats(‘SYS’);You can agenda a dbms_job for walking stats for SYS schema.

Q31. What Are Processing Types Of Element?

Elements are not anything but the components of the profits.

Eg. Basic, HRA, TA, BONUS, Lo and so forth., There are 2 kinds of Processing

Recurring: if an entry of this element applies in each length until the entry is ended

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

Q32. 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 no longer, the Form Function for this display has a parameter towhich we pass name of the “Request Group”, as a result securing the listing of Concurrent Programsthat are seen in “Run Request” Form. Just so you recognize, there are over 600 form functionsfor “Run Reports”

Q33. How Will You Open A Bc4j Package In Jdeveloper?

Oracle ships a record named server.Xml with every bc4j package deal. You will want to ftp that file along different bc4j objects(VO’s, EO’s, AM, Classes and many others).

Opening the server.Xml will load the complete package deal starting from AM(utility module). This is a mandatory step when building Extensions to framework.

Q34. What Are Two Modes Of Date Track And What Is Date Track?

Date Track modes are:

Update

Correction

Q35. On 10g, How Will You Use Awr?

By walking under scripts. These are both the equal scripts, however with differing parameters.

$ORACLE_HOME/rdbms/admin/awrrpt.Square

$ORACLE_HOME/rdbms/admin/awrrpti.Square

Q36. Can You List Any One Single Limitation Of Forms Personalization Feature That Was Delivered With 11.Five.10?

You can't put in force interactive messages, i.E. A message will supply a couple of alternatives for Response. The fine you can get from Forms Personalization to do is popup up Message with OK option.

Q37. What Are Basic Set Ups Of Oracle Hrms?

In oracle HRMS there are such a lot of modules like Core HR, Payroll, Self Service HR, Oracle studying management, iRecruitment, Time and Labour, Compensation Work bench, Oracle Advanced Benefits, Performance Management System and so forth., Core HR and System Administrator are the Heart of Oracle HRMS.

All basic set u.S.Will do in Core HR with the assist of System Administrator.

In gadget administrator we can create all the Users and Responsibilities, Flex fields, Profile values and so forth., In center HR we can create Organizations, Locations, Jobs, Positions, Grades, Organization Hierarchy, function Hierarchy, We will create all the personnel also. These are the Basic setups in HRMS.

Q38. Framework Screens To Meet Your Corporate Standards. How Will You Do It?

You will need to do the below steps:

Go to Mid Tier, and open $OA_HTML/cabo/patterns/custom.Xss

Enter underneath textual content( exchange hues as needed)

<style name=”DarkBackground”>

<property name=”background-color”>#000066</property>

</style>

<style name=”TextForeground”>

<property name=”color”>#0000FF</property>

</style>

cd $OA_HTML/cabo/styles/cache

Take a backup of all of the css files.

Delete all of the documents of following pattern oracle-laptop*.Css

The idea here is to delete the cache. Next time when you logon to Oracle Apps Self Service, the Framework will rebuild the css record if located lacking for your browser.

Q39. Can You Extend And Substitute A Root Am ( Application Module) In Oa Framework Using Jdeveloper?

You can enlarge the AM in jDeveloper, but it doesn’t work( as a minimum it didn’t work in 11.Five.Nine).

Q40. What Are Termination Roles Of An Element?

Termination Rules of an Element:

Actual Termination: For a nonrecurring detail, choose Actual Termination if you need the entries to close down at the give up of the pay period wherein the worker leaves.

Final Close: in case you need the entries to stay open past the employee’s leaving date so that you can hold to pay the worker.

The Last Standard Process date defaults to the last day of the pay period wherein the worker is terminated, however you can set it to a later length while you terminate an worker.