Thursday Feb 05, 2015

How To Upload Meter Readings Using the Install Base Counter Readings Open Interface

Do you need some assistance when loading counter readings into Install Base?

We have recently updated the following document to provide you with instructions on how to complete the process.

How to Upload Meter Readings Using the Install Base - Counter Readings Open Interface (CSICTRML) Doc ID 1909396.1

This also has an example template on how to populate mandatory fields in the CSI_CTR_READINGS_INTERFACE table.

The following fields are mandatory and must be populated:

  • counter_interface_id
  • batch_name
  • source_transaction_date
  • process_status
  • counter_id
  • last_update_date
  • last_updated_by
  • creation_date
  • created_by
  • source_transaction_type_id
  • counter_name

Once you have loaded the data into the interface table run the Install Base - Counter Readings Open Interface program.

Counter Readings Open Interface Program

Note: DO NOT accept the default date ranges.  By default they are set to the same value therefore will not find any records.

If you require further assistance on this topic, please log a Service Request with Oracle Global Support.

Wednesday Dec 17, 2014

Spares Management Planner's Dashboard Updates

The Planner's Desktop provides functionality to plan and view inventory across the entire field service supply chain. This feature is also available as a form or window and an Application Development Framework (ADF) page, named Planner’s Dashboard, from the Spares Management responsibility.  The Planner’s Dashboard is the ADF version of Planner’s Desktop. This page consists of the following features: spares planning, view inventory item details, search planning hierarchy nodes and planning parameters.

The EBS 12.2.4 Spares Management Planners Dashboard functionality requires deployment on the WebLogic Server.  Previously the ADF Planner'st Dashboard had to be deployed on a standalone WebLogic Server, but it is now possible to integrate it into the WebLogic server that is included with the EBS install.  See Doc ID 1925014.1: Spares Management: 12.2.4+ ADF Planners Dashboard Deployment Guide for details of steps to implement the Application Developers Framework (ADF) based Planners Dashboard in 12.2.4 and also some troubleshooting hints.

Monday Nov 17, 2014

New In Oracle Teleservice: Raise Service Request Against Any Installed Instance

When raising a new Service Request in Oracle Teleservice, it was only possible to specify an install base instance that was owned by the customer on the service request.  Now, a new profile option 'Service: Restrict Installed Base by Customer' has been added to allow all instances to be visible and selected within the service request.
  • If this profile is set to Yes: when a Customer party is entered, the Instance LOV will show the Installed Base Instances that have this customer party as either an owner or a related party.
  • If this profile is set to No: The instance LOV will show all active Installed Base instances.
  • The default value for the profile is 'Yes'.
This new functionality is available via the Service October 2014 RUP Patch 19625361:R12.CS.B.

We advise that this profile be used in conjuction with the profile option 'Service: Enable message when Customer Party and Incident Customer are different' so that the user is aware that the selected instance is not owned by the SR customer party.  For more details, see the Functional Impact Document for October 2014 in Functional Impact Document - 12.1.3 Consolidations - CS Cumulative Patches (Doc ID 1608427.1).

Friday Nov 07, 2014

Service Contracts APIs are Finally Here!

For some time now customers have been lobbying hard for Public APIs for Oracle Service Contracts.  Now what you've all been waiting for: public APIs for service contracts data creation, update and deletion are finally here!

Many customers implement service contracts while retaining legacy (or building custom) front-end systems for entry of source transactions.  These legacy / custom transaction systems typically handle quoting and order entry and when a quote is approved or a deal is closed, there is a need for back-end programmatic mechanisms to create service contracts for the purposes of future administration, billing and to provide entitlements.   In Release 12.2.4 public and supported APIs for service contracts data manipulation have been provided.

For more details about the APIs see R12.2.4: Service Contracts API Bulletin - Technical Documentation on Available Public APIs (Doc ID 1941609.1)

The following APIs are provided:

API Name


Creating a contract header of Service Agreements, Subscription Agreements, Warranty and Extended Warranty.


Updating contract header information.


Creating a template contract from any contract.


Creating a contract from a template.


Ccreating contract lines of type Service, Usage, Extended Warranty and Subscription.


Updating contract lines of type Service, Usage, Extended Warranty and Subscription.


Generating the billing schedules.


Change the contract status from Entered to Cancelled, Cancelled to Entered and also to different statuses within the same status type.


