Friday Jun 27, 2014

New OM 12.1 Cumulative Patch Released!

ORDER MANAGEMENT 12.1 JAN 2014 CUMULATIVE PATCH 19018023 has been released!!

The best way to stay ahead of data and program issues is to apply the latest cumulative patches (RUPs) at your first opportunity.

You can review the current list of cumulative patches via Order Management Cumulative Patches for Releases:11.5.10, 12.0.4, and 12.1, Doc ID 453944.1.

You can also dynamically search the latest EBS recommended patches using tools that are already available to you. See Doc ID 1400757.1 How to Find E-Business Suite Recommended Patches for the three methods. By using Method 1, Patch Wizard, you can see whether the recommended patches are already applied in your instance. You can also see the changes that an un-applied patch will introduce to your instance if you applied it.

Thursday Jun 26, 2014

During R12.2.3 Upgrade QP_UTIL_PUB Is Invalid

Release 12.2.3 upgrade below pll files recompile failed.  The following Oracle Forms objects did not generate successfully:

QOTLNSVI.pll         OEXOEGWY.pll
QOTPRDTL.pll         OEXOEADJ.pll
OEXOEBSE.pll         OEXOEBSO.pll
OEXTRTYP.pll         OKSAUDET.pll
QOTLNDET.pll         OEXOEHDR.pll
QPXQPDEB.pll         OEXOELIN.pll

There is a documented workaround for those that are receiving this error in note:  During R12.2.3 Upgrade on Patch 17020683 the pll Recompile Failed Showing That Object APPS.QP_UTIL_PUB Is Invalid, Doc ID 1683318.1

For those that have not yet upgraded, please review the readme and pre-requisites for Patch 18977965 as a pre-install / pre-upgrade step.

Announcing RapidSR for Oracle Payables: Automated Troubleshooting (AT)

What's New?

Customers are now able to create an accounting SR, upload the Master GDF diagnostic, and have the system automatically analyze the MGD output and update the SR with a solution summary.  In most situations we anticipate this to be much faster than waiting for an engineer to pick up and process the SR.  We call it RapidSR because it is FAST!

This first automation phase involves AP Accounting issues and covers the following impact areas:

  • GL Transfer
  • Accounting Failure
  • Accounting Incorrect
  • Period Close
  • Sweep
  • Trial Balance

A valid MGD output is required for automation to work and the requirements are:

  • Minimum version required = 120.213 or above
  • The diagnostic must be run in a single transaction mode. 

Doc ID 1608498.1 - SRDC R12: Collect Validation Information for Data Related to Invoices, Payments, Accounting, Suppliers and EBTax provides the link to the latest version of the MGD.

How Do You Log An Automation SR?

Step 1) Simple, when logging your next SR for an Accounting problem, simply select the following problem type:

Accounting Issues and Reporting > Create Accounting Fails for Specific Invoice, Check or Vendor

Note: Sev1’s and OnDemand/Cloud SRs will not be automated even when choosing this option.

Step 2) The Automated Troubleshooting Instructions: Payables Data Corruption Screening (Doc ID 1672163.1) document will appear explaining in more detail what will happen.

Click Next

Step 3) You have one question to answer - just tell us which impact area is causing you problems...

IMPORTANT: Click on the Note icon and carefully read the description for each impact area to properly select the closest match.  The Impact Area is the primary driver that AT uses to help provide a solution. 

Step 4) Choose severity and submit the SR.

That's it!

What Happens Next? 

Shortly afterwards you will receive a request to upload the MGD (if already uploaded then just ignore this step).  You will be reminded several times to provide files but the system will wait for you to provide this. 

Once the MGD is available our automated system will review it and paste your solution in the SR for you similar to the screenshot below:

How cool is that?

Be aware that if at any time you update the SR (except to upload the MGD file) before automation has completed, you will cause the SR to fall out of automation and be routed to an Accounting engineer.   Please give the process time to work, around 30-60 minutes depending on how long the MGD output is, and we think you will be amazed at how quickly and efficiently you will have a solution available and documented in your SR.

