there are 8 types of valuesets in apps 11.5.9. they arenoneindependentdependenttabletranslated independenttranslated dependentspecialpairtrns independent and trns dependent are used for multilanguage support.--oraclehari@gmail.com
Manivannan .S
Feb 21st, 2006
The valueset are like how we define constraints in Oracle Database. In oracle Apps there are six value sets1. Independent - The Value which we provide to the Segments are independent (Ex. Compa...
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...
We cannot use ref cursors in the client side (FORMS Libraries ) library. This feature is available only on the server side PLSQL. i.e. Packages which reside in the databse.
HD
Feb 17th, 2006
Could someone please answer why we cannot use REF Cursors in CUSTOM.pll
There are 2 flexfields in AR1.Sales Location 2.Teritory Of which sales location is mandatory.A sales tax is calculated by considering the ship-to information.Teritory flexfield is optional.Ashok
Bonthu N Reddy
Feb 14th, 2006
There r two Flex fields available in AR 1) SALES TAX LOCATION.2)TERRITORY.Cheers,Bonthu N Reddy.
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...
Import data from Legacy system to GL1> Trasnfer data from Legacy sytem to GL_INTERFACE table by creating PLSQL Procedure with related defined Source name in GL setups. 2> Open Standard form...
thomas
Apr 22nd, 2006
1. Load the data in GL INTERFACE.2. Call Journal Import3. Call Journal PostingYou can do virtually all the above from a single PL/SQL package. This information is alo available in the GL trm, and help can be takn from the Oracle metalink.
The Flow of PO starts when the Request for Goods started, This is the P2P (Procure to Pay) Cycle. The Matching is one of the concepts in the P2P The 2 way matching is the Ensuring the Invoice and PO d...
Vijay
Jun 21st, 2006
Two-way Matching means checking of the invoice by ordered quantity & PO rateThree-way Matching means checking of the invoice by ordered quantity & PO rate,invoiceFour-way Matching means checking of the invoice by ordered quantity & PO rate,invoice,quantity recieved
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.
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...
1) create P_from_date and P_to_date are user bind parameters 2) Create LP_WHERE_CLS lexical parameter.3) Write below code in the After Parameter Form Trigger If :p_from_date is not Nu...
user_pc
Apr 11th, 2006
To use a lexical parameter in the query of your data model, prefix it with a '&' (ampersand)example SELECT ename FROM emp WHERE &lp_lexical_valThe value of p_lexical_val may be set in th...
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...
Hi, request sets holds a group of request in a particular sequence. the requests can be reports or procedures. by submitting a single request ,u can run many concurrent programs at once.
Bonthu N Reddy.
Feb 13th, 2006
Request sets define run and print options and possibly parameter values for a collection of reports or c...
There r 8 types of value sets,they r1. none2.pair3.special4.table5.translatable dependent6. translatable independent7.dependent8.independent
Amit Chintawar
Mar 29th, 2006
Different types of Value sets are,1) Independant- This Value set contains list of values which does not depends on any other value2) Dependant- It contains values which ...
errbuf:This is out parameter which will through the error messges in to the log file.retcode: This is also out parameter, it will tells the status of the concurrent program.if sucess it wi...
Oracle Apps DBA define the capability of Concurrent Manager. The concurrent manager might be defined to handle few requests only. Therefore your equest was kept on hold/pending.-Fanish
pramod
Dec 25th, 2005
The reason may be like it..1) Other people have set priorty high than ur program. 2) Imcompatible programs are running. 3) Concurrent manager is down.
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
Ans