Friday Apr 11, 2014

Avoid Install Base Errors! Apply New R12 Consolidated Patch

Recently we've found that some customers are reporting errors after applying Patch 17182398:R12.CSI.B.  We found that this was due to not applying a pre-requisite patch (Patch 16914038:R12.CSI.B).  So, to avoid this problem, the Install Base development team have released a new consolidated patch which includes the pre-requisite: Patch 18479621:R12.CSI.B: ORACLE INSTALLED BASE 12.1.X CONSOLIDATION. 

This patch supersedes Patch 17182398:R12.CSI.B and should be applied by all new R12 IB implementations or any R12.1.x upgrades.  The patch includes a large number of fixes and is recommended for all Install Base customers.  If you have already applied Patch 17182398:R12.CSI.B with its correct pre-requisite patch, then there is no need to apply Patch 18479621:R12.CSI.B.

All details about this new consolidation are included in article: About R12.1.X Consolidated Patch For Oracle Installed Base - 18479621:R12.CSI.B (Doc ID 1642057.1)

Thursday Apr 10, 2014

Should You Apply The R12.1.3+ EBS Wide RPC or Wait for a Payables Specific RPC?

Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection is Available!

The last RPC for Oracle Payables was released in September 2013 (Doc ID 1397581.1) and usually at this time of year we see development release the next RPC for Payables.   However, this year there will not be a new Payables RPC released until much later in the year.

Instead of a March 2014 Payables RPC development have released the 12.1.3+ RPC that is EBS wide.  This patch includes ALL the recommended patches along with their dependencies. 

If you are running R12.1.3 but have not yet applied the September 2013 RPCs for Payables then you can instead choose to apply this latest R12.1.3+ patch which includes all the RPCs for Payables and the companion RPCs for Workflow, PCard and iSupplier in addition to Cash Management and EBTax RPCs.  

Applying this patch in a single downtime patching window saves effort and time, rather than applying each recommended patch individually.

For more information on the R12.1.3+  RPC please refer to Doc ID 1638535.1 - Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 1 (RPC1) 

Note: Before upgrading to Oracle E-Business Suite Release 12.1.3 and applying 12.1.3+ E-Business Suite RPC1, refer to Doc ID 761570.1 - Database Preparation Guidelines for an Oracle E-Business Suite Release 12.1 Upgrade - and ensure that all patches for your specific database release are applied to your environment. 

Thursday Apr 03, 2014

New Contracts RUP Patches Released

You may have noticed in last week's post CRM Product Family Latest Patch Information that there are new Contracts RUP patches released.  These are important patches and I wanted to tell you more about them here, in case you missed the information in last week's entry. 

Service Contracts

Patch 17155169:R12.OKS.B is the first RUP patch released for Service Contracts in R12.1.3 (see Doc ID 1612461.1 for the readme).  It contains many bug fixes encountered since R12.1.3 was first released and it's highly recommended that you apply this patch.  In addition to the bug fixes, the patch also delivers a number of enhancements including:

  • Service Contract Renewal Performance Enhancements
  • Performance Enhancements to Main Billing Program for Usage Contracts
  • Mass Update Tool for Contract Authoring
  • Selective Update of Warranty Contracts Upon IB Transfer of Ownership
  • Flexible Invoice Text Defaulting.

Details of the enhancements are given in Doc ID 1467147.1.

Sales/Procurement Contracts