Terminate a contract/line/subline with various options like suppress credit, full credit or with some override amount.


Delete contract/line/subline.


Renew a contract.


Cascade attributes like dates and price list from headers to lines and from lines to sublines.


Perform QA check and submit the contract for approval for contracts which are in ‘Entered Status’.  Contracts in QA hold status are moved to Active once the contract passes the QA check.


Creating a subline/covered level under a service/usage or extended warranty line.


Updating contract subline.

Wednesday Oct 29, 2014

CRM Service: New Consolidated RUP Patch Released

The September RUP patch for the EBS Service products has been released and the changes are documented in the Functional Impact Assessment document available via Doc ID 1608427.1.

Included in this month's RUP patch are some new features:

  • Ability to have a task view of the Service History.
  • Ability to view "Incident City" in Find SR form grid.
  • Ability to see Tag, Serial, Instance, Item and Item description in Find SR form - Tag LOV.
  • Mass Update Charges functionality.

The Service product releases a RUP patch each month and they are cumulative patches.  New fixes are built on top of the latest RUP patch so it's always a good idea to patch up to the latest Service RUP patch. 

Friday Oct 24, 2014

How to Customize Your Field Service Wireless Application

For some time now customers have been asking for the ability to customize the Field Service Wireless application so that custom pages can be added.  The Field Service development team listened and have now incorporated that functionality into the product in 12.1.3+.

The application now allows you to add a custom page built using JSP technology using AOL/J infrastructure.

Refer to Doc ID 1936276.1 for full instructions, including sample JSP code.

Monday Sep 08, 2014

How to Fix FRM- and ORA- Errors in Oracle Teleservice

We get hundreds of support service requests reporting various FRM-xxxx or ORA-xxxx errors in the Oracle Teleservice Service Request, Contact Center or Tasks forms.  Did you know that there are just a few simple steps to resolving these errors?  The vast majority of these support requests are easily fixed by following one or more of the steps below:
  • Regenerate all JTF, CS and CSC packages, objects, forms and libraries.
  • Make sure that all the required products are set as 'Installed'.
  • Apply the latest Service RUP patch so that you are on the latest codeline.
  • Ensure that you have correctly set the MO: Operating Unit profile.
Want to know more?  Take a look at our Troubleshooting guide: Service: Troubleshooting FRM-40735 Errors (FRM-40105, ORA-06508, ORA-1403, ORA-4062) in Service Requests, Contact Center, Tasks (Doc ID 1326683.1).

Thursday Sep 04, 2014

Implementing SFTP with Paymentech For Oracle Payments R12

Back in October 2013 we passed on the information that Paymentech had announced the decommissioning of the FTP protocol (Payments - Chase Paymentech PTK Decomissioning FTP After July 2014).  The deadline for this has been extended to October 2014.

We are pleased to announce that there is now a patch available for Oracle Payments R12 which will enable the use of SFTP Put and Get protocol for Paymentech.  Please review Instructions to Implement SFTP Put and Get Protocol with Paymentech in R12 (Doc ID 1921905.1) for details of the patch and how to implement this new functionality.

Friday Aug 22, 2014

Channel Revenue Management and General Ledger Integration

Back in February of this year, we told you about the EBS Business Process Advisor: CRM Channel Revenue Management document which has detailed information about the Channel Revenue Management application business flow and explains integration points with other applications.  But we thought that you might like to have even more information on exactly how Channel Revenue Management passes data to General Ledger.

Take a look at Integration Troubleshooting: Oracle Channel Revenue Management to GL via Subledger Accounting (Doc ID 1604094.2).  This note includes comprehensive information about the data flow between Channel Revenue Management and GL, offers troubleshooting tips and explains some key setups.

Let us know what you think - start a discussion in the My Oracle Support Channel Revenue Management Community!

Thursday Jul 31, 2014

Oracle Service Contracts – How to Drive Contract Coverage by Severity

When it comes to service level agreements for service tasks, a common business need is to cover High priority tasks round the clock, but without providing similar coverage to a Low or Medium priority task.  Oracle Service Contracts now provides the ability to define contract Coverage Time, Reaction Time and Resolution Time based on the severity of the task, assisting organizations in providing an appropriate service response according to task severity.   This results in cost savings by avoiding manual interventions that are otherwise needed for modifying the planned end dates and rescheduling tasks as per the severity.

