Oracle Applications – Technical Interview Questions


Hello Friends, Upon requests on some of my friends, i am posting few more generic oracle applications’ questions. hope this will give you overview of generic features. do share your feedback if these are good n useful.

what is a flexfield qualifier ?

Oracle Applications products use flexfield qualifiers to identify certain segments used for specific purposes. eg: segment named ‘Account’ is qualified as ‘Natural Account’so that it identifies Accounts, similarly a segment named ‘Company’ can be qualified as ‘Balancing Segment’, i.e, for these segment values B/S can be brought out in Accounting Flexfield in GL.

A flexfield is made of segments and oracle identifies if particular segment in the accounting flexfield is an account segment or a company segment, based on some predefined values called as flexfield qualifiers which are assigned to the segments to look meaningful for defining the accounting flexfield. Eg: Account segment uses Natural Account segment and the company segment uses Balancing segment are mandatory for defining the accounting flexfield. Other values are Cost center segment, Inter company segment, secondary tracking segment

What is the difference between configuration, conversion, and customization?

Conversion ,customization and configuration are part of an oracle implementation project they come in this order

1. configuration/set up

2. Customization

3. Conversion

Configuration is setting up customer specific requirement which generally exist in oracle apps customization is filling the gap between oracle apps and Customer requirement by developing some extension and solution design

Customization is relatively different thing, something that is not a part of oracle apps core product but the client requirement demands it we go for Customization. If the functionality demanded by the client exists in the application, it is to be configured according to his needs by taking some data, this is called configuration

Conversion is structural change of customer data in a form which is compatible with oracle database best of luck. Conversion is the process of mapping the tables from a legacy system to apps system. Sometimes conversions can be from one version to other

Where we can check the status of PO.

In po_headers_all authorization_status coloumn is their we can find through this coloumn

What is back order in OM

There are few reasons that a scheduled order could be Backordered during pick release process.

1. In-sufficient onhand

2. Order might be put as ‘Pick release hold’

3. If it’s a lot controlled item being involved then some of the factors will be checking at picking rule setup (like Lot- expiration date, etc) and tured to ‘Backordered’ incase the criteria does not meet.

Where we find the status of order information.

Order header status is in oe_order_headers_all table reference with flow_status_code column and order line status would be oe_order_lines_all table reference with flow_status_code column.

What are the tables of auto invoice?

RA_INTERFACE_LINES_ALL, RA_INTERFACE_DISTRIBUTIONS_ALL ARE THE TWO INTERFACE TABLES MAINLY USED BT AUTOINVOICE.  FURTHER DATA READ FROM THESE TABLES WILL BE INSERTED INTO RA_CUSTOMER_TRX_ALL , RA_CUSTOMER_TRX_LINES_ALL , RA_CUST_TRX_LINE_GL_DIST_ALL , AR_PAYMENT_SCHEDULES_ALL AFTER VALIDATING.

For report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we will make it.

While defining Parameters you can set range option(in concurrent prog parameters window). Select low for from_Date and high for to_Date.Then it will not allow for from_date > to_date.

How to find the custom directory in front end.

From Application Developer responsibility, navigate to Application –> Register. Query for the custom application name. The value in the field Basepath, is the OS system variable that stores the actual directory info.

What are the execution methods in oracle apps?

1. Host

2. Immediate

3. Java Stored Procedure

4. Java Concurrent Program

5. Multi Language Function

6. Oracle Reports

7. Request Set Stage Function

8. Pl/Sql Stored Procedure

9. Spawned

10. Sql*Lodar

11. Sql*Plus

12. Perl Concurrent Program

What are APIs

API stands for application program interface. Oracle has its own api facility to transfer data from a external source to oracle base table so api is an standard oracle tool to transfer data to oracle database. It is a very simple method and a person with no technical background also can use api. Example-uploading journal and budget data through API.

Thanks – plz share questions if you have more in this area. also share your comment/feedback. Shivmohan Purohit

Shivmohan – Oracle E-Business Suites


Just to thought how to define Oracle E-business Suite term.

What is Oracle E-Business Suite

 

Oracle’s E-Business Suite is a fully integrated system package that provides access to Oracle’s business applications in a database environment. The suite is available in internet format and provides strong flexibility in integrating Oracle systems across applications. The E-Business Suite includes multiple products, such as Oracle Financials (Oracle General Ledger, Oracle Payables, Oracle Receivable), Oracle Logistics, Oracle HR, and Oracle Sales. The most current E-Business Suite release is edition 12, which debuted in January 2007

 The suite is comprised of a three-tiered hardware architecture. The tiers are database, application and PC. Sometimes referred to as Oracle’s “E-Business Suite”, Oracle Applications (currently Release 12, released 31st January 2007), contains several product lines.

 

Thanks – Shivmohan Purohit 

 

Shivmohan – Oracle Financials


What is Oracle Financials?

 

Oracle Financials products provide organizations with solutions to a wide range of long- and short-term accounting system issues. Regardless of the size of the business, Oracle Financials can meet accounting management demands with:

Oracle Assets: Ensures that an organization’s property and equipment investment is accurate and that the correct asset tax accounting strategies are chosen.

Oracle General Ledger: Offers a complete solution to journal entry, budgeting, allocations, consolidation, and financial reporting needs.

Oracle Inventory: Helps an organization make better inventory decisions by minimizing stock and maximizing cash flow.

Oracle Order Management: Provides organizations with a sophisticated order entry system for managing customer commitments.

Oracle Payables: Lets an organization process more invoices with fewer staff members and tighter controls. Helps save money through maximum discounts, bank float, and prevention of duplicate payment.

Oracle Purchasing: Improves buying power, helps negotiate bigger discounts, eliminates paper flow, increases financial controls, and increases productivity.

Oracle Receivables:. Improves cash flow by letting an organization process more payments faster, without off-line research. Helps correctly account for cash, reduce outstanding receivables, and improve collection effectiveness.

Oracle Revenue Accounting Gives an organization timely and accurate revenue and flexible commissions reporting.

Oracle Sales Analysis: Allows for better forecasting, planning. and reporting of sales information.

Thanks , plz share your feedback / comments
Shivmohan Purohit