Interview Questions Answers in Oracle Apps Technical, SQL PLSQL

Questions / { venkateswararao }

Questions Answers Category Views Company eMail

Answers / { venkateswararao }

Question { Convergys, 9137 }

How will U link GL with OU in Multi-org environment.

Answer

create set of books and link with profile gl_set_of_books
with user
i think this is the correct.i not correct me

Is This Answer Correct ?

0 Yes

0 No

Question { TCS, 23865 }

what is mean by forward declaration and where we'll use it.

Answer

A forward declaration looks like the package definition
part but is inside the bode.

e.g.

procedure A is
begin
B;
end A;

procedure B is
begin
null;
end B;

will not work, because during call to B B is still unknown
(1 Step compiler) therefore we need a forward declaration:

procedure B;

procedure A is
begin
B;
end A;

procedure B is
begin
null;
end B;

now we can compile

Is This Answer Correct ?

30 Yes

2 No

Question { TCS, 8439 }

How You Will display the key flexifields in your report

Answer

IF YOUR INFORMATION CANTAIN IS
SEGMENT1
SEGMNET2
SEGMENT3
BY USING CONCATED OPERATOR SEGMENT1||SEGMENT2||SEGMENT3

Is This Answer Correct ?

1 Yes

4 No

Question { TCS, 6358 }

What will happen If I am not giveing the Suspense accout
while defineing the Set of Books in GL?

Answer

IF YOU ENTER JOURNAL
CASH A/C DR 10,000
TO RENT A/C CR 8000
IF YOU DONOT ENABLE SUSPENCEA/C THE A/C IS NOT
AUTOMATICALLY CREATED AND IT IS NOT POSTED

IT IS IN ENABLE STATE THIS IS POSTED AND EXCESS AMT IS
CREDITED TO SUSPENCE A/C

Is This Answer Correct ?

1 Yes

0 No

Question { TCS, 10553 }

what is the need of registering table in apps?

Answer

IF YOU REGISTER TABLE IN APPS
--WE CAN USE THIS TABLE IN VALUESET
--WE CAN AUTOMATICALLY POPULATE DATA TO APPS

Is This Answer Correct ?

11 Yes

3 No

Question { 22887 }

WHAT IS REFCURSOR IN ORACLE ?

Answer

refcusor is globAL DECLARATION FOR EVERY AT THE TIME OF
OPENING CURSOR WE PASS SELECT STATEMENT DYNAMICALLY

Is This Answer Correct ?

10 Yes

1 No

Question { IBM, 7227 }

What is implicity cursor . When it fires . For which
statement it will fire(Insert/update/delte).
What is the attribute of implicity and explicity cursor
oracle 9i.
What is the Rec cursor.

Answer

EVERY SQL STMT IMPLICITY OPENS ONE CURSOR AND PARSE AND
EXECUTE QUERY FOR EVER STMT IT WILL FIRE
IMPLIST
SQL%

Is This Answer Correct ?

6 Yes

0 No

Question { TCS, 6794 }

What is set function in sql .E.g.What is difference between
union and union all

Answer

set operators are used to combine the out put of more than
one query.

union: used to combine the output Query1 and query2
and display them uniquely AND OUTPUT IS SORTED
ACCORDING TO FIRST COLUMN OF QUERY1

union all : it would combine the two query and displays then
as its duplicates AND HERE NO SORTING IS DONE.

Is This Answer Correct ?

3 Yes

0 No

Question { IBM, 8504 }

What is multoorg and what is it's level or structure

Answer

multiorg nothing under single database instance
maintaing multiple organization information
like
businessgroups->glsetofbooks->legal entity->operating unit-
>inventory

Is This Answer Correct ?

5 Yes

0 No

Question { IBM, 8213 }

In which table or database definition we can find the link
of organization and operation units.

Answer

hr_operating_units --org_id
org_organization_definations
-- i am not sure i wll respond again if it is wrong

Is This Answer Correct ?

2 Yes

0 No

Question { IBM, 8258 }

What multi org tables . example - difference between app
table non all table . Po_header and po_headers_all

Answer

-all is multiorgtable which contains all orgnization
information
po_hedear is the view which contains information abt
particular organization of user is login
-- little tricy to understand how it works
how view get particular organization data
select * from po_headers where org_id=:client_info
client_info holds the org_id which user logged
if any dout askvenki@gmail.com i will respond

Is This Answer Correct ?

9 Yes

0 No

Question { TCS, 14497 }

Except the SRS window in which we can submit the
concurrent program.

Answer

--i think it is not possible

Is This Answer Correct ?

0 Yes

13 No

Question { IBM, 25683 }

What is MO operating units. Why it need to to set this and
where .

Answer

This the profile which holds the value of operating unit
orgid when ever user login into system his org id is
value is transfered to profile value base on this profile
we get data and put data from database

Is This Answer Correct ?

11 Yes

2 No

Question { 18215 }

while registering executable and concurent program we
register both with application name|?
so my question is why we are defining in both concurent
program and executable?

Answer

could u tell more abt this

Is This Answer Correct ?

1 Yes

0 No