Tuesday Jun 25, 2013

New and Improved Search Helpers Now Procurement Assistants!

Check out the new and improved Procurement Assistants (formerly Search Helpers). Let us guide you simply to Issue Resolution.  To access all our Procurement Search Helpers see Doc ID 1391694.2 our Procurement Information Center.

Here you will see links to our Procurement Search Helpers:

Assistants provide a collection of solutions based on the symptoms you enter. For example simply choose the radial button that pertains to your issue, as shown here:

Then choose the additional symptom(s) that pertain and potential solution documents will be returned as shown here:

Try these before logging a Service Request.

Current Procurement Assistants:

Doc ID



 Assistant: Oracle Purchasing - Purchase Order and Requisition Approval (Search Helper)


Assistant: Oracle Purchasing PO Output for Communication / Supplier Notification Issues (Search Helper)


Assistant: Oracle Purchasing Requisition To Purchase Order (Search Helper)


Assistant: Oracle Purchasing Purchase Document Open Interface and API (Search Helper)


Assistant: Oracle Inventory Management RVTII-060 Errors in Receiving (Search Helper)


Assistant: Oracle Purchasing Buyer Work Center Search Helper (Search Helper)


Assistant: Oracle Purchasing - Document Control : Cancel and Close

Friday May 24, 2013

Are You Using Encumbrance Accounting in 12.1.3 Procurement?

Are you using Encumbrance accounting in 12.1.3 Procurement?  If so, this could potentially impact you!

So what’s the issue? After applying March 2013 RUP Patch 15843459, when attempting to cancel a Purchase Order line with backing requisition, without cancelling the requisition, the following error occurs.

Error after patching

So what’s the fix? To resolve this issue apply Patch 16781315:R12.PO.B. For more information see Doc ID 1553897.1.


Wednesday May 08, 2013

Continue Your Procurement Education by Attending These Upcoming Webcasts


The Procurement team have more webcasts for you in May and June.  Join us in these webcasts for an in-depth look at different areas of the Procurement product suite and get hints and tips from the experts.

There are three upcoming webcasts in May:

  • Subject: EMD - Earnest Money Deposit in Oracle Sourcing
    Date: 14-May-2013 2:00 pm GMT+01:00 / 9:00 am EDT/ 7:00 am MDT

  • Subject: Exploring the Buyer Workcenter and New Troubleshooting Tools for Approvals: PO Analyzer and Purge PO Workflows Script
    Date: 28-May-2013  3:00 pm GMT+01:00) / 10:00 am, EDT / 8:00am MDT

  • Subject: Powering Up Oracle Purchasing With Personalizations
    Date: 29-May-2013 3:00 pm GMT+01:00 / 10:00 am EDT / 8:00 am MDT

And there are two more scheduled for June:

  • Subject: R12 Period End Accruals - Theory,Practical Demonstration and Troubleshooting
    Date: 18-Jun-2013 3:00 pm GMT+01:00) / 10:00 am EDT / 8:00 am MDT

  • Subject: R12 On Line Accruals- Theory, Practical Demonstration and Troubleshooting
    23-Jul-2013 3:00 pm GMT+01:00 / 10:00 am EDT / 8:00 am MDT

Go to Doc ID 1456150.1 and register now!

Monday May 06, 2013

Did You Know Applying the 12.1.3 Rollup Patch (RUP) 15843459:R12.PRC_PF.B Will Prevent/Resolve the following Issues?

If you haven't applied the Procurement RUP Patch 15843459:R12.PRC_PF.B yet, then here are even more reasons to do so. 

Below is a listing of some of the issues that you can prevent happening in your environment by applying this patch.




PO & Req Processing


Find that upon doing a cancel, the form does nothing and returns back to the cancel form.


Prevent error FRM-40654 when there are trailing spaces in the tables for most of the fields. After applying the patch, the form will still display the error but a requery will allow to save the transaction.


Poor performance in Create internal orders process


When performing a search in buyer work center, it errors with 'You have encountered an unexpected error. Please contact the System Administrator for assistance'


Import Price Catalog error with ORA-6533


When creating a Requisition the item price is being rounded to 5 decimals



When attempting to Submit a Purchase Order for approval, error occurs: 'There exists a closed wip job for this document'


Action History form for Purchase Orders (PO) does not display the delegate action, as it does for Purchase Requisitions


In Oracle Purchasing, approval screen shows up only with buttons with no text on them


The note entered in the response section of notification is not displayed in the action history when a purchase order is rejected


In Oracle Purchasing, BPA were not getting approved if they were having any canceled lines with expiration date out of the effective range of the header



Unexpected error - java.lang.NullPointerException when attempting to view requisition details after using the "My Group's Requisitions" view


