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

Is it possible to add a custom tab, apart from the existing two custom tabs, to the existing eBusiness Center form? If yes, can anybody help me figuring out how it could be done? The requirement is client wants to add 4 custom tabs which is different information and also different (custom) tables. Does anybody have documentation regarding addition of custom tabs and how the design should go?Thanks...

I am going to work on open return sales order conversion with line category is "Awaiting Return" and first time i am doing this conversions...Could you please any one tell me the process and if you guys having any sample codes,please mail me to raviapps84@gmail.com...Thanks in AdvanceRavi