In rule base optimization we use the Query to tune,but in cost base optimization we use the data retrieved by the query.

Anurag Kehri

• Jan 10th, 2006

Oracle having two mode of optimization.1.Rule Based Optimizer(RBO).2.Cost Based Optimization(CBO).RBO is syntex driven,it uses basically a some kind of ranking system(20 condition ranking rule),c...

Answer Question  Select Best Answer

Manivannan .S

• Dec 15th, 2005

Defining Concurrent Program :::::The program's application determines what ORACLE username your program runs in and where to place the log and output files. Request Group::::::Select the name of the a...

Answer Question  Select Best Answer

Nitin

• Jan 27th, 2006

US is the language directory specifying that the source files to be placed under this dir is for English/American LanguageThis is the standard of apps directory structure  that for very language ...

Answer Question  Select Best Answer

krish

• Apr 13th, 2006

A party is an entity that can enter into business and can be of the type Organization orPerson. A party exists separately from any business relationship that it enters in to with another party. Inform...

Answer Question  Select Best Answer

merve

• Aug 2nd, 2006

declarel_blob blob;l_bfile bfile;begininsert into demo values ( 1, empty_blob() ) returning theBlob into l_blob;l_bfile := bfilename( 'MY_FILES', 'aria.gif' );dbms_lob.fileopen( l_bfile );dbms_lob.loadfromfile( l_blob, l_bfile,dbms_lob.getlength( l_bfile ) );dbms_lob.fileclose( l_bfile );end;/

Answer Question  Select Best Answer

viji

• Jun 8th, 2006

Autolockbox is an interface programme run in receivables inorder to transfer receipts from the bank to AR.The flow is:payments by the customers can be of 2 methods either by cash or cheque and usually...

Answer Question  Select Best Answer

Mark

• Jul 16th, 2006

PASTA is primarily meant for PDF and PS reports. If you have TEXT reports, they need to transformed into PDF format before they can be printed on any printer without having to tweak the prin...

Answer Question  Select Best Answer

geetha24

 Profile Answers by geetha24 Questions by geetha24

• Jul 13th, 2006

     Quick Pick is variable because it selects values from user-defined tables.   Quick Code is static & it selects values from system table called FND_LOOKUPS. Quick Code is faster then Quick Pick because it uses internal CACHE.

Answer Question  Select Best Answer

Fanish

• Aug 30th, 2006

The Workflow is created using the Oracle Workflow Builder which is now a bundled software with Oracle 9i database.Let me know if you have any more question related to Workflow.-Fanish

Answer Question  Select Best Answer

tigerc696

 Profile Answers by tigerc696 Questions by tigerc696

• Jul 26th, 2006

The Oracle Accounting Flexfield is the base structure you will use to design your general ledger accounts. Oracle allows you to create flexible multi-segmented account strings.When you setup Oracle Fi...

Answer Question  Select Best Answer

Supratim Saha

• Sep 16th, 2006

mtl_sales_orders is a KFF setup in inventory. the segments enabled typically are (1) Sales order no (2) order source (3) order type. any inventory transactions initiated from OM will have a linka...

Answer Question  Select Best Answer

vinodks

 Profile Answers by vinodks Questions by vinodks

• Aug 28th, 2006

hi,  Sure we can use the independent vlaue set to the DFF

Answer Question  Select Best Answer

Monica

• Oct 3rd, 2006

Quote to cash cycle will essentially have 1. BOM2, Inventory3. Order entry (OE)4. Order Managemnet (ONT)5. ASO (Order Capture)6. WF (workflow  ) 

Answer Question  Select Best Answer

rakesh.apps

 Profile Answers by rakesh.apps Questions by rakesh.apps

• Aug 8th, 2007

1. give the name in the valueset field2. select the format type whether it is char or number etc and give the size3. select validation type as TABLE 4. press the Edit Informa...

Answer Question  Select Best Answer

Prakash

• Jul 30th, 2011

Revaluation: adjusts asset or liability accounts that may be materially understated or overstated due to a significant fluctuation in the exchange rate between the time the transaction was entered...

Answer Question  Select Best Answer

After we raise a PO and the po is approved and we do receiving but at the time of receiving if the price of the item is less then the PO price do we update the price in receipt and can anyone give the steps.

mejigs

 Profile Answers by mejigs Questions by mejigs

• Apr 5th, 2011

Hi,While receiving if Invoice received is different than PO price, Standard Purchase price variance (PPV) report can be used to report the difference. Optionally you can revise PO (it will create a new revision for PO) and get approvals before receiving it.Thanks,Jigisha

Answer Question  Select Best Answer

subbupdk

 Profile Answers by subbupdk Questions by subbupdk

• Apr 14th, 2008

Go to concurrent progam define window and see the out put style, if it's text means character mode or it's in PDF means bitmap.

Answer Question  Select Best Answer

Antony

• Aug 22nd, 2007

First the report should be developed in XML tag,because it is easier to convert into optio.2.The driver for optio you have to install it in Apps server.3.Make a queue setup in Optio.4.Make a setup for...

Answer Question  Select Best Answer

harshad

• Dec 29th, 2005

invoices for the periodic expenses are called as recurring invoiceseg, electricity bill,      home rent

kc

• Dec 13th, 2005

Recurring invoices are those invoices which re occur after a specific time interval eg. Monthly Rent

Answer Question  Select Best Answer

diwaker

• Dec 22nd, 2005

Types of Invoices: 1)standard invoice,2)pre-payment,3)debit memo,4)credit-memo,        5)with-holding tax,6)PO DEFAULT 7) Quick Match 8)Expense ReortRecurring Invoic...

chenna

• Dec 2nd, 2005

hi,    standard invoice,pre-payment,debit memo,credit-memo,with-holding tax, and two more are there .But generally we use these five only.If u want more information then send a mail to chenna_darapaneni@yahoo.co.in. I'll send u indetail.

Answer Question  Select Best Answer