When changing the expiration date for an agreement in Buyers Worbench, it only displays items in iProcurement for new lines but not for old lines


Error 'An error has occurred during tax calculation which could impact tax information display' in requisition creation


After using the 'Back' button during requisition checkout, the following error occurs: An error has occurred in building your approver list

 Refer to Document ID 1468883.1 for all you need to know about the RUP.

Tuesday Apr 09, 2013

Register now for these upcoming Procurement Webcasts!

The Procurement team are announcing two upcoming webcasts in April and May. Webcasts are a great way to learn more about detailed topics, direct from the experts.


Subject:  Session Requisition Imported from other Modules (WIP, OM, …)

Date: 23-April-2013 at 2:00 pm, GMT Summer Time (London, GMT+01:00) / 3:00 pm, Egypt Time (Cairo, GMT+02:00) / 06:00 am Pacific / 7:00 am Mountain / 9:00 am Eastern

This one-hour session is recommended for technical and functional users who need to know about how to import requisition from other modules and the setup involved.  In addition troubleshooting and diagnostic steps will be presented.

Topics will include:

  • Introduction to scenarios in other modules from where Requisitions are created
  • Setups involved in each module
  • Requisition Import
  • Demo showing Tables Involved
  • Common Issues & Diagnostic Steps.


For more details and to register go to Doc ID 1456150.1.


Subject: EMD - Earnest Money Deposit in Oracle Sourcing

Date: 14-May-2013 at 2:00 pm, GMT Summer Time (London, GMT+01:00) / 9:00 am, Eastern Daylight Time (New York, GMT-04:00) / 7:00 am, Mountain Daylight Time (Denver, GMT-06:00) / 3:00 pm, Egypt Time (Cairo, GMT+02:00)

This one-hour session is recommended for technical and functional users who would like to utilize the feature of EMD in oracle sourcing. This session will provide the necessary setup steps to be done to enable EMD.  There will be a demonstration along with trouble shooting steps.  Additionally the integration with Oracle Financials will be explained.

Topics will include:

  • Concepts of EMD
  • Setup steps required to utilize EMD in sourcing
  • Demonstration
  • Troubleshooting steps
  • Q&A.


For more details and to register go to Doc ID 1456150.1.

Monday Apr 08, 2013

Check Out The Revamped Procurement Information Centers

Check out the new format in the Procurement Information Center.  From the main page Doc ID 1391332.2, choose the Product Group you are interested in: Purchasing, iProcurement or iSupplier Portal to access the Information Center you are interested in.

For example, drilling down on the Purchasing link we see tabs for each of the Product groups with information provided in a more user friendly format:

Visit the Information Centers for easy access to a wealth of cataloged notes without having to search.  You can access all information centers via the E-Business Suite Product Information Center Index (Doc ID 444.2).

Thursday Apr 04, 2013

Don’t Delay, Apply the New 12.1.3 Procurement Rollup Patch

A new critical rollup patch (RUP) has just been released by Development for our 12.1.3 Procurement customers.  This new Patch 15843459:R12.PRC_PF.B contains important fixes for Purchasing, Internet Supplier Portal (iSupplier), Sourcing  and iProcurement (Web).   Development and support advise customers on Release 12.1.3 to download and apply the latest patch.

Go to My Oracle Support and enter Document ID 1468883.1 in the Knowledge Base search. This note contains information on who should apply the patch, how to apply the patch, critical fixes and important new features.

Monday Mar 18, 2013

How to Diagnose and Resolve 'System failed to generate the PDF' Errors in Procurement

Did you Know that most of the Procurement ‘System Failed to Generate PDF’ errors can be resolved with a few setup steps and patching?  Doc ID 1520871.1 has been written to  provide you with best practices for preventing and resolving the error.

Doc ID 1520871.1

Don’t miss the important  sections where you can see how to quickly resolve known issues relating to this error.  Take a look at the note for comprehensive troubleshooting and if you have any questions come and ask the experts in the Procurement Community.

Thursday Mar 14, 2013

Resolving R12 Procurement Invalids

Did you know that there are 25 known issues with Procurement-related invalid objects after migrating to R12?  Check out Doc ID 1527251.1 'Guide to R12 Invalids for Procurement Products'.

Doc ID /1527251.1

The note provides the steps to first attempt to compile them through adadmin then, for any remaining invalids, the note gives instructions for known fixes.  So check out the note now if you have invalid Procurement objects after upgrading to R12, or if you are in the process of upgrading, check the recommended patches and avoid potential problems from happening.

Monday Mar 11, 2013

Do You Dread Accrual Reconciliation in Procurement?

