Monday Jul 29, 2013

Webcast Announcement: EBS CRM Fundamentals - Resources


Webcast: EBS CRM Fundamentals - Resources

Date: August 13, 2013 at 11am ET, 10am CT, 9am MT, 8am PT, 4pm GMT+1, 8.30pm IST

The EBS CRM team will be presenting a webcast on one of the cornerstones of EBS CRM: resources.  Join the team for this presentation which will review the set up and maintenance of resources and their use in the CRM applications.  During this one hour webcast, we will review the purpose behind resources, how they are set up and pertinent tables regarding resource management within EBS CRM.

Topics will Include

  • Types of Resources in CRM
  • Set up and import of resources
  • Creating groups and roles
  • Maintaining resources
  • Trouble Shooting Resource Issues
  • CRM Resource tables
  • Review the purpose of CRM Sysadmin Roles.

Further details and links to register are in Doc ID 1568712.1.

Friday Jul 26, 2013

Improved PO Approval Analyzer Released

A new version of the PO Approval Analyzer is now available!  Download version 120.4 from Doc ID 1525670.1 to have these great new features and fixes:

  • Improved messages in the health check chart
  • Additional error handling into the output file including parameter errors so there is no need to check the log file
  • Changes in the concurrent program definition to prevent incorrect formatting when viewing the output from the application (requires a reload of file podiagaa.ldt)
  • New reset summary section with a quick overview of the number of documents with workflow errors, as shown here:
Remember that the analyzer script may be safely run at any time.  It can be used either reactively, when you are experiencing issues with a particular PO, Requisition or Release, or proactively, to detect issues with all transactions in an operating unit from a specified date forward.  No data is created, updated, or deleted by this script.  All the details are included in Doc ID 1525670.1.

Tuesday Jul 23, 2013

Buyer Work Center (BWC) Recommended Patching

If you are on R12.1.3 and use the Buyer Work Center then we recommend that you apply the 12.1.3 Procurement RUP Patch 15843459:R12.PRC_PF.B, or higher, to maximize the full benefits of the Buyer Work Center and to resolve known issues.

See Doc ID 1549958.1 for the link to information on Patch 15843459.

By applying this RUP or higher the issues listed in the table below can be prevented/resolved:

BWC Issue

Original Patch Number

Fixed files

Purchase Order Charge Account Is Not Updated When Changing Requestor Or Category in the BWC



When changing quantity at shipment level in update mode from one with no decimals to one with decimals the change is not effective



In the BWC drop down list for Communication Method still includes values that have been disabled.



When searching for a Requisition using a List of Values (LOV), slow response then an error page is displayed: Internal server error



Cannot Enter condition "order is" when accessed from view mode (click on personalize, create new View) while the same condition can be created when accessed from search mode.


DocumentConstants.class 120.207.12010000.13
AgreementsSummaryCO.class 120.6.12010000.3
DocumentNumbersLovCO.class 120.1.12010000.4
DocumentStylesLovCO.class 120.1.12010000.2

After creating a view for Order distributions lines, the view ends in timeout.

11929574:R12.PO.B 120.156.12010000.13

Bad performance on some order views in the Buyer's Work Center. For example choose personalize button from the Orders Tab, create or duplicate a view, choose properties and add one sort setting.

12546854:R12.PO.B 120.10.12010000.6

When attempting to view purchase order from BWC then try to return to the orders home page, The following error occurs:  The Changes you made to this page have not been saved….


In Requisitions BWC, after performing a search, if the user clicks on the 'Requisitions' tab and selects all the  results and add them to the Document Builder, the results table gets populated with all requisitions in the system.

12561719:R12.PO.B 120.14.12010000.2 120.2.12010000.2 120.4.12010000.4

In PBWC PO order view, update is done when user is not in update mode.


When updating a schedule in BWC  click on next schedule, the quantity  is updated on the next schedule with the value just modified.


