Technical Interview Questions In Oracle Apps Hrms.pdf 4z284v

Technical Interview Questions in Oracle Apps HRMS - 4 1. 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. 2. Key Flexfields (KFFs) in HRMS =>Job KFF, =>Grade KFF, =>People Group KFF, =>Position KFF, => Cost Allocation KFF, => Competence KFF 3.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 4. 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 5. 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 6. APIs in HRMS API are used in HR to insert the data into the Base tables. As its very secured system, the 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 7. 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 Posted by Hussain Jaff at 2:45 AM No comments: Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: 17 September 2006, Written by Anil i Sunday

Technical Interview Questions in Oracle Apps HRMS - III Technical Interview Questions in Oracle Apps III

Written by Anil i Sunday, 17 September 2006 Question: How will you migrate Oracle General Ledger Currencies and Sets of Books Definitions fromone environment to another without reKeying? Will you use FNDLOAD? Answer: FNDLOAD can not be used in the scenario. You can use migrator available in "Oracle iSetup" Responsibility

Question: This is a very tough one, almost impossible to answer, but yet I will ask. Which Form in Oracle Applications has most number of Form Functions? Answer: "Run Reports". And why not, the Form Function for this screen has a parameter to which we name of the

"Request Group", hence securing the list of Concurrent Programs that are visible in "Run Request" Form. Just so that you know, there are over 600 form functions for "Run Reports"

Question: Which responsibility do you need to extract Self Service Personalizations? Answer:Functional Question: Can you list any one single limitation of Forms Personalization feature that was delivered with 11.5.10 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.

Question: You have just created two concurrent programs namely "XX PO Prog1" & "XX PO Prog2". 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? Answer: 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, enter REQUEST_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. Question: Does Oracle 10g rule based optimization? Answer: The official stance is that RBO is no longer ed by 10g. Question: Does oracle partitioning of tables in Oracle Apps? Answer: Yes, Oracle does 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 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). Question: What will be your partitioning strategy on GL_BALANCES? Your views please? 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. Question: Does Oracle running of gather stats on SYS schema in Oracle Apps? 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. Question: Can you use concurrent program "Gather Schema Statistics" to gather stats on sys schema in oracle apps? Answer: No, "Gather Schema Statistics" has no parameters for SYS schema. Please use dbms_job.

Question: Which table is used to provide drill down from Oracle GL into sub-ledger? Answer: GL_IMPORT_REFERENCES Question: What is the significance of profile option “Node Trust Level” in Oracle Apps. 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. Question: What is the significance of profile option “Responsibility Trust Level”. 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. Question: What else can you suggest to restrict the access to screens from external web tiers? Answer: You may use URL filtering within Apache. Question: What is the role of Document Manager in Oracle Purchasing? Answer: POXCON is an immediate concurrent program. It receives pipe signal from the application when a request is made for approval/reservations/receipts. Question: How to debug a document manager in Oracle Apps? Answer: Document manger runs within the concurrent manager in Oracle Applications. When an application uses a Document Manager, it sends a pipe signal which is picked up by the document manager. There are two mechanisms by which to trace the document manager 1. Set the debugging on by using profile option STEP 1. Set profile option "Concurrent:Debug Flags" to TCTM1 This profile should only generate debugs when set at Site level(I think, as I have only tried site), because Document Manager runs in a different session. STEP 2. Bounce the Document Managers STEP 3. Retry the Workflow to generate debugs. STEP 4. Reset profile option "Concurrent:Debug Flags" to blank STEP 5. have a look at debug information in table fnd_concurrent_debug_info 2. Enable tracing for the document managers This can be done by setting profile option “Initialization SQL Statement – Custom” against your name before reproducing the issue. The value of this profile will be set so as to enable trace using event 10046, level 12. Question: 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. Answer: In the options field of the concurrent program you can enter something similar to below. - :/home/xxvisiondev/XXDEVDB/comn/java/appsborg.zip:/home/xxvisiondev/XXDEVDB/comn/java Question: How will you open a bc4j package in jdeveloper? Answer: Oracle ships a file named server.xml with each bc4j package. You will need to ftp that file alongside other bc4j objects(VO’s, EO’s, AM, Classes etc). Opening the server.xml will load the complete package starting from AM(application module). This is a mandatory step when building Extensions to framework. Question: In OA Framework Self-Service screen, you wish to disable a tab. How will you do it? Answer: Generally speaking, the tabs on a OA Framework page are nothing but the SubMenus. By entering menu exclusion against the responsibility, you can remove the tab from self service page. Question: In self service, you wish to change the background color and the foreground text of the OA Framework screens to meet your corporate standards. How will you do it? Answer: You will need to do the below steps a….Go to Mid Tier, and open $OA_HTML/cabo/styles/custom.xss b…Enter below text( change colours as needed) <style name="DarkBackground"> <property name="background-color">#000066 <style name="TextForeground"> <property name="color">#0000FF c… cd $OA_HTML/cabo/styles/cache d…Take a backup of all the css files.