What If Automation Cannot Provide A Solution? 

If the automation engine cannot determine a solution for your issue because the MGD doesn't have any corruption signatures found or an invalid MGD file was uploaded, or if you have problems running the MGD and need assistance then the SR will drop out of automation and be routed to an engineer so you really have nothing to lose giving automation a try! 

We are excited about this new feature, so if you have an Accounting SR to log, please start selecting the Create Accounting Fails for Specific Invoice, Check or Vendor option from under the Accounting Issues and Reporting menu and give it a try!

Please provide any feedback on this process direct on our community post on this topic. 

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.

Wednesday Jun 25, 2014

My Oracle Support Accreditation for E-Business Suite

The My Oracle Support Accreditation Series delivers a targeted learning experience that is designed to increase your expertise with My Oracle Support core functions and build skills to help you leverage Oracle product solutions, tools, and knowledge.

The accreditation framework for Oracle E-Business Suite is targeted to customers and partners who actively use My Oracle Support and Oracle E-Business Suite. The content is focused on building skills around best practices, recommendations, and tool enablement – taking your expertise with Oracle E-Business Suite to the next level. The Oracle E-Business Suite course covers:

•    Staying informed
•    Period Close
•    Patching
•    Certifications
•    Upgrade Advisor
•    Reporting 

Visit the My Oracle Support Accreditation Index and get started with the Level 1 My Oracle Support Accreditation path and the Level 2 Oracle E-Business Suite learning path today.

Tuesday Jun 24, 2014

Journal Lines Reconciliation - What's Different in Release12?

General Ledger Reconciliation feature allows accounting users to reconcile transactions for accounts that should balance to zero, cross-referencing such transactions with each-other through reconciliation references. Either Manual or Automatic, using references from GL or Subledgers, including complete accounting code combinations or just the natural account segment value, when the balance for a group of transactions is zero the transactions are marked as reconciled. 

What's different in Release12?  

Part of European Localizations in 11i, Reconciliation feature was incorporated in the Standard Applications Release 12 due to its importance for the business.

What features are included?

  • Populate reconciliation references for journal lines or headers
  • Create references from Subledgers directly
  • Replicate references to Reporting Ledgers
  • Perform Manual or Automatic reconciliation
  • Multi-currency reconciliation
  • Report on reconciled-unreconciled transactions
Reconciliation form

Need to know more?  

Find out all the details related to available features, setup requirements, reporting, technical information - all delivered in clear steps with screenshots and quick tips through this New Whitepaper Document:

Journal Line Reconciliation in R12: A Whitepaper (Doc ID 1673357.1)

Share this with your financial users today!

Webcast: Setup and Usage of Configure to Order (CTO) Business Flow in Sync with Work in Process

Webcast_icon.jpgWebcast: Setup and Usage of Configure to Order (CTO) Business Flow in Sync with Work in Process

Date: June 25, 2014 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 8:30 pm, India Time (Mumbai, GMT+05:30)

This one-hour session is recommended for Functional Users, Key Users, and Implementation Consultants, and will show During this presentation will show a complete setup of a CTO Model with options then how this model is being used to generate a CTO item. This webcast will also demonstrate how CTO item will be generating discrete jobs in Work in Process.

Topics will include:

  • define CTO Model
  • define CTO components
  • define Options, Bills of Material and Routing for the CTO Model
  • define Sales Order for the CTO Model
  • use the Oracle Configurator to generate the CTO Item
  • auto-generate WIP Discrete Job to fulfill the SO

Details & Registration: Doc ID 1670446.1

Monday Jun 23, 2014

General Ledger - Accounting Setups Diagnostic Now Available!

Accounting Setup Manager is the central place where all accounting setup is defined and maintained. Collecting information related to your ledger and its configuration could be time-consuming while the ledger architecture is much more complex in Release 12 and multiple pages need to be accessed in order to gather a complete set of details. 