OrderShipmentDetailsCO.j 120.26.12010000.2 

Slow performance on Orders tab->action view requisitions


From the Orders tab in 'Update PO Line' the Category List of value is not sorted alphabetically.



When searching for requisition lines using a specific criteria like Source, Supplier, Currency system does not return correct values, even if requisition lines with these values exist.  If a new search is made using only Source = Supplier and a Supplier is named, the system will return the correct results including the line with currency used on the first search criteria.



Trying to update an incomplete Finally Closed PO in the Buyer Work Center errs with
You cannot update this document because its status is either Frozen, Canceled, Finally closed, In process,  Incomplete or Pre-approved




When attempting to query a PO in Buyer Work Center the following error occurs:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.

12885750:R12.PO.B 120.2.12010000.2 120.4.12010000.2 120.2.12010000.2

Users encounters 'You have encountered an unexpected error' exception  after clicking the 'Amount' column header to sort the queried Purchase Order distributions in BWC:  Exception Detail: oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.


PoDistributionsSummaryVO.xml           120.27.12010000.4
PoDistributionsSummaryVORowImpl.class   120.26.12010000.3

When attempting to create a View on the Requisition tab in the BWC java.lang.NullPointerException occurs.



On Requisition Summary of BWC searching using non view attribute criteria results in blind query.



Search requisitions summary in BWC, no data found when use the same date in the From/ To fields

13448804:R12.PO.B     120.9.12010000.5

Search on Orders Lines tab, the 'Approval Status' contains list of values not only for Approval Status but also for Document Status.  


OrderLinesSummaryRN.xml  120.31.12010000.5

After cancelling a Purchase Order line and redirected back to the PO lines page , there are no lines displayed.

13776662:R12.PO.B 120.156.12010000.35 120.23.12010000.5  120.11.12010000.8  120.19.12010000.4  

Autocreated PO from Requisition having line type set to 'Amount Based'which is fully received and fully invoiced, the amount Received - Delivered -  billed or Cancelled is always zero

13959141:R12.PO.B      120.84.12010000.30   120.48.12010000.24

While trying to search on the BWC for Orders > Lines  and enter the 'Source Document Number' then enter % on the 'Source Document Line' it produce this error  'You must select at least one Document Number before selecting a Line Number.' and no lines retrieved, although there are existing lines for the PO.


DocumentSrcDocLineVO.xml 120.2.12010000.4 

When Autocreating a PO from a Requisition or directly creating a PO, before submitting for approval, change the requester or the category (account generator uses the requester to determine cost center, and item category to determine account).  Expected behavior is for the distribution to be updated accordingly, but this does not occur.

9480839:R12.PO.B 120.48.12010000.13 120.111.12010000.19
poprf.ldt 120.12.12010000

How to make Buyer Work Center Read Only


After cancelling a PO line and opening it in view-only mode, clicking on 'update' causes a non-cancelled line to open up in update mode.

13981392:R12.PO.B 120.156.12010000.39

Using Purchasing, when using the return to demand workbench after creating a purchase order in the buyer work center - adding a second line to the purchase order - does not show the latest purchase order information.

Patch 13510892 (replaced by 14213029:R12.PO.B)

Monday Jul 22, 2013

Announcing Payables Webcast Program for August


The Payables and Receivables teams have three webcasts scheduled in August.  Join us for these webcasts on the following topics:

  • Using The New Trial Balance Helper (TBH) To Troubleshoot Payables Trial Balance (APTB) Issues 
  • Everything You Need to Know About Oracle Payments Transmission 
  • Using The Oracle Internet Expenses Setup Helper (OSH) To Troubleshoot Oracle Internet Expenses (OIE) Setup Issues.
See below for more details and how to register.

Webcast: Using The New Trial Balance Helper (TBH) To Troubleshoot Payables Trial Balance (APTB) Issues

Date:  August 7, 2013 at 11 am ET, 10 am CT, 9 am MT, 8 am PT