e…Delete all the files of following pattern oracle-desktop*.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 file if found missing for your browser. Question: Can you extend and substitue a root AM ( Application Module) in OA Framework using JDeveloper. Answer: You can extend the AM in jDeveloper, but it doesn’t work( at least it didn’t work in 11.5.9). I am hopeful that Oracle will deliver a solution to this in the future. Question: In a workflow notification, you have a free text response field where the enters the Vendor Number for the new vendor. You want to validate the value entered in the notification response field upon the submission of a response. How will you do it? Answer: You will need to attach a post notification function to the Workflow Notification. The PL/SQL code will look similar to below:The below code will display an error in the notification when attempts to create a Duplicate Vendor Number.

PROCEDURE validate_response_from_notif ( itemtype IN VARCHAR2 ,itemkey IN VARCHAR2 ,actid IN NUMBER ,funcmode IN VARCHAR2 ,RESULT IN OUT VARCHAR2 ) IS l_nid NUMBER; l_activity_result_code VARCHAR2(200); v_newly_entered_vendor_num VARCHAR2(50); CURSOR c_get_response_for_new_vendor IS SELECT wl.lookup_code FROM wf_notification_attributes wna ,wf_notifications wn ,wf_message_attributes_vl wma ,wf_lookups wl WHERE wna.notification_id = l_nid AND wna.notification_id = wn.notification_id AND wn.message_name = wma.message_name AND wn.message_type = wma.message_type AND wna.NAME = wma.NAME AND wma.SUBTYPE = 'RESPOND' AND wma.format = wl.lookup_type AND wna.text_value = wl.lookup_code AND wma.TYPE = 'LOOKUP' AND decode(wma.NAME, 'RESULT', 'RESULT', 'NORESULT') = 'RESULT'; BEGIN IF (funcmode IN ('RESPOND')) THEN l_nid := wf_engine.context_nid; OPEN c_get_response_for_new_vendor; FETCH c_get_response_for_new_vendor INTO l_activity_result_code; CLOSE c_get_response_for_new_vendor; v_newly_entered_vendor_num := wf_notification.getattrtext(l_nid,'NEWLY_ENTERED_VENDOR_NUM_4_PO'); IF l_activity_result_code = 'NEW_VENDOR' AND does_vendor_exist(p_vendor => v_newly_entered_vendor_num) THEN RESULT := 'ERROR: VendorNumber you entered already exists'; RETURN; END IF; END IF; EXCEPTION WHEN OTHERS THEN RESULT := SQLERRM; END validate_response_from_notif; Question: How to make concurrent program end with warning? Answer: 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 = pContext.getReqCompletion(); lRC.setCompletion(ReqCompletion.WARNING, "WARNING"); Question: How do you link a Host type concurrent program to Concurrent Manager? Answer: Assuming your executable script is LOADPO.prog, then use the commands below

cd $XXPO_TOP/bin ln -s $FND_TOP/bin/fndesr $XXPO_TOP/bin/LOADPO

Question: How do you know if a specific Oracle patch has been applied in apps to your environment. Answer: Use table ad_bugs, in which column bug_number is the patch number.

SELECT bug_number ,to_char(creation_date, 'DD-MON-YYYY HH24:MI:SS') dated FROM apps.ad_bugs WHERE bug_number = TRIM('&bug_number') ;

Question: How do you send a particular Oracle Apps Workflow Activity/Function within a workflow process into background mode. Answer: 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. Question: What are the various ways to kick-off a workflow Answer: You can eiter use wf_engine.start_process or you can attach a runnable process such ghat it subscribes to a workflow event. Question: 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 ,' '); 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. Question: On 10g, how will you use awr? Answer: By running below scripts. These are both the same scripts, but with differing parameters.

$ORACLE_HOME/rdbms//awrrpt.sql $ORACLE_HOME/rdbms//awrrpti.sql

Question : How will you configure Apache to run in Debug mode, specifically usefull when debugging iProcurement ( prior to 11.5.10). Answer: 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

Question: How will you add a new column to a List Of Values ( LOV ) in Oracle Applications Framework? Can this be done without customization? Answer: 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 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.

Question: Can you do fnd_request.submit_request from SQL Plus in Oracle? Answer: You will need to initialize the global variables first using fnd_global.initialize

