InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 151. |
Explain The Process Of Extracting Data From Source Systems, Storing In Ods And How Data Modelling Is Done? |
|
Answer» There are VARIOUS ways of Extracting Data from Source Systems. For example , You can use a DATA step, an Import Process. It depends with your input data STYLES. What kind of File/database it is residing in. Storing ur data in an ODS can be DONE thru an ODS STMT/export stmt/FILE stmt, again which depends on the file & data FORMAT,You want your output to be in. There are various ways of Extracting Data from Source Systems. For example , You can use a DATA step, an Import Process. It depends with your input data styles. What kind of File/database it is residing in. Storing ur data in an ODS can be done thru an ODS stmt/export stmt/FILE stmt, again which depends on the file & data format,You want your output to be in. |
|
| 152. |
Can We Use Procedural Logic Inside Infromatica? If Yes How, If Now How Can We Use External Procedural Logic In Informatica? |
|
Answer» Yes, you can USE advanced external TRANSFORMATION. for more DETAIL you can refer the manual of informatica transformation guide in that ADVANCE external transformation. You can use c++ language on unix and c++, VB vc++ on windows server. Yes, you can use advanced external transformation. for more detail you can refer the manual of informatica transformation guide in that advance external transformation. You can use c++ language on unix and c++, vb vc++ on windows server. |
|
| 153. |
What Are Autonomous Transactions? Give A Scenario Where You Have Used Autonomous Transaction In Your Reports? |
|
Answer» An autonomous TRANSACTION is an independent transaction started by another transaction, the main transaction. Autonomous transactions let you suspend the main transaction, do SQL operations, commit or roll BACK those operations, then resume the main transaction. Once started, an autonomous transaction is fully independent. It shares no LOCKS, resources, or commit-dependencies with the main transaction. So, you can log events, increment retry counters, and so on, even if the main transaction rolls back. More important, autonomous transactions HELP you build modular, reusable software components. For example, stored procedures can start and finish autonomous transactions on their own. A calling application need not know about a procedure's autonomous operations, and the procedure need not know about the application's transaction context. That makes autonomous transactions less error-prone than regular transactions and easier to use. An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions let you suspend the main transaction, do SQL operations, commit or roll back those operations, then resume the main transaction. Once started, an autonomous transaction is fully independent. It shares no locks, resources, or commit-dependencies with the main transaction. So, you can log events, increment retry counters, and so on, even if the main transaction rolls back. More important, autonomous transactions help you build modular, reusable software components. For example, stored procedures can start and finish autonomous transactions on their own. A calling application need not know about a procedure's autonomous operations, and the procedure need not know about the application's transaction context. That makes autonomous transactions less error-prone than regular transactions and easier to use. |
|
| 154. |
What Is A Flexfield? What Are Descriptive And Key Flexfields? |
|
Answer» An Oracle Applications field made up of segments. Each SEGMENT has an ASSIGNED name and a set of valid values. Oracle Applications uses flexfields to CAPTURE INFORMATION about your organization. An Oracle Applications field made up of segments. Each segment has an assigned name and a set of valid values. Oracle Applications uses flexfields to capture information about your organization. |
|
| 155. |
What Is Record Group? |
|
Answer» Record group are used with LOVS to hold sql QUERY for your list of values. The record group can contain static data as WELL it can access data from database tables through sql QUERIES. Record group are used with LOVs to hold sql query for your list of values. The record group can contain static data as well it can access data from database tables through sql queries. |
|
| 156. |
What Is The Use Of Cursors In Pl/sql? What Is Ref Cursor? |
|
Answer» The cursor is used to handle MULTIPLE row query in PL/SQL. ORACLE uses implicit cursors to handle all its queries. Oracle uses unnamed memory spaces to store data used in implicit cursors, with REF cursors you can define a cursor VARIABLE which will point to that memory SPACE and can be used like POINTERS in our 3GLs. The cursor is used to handle multiple row query in PL/SQL. Oracle uses implicit cursors to handle all its queries. Oracle uses unnamed memory spaces to store data used in implicit cursors, with REF cursors you can define a cursor variable which will point to that memory space and can be used like pointers in our 3GLs. |
|
| 157. |
How To Attach Reports In Oracle Applications? |
|
Answer» The steps are as follows:
The steps are as follows: |
|
| 158. |
What Is The Minimum Number Of Groups Required For A Matrix Report? |
|
Answer» The minimum of GROUPS REQUIRED for a matrix REPORT are 4. The minimum of groups required for a matrix report are 4. |
|
| 159. |
What Is A Lexical Parameter? |
|
Answer» Lexical PARAMETER is USED to REPLACE the where, ORDER by ………conditions at run time. Lexical Parameter is used to replace the where, order by ………conditions at run time. |
|
| 160. |
What Is The Firing Sequence Of Report Trigger? |
|
Answer» First the before parameter trigger will RAISE, after firing this trigger parameter form will displayed, after passing parameter after parameter trigger will fire query will parsed & then before report trigger will FIRED then if there are number of pages in your report then the between pages trigger will fired but it will fire between first & second & so on pages but it will not fired in reverse CONDITION the after report trigger will fire after closing the run time parameter form is CLOSED. First the before parameter trigger will raise, after firing this trigger parameter form will displayed, after passing parameter after parameter trigger will fire query will parsed & then before report trigger will fired then if there are number of pages in your report then the between pages trigger will fired but it will fire between first & second & so on pages but it will not fired in reverse condition the after report trigger will fire after closing the run time parameter form is closed. |
|
| 161. |
What Is The Lock Option In Reports Layout? |
|
Answer» By using the LOCK option we cannot move the fields in the layout EDITOR outside the FRAME. This is USEFUL for maintaining the fields. By using the lock option we cannot move the fields in the layout editor outside the frame. This is useful for maintaining the fields. |
|
| 162. |
Can You Send Blob Attachments Via Workflow Notifications? |
|
Answer» YES, you can SEND BLOB ATTACHMENTS. Yes, you can send BLOB Attachments. |
|
| 163. |
Give Me One Example Of Securing Attributes In Iprocurement? |
|
Answer» 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. 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. |
|
| 164. |
Give Me One Example Where Apps Uses Partitioning? |
|
Answer» WF_LOCAL_ROLES. WF_LOCAL_ROLES. |
|
| 165. |
Tell Me Some Limitations Of Forms Personalization When Compared To Custom.pll? |
|
Answer» -->Can't create RECORD group queries, HENCE can’t implement LOV Query changes. -->Can't create record group queries, hence can’t implement LOV Query changes. |
|
| 166. |
What Are The Key Benefits Of Forms Personalization Over Custom.pll? |
|
Answer» -->Multiple users can DEVELOP forms personalization at any GIVEN point in time. -->Multiple users can develop forms personalization at any given point in time. |
|
| 167. |
How Would You Know If The Purchase Order Xml Has Been Transmitted To Vendor, Looking At The Tables? |
|
Answer» The XML delivery status can be FOUND from a table named ecx_oxta_logmsg. Use the query below SELECT edoc.document_number, DECODE(eol.result_code, 1000,'Success','Failure')AS status, eol. result_ text FROM ecx_oxta_ logmsg eol, ecx_ doclogs edoc, ecx_ outbound_ LOGS eog WHERE edoc. msgid = eol. sender_ message_ id AND eog. out_ msgid = edoc. msgid ORDER BY edoc. document_ numberThe XML delivery status can be found from a table named ecx_oxta_logmsg. Use the query below |
|
| 168. |
Are Suppliers A Part Of Tca? |
|
Answer» Unfortunately not YET. However, RELEASE 12 will be merging Suppliers into TCA. Unfortunately not yet. However, Release 12 will be merging Suppliers into TCA. |
|
| 169. |
Does Oracle Iprocurement Use Same Tables As Oracle Purchasing? |
|
Answer» Yes, iProcurement USES the same SET of requisition tables as are USED by CORE PURCHASING. Yes, iProcurement uses the same set of requisition tables as are used by Core Purchasing. |
|
| 170. |
How Can You Import Invoices Into Oracle Receivables? |
|
Answer» You can either use AutoInvoice by populating tables RA_ INTERFACE_ LINES_ ALL, RA_ INTERFACE _ DISTRIBUTIONS _ALL & RA_ INTERFACE_ SALESCREDITS_ ALL. ALTERNATELY you may decide to use API ar_ invoice_ api_ pub.create_ single_ invoice for Receivables Invoice Import. You can either use AutoInvoice by populating tables RA_ INTERFACE_ LINES_ ALL, RA_ INTERFACE _ DISTRIBUTIONS _ALL & RA_ INTERFACE_ SALESCREDITS_ ALL. Alternately you may decide to use API ar_ invoice_ api_ pub.create_ single_ invoice for Receivables Invoice Import. |
|
| 171. |
In A Oracle Report Data Group, You Have A "data Link" Between Two Queries. How Do You Ensure That The Data Link Is Made Outer Joined? |
|
Answer» The DATA LINK is an OUTER JOIN by DEFAULT. The data link is an Outer Join by default. |
|
| 172. |
In Oracle Oa Framework, Is The Mds Page/document Definition Stored In Database Or In The File System? |
|
Answer» The MDS document DETAILS are loaded into DATABASE, in the following SETS of TABLES. JDR_ATTRIBUTES The Document is loaded via XMLImporter. The MDS document details are loaded into database, in the following sets of tables. JDR_ATTRIBUTES The Document is loaded via XMLImporter. |
|
| 173. |
If You Wish To Trigger Of An Update Or Insert In Bespoke Table Or Take Some Action In Response To A Tca Record Being Created Or Modified, How Would You Do It? Will You Write A Database Triggers On Tca Tables? |
|
Answer» There are various pre-defined Events that are invoked from the Oracle TCA API’s. TCA was Oracle’s FIRST initiative towards a fully API based approach, which means the screen and the PROCESSES all use the same SET of APIs for doing same task. In order to take an action when these events OCCUR, you can subscribe a custom PL/SQL procedure or a Custom Workflow to these events. Some of the important TCA events are listed below:- oracle.apps.ar.hz.ContactPoint.update There are various pre-defined Events that are invoked from the Oracle TCA API’s. TCA was Oracle’s first initiative towards a fully API based approach, which means the screen and the processes all use the same set of APIs for doing same task. In order to take an action when these events occur, you can subscribe a custom PL/SQL procedure or a Custom Workflow to these events. Some of the important TCA events are listed below:- oracle.apps.ar.hz.ContactPoint.update |
|
| 174. |
What Is The Best Way To Add Debugging To The Code In Apps? |
|
Answer» Use fnd_log.string , i.e. FND Logging. Behind the scenes Oracles FND Logging USES autonomous transaction to insert RECORDS in a table named fnd_log_messages. For EXAMPLE DECLARE BEGIN fnd_log.STRING(log_level => fnd_log.level_statement ,module=>'xxxx '||'pkg/procedurename ' ,message=>'your debug message here'); END ; Three profile options effecting FND Logging are FND: Debug Log MODE.FND: Debug Log ENABLED. FND: Debug Log Module.
Use fnd_log.string , i.e. FND Logging. Behind the scenes Oracles FND Logging uses autonomous transaction to insert records in a table named fnd_log_messages. For example
|
|
| 175. |
For A Pl/sql Based Concurrent Program Do You Have To Issue A Commit At The End? |
|
Answer» The CONCURRENT program RUNS WITHIN its own new session. In APPS, the default database setting ENFORCES a commit at the end of each session. Hence no explicit COMMIT is required. The concurrent program runs within its own new session. In APPS, the default database setting enforces a commit at the end of each session. Hence no explicit COMMIT is required. |
|
| 176. |
What Are The Settings Needed For Printing Bitmap Reports? |
|
Answer» GET your DBA to CONFIGURE TWO files i.e. uiprint.txt & default. PPD. Get your DBA to configure two files i.e. uiprint.txt & default. ppd. |
|
| 177. |
Does Oracle Grants Use Its Own Schema Or Does It Uses Oracle Project Accounting Schema? |
|
Answer» Although Oracle Grants has its own schema i.e. GMS, it reuses MANY of the TABLES with in Oracle Projects Schema LIKE PA_ PROJECTS_ ALL, PA_ EXPENDITURE_ ITEMS_ ALL, PA_ EXPENDITURE_ TYPES etc. Although Oracle Grants has its own schema i.e. GMS, it reuses many of the tables with in Oracle Projects Schema like PA_ PROJECTS_ ALL, PA_ EXPENDITURE_ ITEMS_ ALL, PA_ EXPENDITURE_ TYPES etc. |
|
| 178. |
Does Oracle Have A Test Environment On Exchange? |
|
Answer» HTTP://testexchange.oracle.com. http://testexchange.oracle.com. |
|
| 179. |
What Is The Key Benefit Of Punching Out To Suppliers Catalogs Rather Than Loading Their Catalogs Locally In Oracle Iprocurement? |
|
Answer» Punchout has several advantages like, Catalogs don’t need to be LOADED locally saves space on your system. You can GET up-to-date list of catalogs by PUNCHING out and ALSO you get the benefit of up-to-date pricing INFORMATION on vendor items. Punchout has several advantages like, Catalogs don’t need to be loaded locally saves space on your system. You can get up-to-date list of catalogs by punching out and also you get the benefit of up-to-date pricing information on vendor items. |
|
| 180. |
You Have Written A Piece Of Code In Por_custom_pkg For Oracle Iprocurement, But Its Not Taking Any Effect? What May Be The Reason? |
|
Answer» 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 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 |
|
| 181. |
What Is The Difference Between Running Gather Stats And "program - Optimizer [rgoptm]" In Oracle General Ledger? |
|
Answer» “Gather Stats” will simply gather the stats against existing TABLES, indexes ETC. However Gather Stats does not create any new indexes. But “PROGRAM – Optimizer[RGOPTM]” can create indexes on GL_CODE_COMBINATIONS, provided ACCOUNTING segment has the indexed flag ENABLED. “Gather Stats” will simply gather the stats against existing tables, indexes etc. However Gather Stats does not create any new indexes. But “Program – Optimizer[RGOPTM]” can create indexes on GL_CODE_COMBINATIONS, provided accounting segment has the indexed flag enabled. |
|
| 182. |
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. You can eiter use wf_engine. start_process or you can attach a runnable process such ghat it subscribes to a workflow event. |
|
| 183. |
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. 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. |
|
| 184. |
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. 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. |
|
| 185. |
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. 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. |
|
| 186. |
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. No, "Gather Schema Statistics" has no parameters for SYS schema. Please use dbms_job. |
|
| 187. |
Does Oracle 10g Support Rule Based Optimization? |
|
Answer» The official STANCE is that RBO is no longer supported by 10G. The official stance is that RBO is no longer supported by 10g. |
|
| 188. |
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 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". "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". |
|
| 189. |
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. FNDLOAD can not be used in the scenario. You can use migrator available in "Oracle iSetup" Responsibility. |
|
| 190. |
Is There A Pl/sql Engine In Sql*plus? |
|
Answer» No. Unlike Oracle Forms, SQL*Plus does not have a PL/SQL engine. Thus, all your PL/SQL are send directly to the DATABASE engine for execution. This MAKES it MUCH more efficient as SQL STATEMENTS are not STRIPPED off and send to the database individually. No. Unlike Oracle Forms, SQL*Plus does not have a PL/SQL engine. Thus, all your PL/SQL are send directly to the database engine for execution. This makes it much more efficient as SQL statements are not stripped off and send to the database individually. |
|
| 191. |
What Is Pl/sql? |
|
Answer» PL/SQL is Oracle's PROCEDURAL Language extension to SQL. The language INCLUDES object ORIENTED PROGRAMMING techniques such as encapsulation, function overloading, information hiding (all but inheritance), and so, brings state-of-the-art programming to the Oracle database server and a variety of Oracle tools. PL/SQL is Oracle's Procedural Language extension to SQL. The language includes object oriented programming techniques such as encapsulation, function overloading, information hiding (all but inheritance), and so, brings state-of-the-art programming to the Oracle database server and a variety of Oracle tools. |
|
| 192. |
Which Of The Following Is Not A Schema Object : Indexes, Tables, Public Synonyms, Triggers And Packages ? |
|
Answer» Public synonyms. |
|
| 193. |
What Is Implicit Cursor And How Is It Used By Oracle ? |
|
Answer» An implicit CURSOR is a cursor which is INTERNALLY CREATED by Oracle. It is created by Oracle for each INDIVIDUAL SQL. An implicit cursor is a cursor which is internally created by Oracle. It is created by Oracle for each individual SQL. |
|
| 194. |
What Are The Various Types Of Queries ? |
| Answer» | |
| 195. |
If You Insert A Row In A Table, Then Create Another Table And Then Say Rollback. In This Case Will The Row Be Inserted ? |
|
Answer» Yes. Because CREATE table is a DDL which commits automatically as SOON as it is executed. The DDL commits the transaction even if the create statement fails INTERNALLY (EG table already exists error) and not syntactically. Yes. Because Create table is a DDL which commits automatically as soon as it is executed. The DDL commits the transaction even if the create statement fails internally (eg table already exists error) and not syntactically. |
|
| 196. |
What Is A Package Cursor ? |
|
Answer» A PACKAGE cursor is a cursor which you DECLARE in the package specification without an SQL STATEMENT. The SQL statement for the cursor is attached DYNAMICALLY at runtime from CALLING procedures. A package cursor is a cursor which you declare in the package specification without an SQL statement. The SQL statement for the cursor is attached dynamically at runtime from calling procedures. |
|
| 197. |
What Are Various Types Of Joins ? |
|
Answer» EQUIJOINS, Non-equijoins, SELF JOIN, OUTER join. Equijoins, Non-equijoins, self join, outer join. |
|
| 198. |
What Are The Types Of Notation ? |
|
Answer» POSITION, NAMED, MIXED and RESTRICTIONS. Position, Named, Mixed and Restrictions. |
|
| 199. |
What Are Actual And Formal Parameters ? |
|
Answer» Actual Parameters : Subprograms pass INFORMATION using parameters. The variables or expressions referenced in the parameter list of a subprogram call are actual parameters. For EXAMPLE, the following procedure call lists two actual parameters named emp_num and amount: EG. raise_salary(emp_num, amount); Formal Parameters : The variables DECLARED in a subprogram specification and referenced in the subprogram body are formal parameters. For example, the following procedure declares two formal parameters named emp_id and increase: Eg. PROCEDURE raise_salary (emp_id INTEGER, increase REAL) IS current_salary REAL; Actual Parameters : Subprograms pass information using parameters. The variables or expressions referenced in the parameter list of a subprogram call are actual parameters. For example, the following procedure call lists two actual parameters named emp_num and amount: Eg. raise_salary(emp_num, amount); Formal Parameters : The variables declared in a subprogram specification and referenced in the subprogram body are formal parameters. For example, the following procedure declares two formal parameters named emp_id and increase: Eg. PROCEDURE raise_salary (emp_id INTEGER, increase REAL) IS current_salary REAL; |
|
| 200. |
What Is A Forward Declaration ? What Is Its Use ? |
|
Answer» PL/SQL requires that you DECLARE an identifier before USING it. THEREFORE, you must declare a subprogram before calling it. This declaration at the start of a subprogram is CALLED forward declaration. A forward declaration consists of a subprogram specification terminated by a semicolon. PL/SQL requires that you declare an identifier before using it. Therefore, you must declare a subprogram before calling it. This declaration at the start of a subprogram is called forward declaration. A forward declaration consists of a subprogram specification terminated by a semicolon. |
|