Oracle CRM Interview Questions and Answers

Oracle CRM is one of the leading players of today’s CRM market which can boast with a robust and intuitive interface, and a variety of product lines and deployment models. As diverse as it is, Oracle CRM makes customer relationship management easy for businesses of all scales and industries, allowing them to optimize their sales processes, and boost sales productivity.

The tool is enabled to regulate and manage customer relationship all the way from lead qualification and categorization to opportunity tracking/management, including in the meantime forecasting optimization, analytics & reporting, and a set of powerful historical analysis for smarter business decisions. Information is properly organized, and easily accessible by everyone in the team, from any device. On top of that, Oracle CRM is empowered with strong, integrated marketing campaign management features, lead nurturing, and ROI measurement tools.

1. Partner relationship management
2. Social CRM
3. Customer data integration
4. Quote and order capture
5. Business Intelligence(BI) applications
6. Price Management
7. CRM gadgets
8. Self-service and eBilling
9. Integration to Siebel CRM

OM does not support credit card RMAs right now.

On the Sales Order form, after you have entered the header and line Information, click on the ‘Actions’ button. >From the LOV choose ‘Return Line Lot/Serial Numbers’. This will allow you to enter the Quantity and Serial Number range.

You have only one option of pricing when doing an RMA: Price as of current date.

No. RMA Receipts are not supported in Receiving Open interface. While saving through the forms in immediate mode, certain actions are taken to update the Order Management tables which will not happen if an API is used to populate the rcv tables. This is true for Batch mode also.

The TOP Model Line is not shippable but has a price on it to generate the credit. But the Configured item is shippable and is the one which is received as a RMA in the Warehouse but it has no price on it. So it doesn’t generate the credit. It acts as a fulfillment (pre-condition) for issuing credit on TOP model line RMA.

The Additional Line Info > Return Activity will show data for the Outbound line against which the Return is created. This screen won’t show information for a Return Line. So query the Order/Line against which the RMA is created and go to Additional Line Info -> Return Activity. You will see the details about the return lines for that outbound line. When a return is created from an outgoing order, and that order is received, the receiving activity appears on the Return Activity form of the original order (the one you copied from).

Order cycle was used in previous releases. For release 11I, Order Management started to use Oracle Workflow to control the cycles. The name of the order cycle was replaced by transaction type. Its configuration has also changed. To see more information about it you can see the Oracle Workflow Guide release 2.5 and the Order Management User Guide.

The default is Entering.

When a new hold with NO responsibility to apply and Remove the hold has been created, then any responsibility can apply and Remove the hold. However, if the newly created hold is assigned a responsibility to one of the functions, this does not mean any responsibility can perform the corresponding function.

Ex: Create hold – Management Review

Assign Order Management Super User the ability to apply the hold.

Result: Order Management Super User can apply the hold, but no one can remove the hold.

• Orders Organizer
• Query for an order number on the Main tab
• Click on Actions button
• Click on Additional Line Information, or Additional Header Information (depending on if it is line or order hold).
• Click on Holds tab all lines/orders will show the Hold Source history here. Hold Comments/Release Comments are shown here too.

The Hold Checkbox is missing on the Sales Order Header and/or the Sales Order Line?

When a newly created sales order goes on hold, the user will not see the hold unless one navigates to the Actions / Additional Order Information button. The hold MUST be visible on the Sales Order header as well as the Sales Order line to which the hold applies (as it did in Release 10.7, 11).To clarify one thing: In R10.7/R11.0, user would see HOLD checkbox at the order level and at the line level, and IN ADDITION, user could press the HOLD button to see the hold details. In R11i, user can ONLY see the hold details in Additional Order Information.

Only user defined holds are listed in the LOV. For example, since Credit Check is a system defined hold, it is not allowed to be applied manually.

Yes, this will normally default from the customer, but the you can override this on the order line.

The lead time will be calculated according to your setup in the supply chain planning sourcing rule.

Based on the information about supply and demand from various resources (can be gathered from multiple instances), the planning engine will create plans and available information. When the request is sent via an API (information request being: ‘I need this product, this quantity, on this date’), the question will be answered by the central planning server.

Latest Acceptable Date is available as a Folder Field in Sales Order Pad and iti s updatable as we expect a Customer/CSR/Selling Org to decide what is the acceptable scheduling window. You can restrict access to this field. It only really affects ATP-enabled items as Non-ATP items are never scheduled by APS (Planning).

Schedule Ship date is the date planned for shipping an item. While scheduling, availability of the component is checked and this is always current date or future date. Based on the availability, schedule ship date is populated. System will not be able to check the availability in past and the schedule ship date will always be system date or a future date.

Keyflexfields are used throughout the Applications to uniquely identify information’s such as GL accounts, INV items, Fixed Assets and other entities that every business needs to keep track of.

Descriptive flexfields enable you to capture additional pieces of information from transaction entered into Oracle EBS.

DFF and KFF share common features. They are multisegment fields. Application validates individual segments based on makes value set rules and ensures that the segments makes sense using CVR (cross-validation rules).

DROP TABLE Removes one or more table definitions and all data, indexes, triggers, constraints, and permission specifications for those tables.

TRUNCATE TABLE Removes all rows from a table without logging the individual row deletions. TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause; however, TRUNCATE TABLE is faster and uses fewer system and transaction log resources.

As far as speed is concerned the difference should be small. And anyway, if you don’t need the table structure at all, certainly use DROP.