Do you dread accrual reconciliation in Procurement?  The Accrual Diagnostics script is here to help!  Designed to be run when there is a reconciliation issue between subledger and GL, the Accrual Diagnostics script will spool full table contents to an html file.  Get all the data you need in one shot to analyze your problems with reconciling between the Subledger and GL.  Note the user friendly report output:

Accrual Diagnostic example output

Once you review the data if you still need help, you can provide the report output to Oracle Support to help expedite resolution. 

Visit Doc ID 1478292.1.1 now!

Tuesday Feb 12, 2013

Join our iProcurement Experts to Learn How To Diagnose Requisition Creation Issues


Subject: Diagnosing Issues With Requistion Creation in Procurement

Date: 19th March 2013,  at 2:00 pm, GMT  / 4:00 pm, Cairo / 07:00 am Pacific / 8:00 am Mountain / 10:00 am Eastern

This one-hour session is recommended for technical and functional users who are familiar with the Procurement module and would like to understand:

  1. Basic setup of Requisition Creation.
  2. Functionality of the Requisition Creation (i.e.; Copy to Cart, System Saved Requisition etc.).

Topics will include:

  •     Debugging setup related issues during Requisition Creation.
  •     Preliminary Checks for the issues related to the Requisition Creation.
  •     Demo on Requisition Creation.
  •     Knowledge Sharing on My Oracle Support Notes.


For more details and to register go to Doc ID 1456150.1

Don't forget that you can always see a schedule of upcoming Procurement webcasts and access archived webcasts from Doc ID 1456150.1.

Patch Wizard

Friday Feb 01, 2013

Don’t Miss These Upcoming Procurement Webcasts


Don't miss these three upcoming Procurement product webcasts.

These one-hour sessions are recommended for Procurement technical and functional users and cover topics such as setup, diagnostics and debugging.

  • Understanding Accrual Reconciliation Process and Troubleshooting in R12
    February 5, 2013
    at 2:00pm London / 6:00 am Pacific / 7:00 am Mountain / 9:00 am Eastern

  • Diagnosing Issues with Requisition Creation in Procurement
    March 19, 2013 at 2:00pm London / 7:00 am Pacific / 8:00 am Mountain / 10:00 am Eastern

  • Requisition Import Interfaced to Other Oracle modules
    April 23, 2013
    at 2:00 pm London /  06:00 am Pacific / 7:00 am Mountain / 9:00 am Eastern

Monday Jan 21, 2013

Avoid APP-PO-14142 Errors with Latest Procurement Rollup Patch

Did you know that by applying  Procurement 12.1.3 Rollup Patch 14254641:R12.PRC_PF.B you can prevent all of the following APP-PO-14142 errors?  Each note listed below indicates a known issue and provides a one off patch fix.  But by applying the rollup patch you can prevent all the issues listed.

APP-PO-14142 Errors

In addition, the patch also fixes a large number of other bugs and introduces new enhanced functionality such as implementation of Approvals Management for Purchase Orders, improvements in Buyer Work Center and enhancements to iProcurement.

For more information on RUP Patch 14254641:R12.PRC_PF.B see Doc ID 1468883.1.

Be Proactive and apply the patch today!

Wednesday Jan 02, 2013

Don’t miss the Procurement Webcast: ‘Understanding the Accrual Reconciliation Process and Troubleshooting in R12'


February 5, 2013 at 16:30 Cairo / 14:00 London / 6:00 am Pacific / 7:00 am Mountain / 9:00 am Eastern

This one-hour session is recommended for technical and functional users who would like to understand online accrual reconciliation process in R12 discrete manufacturing and troubleshooting steps described in Doc ID 1478292.1.

Topics will include:

  •     Overview of Accruals
  •     Setups
  •     Accruals Reconciliation Reports
  •     Accruals Data flow
  •     Diagnostics Script
See Doc ID 1516013.1 for further details.

Click here to register for this event.

Thursday Dec 13, 2012

Do you have Reconciliation Problems in Procurement between the Subledger and GL?

We are happy to announce the New Accrual Reconciliation Diagnostic & Troubleshooting Guide provided in Doc ID 1478292.1.  The Accrual Diagnostics script is designed to run when there is a reconciliation issue between subledger and GL and provides a user friendly report .  It was created to allow customers to run a single script to retrieve all data from various tables instead of having to run individual scripts. 

Doc ID 1478292.1 guides you through downloading and running the script, includes a full sample output in the attachments and gives steps for troubleshooting based on the report output.

Doc 1478292.1

We welcome your feedback for improvement of the Diagnostic. After visiting the note, click on the +/- icon in the note (shown in the sceenshot above) and provide us with your valuable comments!


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