Oracle EBS Interview Question And Answers

What is Oracle Alert?

Oracle Alert, allows you to view the critical activities in your database immediately.

Name the products in the Oracle E-Business Suite Technology Layer?

The products in the technology layer are:

• Oracle Application Object Library (FND)
• Oracle Applications DBA (AD)
• Oracle Common Modules (AK),
• Oracle Applications Utilities (AU),
• Oracle Workflow (WF),
• Oracle Alerts (ALR),
• Oracle Applications Framework (FWK).

There are six types of SQL statements, name them.

The SQL Statements are:

• Data Definition Language (DDL) Statements,
• Data Manipulation Language (DML) Statements,
• Transaction Control Statements,
• Session Control Statements,
• System Control Statements,
• Embedded SQL Statements.

What is the concept of ‘multi org’ and how can I create a report for it?

The term ‘Multi org’ means a single installation of “Oracle Applications” will support multiple organizations with the use of a different ‘Set of Books’, and support any number of ‘Legal Entities’.

E.g. Take the Example of TATA Industry. TATA will install the business in a single instance, but it supports these multiple businesses: Tata Sky, Tata Motors, Tata Consulting Services and etc.

The ‘Multi org’ is also a server side enhancement that enables multiple business units in an enterprise to use a single installation of Oracle products.

This is the set-up procedure:

• We have to defineSOB.
• We need to define Business Group.
• Identify GRE/ Legal Entity.
• Identify the Operating Unit.
• Conduct an Inventory of Organization.
• Conduct a Sub-Inventory.
• Identify all locations.
• You should take note that after defining the ‘OU’, you need to run a report ‘ADADMIN’ to convert to ‘multi org’ for one time only.
• After the setup, run ‘Seed data Replication’ report.

For a ‘Total Profile Option’:

• MO: Operating Unit
• MO: Top Reporting Level
• HR: User Type to HR User
• HR: Security Profile Option
• HR: Business Group System

What are the steps of doing a ‘multi org’?

In doing a ‘Multi org’ setup, you have to undergo several procedures.

First, you have to create your own Business Group from HRMS and give your BG information. Assign this Business Group at the Responsibility level of Profile Options, from the system administrator. BG is nothing but your own organization.

After that define the SOB, and then assign it to all your responsibilities using a system administrator.

Then, define your Legal Entity and give your LE accounting information. Assign your SOB to LE.

From there, create your Operating Unit; give OU information, assigning your LE to OU.

Now, create the Inventory Organization, give the accounting information, and assign your OU to the Inventory organization.

Assign your OU at the responsibility level of Profile Options.

Finally, run replicate the Seed Data program.

Multi org setups will now be completed.

One can implement a single module or more than one module for a client. In that case, if a company wants to implement AR alone, how will it be possible for them to have a Multi Org Set up?

The Multi org forms are available in HRMS module and in Purchases Module, but if the client is not interested in these 2 modules and he is only interested in AR alone, should the following actions be considered?

He cannot implement Multi Org.

He should buy some other modules.

Oracle will include those necessary forms in AR module and give it to the client.

Can the shared licenses be misused by implementers or clients? Can oracle identify if such a thing happens?

The third one is the closest answer. What you buy from Oracle is a license to use the applications that you pay for. What Oracle ships to you on CD is the entire Applications suite. This is because of the dependence of each module on other modules.

You have to make sure that the people who are implementing the application have access to all of the Responsibilities required to do the setup, but the end users will only have access to the Responsibilities for Receivables (or those necessary to perform their jobs).

When you license an application in the Oracle E-Business Suite you also get a so-called "shared" license so that you have access to the necessary functionality in other applications. For instance, if you buy Oracle Purchasing you also get access to simplified forms for registering organizations.

The entire E-Business Suite is installed when you install the Oracle E-Business Suite. So in theory, you could also use all of it even though you have only licensed parts of it. Oracle has no more control over this than over other aspects of your license such as number of CPUs, number of users and number of instances, though I am sure they have something in their contracts that ensure that audits can be performed.

Ignoring the ethical and legal ramifications of such abuse, I still do not think it would be a good idea. You would have absolutely no support for the unlicensed applications and Oracle might become curious if you started to download patches for applications you have not licensed.

What are the changes required to be done?

You can change the values in the Value Set and add new values, but you cannot change the size, length and number of characters. Please refer to the Flexfields manual for further information.

Data Load is an end user tool. Loading values into a Value Set should be performed by a Functional person, whether they do it manually or using Data Load.

Visit the Data Load site for yourself and look at the user guide and the specimen spreadsheets. This should give you enough information to get you up and running.

Can it be used in case of outsourcing for different organizations?

Yes, you can use one installation for many businesses. That is the point of multi-organization. For unrelated business you should use different operating units for the various businesses.

There are some caveats:

• Not all applications are multi-organization. This could potentially reveal information about one business to people from another.
• Various customers have various needs and might require extensions and functionality found in future versions at different times.

Can you tell me if there’s any difference between “ORG_ID” and “ORGANIZATION_ID” in a multi-org environment?

 “ORG_ID” is a column used to refer to an operating unit in a multi-org enabled application. “ORGANIZATION_ID” is just a reference to any organization unit.

“Ord_id” refers to the operating unit and “Organization_id” is the inventory in any operating unit.

Under one “Org_id”, you can have multiple “organizations_id” or inventories.

To see the value of “org_id” in apps, go to Diagnosis->examine->select “$profile block” and column “Org_id”.

In Oracle Inventory, when you open any form, it will ask you first to select an organization. There is a form called “Change Organization”, that is the inventory needed to select or the organization.

What is an Accounting Flexfields?

A basic difference between flexfield and other normal fields is that you can configure flexfield according to your requirement.

Meanwhile, the Text Field is a base.

The Flexfield is basically a functionality provided by Oracle to capture data that is not included in the standard product.

There are 2 types of flex field:

• Key Flexfield (KFF)
•         Descriptive Flexfield (DFF)

KFF is an intelligent Flexfield and is used in accounting and item level capturing the data. These are used in situation where complex data is involved and indexing is important. It is application dependant.

DFF is used to capture the data that is not supported by standard product. It is application dependant and can be configured as required. You can have more than one text field in DFF. This gives you more room and flexibility to capture the data and fulfill the requirement.

To capture ‘Accounting Codes’, you can use KFF. This is an ‘Intelligent KFF’. It can capture the accounting codes that are complex.

 In Oracle there are background processes, which processes are the most important?

The background processes in Oracle which are most important are:

• SMON (System Monitor Process),
• PMON (Process Monitor Process),
• DBWR (Database Writer or Dirty Buffer Writer Process),
• LGWR (Log Writer process),
• ARCH (optional archive process).

How many access control layers do you have within Oracle Applications?

There are six access control layers, the first three layers of the stack are called core security; the first layer is function security, which is the base layer of the security stack, the second layer is data security, and the third layer is role-based access control (RBAC). Layer 4-6 is known as the administrative features; the fourth layer is called delegated administration, the fifth layer is provisioning features and the sixth layer is called self-service and approvals.

How many program library types? Name the library types?

There are two program library types, which are concurrent library and transaction library.

What is the default structure name for all descriptive Flexfields (DFFs)?

The name for the default structure is called Global Data Elements.

The: block. Field mechanism is used for? What happens if this mechanism is used in your value sets?

This mechanism is only used for backward compatibility; if you use the: block. fieldmechanism in your value sets, your value sets will not be compatible with future releases of Oracle Applications.

What are the steps to enable the shorthand entry feature?

First you would go to the shorthand aliases window, you would then select the name and structure of the key flexfield, and thirdly you would want to check the enabled check box located in the shorthand region and then enter a prompt for the shorthand window. After you complete those steps, you would enter the maximum alias size, and then save your changes.

What are the key flexfields that are only used in Oracle Applications by the Accounting flexfield and no other flexfield?

The key flexfields are

parent,

rollup group,

hierarchy level,

segment qualifier information.10

What are the seeded business events in the General Ledger?

The seeded business events are:

• Period Re-opened,
• Journal Import Completed,
• Account Disabled,
• Period Opened,
• Period Closed,
• Journal Import Started,
• Posting Completed,
• Secondary Ledger Deleted,
• Reporting Currency Deleted,
• Accounting Setup Completed.

How would you define EDI?

EDI stands for Electronic Data Interchange; EDI allows business documents to be transferred electronically between two organizations computers systems, over a communication network.

Why not take a look in the Oracle Applications Developer's Guide that is available for download from the OTN?

Of particular interest would be Chapter 6 "Setting the Properties of Widget Objects" (especially the section named "Setting Item Properties") and Chapter 28 "Using the CUSTOM Library".

Something like this in the EVENT procedure in the CUSTOM package should do it:

IF form_name = '<name of form>'

THEN

IF event_name = 'WHEN-NEW-FORM-INSTANCE'

THEN

app_item_property2.set_property(

'<name of block>.<name of item>'

, REQUIRED

, PROPERTY_ON

);

END IF;

END IF;

Is there any way to compile the program in the server?

You can compile the library on the server using the f60gen command. The syntax for compiling an Apps Forms library module is:

‘f60gen module=library_name.pll userid=apps/password module_type=library batch=yes compile_all=special’;

I think you will find the Oracle Forms in Applications FAQ, in Metalink note 177610.1 useful.

Do we have to change any attribute or flag values in the order header interface tables ?

One suggestion is you can make quantity zero for all the line.

Another suggestion is the following:

