Explore topic-wise InterviewSolutions in .

WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest ROW fetched from a cursor. Database TRIGGERS.

WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers.

% TYPE provides the DATA type of a VARIABLE or a database column to that variable.

% ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in the CURSOR.

The ADVANTAGES are : I. Need not know about variable's data type ii. If the database definition of a column in a table changes, the data type of a variable changes accordingly.

% TYPE provides the data type of a variable or a database column to that variable.

% ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in the cursor.

The advantages are : I. Need not know about variable's data type ii. If the database definition of a column in a table changes, the data type of a variable changes accordingly.

Some scalar DATA types such as

NUMBER,
VARCHAR2,
DATE,
CHAR,
LONG,
BOOLEAN.

Some composite data types such as RECORD & TABLE.

Some scalar data types such as

NUMBER,
VARCHAR2,
DATE,
CHAR,
LONG,
BOOLEAN.

Some composite data types such as RECORD & TABLE.

A set of related declarations and PROCEDURAL statements is called block.

DECLARE -- declaration section

BEGIN -- executable statements -- main section

EXCEPTION -- handling possible EXCEPTIONS -- occuring in the main section END;

A set of related declarations and procedural statements is called block.

DECLARE -- declaration section

BEGIN -- executable statements -- main section

EXCEPTION -- handling possible exceptions -- occuring in the main section END;

For improving performance, we need to check the sql statement BLOCKS, because for every sql SATEMENT execution transfor to sql ENGINE and COME back to plsq engine that process takes more time to process the plsql block.

For improving performance, we need to check the sql statement blocks, because for every sql satement execution transfor to sql engine and come back to plsq engine that process takes more time to process the plsql block.

YES we can USE objects, ARRAYS to return more than one VALUE.

yes we can use objects, arrays to return more than one value.

Execute procedure name (parameter1,parameter2)

SELECT timestamps, owner, obj_name, action_name from dba_audit_trail;this STATEMENT gives LAST executed time for procedure , FUNCTION & PACKAGE.

Execute procedure name (parameter1,parameter2)

Select timestamps, owner, obj_name, action_name from dba_audit_trail;this statement gives last executed time for procedure , function & package.

Implicit Cursor are declared and USED by the oracle INTERNALLY. whereas the EXPLICIT CURSORS are declared and used by the user. more over implicitly cursors are no need to declare oracle CREATES and process and closes autometically. the explicit cursor should be declared and closed by the user.

Implicit cursors are used for single row query whereas explicit cursor is used for multiple row query.

Implicit Cursor are declared and used by the oracle internally. whereas the explicit cursors are declared and used by the user. more over implicitly cursors are no need to declare oracle creates and process and closes autometically. the explicit cursor should be declared and closed by the user.

Implicit cursors are used for single row query whereas explicit cursor is used for multiple row query.

Just use subquery in for clause

ex:

no EXIT STATEMENT needed implicit OPEN,fetch,CLOSE occurs.

Just use subquery in for clause

ex:

no exit statement needed implicit open,fetch,close occurs.

Answer : CREATE OR REPLACE PROCEDURE ddl_create_proc (p_table_name IN VARCHAR2) AS l_stmt VARCHAR2(200); BEGIN DBMS_OUTPUT.put_line('STARTING '); l_stmt := 'create table '|| p_table_name || ' as (SELECT * from emp )'; execute IMMEDIATE l_stmt; DBMS_OUTPUT.put_line('end '); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line ('exception '||SQLERRM || 'message'||sqlcode); END;

YES Distributed database system BASED on 2 phase COMMIT, one QUERY is independent of 2nd query so of COURSE we can run.

Yes Distributed database system based on 2 phase commit, one query is independent of 2nd query so of course we can run.

ROWID - Hexa decimal number each and every ROW having unique.Used in searching.

ROWNUM - It is a integer number ALSO unique for sorting Normally TOP N Analysys.

Other Psudo Column are:

NEXTVAL,CURRVAL Of sequence are some exampls. psudo columns are default columns provided by ORACLE.

ROWID - Hexa decimal number each and every row having unique.Used in searching.

