-
-
-
What are the different types of Value sets and expalin them briefly which value set will use when?
poojar
- Mar 3rd, 2006
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...
-
How to write a query for a report in apps using md 50
Ajay Kunde
- Feb 21st, 2007
1. When you get MD050, first take some time to analyse the MD50 and understand the functionality of the report.2. See the layout given in MD050.3. Try to find out the Tables involved in that.4. Develo...
fanish
- Aug 30th, 2006
Let me first tell you about MD50, it a functional document which we receive from Client for technical development MD70. MD50 defines the functional requirement of customization.Suppose if the MD50 say...
-
-
What are the 2 mandatory parameters that we pass when we register a conc program in oracle applications
Siva
- Jul 24th, 2006
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...
-
-
-
Tell me about TCA(Trading Community Architecture)?
gajendra_nath
- Sep 11th, 2008
TCA API's brought a fresh approach to standardise DML's in Oracle Apps. I think this is one of Oracle's best written modules in APPS, but the flaws that exist are primarily because Oracle developed TC...
anil
- Oct 4th, 2006
Trading Community Architecture (TCA) is a structure designed to support complex trading relationships within an organization. The TCA model revolves around the party concept and the relationships associated with it.
-
What are the changes 10.7 to 11.5.9?
sudheer12d
- Jan 18th, 2007
Hi Navigation Changed for all the modulesFeel & look is chnaged.Email notification is enabled in 11.5.9Extra Forms are added to the modules for the ease understanding for the usersMany DFF's are&n...
sravan
- Oct 19th, 2006
some extra colourswork flowadditional segments in gl modulethese r some of the changes
-
How to run a report in a multi org environment for all orgs at one stroke Typically, to run for a single org, in the before report trigger, user_exit FND GETPROFILE is used. What if the report at a single run has to generate data for all offices.
vipulgosai
- Apr 25th, 2008
Hi,Use Base table instead of multi-org table. Mean to say...use AP_INVOICEs_All instead of AP_INVOICE(view) as AP_INVOICE is multi-org view and it fetch rows based on org_id.
PREM
- Oct 30th, 2006
IN THE CONCURRENT PROGRAMM FORM OR WINDOW U HAVE "COPY TO' OPTION AT THE BOTTOM LEFT. CLICK THAT OPTION AND THE SAME REPORT CAN ATTACH TO OTHER ORGANIZATIONS REPEAT IT FOR MULTI ORGANIZATIONS.
-
What is an OPEN PURCHASE ORDER, What is the difference between POSTING JOURNALS and UNPOSTING JOURNALS, What is the need for posting journals in GL module?
rajeshnrk8
- Mar 25th, 2009
Posting journals will have the status as 'P'. We need to post the journals in order to reflect the journals amount in the financial statements.
rakesh.apps
- Aug 8th, 2007
Purchase Order whose status is OPEN is called?OPEN?Purchase?OrderThat means the PO is raised say some item x 50kgs,?but?the?supplier?send?the?x?item?say?25?in?one?shipment i.e?still?supplier?has?to?send the another 25kgs to fulfill?the?PO,?then?that?PO?is?said?to?be?OPEN?Purchase?Order.
-
What is the difference between sales order and invoice?
Manishas
- Feb 26th, 2007
1> Sales Order is for Material requirement and Invoice is for Payment requirement.2> Sales order comprised of a Material related Information(Customer info, Material qty, price). &...
Namita
- Feb 20th, 2007
Sales order is list of material that a customer is buying from a comapny having useful information as such order no, customer information.Invoice is defined as bill for any purchase.
-
Where do you use parametrized cursor in oracle apps? Explain with real-time example?
aksesa
- Apr 5th, 2010
Normally when we want to process the bulk records that time we use the parameterized cursor.Eg: If we want to extract certain PO details every day for DATA WAREHOUSE extract then we have to use the parameterized Cursor. In cursor parameter we can pass status of PO, Extract Date etc.
trraka
- Jan 23rd, 2008
Parametrized Cursors are frequently used when picking the data from master -detail tables .(Generally in interfaces) Or the same table with header as well as line informationcursor c1 is select a...
-
What is the difference between parameter passing by reference and passing by value
aksesa
- Apr 5th, 2010
In parameter in stored procedure is passing by refrence. OUT parameter is passing by value. If we want to use pass OUT parameter as passing by value then we can use NOCOPY for OUT parameter which will be used as passing by reference.
Senthil
- Aug 6th, 2007
IN parameter and IN OUT Parameter are the parameters can be passed by reference or Valur whereas OUT parameters are passed by value.
-
What is in-bound interface and out bound interface
rajeshnrk8
- Mar 25th, 2009
Inbound interface: We load the data which we got from the legacy systems.Outbound interface : We extract the data for legacy systems.
anil kumar
- May 29th, 2007
Inbound Interface: The Data that is being brought in to oracle application from markets?Eg: Purchase Requisitions (From Market-->Oracle)Out Bound Interface: The data that is being sent to markets fro...
-
-
-
-
Oracle Apps Technical Interview Questions
Ans