Collect all this setup information in one diagnostic run! Find information related to: 

  • Primary Ledger and its associated ledgers 
  • Legal Entities
  • Configuration details
  • Ledgers relationships
  • Balancing segments assignments
  • Intercompany and Intracompany rules
  • Relevant table data and files version
Sample Diagnostic Output

Tired of running too many scripts, browse through many setup pages and take screenshots to prove your ledger's configuration?

Get it all at once with a single Sql run!

New Diagnostic tool available in: R12: Accounting Setup Manager (ASM) Diagnostic (Doc ID 1643493.1)

Important Announcement for Oracle EBS HRMS (Netherlands) Users!

The following patches have been released via MyOracleSupport: 

Release 12.0 Patch 18789871:R12.PAY.A
Release 12.1 Patch 18789871:R12.PAY.B
Release 12.2 Patch 18789871:R12.PAY.C

 The following legislative changes for Oracle EBS HRMS (Netherlands) Users are included in the patch: 

1. Discount hiring young employee effective from July 2014
In Dutch localization, as of 1-July-2014, an employer can receive a discount when hiring new young employees from a previous unemployment or disability situation. The discount must be calculated on a periodic basis and reported in the Wage Report. This patch delivers a new element 'Discount for Hiring Young Employees' which can be attached to the employees for the eligible period.

2. Legal Minimum Wage Changes effective from July 2014
To comply with the legislative changes for Legal Minimum Wages effective 01-Jul-2014, this patch modifies the values of the predefined user table NL_LEGAL_MINIMUM_WAGES effective from 01-Jul-2014.

NOTE: There are Post Install Steps which need to be run after patch installation. Doc ID 1603678.1 - Netherlands : Legislative Updates for 2014 has important installation, setup instructions and guidelines.

The following MyOracleSupport notes have been updated: 

Netherlands : Legislative Updates for 2014 (Doc ID 1603678.1)
Netherlands Payroll Mandatory Patches Release 12.0 (Doc ID 552364.1)
Netherlands Payroll Mandatory Patches Release 12.1 (Doc ID 863866.1)
Netherlands Payroll Mandatory Patches Release 12.2 (Doc ID 1626273.1)

If you encounter any issues with these patches, please raise a Service Request via My Oracle Support with Oracle Payroll Support.

Friday Jun 20, 2014

Information From the Field Service & Depot Repair CAB Meeting

Earlier in the year the '2014 Service and Depot Repair Customer Advisory Board' (CAB) meeting took place in Redwood Shores.  Some of the presentations delivered at the meeting have now been made available and these have been uploaded to the Field Service and Depot Repair Community (in the Contents > Documents section).

The topics covered include:

  • EBS Endeca for Field Service: provides a product update, and summarizes the Endeca extensions for Oracle Field Service (Rel 12.1.3).
  • EBS Advanced Scheduler & Spares Management Update: covers material relating to Field Service Advanced Scheduler, Dispatch Center & Spares Management.
  • Depot Repair Receiving:  a 10 minute video of the functionality provided by the Depot Repair Receiving step of the Returns Management flow.
  • Create and Submit an Estimate: 10 minute video presentation outlining the process to create and submit an estimate using the Depot Technician Portal

There are also other documents from the CAB uploaded in the MOS Field Service and Depot Repair Community.

For further information or if you have comments on any of these materials, please see the Community thread: Presentations from the '2014 Service and Depot Repair Customer Advisory Board' meeting.

Thursday Jun 19, 2014

Tendering in Oracle Transportation Management

Tendering in Oracle Transportation Management involves the following basic functions:
  • Shipper sending the offer request to the transporter for moving the cargo
  • Transporters sending in their respective offers
  • Analyzing the offers and awarding of bid to the best/low cost transporter
This document covers the following topics:
  • About Tendering
  • Types of Tendering
  • Setup, Scenario & Statuses
  • Diagnostics

For the whitepaper, visit Tendering in Oracle Transportation Management, Doc ID 1677607.1.

Wednesday Jun 18, 2014

What R12 Diagnostics are Available for Inventory?