If you created the ‘Order’, the header level ‘Status’ is "Entered". Click the ‘Action’ button; selectthe ‘Cancel Action’ from list of values. One screen will appear there, select the ‘Reason’ and enteryour comments. Click ‘OK’. The ‘Order’ and ‘Lines’ will now cancel. Re-query the order and check the status for ‘Header’, and then the ‘Lines’ will get cancelled.

Interested in mastering Oracle EBS Training?
Enroll now for FREE demo on Oracle EBS Training.

What are drop-ship orders from Order Management and Kanban orders from Inventory?  

Drop ship items are shipped directly from a supplier to the customer, who placed the order. The customer calls with a request for goods, which are captured in a sales order. A purchase requisition, then a purchase order is generated to notify your supplier about the requirement. After the supplier has shipped the item to the customer, they notify your purchasing department. Then a regularly scheduled automatic interface updates the sales order with this data. Once purchasing enters receipt information, the sales order information is passed to Accounts Receivable for Invoicing.

Kanban is a replenishment method where signals were made in the form of color-coded cards to indicate the need of replenishment.

Kanban is a means of supporting pull-based replenishment in manufacturing systems. A Kanban system is a self-regulating pull system that leads to shorter lead times and reduced inventory.

Kanban systems are typically applied to items that have relatively constant demand and medium-to-high production volume.

Kanbans represent replenishment signals that are usually manual and highly visible, such as a color-coded card that moves with the material, a light that goes on when replenishment is required, or an empty bin that is moved to the supply location to trigger replenishment. The system includes an API that can be called by external systems, such as bar code readers, to trigger replenishment signals.

Kanbans can be replenished from an external supplier or an internal organization. When I went to release the order, the document set is defined as seeded for Pick Slip Report.

When I clicked Concurrent Button on Release Order Form it needs to generate a Pick Slip Report. It shows "No Data Found" on the report when I try to view the output.

What could be the cause for this?

You may not be given the parameters for that concurrent request. For this, you have to do some basics setups.

Go to the System administrator> program define> query for Pick slip report.

In output, blockcheck the format;

 (B)Parameters > check for the parameters;

You can also try to find your attached file.

There could be two (2) possibilities for this.

Checkthe item attributes > Order management in item master.

From there, you have to check the following:

ATP should be null;

defaultpick slip ruleshould be defined;

In the organizational setup, check the ATP & Pick slip is defined as follows: inv > setup > org > parameters > tabATP,pick slip

'A period with this period type, period year and period number already exists.'

How can I change the sequence numbers?

If you have not done any transactions, delete all the periods and re-enter it again.

The Period Type, Period Year, and Period number should be unique.

Another solution is to change the numbers of one row at a time and save the changes after each update.

Why was the list of values for the account numbers not displayed?

Check the following:

Account Type --> In general, this is an OE account.

Allow Posting --> Allow posting should be "Yes".

Enabled --> Make sure this account is enabled.

I created three (3) definitions for accounting flexfield and attached value sets to them. However, when I compiled them, the following error occurs:

“APP-FND-00668: The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the function: FDFRKS could not find the structure definition for the flexfield specified by Application = &APPL, Code = GL# and Structure number = 52733 (APPID=101)

--------------------------------------------------------------

FDFBKS: REQUIRED constraint specified for the GL_ACCOUNT qualifier is not satisfied.”

What could be the reason for this?

You can check the following:

Log on and select “Responsibility”.

(N) UK/IR AP Manager User Name Password

Enter the user name and password with the ‘appropriate authority’ > ‘Welcome’ screen opens > ‘Navigator screen’ opens;

2. Run the “Payables Transfer” to “GL” (N) Other > Request > Run > Submit request window opens;

>Single Request radio button; >(B) OK; >Parameters window opens;

>Go to Name > Payables Transfer to General Ledger;

Parameters should appear as follows:

Set of Books > Transfer Reporting Books: No To Date: Today’s date Journal Category: All Validate Accounts: Yes Transfer to GL Interface: In Detail Submit Journal Import: Yes

(B) OK > Request is submitted; (B) Submit > Requests window opens displaying all requests;

(M) View > Requests; (B) Find > Select Request of interest;

(B) View Output > The report opens;

As for the error, you can view ‘log file output’ or some of the transaction are stuck in AP interface. Clear these interface and run the concurrent program.

If any CCID is incorrect, correct it and then run transfer to GL.

Check and get back on the same.

When I run the 'Payables Transfer to General Ledger' program in order to post accounting entries from payables to General Ledger, there are some accounting lines which are posted to GL, but their status is still 'Unposted' in Payables. That's why I’m not able to close the ap period.

What could be the cause and what can be the solution?

To solve this problem, you can try the following:

Run the appropriate diagnostic for Payables. There is one for period end.

Search MetaLink to see if anybody else has encountered the same problem before.

Log an SR with Oracle Support.