Oracle Install Base

Oracle Install Base (IB) is an item instance life cycle tracking application.

Mark item as Install Base Trackable in Oracle Inventory and when item instance is created, it's created in IB (CSI_ITEM_INSTANCES) and further changes traced (CSI_TRANSACTIONS, CSI_ITEM_INSTANCES_H). Traced from the time it's received in inventory.

Usually serialized items, When a trackable item is defined in Oracle Inventory as non-serialized, it is typically for smaller objects (can be tracked only as a group) whose real-world instances do not require individual tracking e.g. screw.

Items can be serialized at receipt or at sales order issue.

Oracle Install Base interacts with: 

• Oracle PO (PO receipt --> Update Inv Data --> IB created or changed), 
• Oracle WIP (Issue components --> Complete work order --> Update Inv Data --> IB created or changed),
• Oracle OM (),

To find the Installation Details for a Sales Order number:

select ctld.*

from csi_t_transaction_lines ctl,

csi_t_txn_line_details ctld

where ctl.transaction_line_id = ctld.transaction_line_id (+)

and ctl.source_transaction_id in

(select line_id from oe_order_lines_all where header_id=

(select header_id from oe_order_headers_all

where order_number = ))

Oracle CRM Service - Elementary

In Oracle CRM modules, apart from creating username it's important you create them as Resource and assign a role.

Step1. Create a new employee

(R) HRMS Manager
(N) People --> Enter and Maintain

Step 2. Create applications username

(R) System Administrator
(N) Security --> User --> Define

Step 3. Import Resource into CRM

(R) Manager
(N) Setup --> CRM Foundation --> Resource Manager --> Maintain Resources --> Import Resources

Step 4. Assign required role(s) to the resource

Navigation same as Step 3 and go to tab 'Roles'.

--------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------
The CRM 'Service Suite' components:

• TeleService module
• Depot Repair module
• iSupport module
• eMail Center module
• Preventive Maintenance module - uses CMRO (Complex Maintenance, Repair and Overhaul) to create SR and tasks. 
• Service Contracts module
• Install Base module
• Knowledge Management
• Common Application Components like Territory Manager, Task Manger, Resource Manager.

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

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

Process Flows:

Service Request to Resolution

There are three components to this flow:

1. Service Call Intake (SR created via TeleService, iSupport, eMail Center)
2. Execution Channel
3. Service Execution

The Execution Channel has three alternatives:

• Technical Support
• Field Service
• Depot Repair

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

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

Issue: User Maintenance link under CRM HTML Administration throws message, "You don't have sufficient privileges to view this page."
Sol: Login with SYSADMIN account and assign JTF_SYSTEM_ADMIN_ROLE to your id.

Issue: When creating a new Service Request (SR), it throws error message, "The user-to-resource link has not be setup correctly."
Sol: Either the user is not yet defined as resource or User Name is not defined (or re-define) in the Resource Details screen (under Maintain Resources)