DECLARE v_session_id INTEGER := env('sessionid') ; BEGIN fnd_global.initialize ( SESSION_ID => v_session_id ,_ID => ,RESP_ID => ,RESP_APPL_ID => ,SECURITY_GROUP_ID => 0 ,SITE_ID => NULL ,_ID => 3115003--Any number here ,CONC__ID => NULL ,PROG_APPL_ID => NULL ,CONC_PROGRAM_ID => NULL ,CONC_REQUEST_ID => NULL ,CONC_PRIORITY_REQUEST => NULL ); commit ; END ; / Optionally you may use fnd_global.apps_initialize, which internally calls fnd_global.initialize

fnd_global.apps_initialize(_id => :_id, resp_id => :resp_id, resp_appl_id => :resp_appl_id, security_group_id => :security_group_id, server_id => :server_id);

By doing the above, your

Posted by Hussain Jaff at 2:41 AM No comments: Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest

Technical Interview Questions in Oracle Apps HRMS - II ORACLE HRMS Interview Questions and answers - ii Question:What are the minimum classifications to create a Business Group? (i) Business Group (ii) GRE/Legal Entity (iii) HR Organization Question: What are the Pre-Requisites for creating a Business Group? (i) Value Sets (ii) Key Flex fields (iii) Location Question: What is the use of HR Organization? If we want to assign the employee information to a Business Group then we need to have HR Organization classification under a Business Group. Question: What is People Group? (i) It is a Flexible area for holding -defined assignment data. (ii) Data can be used for grouping sets of assignment together. (iii) People group can be used for Element eligibility. (iv) This information is used by the Payroll Run. (v) The data will be held in PAY_PEOPLE_GROUPS. (vi) GROUP_NAME field holds the concatenation of Segment data. Question: What is the KFF structure for SIT? Personal Analysis Flexfields. Question: What is the DFF structure for EIT? (i) Extra Person Information (ii) Assignment Extra Information

(iii) Extra Location Information (iv) Extra Position Information (v) Extra Job Information (vi) Organization Developer DF Question: How to enable EIT? Switch Responsibility to ‘Human Resources, Vision Enterprises’ Double click on ‘Security’ Click on ‘Information Types’ Create your own ‘Information Types’ under your ‘Responsibility Name’. Question: How to enable SIT? Switch Responsibility to ‘Human Resources, Vision Enterprises’ Double click on ‘Other Definitions’ Click on ‘Special Information Types’ Question: 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. Question: What is the use of Object Version Number? 1) It is used to capture the latest record from the data base table. 2) When a row is inserted its number is set to 1. 3) If any updates performed on the row then the OVN is incremented. 4) Every API has the OVN parameter. 5) For create API this parameter is defined as an OUT parameter. 6) For update API this parameter is defined as an IN OUT parameter. 7) The APIs use it to check a row has been updated by another , to prevent overwriting their changes. Question: What is the Element? It is a Data Structure which is used to hold information for both Human Resources and Payroll. In Human Resources elements may represents compensation types including Earnings such as Salary, Hourly Wages and Bonuses. In Payroll, elements constitute all the items in the Payroll run process. Question: What are the Classification Priorities? (i) Information (ii) Non-Payroll (iii) Earnings (iv) Pre-Tax Deductions (v) Tax Deductions (vi) Employer Tax (vii) Voluntary Deductions (viii) In Voluntary Deductions Question: What the Element can represent? Earnings --> such as Salary, Wages & Bonuses Benefits --> such as employee stock & pension plans Non-Payroll items --> such as Expenses Absences from work Voluntary and In-Voluntary deductions Employer Taxes and other Liabilities. Question: What are the pre-defined Elements? UK Payroll legislation provides many predefined elements --Tax --National Insurance (Employee/Employer) --Court Orders These Elements cannot be modified. Question: What are the Element Entry Concepts? Recurring à Recurring Entries can exists over many Payroll periods Non-Recurring à Non-Recurring Entries are valid for single Payroll period only.