Prior to Release 12.1.3+, users defined Reaction and Resolution Times based on the specific number of hours it took to respond to a task.  With Release 12.1.3+ (via Patch 17891741:R12.OKS.B), Reaction and Resolution Times can be defined as a variable number of hours depending on when a task gets created, thereby ensuring compliance with the promised service level agreements.

For more details, take a look at Oracle Service Contracts – How to Drive Contract Coverage by Task Severity (Doc ID 1911887.1) which explains the new functionality and how to implement it.

Monday Jul 28, 2014

How to Customize the Field Service Debrief Report

The Field Service Debrief Report shows a summary of all the debrief lines added for a task and it contains the customer signature image.  The report is built using the XML Publisher techstack and is generated with two parts:

  • Report Format (using RTF template)
  • Data XML file (generated using the standard code).

A common requirement is to change this report to meet specific business requirements.  In Customize Field Service Debrief Report (Doc ID 1669768.1) we discuss how to customize this report for both Format and Data.  The note also provides sample hook and java code to generate the custom data XML.

Wednesday Jul 23, 2014

CRM Product Family Latest Patches For 12.1.3

See the table below for recent 12.1.3 RUP patching information for the CRM family products. 

Product Details
Lease and Finance Management Patch 19142659:R12.OKL.B:OLFM : 1213 RUP3 DELTA 24 Doc ID 1906489.1
Core Service
Patch 18843305:R12.CS.B: 12.1.3:BUG FIXES FOR CS:JUNE'14 RUP PATCH Doc ID 1608427.1
Install Base
Patch 18479621:R12.CSI.B - ORACLE INSTALLED BASE 12.1.X CONSOLIDATION Doc ID 1642057.1
Depot Repair

For additional recommended patches (or for other modules), take a look at Doc ID 1400757.1: How to Find E-Business Suite Recommended Patches

Monday Jul 14, 2014

How To Customize Oracle Asset Tracking to Meet Specific Business Requirements

Oracle Asset Tracking (OAT) includes a number of client extention hooks that can be used to change the default logic of OAT. These client extention hooks can offer great flexibility for customers to implement their own logic to derive the attributes for a fixed asset during the asset creation/move processes in the OAT module.

Empty stubs are shipped with OAT via package CSE_ASSET_CLIENT_EXT_STUB (CSEFASTB.pls). Custom code needs to be added in a number of of stubs in order to override the default functionality.

In the document 'How To Customize Oracle Asset Tracking to Meet Specific Business Requirements' (Doc ID 1674412.1) we list the stubs that are available and what each one can be used for.  

This is a great resource for any customers who need to customize the standard functionality.  If you have any questions, remember that our experts in the MOS Install Base Community are there to help!

Thursday Jun 26, 2014

New Service Contracts Functionality - Contracts Merge

A common contracts problem is that assets are spread across different contracts and customers want to consolidate different contracts into one.  Up until recently the only way to do this (other than at renewal time) was to author new contracts from scratch or amend existing ones manually.  With Release 12.1.3+ (via Patch 17861639:R12.OKS), users can now move assets from multiple source contracts to a single target contract using the new Contract Merge functionality.  This helps in improving the maintainability of customer contracts and avoids duplication of assets across the contract base.

A new profile option “OKS: Change Party in Contract Merge” allows users to move assets across the customer base. The re-pricing of the assets moved to target contract is controlled using “OKS: Pricing Method for Contract Merge” profile option. For more details on the implementation steps and functionality, please refer toOracle Service Contracts – How To Merge Assets Across Contracts (Doc ID 1684658.1).  This explains how the new feature works, how to use it and includes a UPK demo.

Questions on the new functionality?  Post your comments in the discussion thread in the Contracts and Lease Management Community.

Tuesday Jun 10, 2014

Universal Work Queue Quick Filter Examples

If you use Universal Work Queue then it's likely that you will want to define and use your own Quick Filters.  Quick Filters allow you to focus on specific work classes based on assigned criteria in a node. This makes it much easier for Agents to view their work grouped in a meaningful way.

How to create Universal Work Queue - Quick Filters (Doc ID 803163.1) gives two worked examples to help you understand how to create your own Quick Filters:
     Adding a 'Resource Group' filter
     Adding an Overdue Amounts filter for use in Collections.

We hope you find these examples useful.  Let us know by providing feedback on the document itself or, why not post to the MOS Service Community with your experience and suggestions.


Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected



« December 2016