This one-hour session is recommended for technical and functional users who reconcile Trial Balance data in Oracle Payables.  We will review troubleshooting Payables Trial Balance (APTB) issues by using the new Trial Balance Helper (TBH) tool.


  •     Overview of the Trial Balance Helper (TBH) Diagnostic
  •     How to generate and make use of the diagnostics
  •     Generic troubleshooting tips in APTB.

Further details and links to register are in Doc ID 1563693.1.

Everything You Need to Know About Oracle Payments Transmission

Date: August 14, 2013 at 11 am ET, 10 am CT, 9 am MT, 8 am PT

This one-hour session is recommended for technical and functional users who will be implementing Oracle Payments for automatic credit card and direct debit transaction processing. During this session, we will go over technical components that constitute payment transmission such as transmission protocol, configuration, etc. We will also demonstrate how to setup transmission configuration to transmit the payment file. Information covered will be applicable to both funds capture and disbursement flows.


  •    Overview of Oracle Payments Transmission Feature
  •     Transmission Protocol
  •     Transmission Configuration
  •     Tunneling
  •     Setup of Sample Transmission Protocol

Further details and links to register are in Doc ID 1563692.1.

Webcast: Using The Oracle Internet Expenses Setup Helper (OSH) To Troubleshoot Oracle Internet Expenses (OIE) Setup Issues.

Date: August 21, 2013 at 11 am ET, 10 am CT, 9 am MT, 8 am PT

This one-hour session is recommended for technical and functional users who use the Oracle Internet Expenses (OIE) module in Payables. We will review troubleshooting setup issues by using the new Internet Expenses Setup Helper (OSH).


  •    Overview of the OIE Setup Helper (OSH) Diagnostic
  •     How to generate and make use of the diagnostics

Further details and links to register are in Doc ID 1563691.1.

Wednesday Jul 17, 2013

Mobile Field Service Store and Forward Multiple Platforms

The Mobile Field Service Store and Forward Multiple Platform application allows field service technicians to remotely access customer, product, service request and task related information on mobile devices.  Technicians can continue to update their tasks, capture materials, time, expense details, access inventory levels, return, transfer and request parts, regardless of the internet connectivity and synchronize when they are online. 

This solution integrates data across the Enterprise and Mobile devices through secure channels. This highly optimized solution runs on most of the mobile platforms and form factors that are available in the market. The Multiple Platform application runs in hybrid model that allows technicians to leverage more features when there is connectivity.  The application is available currently on iOS and Android platforms.

In contrast with the current Oracle Mobile Field Service Store and Forward application, the Multiple Platform application does not utilize Oracle Lite server as the middle tier server to synchronize data.  Instead, it uses the Representational State Transfer (REST) APIs to synchronize data between the server and the client database.

Store and Forward on iPhone

If you want to know more see Doc ID 1564644.1 for details of how to use and implement this new feature.

Tuesday Jul 16, 2013

Effect On EBS Contracts Application of Microsoft Ending Support for Windows XP and Office 2003

Microsoft is ending support for Windows XP and Office 2003 on April 8, 2014.  The official announcement is published here:

For further details of what this means for E-Business Suite customers please see the E-Business Suite Technology Blog entry 'Microsoft Ending Support for Windows XP and Office 2003 in April 2014'.


Oracle recommends that E-Business Suite customers upgrade their desktops from Windows XP and Office 2003 to the latest certified equivalents.  As of today, those are Windows 7 and Office 2010.

E-Business Suite Procurement, Sales and Repository Contracts include integration with MS Word for contract clause authoring and contract download/upload.  The Contracts product integration with MS Word requires the Word document to be saved in Word 2003 xml format.  Microsoft's latest versions (Word 2007, Word 2010 and Word 2013) still support saving the documents in 2003 xml format.