Question: What are the types of Element Entry? There are four types Normal Entry Override Entry Additional Entry Adjustment Entry --Additive Adjustment --Replacement Adjustment --Balance Adjustment Question: How can we add a new input value to an existing Element? We can add an additional input values to an existing Element if the element has not been processed in a Payroll run and the Effective data is the same date of creation of the Element. Question: What is the use of ID_FLEX_NUM? It is used to define the Structure Definition. The Structure Definition is held in FND_ID_FLEX_STRUCTURES The Structure Segment Definition is held in FND_ID_FLEX_SEGMENTS Question: What is the Element Link? Links identify one or more assignment components that must be included in an employee's assignment for them to be eligible.Elements can, but they don’t have to, be linked by: Organization GroupJob PositionGrade LocationEmployment Category (i.e., Fulltime-Regular, Part-time-Regular) Payroll Salary Basis Question: What is API? Ø API is packaged procedure which can be used as an entry point into Application. Ø The advantage of using an API is we can enter new information or alter the existing data without manual enters the information into the Application. Ø APIs allow s to maintain HRMS information without using Oracle Application forms. Question: How do i use an API to the data? Ø API package contains many procedures to insert/update/delete the application data. Ø The API is not executed on its own, the API must be called or executed by other pl/sql program. Ø The API package should never be modified for custom use, if modified Oracle will not be able to them. Ø None of the HRMS APIs issue commit, the calling module should manage the commit of the transaction. Question: How do i identify the Package name and version of the API? SELECT text FROM all_source WHERE name like ‘HR_EMPLOYEE_API%’ AND text LIKE ‘%Header%’; Question: Where can i find information on an API and its parameters? Review the package header file for the particular API file (.pkh). Question: What is Object version number and how do I assign values for it in an API? Ø Object Version number is an assigned number to a row in a database table. Ø When a new row inserted its number is set to 1 Ø If any updates performed on the row then the Object version number is incremented. Ø Every API has the p_object_version_number control parameters. Ø For create APIs this parameter is defined as an OUT parameter the API assigns the Object version number to be 1 for row inserts. Ø For update APIs the parameter is defined as IN OUT, for update API the object version number is mandatory. Question: When the HR_7155_OBJECT_LOCKED raised? The current value of object_version_number must be ed in the API call and it is compared to the version on the row in the table. If the versions are different then the HR_7155_OBJECT_LOCKED is raised. Question: What is the p_validate control parameter? Every API has a p_validate control parameter. When the parameter is set to FALSE then all the business function validation is performed. If every thing is validated then row can be inserted/updated/deleted. If p_validate is set to TRUE then only the actual operation is validated. A savepoint is issued at the start of the call and a rollback is done at the end of the call. Can I use an API on an application table on which an event-based alert is defined? Ø No, if an event-based alert defined on an application table then the API will give error. Ø To run API the alert has to be disabled and re-enabled after the API has been executed.

Question: What is the difference between an API and a publicly callable API? Ø An API is an alternative entry for data to be insert/update/delete from the application. Ø The Oracle HRMS Ø Publicly callable APIs engage in validation in the same manner as the forms do with in the application. Ø Validation is performed in of data integrity, insuring that data relationship exist properly between related tables. Ø Validation is also performed against business functionality as the application form would enforce it. Ø Therefore, only p Posted by Hussain Jaff at 2:38 AM No comments: Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest

Technical Interview Questions in Oracle Apps HRMS - I Technical Interview Questions in Oracle Apps HRMS Question: How will you migrate Oracle General Ledger Currencies and Sets of Books Definitions fromone environment to another without reKeying? Will you use FNDLOAD? Answer: FNDLOAD can not be used in the scenario. You can use migrator available in "OracleiSetup" Responsibility Question: 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? Answer: "Run Reports". And why not, the Form Function for this screen has a parameter towhich we 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" Question: Which responsibility do you need to extract Self Service Personalizations? Answer: Functional Question: Can you list any one single limitation of Forms Personalization feature that was delivered with 11.5.10 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. Question: 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? Answer: 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:X X_PO_PROGS" e) Attach this form function to the desired menu. Question: Does Oracle 10g rule based optimization? Answer: The official stance is that RBO is no longer ed by 10g. Question: Does oracle partitioning of tables in Oracle Apps? Answer: Yes, Oracle does 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). Question: What will be your partitioning strategy on GL_BALANCES? Your views please? 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, oron the status of the GL Period. Question: Does Oracle running of gather stats on SYS schema in Oracle Apps? Answer: 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.

Question: Can you use concurrent program "Gather Schema Statistics" to gather stats on sysschema in oracle apps? Answer: No, "Gather Schema Statistics" has no parameters for SYS schema. Please usedbms_job. Question: Which table is used to provide drill down from Oracle GL into sub-ledger? Answer: GL_IMPORT_REFERENCES Question: in Oracle Apps. Answer: 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. Question: What is the significance of profile option â Answer: In order to make a responsibility accessible from an external web tier, you must setprofile option “Res ponsibility Trust at r esponsibility level those responsibilities that have this profile option against them will beaccessible from ExternalMiddle tiers. Question: What else can you suggest to restrict the access to screens from external web tiers? Answer: You may use URL filtering within Apache. Question: What is the role of Document Manager in Oracle Purchasing? Answer: POXCON is an immediate concurrent program. It receives pipe signal from theapplication when a request is made for approval/reservations/receipts.