Oracle Apps FAQS

1. What is Ref Cursor?

Ref cursor is the dynamic cursor where we can pass select stmt at run time

2. What r the collections (row type, collections)

    Row  type

   It allows you to treat tha variables as a unit , all the variables are of same data          type or diff data type

Collections

It allows you to treat tha variables as a unit , all the variables are of same data

3. What is bulk collect and use?

Executing sql statements in plsql programs causes a context switch between the plsql engine and the sql engine. Too many context switches may degrade performance dramatically. In order to reduce the number of these context switches we can use a feature named bulk binding. Bulk binding lets us to transfer rows between the sql engine and the plsql engine as collections. Bulk binding is available for select, insert, delete and update statements.

4. Can we set Index for primary key? If so what is the name of the Index?

When you create a PRIMARY KEY constraint, a unique clustered index on the column or columns is automatically created if a clustered index on the table does not already exist and you do not specify a unique nonclustered index. The primary key column cannot allow NULL values.

When you create a UNIQUE constraint, a unique nonclustered index is created to enforce a UNIQUE constraint by default. You can specify a unique clustered index if a clustered index on the table does not already exist.

5.  How to find how many ‘a’ are there in the specified string ‘aasfdhhjkgjaaaa’?

     Select length(‘aasfdhhjkgjaaaa’)-length(translate(‘aasfdhhjkgjaaaa’’,’xa’,’x’)

6. Can we pass Pl/sql table as a parameter to another procedure or not if so how to pass?

create or replace package package_demo
is
type EmpRecType is RECORD (ID EMP.EMPNO%type,
NAME EMP.ENAME%type);

type EmpTabType is TABLE of EmpRecType;

procedure call_getRecords;

procedure getRecords(emp_table EmpTabType);

end package_demo;
/

create or replace package body package_demo
is
employees EmpTabType;

procedure call_getRecords
is
begin
getRecords(employees);
end call_getRecords;

procedure getRecords(emp_table in EmpTabType)
is
begin
null;
-- perform all you want here...
end getRecords;

end package_demo;

7.      What is Mutating Table?

Table under transition is called Mutating Table. 

8. What are the type of Synonyms?

  2 types

 Public

private

9. When is ‘RAISE_APPLICATION_ERROR’ used?

he RAISE_APPLICATION_ERROR is a procedure defined by Oracle that allows to raise an exception and associate an error number and message with the procedure.

10. Wat are psuedo colomns

Pseudocolumns are not actual columns in a table but they behave like columns. For example, you can select values from a pseudocolumn. However, you cannot insert into, update, or delete from a pseudocolumn. Also note that pseudocolumns are allowed in SQL statements, but not in procedural statements.

Apps

1. What will happen when pick release and pick confirm

pick release: This is only soft reservations.

No physical movement of stock...           

  Pick release is the process by which the items on the sales order are taken out from inventory. The flow is as follows:

1) When an order is booked, based on the setups, the lines are scheduled and they are ready to release. This means the inventory is informed that there is requirement of certain quantity of certain items on certain date.

2) The inventory person ,according to availability allocates the items to those SO Lines and reserves them. 

pick confirm :Hard Reservations. Picked the stock.

Physical movement of stock

3) Then on the day of delivery or somewhere between these items are taken out of inventory and moved to staging subinventory. This means that the items are now ready for shipping and are out of inventory.

When the items reach staging subinventory, they are said to be picked and shipping execution can now ship these items.

2. what is token filed in conc program

TOKEN is an Interface between Concurrent Program and Report builder. This will map the concurrent program parameter values to the report builder parameters(User and System parameters).

3. Where the sql stmt fires in triggers

    After Parameter Form trigger

4. can we call conc prog from report

yes

5. validation trigger

Validation Triggers are PL/SQL functions that are executed when parameter values are specified on the command line and when you accept the Runtime Parameter Form. (Notice that this means each Validation Trigger may fire twice when you execute the report). Validation Triggers are also used to validate the Initial Value of the parameter in the Parameter property sheet

6. Can you use placeholder column with out using formula column?

No

7. When you will go for XML reports and when you will go for Discoverer reports.

8. How can you use DDL stmt  in report?

     Using SRW.DO_SQL

9. If you have one company in France and one in Germany using the same currency will you use different set of books ?

        No

 

10. What are the different types of documents in PO ?

PO, Requisitions, Quotations, RFQs