ROWNUM - It is a integer number also unique for sorting Normally TOP N Analysys.

Other Psudo Column are:

NEXTVAL,CURRVAL Of sequence are some exampls. psudo columns are default columns provided by oracle.

Stored procedures are subprogrammes stored in the database and can be CALLED &executee multiple times wherein an application procedure is the one being USED for a particular application same is the WAY for function.

Both can be executed any NUMBER of times. Only DIFFERENCE is that stored procedures / functions are stored in database in complied format while the application procedures/functions are not in precomplied format and at run time has to be compiled.

Stored procedures are subprogrammes stored in the database and can be called &executee multiple times wherein an application procedure is the one being used for a particular application same is the way for function.

Both can be executed any number of times. Only difference is that stored procedures / functions are stored in database in complied format while the application procedures/functions are not in precomplied format and at run time has to be compiled.

Discount refers to the payment terms or on quantity(bulk oreder discount)oredered. In the invoice received from supplier, discounts term is sepcificaly stated.E.G. If PAID with in 15 days discount @ 2%, what you need to do is pay 2% less then the original invoice amount,however caution should be taken that the freight amount should not be CONSIDERED while calculating the discount. Adjusment could be for various reasons.Over priced invoice,short delivery of quantity as per goods received NOTE, poor quality etc.Agreed upon amount will be deducted from the invice, while making the PAYMENTS.

Discount refers to the payment terms or on quantity(bulk oreder discount)oredered. In the invoice received from supplier, discounts term is sepcificaly stated.E.G. If paid with in 15 days discount @ 2%, what you need to do is pay 2% less then the original invoice amount,however caution should be taken that the freight amount should not be considered while calculating the discount. Adjusment could be for various reasons.Over priced invoice,short delivery of quantity as per goods received note, poor quality etc.Agreed upon amount will be deducted from the invice, while making the payments.

Summary ACCOUNT is an account whose BALANCE represents the sum of other account balances. You can use summary accounts for faster reporting and inquiry as well as in formulas and allocations.

ROLLUP group is a collection of parent segment values for a given segment. You use rollup groups to define summary accounts based on parents in the group. You can use letters as well as numbers to name your rollup groups.

Summary Account is an account whose balance represents the sum of other account balances. You can use summary accounts for faster reporting and inquiry as well as in formulas and allocations.

Rollup group is a collection of parent segment values for a given segment. You use rollup groups to define summary accounts based on parents in the group. You can use letters as well as numbers to name your rollup groups.

All the setups(Form, form function, form function attaching to MENU, menu to RESPONSIBILITY) are fine.

But even I am getting the error Function is not AVAILABLE to this responsibiltiy, please contact the system administrator.

This error we are getting for all CUSTOM developed forms. Same things are working fine in other INSTANCES.

All the setups(Form, form function, form function attaching to menu, menu to responsibility) are fine.

But even I am getting the error Function is not available to this responsibiltiy, please contact the system administrator.

This error we are getting for all custom developed forms. Same things are working fine in other instances.

VB.NET is a windows APPLICATION.

Where as C# is a CONSOLE.

vb.net is supported MULTIPLE inheritance c# does not supported multiple inheritances.

VB.NET is a windows application.

Where as C# is a console.

vb.net is supported multiple inheritance c# does not supported multiple inheritances.

SET of book is a combination of currency,CALENDAR,chart of accounts. FOUR conditions when u change ur sob is:

1. check your currency.
2. check your calendar.
3. check your chart of accounts.
4. You have to assign your sob to your RESPONSIBILITY.

set of book is a combination of currency,calendar,chart of accounts. Four conditions when u change ur sob is:

If it is accounting period types, then there are three pre-defined types, namely MONTH, quarter and year. User can also add period types.

If it is period STATUS, then there are 5 period status, namely NEVER opened, Open, Future Enterable, closed and PERMANENTLY closed.

If it is accounting period types, then there are three pre-defined types, namely month, quarter and year. User can also add period types.

If it is period status, then there are 5 period status, namely Never opened, Open, Future Enterable, closed and Permanently closed.

Types of invoices:

• Invoice.
• Credit MEMO.
• Debit Memo.
• Gaurantee.
• CHARGE BACK.
• DEPOSITE.

Types of invoices:

Cross Validation Rule : RULES that define valid combinations of segment VALUES a user can enter in an account. Cross-validation rules restrict USERS from ENTERING invalid combinations of account segment values.

Security Rule : It determines the accounting transaction user can VIEW at differenty levels of hierarchy, such as at Site Level -->Application Level --> Responsibility Level --> User level.

Cross Validation Rule : Rules that define valid combinations of segment values a user can enter in an account. Cross-validation rules restrict users from entering invalid combinations of account segment values.

Security Rule : It determines the accounting transaction user can view at differenty levels of hierarchy, such as at Site Level -->Application Level --> Responsibility Level --> User level.

1. Manual entry.
2. Subledger Entry.
3. SPREADSHEET Entry.
4. RECURRING Entry.
5. Mass ALLOCATION.

Types of Invoice :STANDARD, CM, DM, Expense, Pre-Payment.

Recurring Invoice is a TYPE of invoice which occurs at definite intervals of time. The best example for a recurring invoice is RENT paid to the OWNER.

Types of Invoice :Standard, CM, DM, Expense, Pre-Payment.

Recurring Invoice is a type of invoice which occurs at definite intervals of time. The best example for a recurring invoice is Rent paid to the Owner.

Some times suppliers would not be sending any invoices.But STILL the payment have to made to him.ex: rent,lease rentels. In this situvation we have to create invoice every period wise.For that PURPOSE we have to create one recurring invoice template. Template means with one master copy creating the MULTIPLE invoices is called template.here we are creating the one invoice master copy is formally known as arecurring invoice or recurring inavoice tempalate. SET UP:

1. we have to create one special calender .
2. we have to create one full DISTRIBUTION set.
3. we have to ENTER payment terms in the recurring invoice window.
4. enter the template no,first invoice amount,special invoice amounts.

Some times suppliers would not be sending any invoices.But still the payment have to made to him.ex: rent,lease rentels. In this situvation we have to create invoice every period wise.For that purpose we have to create one recurring invoice template. Template means with one master copy creating the multiple invoices is called template.here we are creating the one invoice master copy is formally known as arecurring invoice or recurring inavoice tempalate. SET UP:

Drilldown from ORACLE General Ledger 11i is supported for Oracle Payables, Oracle Receivables, Oracle ASSETS (EXCEPT depreciation), PROJECTS, Purchasing, Inventory, and Work in Process (WIP).

Drilldown from Oracle General Ledger 11i is supported for Oracle Payables, Oracle Receivables, Oracle Assets (except depreciation), Projects, Purchasing, Inventory, and Work in Process (WIP).

There are 4 TYPES of journal entries.

1. BASIC Journal Entry - Used for most of the accounting TRANSACTIONS.
2. Reversing JE - Created by reversing the existing journal entry.
3. Recurring JE - Defined once and then generated for subsequent accounting PERIOD.
4. Mass Allocation - Created to allocate the revenues and assets to a GROUP of resources(cost centers, depts, divisions,etc) from a single Journal.

There are 4 types of journal entries.

GL date is the date used to determine the CORRECT accounting period for your transactions where as the GL POSTING date is the date when the JOURNAL entry is POSTED TH GL.

GL date is the date used to determine the correct accounting period for your transactions where as the GL posting date is the date when the journal entry is posted th GL.

GL is like AR->GL<-AP.

AR and AP both TRANSFER the data in GL .

AR Contains all Invoices/Receipts /CM/DM and same WAY AP also have AP VOUCHERS.

GL is like AR->GL<-AP.

AR and AP both transfer the data in GL .

AR Contains all Invoices/Receipts /CM/DM and same way AP also have AP Vouchers.

Let me brief you about both MRC and Multi Org. MRC stands for Multi reporting currency. which means you should have different SOBs, One must be primary and others are reporting. (max. 8).