Please see Doc ID 1476036.1: Supported Formats in Contract Terms Authoring which includes:

  • details of required and recommended patches
  • Microsoft Word Releases certified to be used with Oracle Contracts product
  • Microsoft Word supported formatting.


If you have questions about the effect of this announcement on EBS generally you can post your comment or query on the E-Business Suite Technology blog entry.
For questions on the effect on the EBS Contracts suite of products please post your comments or query on the MOS Contracts and Lease Management Community.

Attention DBAs! Just Released - Procurement Approvals Rollup Patch


Development have just released a new 12.1.3 Rollup (RUP) Patch 16932593:R12.PRC_PF.B that is specific for Procurement Approvals.  This patch includes critical fixes not only for standard Purchasing Approval but also the Approval Management Engine (AME).  Additionally it includes fixes for supplier communication, approval notifications and more.  These important changes are not incorporated in the current 12.1.3 Procurement RUP (March 2013). 

Review Doc ID 1567464.1 to see all the information about this patch including the list of fixes and new features included. 

Be proactive and apply the new Approvals RUP today!

Monday Jul 15, 2013

Latest DSTv20 Timezone Patches Available for EBS

Make sure to take a look at the latest DSTv20 Timezone Patches Available for EBS!

Is your EBS Release 11i, 12.0, or 12.1 environment configured to support Daylight Saving Time (DST) or international time zones?

DSTv20 is now available and certified with Oracle EBS Release 11i, 12.0, and 12.1.

Click here for more information!  

The following notes identify the various components in your E-Business Suite environment that may need DST patches:

Doc ID 563019.1: Complying with Daylight Saving Time (DST) and Time Zone Rule Changes in E-Business Suite 12
Doc ID 458452.1: Complying with Daylight Saving Time (DST) and Time Zone Rule Changes in E-Business Suite 11i 

Oracle Asset Tracking Business Flows

A comprehensive library of test cases for the major OAT business flows has been published. If you are implementing or using Oracle Asset Tracking you will find these new business flows documents invaluable.  Each test case document outlines a business flow with the required setup and each step in the flow is detailed and illustrated with screenshots.

Doc ID 1550977.1:  Master Note For Oracle Asset Tracking Test Case Documents is the index note which cross-references each individual test case document.  The detailed documents are listed below.

Business Flow

Document ID

Complete Mandatory Setups For Oracle Asset Tracking


Create a Normal or Depreciable Item For Use in Oracle Asset Tracking


PO Receipt to Projects For a Normal Item


Inventory Issue to Projects For a Normal Item


PO Receipt to Inventory For a Normal Item



PO Receipt to Inventory For a Depreciable Item




Miscellaneous Receipt to Inventory For a Depreciable Item


Miscellaneous Issue of Items For a Depreciable Item


Move Transaction for a Depreciable Item


Invoice Price Variance (IPV) for a Depreciable Item


Invoice Price Variance (IPV) for a Normal Item


Asset Retirement





Take a look at these documents and remember, if you have questions about any of the content, you can ask the experts in the MOS Install Base Community.

Friday Jul 12, 2013

Did you know EBS R12.1 is Certified on 2012 Hyper-V Windows Guests?

EBS R12.1 is now certified on Windows Server 2008 (32-bit) and Windows Server 2008 R2 running as guest operating systems within Window Server 2012 Hyper-V virtual machines.

Read the EBS Technology Blog entry E-Business Suite R12 Certified on 2012 Hyper-V Windows Guests for more information or read the notes below for all the details:

  • Doc ID 761567.1 - Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Microsoft Windows Server (32-bit)
  • Doc ID 1188535.1 - Migrating Oracle E-Business Suite Release 12 to Microsoft Windows Server 2008 R2
  • Doc ID 1563794.1 - Certified Software on Microsoft Windows Server 2012 Hyper-V

Wednesday Jul 10, 2013

Announcing India Localizations Generic Data Fix

