APPS-QUIRES

What is the architecture of Oracle Apps? (asked in accenture)

Oracle Application Architecture is 3 Tier Architecture.

1) Database Tier ( Ex:- Oracle )/ Server/ Back End.

2) Client/ Front End ( Ex:- Forms ).

3) Application Tier ( New Tier ).

Hi,Did they ask you about the Apps Architecture (or) the Hierarchy? Generally they ask you about the Apps Hierarchy i.e, how Apps implemenations are done.As per what he/she has mentioned it, it is 3 t...

=======


Difference btw supplier_id,party_id,customer_id ,vendor_id

Jaya is correct. But Party could be the super type that has all the data the other three share in common. All the common data goes in Party, the individually specific data goes in the other three.
Answered by: Jaya on: Apr 28th, 2012

supplier_id - is the party referred as, in payables AP
Vendor_id - is the party refereed as, in PO
customer_id and party_id is party referred as, in AR

===========
Which command is used to execute a store procedure?

There are two ways to execute the stored procedure
1. EXEC
2. Create anonymous block
EX:
BEGIN

END;

IF procedure is declared in package then we have to call this procedure in following way:

========
How many kff's are there in GL module in Oracle Apps.?
1) Accounting Flexfield
2) Repeating attributes Flex field
3)gl ledger flex field(this is used for mass allocation purpose whenever we are run the mass allocation generate report that time added one more segment that is gl leder flex filed.

Only one Key Flex filed is in General Ledger i.e Accounting Flexfield.
=========
Contract purchase agreement.



Contract purchase agreement.
Asked By: chandrashena | Asked On: Oct 20th, 2010
3 answers

What is contract purchase agreement,when do we use it?
Answered by: sunita on: Mar 7th, 2012

Contract purchase agreements are created for suppliers to agree on specific terms and conditions without indicating the goods and services that u will be purchasing,
Answered by: venkat on: Oct 16th, 2011

You create contract purchase agreements with your suppliers to agree on specific terms and conditions without indicating the goods and services that you will be purchasing. You can later issue standar...

===========


Functional consultant
Asked By: arameshofc | Asked On: Dec 28th, 2007
2 answers

What is the procedure for testing after implementation as a functional consultant?
Answered by: Bonthu Nagi Reddy on: Mar 5th, 2012

The functional consultant has to understand the modules they are implementing and the set up and configuration options available, the key skill is being able to map the requirements of the customer to...
Answered by: maheshtiwari9 on: Sep 6th, 2008

Functional guys are needed to provide the necessary information taken from clients or from the legacy system to the techies and rest. They will take care to provide necessary guidance and information given to them.
======


I want to know that if any user is disabled the system administrator responsibility then what I do? Because when this responsibility is disabled then he didn't show from any user. So, this is very critical...
Asked By: devesh | Asked On: Oct 16th, 2005
9 answers

Answered by: Bonthu Nagi Reddy on: Mar 5th, 2012

1) Log on to System Administrator.

2) Go to Security > User > Query the User Name.

3) Remove the Date Effective To( i.e which is end dated as open).

You can be able to view the System Administrator Responsibility.
Answered by: kothariketan on: Aug 16th, 2007

The system administrator responsibility got disabled. We can still use application developer responsibility and add "Define Responsibility" function / screen to existing any responsibility. ...
=========


How do I register a concurrent program in Oracle Apps?
Asked By: Meenu | Asked On: Aug 3rd, 2006
7 answers

Answered by: Bonthu Nagi Reddy on: Mar 5th, 2012

1) Log on to System Administrator Responsibility.

2) Define Concurrent Program Executable.

3) Define Concurrent Program by giving Short name, Application Name, Description & also choose the concurrent program executable.
Answered by: shrikantgarud on: Apr 23rd, 2008

IF YOU ARE REGISTERING A REPORT IN CONCURRENT PROGRAMING THEN FOLLOW:UPLOAD U R REPORT.rdf TO THE SERVER ACCORDING TO THE PATHapps/test/peilappl/gl/11.5.0/reports/USCREATE AN EXECUTABLE ------ WHERE T...