Where as Multi Org concept is we will SET up a organisation where we will have a Business group then SOBS then Legal entities then OPERATING units then Inventory ORGANISATIONS and lastly sub Inventory catagerory.. This set up will help to avoid multiple INSTALLATIONS and have only one installation. We will attach all sub ledgers like AP, AR etc at Operating level and GL and FA at SOB level..

Let me brief you about both MRC and Multi Org. MRC stands for Multi reporting currency. which means you should have different SOBs, One must be primary and others are reporting. (max. 8).

Where as Multi Org concept is we will set up a organisation where we will have a Business group then SOBS then Legal entities then Operating units then Inventory organisations and lastly sub Inventory catagerory.. This set up will help to avoid multiple installations and have only one installation. We will attach all sub ledgers like AP, AR etc at Operating level and GL and FA at SOB level..

No can not DELETE a BUDGET.

No can not delete a budget.

YES you can UPDATE an existing ACCOUNT RANGE in Budget Organization.

Yes you can update an existing account range in Budget Organization.

In Coulum we have to mention the NUMBER for control and also in REPORT set we have PUT the budget DEFINED in control field.

In Coulum we have to mention the number for control and also in report set we have put the budget defined in control field.

For each set of books you can have only ONE CURRENT budget at a TIME.

For each set of books you can have only one current budget at a time.

Yes, you can disable budgetary CONTROL for a set of book by UNCHECKING the 'Enable Budgetary Control' CHECK box in the Budgetary control tab page of the DEFINE set of books window.

Yes, you can disable budgetary control for a set of book by unchecking the 'Enable Budgetary Control' check box in the Budgetary control tab page of the define set of books window.

we INTEGRATE AR or AP to GL through SET of Books.

we integrate AR or AP to GL through Set of Books.

Can upload Journal Entries using ADI (Application DESKTOP Integrator) functionality.

ADI is used to interface spreadsheet uploads with Oracle APPLICATIONS data. ADI allows users take ADVANTAGE of many of the data-entry shortcuts of a spreadsheet, such as copying and pasting cells, dragging and DROPPING ranges of cells and using formulas to calculate journal line amounts. ADI validates the data entered against the accounts, security rules and reference information that are defined in the General Ledger (GL).

Can upload Journal Entries using ADI (Application Desktop Integrator) functionality.

ADI is used to interface spreadsheet uploads with Oracle applications data. ADI allows users take advantage of many of the data-entry shortcuts of a spreadsheet, such as copying and pasting cells, dragging and dropping ranges of cells and using formulas to calculate journal line amounts. ADI validates the data entered against the accounts, security rules and reference information that are defined in the General Ledger (GL).

When we have multiple setup and combine primary and SECONDARY BOOKS GETTING the financial reports is called CONSOLIDATION.

We will use consolidation reports at the time of period end closing.

When we have multiple setup and combine primary and secondary books getting the financial reports is called consolidation.

We will use consolidation reports at the time of period end closing.

The PLAN for the FUTURE expenses is planning budget. It is a paper WORK. There is no funds rerequirement. It does not require journals. There is no restrictions for ESTIMATING of funds.

The plan for the future expenses is planning budget. It is a paper work. There is no funds rerequirement. It does not require journals. There is no restrictions for estimating of funds.

EDI - Electronic Data Interchange, to send the data to another server/destination via EDI server.,edi is a TOLL where in whenever the customer is sending the PO it gets saved in this toll, again when the SUPPLIER after supplying the material will send an invoice through EDI, WHEREIN the EDI of the customer will match the PO with the invoice and the invoice will get processed automatically, in CASE if it is not matching it will be in the error sheet.

EDI - Electronic Data Interchange, to send the data to another server/destination via EDI server.,edi is a toll where in whenever the customer is sending the PO it gets saved in this toll, again when the supplier after supplying the material will send an invoice through EDI, wherein the EDI of the customer will match the PO with the invoice and the invoice will get processed automatically, in case if it is not matching it will be in the error sheet.

BROADLY following are the feature / ELEMENTS of ADI:

1. Journal Wizard.
2. Budget Wizard.
3. Report Wizard.
4. Account Hierarchy Editor.
5. ANALYSIS Wizard.
6. Request CENTER.

Broadly following are the feature / elements of ADI:

ADI is used to interface spreadsheet uploads with Oracle applications data. ADI allows USERS take advantage of MANY of the data-entry shortcuts of a spreadsheet, such as copying and pasting cells, DRAGGING and dropping ranges of cells and using formulas to calculate journal line AMOUNTS. ADI validates the data entered against the accounts, security rules and reference information that are defined in the General Ledger (GL).

ADI is used to interface spreadsheet uploads with Oracle applications data. ADI allows users take advantage of many of the data-entry shortcuts of a spreadsheet, such as copying and pasting cells, dragging and dropping ranges of cells and using formulas to calculate journal line amounts. ADI validates the data entered against the accounts, security rules and reference information that are defined in the General Ledger (GL).

MD50 is a Functional DESIGN document used in AIM METHODOLOGY. mainly used for Application EXTENSIONS and INTERFACE functional design.

MD50 is a Functional design document used in AIM methodology. mainly used for Application Extensions and Interface functional design.

GL Posted DATE : It is the defaultly current date, but you can CHANGE it.

GL Date : Beginning and ENDING GL dates that will be PICKED up when interface is executed.

GL Posted Date : It is the defaultly current date, but you can change it.

GL Date : Beginning and ending GL dates that will be picked up when interface is executed.

Basically after entering the transactions, report will be taken to verify the transactions. In case, if approval is needed, it is APPROVED after VERIFYING the transactions. Once you are sure that the transactions are correct, the same can be posted to GL. Once it is posted, most of the informations for the posted transaction can not be modified in the subledger. In case of any wrong entry, you NEED to follow the reversal procedure.

Practically, the verification of transactions are done only during the initial stages after implementation. Once the system becomes stable, it is not followed STRICTLY.

Basically after entering the transactions, report will be taken to verify the transactions. In case, if approval is needed, it is approved after verifying the transactions. Once you are sure that the transactions are correct, the same can be posted to GL. Once it is posted, most of the informations for the posted transaction can not be modified in the subledger. In case of any wrong entry, you need to follow the reversal procedure.

Practically, the verification of transactions are done only during the initial stages after implementation. Once the system becomes stable, it is not followed strictly.

In GL you will have Set of Books Id defined for each set of books you DEFINE for the organizations. Using SOB's ID you will distinguish the Books or Organizations.

In GL you will have Set of Books Id defined for each set of books you define for the organizations. Using SOB's ID you will distinguish the Books or Organizations.

A few more

• Cognos DECISION STREAM
• Oracle WAREHOUSE Builder
• Business OBJECTS XI (Extreme INSIGHT)
• SAP Business Warehouse
• SAS Enterprise ETL Server

Along with the above, need to include the below tools --Informatica --Abintio --DataStage.

A few more

Along with the above, need to include the below tools --Informatica --Abintio --DataStage.

Materialized view is a view in wich DATA is also stored in some TEMP table.i.e if we will go with the View concept in DB in that we only store QUERY and once we call View it extract data from DB. But In materialized View data is stored in some temp tables.

Materialized view is a view in wich data is also stored in some temp table.i.e if we will go with the View concept in DB in that we only store query and once we call View it extract data from DB. But In materialized View data is stored in some temp tables.

Fact LESS table MEANS only the key available in the Fact there is no measures available.

factless fact table means that contains only foreign keys with out any measures example:attendance REPORT of EMPLOYEES in a particular company contains no measures only.

Fact less table means only the key available in the Fact there is no measures available.

factless fact table means that contains only foreign keys with out any measures example:attendance report of employees in a particular company contains no measures only.

You cannot LOOKUP from a SOURCE QUALIFIER DIRECTLY. However, you can OVERRIDE the SQL in the source qualifier to join with the lookup table to perform the lookup.

You cannot lookup from a source qualifier directly. However, you can override the SQL in the source qualifier to join with the lookup table to perform the lookup.

A few are :

• Abinitio
• DataStage
• Informatica
• COGNOS Decision Stream
• ORACLE Warehouse Builder
• Business Objects XI (Extreme Insight)
• SAP Business Warehouse
• SAS Enterprise ETL SERVER.

A few are :