Do you wish you could proactively check your India Localizations data for known data integrity issues?  Take a look at  Doc ID 1542754.1 R12: India Localization Applications Diagnostics and General data Fix Validation (GDF).

Run the Master GDF script prior to logging a Service Request when you suspect data corruption issues in your transaction. The script will validate the data and recommend notes and/or data fix patches which may already be available to resolve the issues with receipts, Receivables invoices, Payables invoices or sales orders.

Service Contracts: New Troubleshooting Assistant for QA Check Issues

A new Troubleshooting Assistant has been published to help you resolve Service Contracts QA check errors. Troubleshooting assistants help you to find a resolution to an issue by guiding you from the problem, through possible scenarios or symptoms, in to the proposed solution(s). Check out the new assistant in Doc ID 1556899.1.

For a full listing of all assistants in EBS check the index note Doc ID 1501724.1.

What version of Java JRE are you running with Oracle E-Business Suite?

What version of Java JRE are you running with Oracle E-Business Suite?

Java Download

The latest Java JRE versions to be certified with Oracle EBS are detailed below.  Click on the title links to access Steven Chan's Oracle EBS Technology Blog which has all the relevant details.

Java JRE 1.6.0_51 is Certified with Oracle E-Business Suite

The latest Java Runtime Environment 1.6.0_51 (a.k.a. JRE 6u51-b11) and later updates on the JRE 6 codeline are now certified with Oracle E-Business Suite Release 11i and 12 for Windows-based desktop clients.  

Java JRE 1.7.0_25 Certified with Oracle E-Business Suite

The latest Java Runtime Environment 7u25 (a.k.a. JRE 7u25-b16) and later updates on the JRE 7 codeline are now certified with Oracle E-Business Suite Release 11i and 12 for Windows-based desktop clients.

Monday Jul 08, 2013

Are you attending the EBS Sessions at July 2013 OAUG Connection Point in Pittsburgh?

Check out what sessions members of our E-Business Suite Applications Technology Group (ATG) will be presenting on at the OAUG Connection Point - AppsTech 2013 to be hosted in the Marriott City Center in  Pittsburgh, PA on July 30-31, 2013.  They'll be speaking at a number of sessions on a wide variety of topics around the ATG products. 

There is also an opportunity to 'Meet the Experts' - where you can meet with experts who specialize in Oracle E-Business Suite technology.  This is the place where attendees can have informal and semistructured but open one-on-one discussions with Strategy and Development regarding Oracle Applications strategy and your specific business and IT strategy. 

Go to Steven Chan's Oracle EBS Technology blog for more details of the EBS Sessions at July 2013 OAUG Connection Point in Pittsburgh.

Sunday Jul 07, 2013

Field Service: Third Party Organization Scheduling in 12.1.3

Oracle Advanced Scheduler is one of the key solution components of the Field Service Application footprint.  The Advanced Scheduler engine has been built with a powerful scheduling and optimization logic.  It is designed to handle complex field service operations servicing a high volume of customer service requests and fulfilling the contractual obligations, duly considering task constraints and resource availability. In fact, resource availability is one of the most important criteria for Scheduler for computing the scheduling options. Prior to 12.1.3, the resource availability model is based on the Calendar and Shifts assigned to the Technicians. Scheduler leverages this resource availability model to schedule tasks to eligible Technicians.

Often, service-providing organizations use both in-house Technicians and Third Party Organization qualified technicians in order to satisfy 24x7 working and customer SLAs.

In 12.1.3 Scheduler is able to distinguish between internal resources and third party service providers as a new feature. Check out Doc ID 1112171.1 for details on this new feature.


For help with using this new feature refer to Doc ID 1563630.1: Setup and Scheduling a 'Supplier Contact' in 12.1.x. There was also a webcast on this topic and you can watch the replay via Doc ID 1455786.1 (go to the 'Archived 2013' tab).

Got more questions on this topic? Why not start a discussion in the MOS Field Service Community.


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



« July 2013 »