========


How will you submit SQL script like as concurrent request?If the temp tablespace is full every time what we will do?
Asked By: nagaraju | Asked On: Jul 14th, 2007
1 answer

Answered by: Bonthu Nagi Reddy on: Mar 5th, 2012

Apps Developer needs to request Apps DBA to extend the disk space, so that Apps DBA Can add the space which would solve the problem.
========


Profile option fnd: diagnostics = yes
Asked By: PreetiM | Asked On: Dec 1st, 2008
2 answers

What is the use of setting profile option fnd: diagnostics to yes. In which table we can veiw the details.
Answered by: Bonthu Nagi Reddy on: Mar 5th, 2012

This is one of the Profile option, if fnd: diagnostics = yes then we can examine any record information from the Form.

Form> Tools> Examine ( we can able to view the record history ).
Answered by: mpoojari on: Jun 14th, 2009

Self Service has a similar profile option. If the profile option FND: Diagnostics is set to Yes, then anyone can use the Diagnostics Examine function which allows users to change database records.rela...
Answer Question  Select Best Answer

What is recurring invoice report from ap?Can you guide some customized reports from AR,AP,GL and PO module?
Asked By: chiranjeevi reddy | Asked On: Feb 8th, 2006
3 answers

Answered by: Bonthu Nagi Reddy on: Mar 5th, 2012

Recurring Invoice is one of the invoice type which can be used for paying to the customer periodically the best example of RI is for paying the Rent.
Answered by: mahes on: Apr 27th, 2007

Recurring invoice is one of the type of invoice in ap module.After receiving the material from the supplier and will pay the amount against the material. for that we will raise the invoice document. a...
Answer Question  Select Best Answer

Questions for Oracle payables
Asked By: nihar | Asked On: Jan 15th, 2007
17 answers

1. what are the types of invoices , what is prepayment & steps to apply it to an invoice ?2. what are the distribution type while entering the invoice? 3. What's the difference between the "payables open interface import" program and the "payables invoice import" program? 4.What is debit...
Answered by: Ganesh on: Feb 14th, 2012

DRM-Customer raise the DRM to reduce the liability. CRM-Supplier raise the CRM and also we can use for refunds. Example: case1 PO is 100 items. Suppler sent 100 Items We re...
Answered by: Arun on: Feb 2nd, 2012

The "Payables Invoice Import" is designed to import expense reports. The sources are: XpenseXpress SelfService Oracle Project Accounting The "Payables Invoice Import" should be used to import exp...
Answer Question  Select Best Answer

Seeded invoice in accounts payable
Asked By: giri.tsg | Asked On: Dec 22nd, 2007
1 answer

What is seeded invoice?
Answered by: Lokesh M on: Feb 12th, 2012

It is a part of Oracle Order Management Implementation. Seeded meaning initial data or pre-defined data provided with the system. Order Management sends invoices and credit memos to Receivables via t...
Answer Question  Select Best Answer

What are the two mandatory parameters used in procedure?
Asked By: syedrafi123 | Asked On: Jan 19th, 2012
1 answer

Answered by: mechrul on: Jan 23rd, 2012

The 2 mandatory parameters are:
1). RetCode.
2). Errbuff.
Answer Question  Select Best Answer

Oracle workflow interview questions.
Asked By: Sri | Asked On: Oct 23rd, 2006
4 answers

Star Read Best Answer
Editorial / Best Answer

Answered by: Arun.Gopalan

Member Since Feb-2008 | Answered On : Feb 7th, 2008

In General you can anticipate questions such as below
1.  What are threshold in Workflows?
2. What are the Access Levels to be set for various requirements such as Read Only, Customizable etc..?
3. How are Deferred Activities started again?
4. How to Launch a Workflow?
5. What are the APIs are generally used in Workflows?
6. Is it possible to launch, Start different Processes in Workflow from Java?
Answered by: Trupti on: Nov 13th, 2011

3.How are Deferred Activities started again? - The process can be restarted by the Notification System, such as when a user responds to a notification; by the background engine, such as when a deferre...
Answered by: Trupti on: Nov 13th, 2011