Imagine a scenario...Inventory period close is fast approaching and you conduct your regular run of the Inventory Analyzer Doc ID 1499475.1 to check the health of your Inventory transactions. The Inventory Analyzer does it's job and identifies records existing with data issues. You're at the point where the Inventory Analyzer has given you a lot of valuable information, including solutions to resolve issues, however you decide you want more detailed information about the transaction records before moving forward. You would like to look specifically at the transactions open interface and pending transactions areas and get more detailed information, including what inventory items are associated with the transactions. You wonder what additional tools are available to collect the information you're looking for? One fantastic resource is the Diagnostics Test Catalog for 12.1.3 and Above Doc ID 1083807.1. The R12 diagnostics catalog allows you to collect detailed information for many areas of your Inventory  environment (as well as many other areas of most EBS Products and R12.2). Access Doc ID 1083807.1, click on the 'Oracle Inventory Management' link, and view the Oracle Inventory Management (INV) diagnostics available in the diagnostics catalog.

Once you've scrolled down, like in the example above, you can take advantage of the Inventory Transactions diagnostics, as well as any of the other diagnostics available for Inventory (and there are many). Keep in mind that the diagnostic catalog should already be part of your EBS environment, but if it is not, the catalog can be added via Doc ID 167000.1 E-Business Suite Diagnostics Installation Guide.

So, be sure to use Oracle E-Business Suite Diagnostics as an additional tool to help troubleshoot problems or issues to proactively help resolve situations in your environment, especially before period close.

Webcast: New Features and Enhancements in Release 12.2 Enterprise Asset Management

Webcast_icon.jpgWebcast: New Features and Enhancements in Release 12.2 Enterprise Asset Management

Date: June 19, 2014 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 8:30 pm, India Time (Mumbai, GMT+05:30)

This one hour advisor webcast session will cover the details of New Features and Enhancements released as part of 12.2 EBS Enterprise Asset Management product. The business value of the enhanced features and their role in running everyday maintenance planning and execution tasks effectively will be discussed.

Topics will include:

  • Safety Enhancements
  • Improvements to Maintenance Material Management
  • Usability Enhancements

Details & Registration: Doc ID 1667477.1

New Patch Released for iSupplier Portal/Supplier Lifecycle Management (SLM)

R12 Patch 18920290:R12.POS.B  has just been released and is available in My Oracle Support for  iSupplier Portal/Supplier Lifecycle Management (SLM).

In Oracle iSupplier Portal/SLM, this patch resolves the issues in the Supplier Registration and Approval Process and includes the fixes from Rollup Patch (RUP) 17525552:R12.PRC_PF.B.

Following are some of the major fixes:

1. Error when trying to attach PRE_QUALIFICATION RFI template to Supplier Registration Request
2. Unable to register new supplier or invite supplier to register
3. Issue of Approval sequence not displayed when request in DRAFT and RIF_SUPPLIER status
4. Supplier unable to submit the RFI response, receiving error 'your company has been deactivated'
5. Build failure for POSSPAPM.WFT UPGRADE
6. Unable to submit prospective supplier registration as RFI response not submitted

See the readme for a list of all changes and any necessary patching information!

Tuesday Jun 17, 2014

Webcast: OPM/LCM: Key setups & Data Diagnostics

Webcast_icon.jpgWebcast: OPM/LCM: Key setups & Data Diagnostics

Date: June 18, 2014 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 8:30 pm, India Time (Mumbai, GMT+05:30)

This one-hour advisor webcast is recommended for technical and functional users who uses Landed Cost Management (LCM) integrated with Oracle Process Manufacturing (OPM). This session covers the setup and transactional data diagnostics including sequence of operations, data flow and table mapping. This covers both LCM as service and pre-receiving which for procure to pay cycle.

Topics will include:

  • Sequence of operations
  • Data flow
  • Table mapping
  • LCM as service
  • Pre-receiving for procurement to pay cycle

Details & Registration: Doc ID 1667794.1


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



« June 2014 »