Question { Oracle, 10477 }

what are the functions you are used in utl_file at the time
of transferring the data?

Answer

IN ABOVE ANS ONLY FOPEN IS A FUNCTION REMAINING ARE
PROCEDURE
FUN IN UTL FILE ARE
F OPEN
IS OPEN
FOPEN NCHAR

MUNEER

Question { Intelligroup, 12880 }

Is it possible calling from one report to another?
if possible means tell me ?

Answer

by using rwrun60 command

Question { IBM, 25593 }

what is back order in OM

Answer

IF SUFFICIENT QUANTITY IS NOT AVILABLE IN INVENTORY THAT
TIME THE LINE STATUS BECOME BACK ORDER

MUNEER

Question { 10549 }

Can we run a package with out specification?If yes how?

Answer

ANS 1 IS CORRECT

MUNEER

Question { 7343 }

we are inserting,update and delete the data we can do
simultaniously, but it will show error in updation? what to
do?

Answer

for that first we have yo check the error

Question { 10894 }

can we write sql statement in Format trigger?

Answer

s


muneer

Question { HCL, 27550 }

In Per_all_people_f table what is the significance
of '_f ' ?

Answer

YES PLZ UNDERSTAND THE QUESTION WHAT F STANDS FOR THATS IT

MUNEER

Question { 8476 }

what is the use of format trigger?a

Answer

it is a function
used to chane the formatting attribute of the object

Question { KPIT, 6749 }

What is Reccuring Invoice ? What is the default invoice
date for reccuring invoices ?

Answer

basically we create ihe RI for periodic buisiness expanses
for ex:house rents,elec bills for which we may not receive
the invoice. to create recurring invoices first we have to
define recurring invoice tamplet

Question { UST, 7906 }

how will you find out check no's for a particular invoice

Answer

in front end:
Payment 'document numbers' displaying in the payment window.
in back end:

> select ac.check_num
from ap_invoices_all aia
,ap_invoice_payments_all aip
,ap_checks_all ac
where aia.invoice_id=aip.invoice_id
and aip.check_id=ac.check_id
and aia.invoice_number='xxxxxxxx';

Question { BirlaSoft, 16535 }

How to generate XML Report with out using rdf?

Answer

BOTH ARE CORRECT VERY GOOD

MUNEER

Question { 14326 }

How many parameters we can pass through pl/sql program in
Oracle apps

Answer

S QUS IS NOT CLEAR ANY WAY IF THE PLSQL BLOCK IS PROCEDURE
THEN WE CAN PASS 100 PARAMETERS INCLUDING ERRBUF AND RETCODE

Question { First Indian Corporation, 10378 }

how to transfer the Invoices entries from AP to GL, can any
body give the answer

Answer

hi
after validate the invoice u have to generete the accounts
for that u click the action button in ivoice screen
and select create accountiong check box
so the AP accounting table get inserted
tables are
ap_ae_headers_all ,ap_ae_lines_all,ap_accounting_events_all
if u want, view that tables.
and then run the concurrent program "payable tranfer to
general ledger" enter the fllowing parameters
from and to date: ur invoice dates
trnsfer to gl :in detail
submit to general ledger:Yes (if u select no here u have to
enter journal inport program manually) and submit the
program.
hence system will create the journal in gl
finally go to gl module and check the journal lines
if u want to post the journal select post
nav-->journal->post
give the batch name and click post(gl_balances table
updated)
and finally check the gl_balances table

MUNEER