2. What are the Access Levels to be set for various requirements such as Read Only, Customizable etc..? Each user of Oracle Workflow Builder operates the system at a certain access level. The access...
Improve Answer

What is profile?
Asked By: Shardul | Asked On: Oct 4th, 2006
8 answers

Answered by: G M RAM on: Sep 20th, 2011

profile is nothing but changeable option it will change the way of application execution,when we create in oracle applications we will design the profile values for every user

you can see the profile levels:

>>>user level
>>>application level
>>>responsibility level
>>>user level
Answered by: Vidya Juturu on: Sep 12th, 2011

Profile is a changable option which will change the Application Execution.
Answer Question  Select Best Answer

Blanket purchase order.
Asked By: chandrashena | Asked On: Oct 20th, 2010
2 answers

What is blanket purchase order? When do we use it?
Answered by: mejigs on: Apr 5th, 2011

Blanket Purchase order can be used when - Duration of contract is fixed- Buyer knows which items to be purchased (fixed set of items)- Quantity of items is unknown- Price given by supplier is fix...
Answered by: vimalasridhar on: Mar 16th, 2011

Blanket Purchase Agreement is raised for long term contract with the supplier. We have price breaks in this. We can create BPA for the item to be supplier by the supplier though we do not know quantit...
=========

===========================

============================
What is record group ?
Answers:

Record Group is an object. It is a collection of records fetched based on SELECT statement. It is of three types:

1. Static

2. Query based

3. Non-query based

The record group has two types
1- static values
2- query based

there is no third type.
==What is the use of cursors in PL/SQL ? What is REF Cursor ? 
If you have not used REF cursor, then when you need to open cursors multiple time, it will throw an error. Because in a procedure there is a limitation availe for maximum number of cursors to be open at any point of time.
===
What the process of po requesation interface
what are the the interface table and basetables
and what are validations?
interface tables: PO_REQUISITIONS_INTERFACE_ALLbase tables: PO_REQUISITIONS_HEADERS_ALL PO_REQUISITION_LINES_ALL PO_REQ_DISTRIBUTIONS_ALL
======
How to pass parameters to a report ? do you have to register them with AOL ? 

 Answers:

frist of all you have to register the parameters of your repot in AOL.

setps

1.switch to SYSADMIN responsibility.

2 register the executable, navigation is

Concurrent>program>executable

3 register the program for this,navigation is

concurrent>program>define

in this form there is a one button <PARAMETER> click and register your

report parameter.

=======
What happens to the form when u register 
Registration of Form in Oracle Apps indicates that the form can be accessed from Oracle Application Responsibility. For that you have define the following.

1. Define the form

2. Define the function

3. Attach the funtion to the Menu

4. Attach the Menu to the responsibility.

=======
What is cost center segment? 
It is one of the segment in the accounting flexfield. It is not necessary that this segment should always be there in the accounting flexfield, but most of the companies include this segment in the accounting flexfield to post the assets and expenses costcenter wise and get the report accordingly.
========
What is the difference between Organization_id and Org_id ? 
OrgId: Org Id is an unique ID for the Operating Unit.Organisation Id: The Organisation Id is an ID for the Inventory Organisation which is under an Operating Unit.

Org Id is an unique ID for the Operating Unit.Organisation Id: The Organisation Id is an ID for the Inventory Organisation which is under an Operating Unit.
=========
List the key flexfields in AR? 
There are 2 Kff's are there in AR1.Sales Tax Location FF-this is a mandatory one to implement2.Territory- its an optional one.
==
What is the difference between data conversion and data migration?
Data Migration is upgrading from one version to another version fro e.g. from 11.5.9 to 11.5.10.. Data Conversion is receiving data from a legacy system or receiving data from another module ( e.g. PA), validating it and converting it to ur our the target module using the standard import program.
========
What are _ALL tables in Oracle Apps? 

ALL tables in oracle applications gives the info about Multiple organizations info about these tables.
=============
Why is FND CURRENCY used in reports 

FND_CURRENCY is basic foundation class used to format currency.
Ex. 1234556
By using above we can print it as
12,34,556
==