Oracle Apps Interview Questions
1. How will you open a bc4j package in jdeveloper?
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.
2. In OA Framework Self-Service screen, you wish to disable a tab. How will you do it?
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.
3.Can you extend and substitue a root AM ( Application Module) in OA Framework using J Developer?
You can extend the AM in j Developer, 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.
4.How will you add a new column to a List Of Values ( LOV ) in Oracle Applications Framework? Can this be done without customization?
Yes, this can be done without customization, i.e. by using OA Framework Extension coupled with Personalization. Implement the following Steps :-
a) Extend the VO ( View Object ), to implement the new SQL required to support the LOV.
b) Substitute the base VO, by using jpximport [ similar to as explained in Link ]
c) Personalize the LOV Region, by clicking on Add New Item. While adding the new Item, you will cross reference the newly added column to VO.
5.You have written a piece of code in POR_CUSTOM_PKG for Oracle Procurement, but its not taking any effect? What may be the reason?
Depending upon which procedure in POR_CUSTOM_PKG has been programmed, one or more of the below profile options must be set to Yes.
POR: Enable Req Header Customization
POR: Enable Requisition Line Customization
POR: Enable Req Distribution Customization
6.In OA Framework, once your application has been extended by substitutions, is it possible to revert back to remove those substitutions?
Yes, by setting profile option ?Disable Self-Service Personal%? to yes, keeping in mind that all your personalizations will get disabled by this profile option. This profile is also very useful when debugging your OA Framework based application in the event of some error. By disabling the personalization via profile, you can isolate the error, i.e. is being caused by your extension/substitution code or by Oracle?s standard functionality.
7.How do you setup a context sensitive flexfield?
Note: I will publish a white paper to sho step by step approach. But for the purpose of your interview, a brief explanation is?a)Create a reference field, b) Use that reference field in ?Context Field? section of DFF Segment screen c) For each possible value of the context field, you will need to create one record in section ?Context Field Value? ( beneath the global data elements).
8.Give me one example of securing attributes in i Procurement?
You can define Realm to bundle suppliers into a Category. Such realm can then be assigned to the User using Define User Screen. Security Attribute ICX_POR_REALM_ID can be used. By doing so, the user will only be made visible those Punchout suppliers that belong to the realm against their securing attributes.
9.How does substitution work in OA Framework? What are the benefits of using Substitution in OA Framework?
Based on the user that has logged into OA Framework, MDS defines the context of the logged in user. Based upon this logged in context, all applicable personalization are applied by MDS. Given that substitutions are loaded as site level personalizations, MDS applies the substituted BC4J objects along with the Personalizations. The above listed steps occur as soon as Root Application module has been loaded.
The benefit of using Substitution is to extend the OA Framework without customization of the underlying code. This is of great help during Upgrades. Entity Objects and Validation Objects can be substituted. I think Root AM?s can?t be substituted given that substitution kicks off after Root AM gets loaded.
10.Does oracle support partitioning of tables in Oracle Apps?
Yes, Oracle does support partitioning of tables in Oracle Applications. There are several implementations that partition on GL_BALANCES. However your client must buy licenses to if they desire to partition tables. To avoid the cost of licensing you may suggest the clients may decide to permanently close their older GL Periods, such that historical records can be archived.
11.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?
“Run Reports”. And why not, the Form Function for this screen has a parameter to which we pass 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”
12.Can you list any one single limitation of Forms Personalization feature that was delivered with 11.5.10?
You can not implement interactive messages, i.e. a message will give multiple options for Response. The best you can get from Forms Personalization to do is popup up Message with OK option.
13.Does Oracle 10g support rule based optimization?
The official stance is that RBO is no longer supported by 10g.