For Sales Procurement Contracts Patch 17755570:R12.OKC.B is the second RUP patch released for R12.1.3 (see Doc ID 1612432.1 for the readme).  This is a recommended patch and contains a large number of bug fixes as well as some important enhancements.  The enhancements include:

  • MS Word 2010 Certification
  • Multi Row Variables or UDA Variables
  • Purge Repository Contracts Concurrent Program
  • Delete Multiple Clauses and Sections in Contract Terms.
    Details of the enhancements are given in Doc ID 1467149.1 (for Sales Contracts) and Doc ID 1467140.1 (for Procurement Contracts).

    Monday Mar 31, 2014

    What's NEW? 12.1.3+ E-business Suite Recommended Patch Collection 1!

    We are very pleased to announce the availability of E-Business Suite 12.1.3+ Recommended Patch Collection 1 (Patch 17774755).  This Recommended Patch Collection combines recommended patches for EBS 12.1.3 into a single integrated and regression-tested patchset.

    Note: Patch 17774755 must be applied into an existing Release 12.1.3 E-Business Suite environment.

    For the complete installation steps and Functional information, refer to My Oracle Support Doc ID 1638535.1.

    Thursday Mar 27, 2014

    CRM Product Family Latest Patch Information

    There have been recent RUP/consolidated patches released for some products in the CRM family. See the table below for recent patching information for the CRM family products. 

    Product Details
    Lease and Finance Management Patch 18088536:R12.OKL.B: OLFM : 1213 RUP3 DELTA 19 Doc ID 1622396.1
    Core Service
    Patch 18265289: 12.1.3::R12.CS.B: 12.1.3:BUG FIXES FOR CS:MARCH'14 RUP PATCH
    Doc ID 1608427.1
    Installed Base
    Patch 17182398:R12.CSI.B: ORACLE INSTALLED BASE 12.1.X CONSOLIDATION Doc ID 1618632.1
    Asset Tracking
    Patch 17181028:R12.CSE.B: ORACLE ASSET TRACKING 12.1.X CONSOLIDATION Doc ID 1619344.1
    Service Contracts
    Patch 17155169:R12.OKS.B: Oracle Service Contract Release Update Pack 1 for 12.1.3
    Doc ID 1612461.1
    Contracts Core
    Patch 17755570:R12.OKC.B: 12.1.3 OKC RUP2
    Doc ID 1612432.1

    The Reference notes, where indicated, provide more information about the patch such as:

    • fixes included
    • new or amended features
    • functional impact
    • testing recommendations
    • instructions for applying the patch. 

    Monday Feb 10, 2014

    Additional Enhancements in 12.1.3: Procurement iSupplier Portal, Sourcing and Supplier Lifecycle Management (SLM) Rollup Patch: 17525552:R12.PRC_PF.B

    Did you see these new additions to Doc ID 1591198.1, section Enhancements introduced in Patch 17525552:R12.PRC_PF.B?  Along with the rest of the enhancements the following information has been appended:

     Functional Area
    Previous Behavior
    Enhanced Behavior
    Send Pre – Qualification Questionnaire  When action ‘Send Pre – Qualification Questionnaire’ is taken,  the notification that is sent to the supplier will be ‘Action Required: Please fill out the Supplier pre – qualification questionnaire’.  In the new process an ‘Invitation to Register’ should be first sent to the supplier, followed then by an ‘Action Required: Please fill out the Supplier pre – qualification questionnaire’ notification. This will be less confusing for the supplier to first see the invitation and then the notification for questionnaire.
    Supplier Registration Actions  Buyer uses Notify button to ask any information from the supplier.  The ‘Notify’ button has been converted to ‘Supplier to Provide Details’ action in actions dropdown in Supplier request review page. 
    During registration process, there won’t be any action like 'Supplier to Provide details’; instead there is 'Send Invitation to Supplier’. But after registration is complete, during the approval process, the buyer/approver will have the action 'Supplier to Provide details'.
    New Supplier Registration Process  After the internal user clicks on ‘Register New Supplier’ button, the user will be guided to ‘Suppliers: Register New Supplier’ page. This page presently has only two buttons – ‘Cancel’ and ‘Save & Continue’.

     As per the new process this page will have three buttons – ‘Cancel’, ‘Send Invitation to Supplier’ and ‘Save Continue’. The buttons are described below:

    •  Save & Continue: This button will save the information and take the requester to the next page - 'New Supplier Request' page where user can then enter more information and take actions such as 'Register, Save, Cancel' etc.
      Note - this button will neither send any invitation to the supplier nor will it change the status of the request. i.e.., it keeps the request in DRAFT mode.
    • Send Invitation to Supplier (New Button): This button will save the information and sends an invitation notification to the supplier to register.  It additionally changes the status of the request to 'Supplier to provide details'.
    Entering Profile Attributes  Currently all UDAs display in the same page, then it requires the buyer to also enter mandatory UDAs specific to supplier.

     When the requester takes action 'Send Invitation to Supplier' on request review page (not on the request creation page), all the mandatory UDAs to be entered by the internal user will be validated and error messages will be displayed. The request is sent to the supplier only if all the mandatory UDAs are entered by the internal user. To achieve this, UDA pages are segregated to 'attributes to be entered by supplier' and 'attributes to be entered by buyer'.

    Friday Jan 24, 2014

    Functional Impact Documents For Monthly Service Cumulative Patches

    The Core Service Development team provide monthly cumulative patches which contain fixes and new functionality.  Although the bugs fixed in each patch are always listed, it can be difficult to fully understand the functional impact of a bug fix and what associated setup is required.  Also, whenever a new cumulative patch is applied there has to be thorough testing and, without a clear understanding of what has changed, it's difficult to decide what business flows need to be re-tested.

    In an effort to meet these testing requirements and make it easier to apply the monthly patches, the Development team will be providing an accompanying document which will describe the impacted flows, list testing recommendations and detail additional setup required for testing the bug fixes.  The first of these documents have been created for the December '13 (Patch 17738111:R12:CS:B) and January '14 (Patch 17855988:R12.CS.B) cumulative patches.  Take a look at Doc ID 1608427.1: Functional Impact Document - 12.1.3 Consolidations to access the documents.  We recommend you bookmark the Doc ID as new documents will be added when new cumulative patches are released.

    Critical Patch Update for January 2014

    Get off to a good start this year and apply the Critical Patch Update for January 2014!

    Go to Doc ID1594621.1 for more details for E-Business Suite.

    Friday Dec 27, 2013

    Wondering Why There Hasn't Been a New 12.1.3 Procurement Rollup Patch (RUP) Recently?

    So are you keeping an eye on Doc ID 1468883.1 and wondering why there has not been a new 12.1.3 RUP released since March 2013 Patch 15843459:R12.PRC_PF.B?

    Instead of releasing all-encompassing RUPs, Procurement Development has been focusing on specific areas.  Visit Doc ID 1468883.1 the ‘Additional Recommended Patching’ section to see the patching available for the following areas:
    • iSupplier Portal, Sourcing and Supplier Lifecycle Management
    • Purchasing Approvals (including AME)
    • Procurement Accounting Processes

    These patches are designed to be applied on top of Patch 15843459.

    Visit Doc ID 1468883.1 ‘Additional Recommended Patching’ section today for details!

    Friday Nov 01, 2013

    CRM: New Rollup Patches Released

    See the table below for new rollup patches released for CRM family products.

    Product  Patch Number
    Service Patch 17467506:R12.CS.B12.1.3:BUG FIXES FOR CS: OCTOBER'13 RUP PATCH
    iStore Patch 16509570:R12.IBE.B- ORACLE ISTORE 12.1.3+ ROLLUP 1
    Doc ID 1560963.1
    Lease and Finance Management
    Patch 17485497:R12.OKL.B - OLFM : 1213 RUP3 DELTA 15 n/a

    For Trade Management and Price Protection the following Information Centers list the latest recommended patches and recently released patches:

    • Critical, Recommended and Latest Patches for Oracle Trade Management (Doc ID 1599010.2)
    • Critical, Recommended and Latest Patches for Oracle Price Protection (Doc ID 1599010.2- go to Channel Revenue Management tab)

    Friday Oct 25, 2013

    New RUP Patch for iSupplier Portal, Sourcing and Supplier Lifecycle Management (SLM)

    Just released - the 12.1.3 Rollup (RUP) Patch 17525552:R12.PRC_PF.B for iSupplier Portal, Sourcing and Supplier Lifecycle Management (SLM).

    Who should apply this patch?

    Anyone that is on Release 12.1.3 and is using  iSupplier Portal, Sourcing or Supplier Lifecycle Management (SLM) functionality.

    The following areas have had major fixes:

    • Prospective Supplier Guided Navigation: The train-navigation is introduced for prospective supplier registration so that prospective suppliers can see all steps needed to successfully register themselves.
    • Supplier Registration Workflow Enhancement: With this release, provided the Approval Management Engine (AME) action required notifications for supplier approval, so that all workflow related features can be enabled. Vacation rules can be set, approvals can be forwarded and more information can be requested through the notification itself.  Additionally AME parallel Approval support for Supplier Registration approvals has been added.
    • Reinstate Supplier Request: Allow buyer to reopen/reinstate the rejected supplier. Supplier is able to access their previously rejected registration again and make changes and resubmit request.
    • Contact Address Association: The prospective supplier is allowed to associate addresses with contacts (including Primary) during the prospective supplier registration process.
    • Primary Contact Enhancement: The prospective supplier can be registered without creating a user account for the primary contact.
    • Mandatory Attributes: In the negotiation requirement creation page, the lookup meaning of 'Internal' has been changed to 'Internal Optional', and a new lookup value with meaning as 'Internal Required' has been added. The values available in the 'Type' dropdown now are Display Only, Internal Optional, Internal Required, Supplier Optional and Supplier Required.  So now during supplier evaluations, internal user response can be set as mandatory by using Internal Required type during requirement creation.
    • Notifications to Supplier:  When the supplier saves and submits their supplier registration request, then a notification with a registration status page link will be sent for further access.  When the buyer approves, rejects or returns the request, the supplier will be notified in an email with the current status.
    There are also 10 major enhancements included in this RUP.

    For information about this RUP; including, the fixes and enhancements included, how to access and apply the patch, performing an impact analysis on your system, and testing recommendations, see Doc ID 1591198.1Don’t delay apply the patch today!

    Monday Oct 21, 2013

    Critical Patch Update for October 2013 Now Available

    The  Critical Patch Update (CPU) for October 2013 was released on October 15, 2013.  Oracle strongly recommends applying the patches as soon as possible.
    The Critical Patch Update Advisory is the starting point for relevant information.  It includes a list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities, and links to other important documents.

    E-Business Suite Releases 11i and 12 Reference:

    Wednesday Aug 21, 2013

    New 12.1.3 Procurement Rollup Patch Specific for Approvals

    See the newly released 12.1.3 Procurement Rollup patch specific for Approvals.
    Here is a high level overview of the fixes included in this Approvals Patch 16932593:R12.PO.B:

    1.      Approvals Management Engine (AME)

    • AME Approval can be completed successfully even when the document verification has failed. Added logic to inform parent workflow to continue when verification fails.
    • The approval chain correctly starts from the submitted of the document when using PO AME approval.

    2.      EDI

    • Vendor site attachment is aligned to the purchasing document.

    3.      Purchase Order Approval

    • Accessing document from approval notification is enhanced.
    • Code related to Document forward are enhanced, this is a major feature used by business users to manage document pending for approval with ex-employees and document pending with employees on vacation.
    • Performance issues on PO approval are rectified and fine-tuned

    4.      Requisition Approval

    • Action history on requisition document is fine tuned to capture delegation and forward to actions.

    5.      Supplier communication

    • Email Notification to supplier displays supplier country of origin instead of supplier country.
    • Enhancement to trigger notification to supplier if Requisition associated to Purchase order is cancelled

    Visit Doc ID 1567464.1  for complete details on this patch.

    Tuesday Aug 13, 2013

    Are you Running EBS 12.1.1 or 12.1.2 in Production?

    If you are currently on EBS 12.1.1 or 12.1.2 then the standard recommendation is is to apply the EBS 12.1.3 suite-wide Release Update Pack.  If you can't apply the suite-wide 12.1.3 Release Update Pack, you should apply the individual 12.1.3 Family Packs for the EBS products that you've deployed.

    But, guess what, you're probably already closer to EBS 12.1.3 than you think!  Why is that?  If you've applied any patches to your 12.1.1 or 12.1.2 environment, you probably already have much of 12.1.3 already in production today.  (You can read more about this and the background to it in the EBS Technology Blog here).

    Check this out yourself and see just how close to EBS 12.1.3 you may be.  The Oracle Applications Manager contains a tool that all Apps DBAs should use: Patch Wizard.  The Patch Wizard has an 'Analyze Specific Patches' function that tells you how a specific patch will affect your system.

    The resulting 'Patch Impact Analysis' report provides you with a summary of:

    • Applications patched
    • New files introduced
    • Existing files changed
    • Existing files unchanged.

    You can learn more about patch wizard, including the latest improvements, in Doc ID 976188.1.

    Sunday Aug 04, 2013

    Upgrading? Make sure you review the below links on the Consolidated Upgrade Patch 2!


    If you are on 11i and are planning to upgrade to R12 then make sure you review the below links on the Consolidated Upgrade Patch 2 (CUP2).  This will help with upgrading from Release 11i to Release 12.1.3.  The Oracle E-Business Suite Pre-install Patches Report serves as a single point of reference for upgrade-related patches that can ONLY be applied prior to running the main upgrade driver for Release 12.1.  These pre-install patches help you avoid certain upgrade script failures, upgrade performance issues and data corruption and upgrade integrity issues.

    Below are links to the release from Development on Steven Chan’s blog and the Document with a short video:


    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



    « April 2014