Monday Oct 07, 2013

What Are The Top ERs in Buyer Work Center?

Would you like to know the disposition of the Top Buyer Work Center (BWC) Enhancement Requests?

Check out Doc ID 1584755.1 which reports on Top BWC Enhancement Requests (ER) that have been implemented, are planned to be implemented within 12 months, or are future planned (part of Development's road map but there is presently no specific implementation date).  These Enhancement Requests are considered 'Top' ERs because they have the highest number of client requests.

See valuable information about fixes, workarounds and more (Doc ID 1584755.1).

Friday Sep 27, 2013

New Procurement Enhancement Community Launched

We are pleased to announce the launch of the Procurement Enhancement Request Community!

This Community has been launched as a new channel to capture and track Enhancement Requests (ERs) for the Oracle Procurement suite of products. ERs captured in the community will be available for collaboration, discussion, and voting in order to highlight those which are most meaningful and impact product value and usability.   Not only can you easily vote for the ERs you want to see adopted but you can also log, track and discuss each ER.  Click on the ‘Quick Preview of Voting List’ and vote by using the thumb icon.  Let your voice be heard by telling us what you want to see implemented in the Procurement Suite.

We really want to hear from you, visit the Procurement ER Community today!

Tuesday Sep 17, 2013

PO Approvals Analyzer Improved

It's hard to keep up with the improvements being made to the PO Approvals Analyzer.  Check out the new version 11 which includes these new features/fixes:
  • Document types section now displays all the settings
  • Resolved issues for blanket releases including incorrect information in distribution section, execution errors when document quantity is zero and exceptions in authority checks
  • Improvement in performance when the analyzer is run for multiple documents
  • Concurrent program was not displaying blanket releases in list of values (requires a reload of file podiagaa.ldt)
PO Approvals Analyzer
Don’t delay another day, download it now! See Doc ID 1525670.1.

Friday Sep 13, 2013

What's New In the Procurement Community Development Corner?

Have you seen what’s new in the Development Corner of the Procurement Community?  There is an interesting focus on the Buyer Work Center (BWC).

See what Procurement Development is driving and join the conversation today!

Friday Sep 06, 2013

Procurement Sessions at Oracle Open World 2013

Check out what is being offered at Open World for Procurement Users.  We have a full week of exciting offerings beginning Sunday, September 22. Don’t miss it!

Oracle Open World 2013

General Sessions: Monday, Sep 23, 2013
Oracle E-Business Suite - Strategy, Update, and Roadmap
 Clifford Godwin, Oracle
12:15 PM - 1:15 PM
Moscone West - 2002/2004
Conference Sessions: Monday, Sep 23, 2013
Oracle Procurement and Spend Analytics for Strategic Sourcing
 William Tokheim, Oracle
 10:45 AM - 11:45 AM
Moscone South - 304
Oracle Advanced Procurement: Strategy, Update, and Roadmap
 Barbara Fox, Oracle   Paulo Back, Oracle
 3:15 PM - 4:15 PM
Moscone West - 2009

Tuesday, Sep 24, 2013
Oracle Supplier Management, Oracle iSupplier Portal, and Oracle Supplier Hub for Collaboration
 Bandarupalli Bharadwaja, Oracle   Mark Peachey, Oracle
10:30 AM - 11:30 AM
Moscone West - 2009
Manage Spending with Oracle iProcurement Extensions for Oracle Endeca/Oracle Supplier Network
 Mark Peachey, Oracle  Sai Pondalur, Oracle
12:00 PM - 1:00 PM
Moscone West - 3018
Improve Spending Visibility with Oracle Procurement and Spend Analytics
 Sree Vaidyanathan, SCEA   Narasimharao Adivikolanu, Oracle
 3:45 PM - 4:45 PM
Moscone South - 307

Wednesday, Sep 25, 2013
Oracle Sourcing and Oracle Procurement Contracts: Actions You Can Take to Spur Performance
 James Anthony, E-Three Limited 
 Pierre Mitchell, Azul Partners
 Paul Mulroy, State Street Bank and Trust Company
 Chris Nelms, Ameren Services Company
 Daniel Ashton, Oracle
11:45 AM - 12:45 PM
Moscone West - 2009
Integrated Oracle E-Business Suite Procurement: Advantages of a 'Suite' Approach
 Sheri Anilonis, Prudential Financial
 Anthony Filosa, Prudential Financial
 William Tokheim, Oracle
3:30 PM - 4:30 PM
Moscone West - 2009

Click for More Information

Click here to see all the offerings available.

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.

Friday Aug 16, 2013

Procurement Community Development Corner is Now Live!

We are excited to announce the launch of our Procurement Community Development Corner, which is now live!  Visit this area regularly to get the latest information straight from the Procurement Development teams. 

We encourage you to participate in any of the discussions presented in this region whether you have additional questions, want to share some best practices, or just want to comment on the discussion.   Check it out!  

Thursday Aug 01, 2013

Hot Off the Presses! Get Your Early Release of the August 2013 Procurement Newsletter!

Get all the recent news and featured topics for the Procurement modules including Purchasing, iProcurement, Sourcing, iSupplier and Oracle Supplier Lifecycle Management.  Find out what Procurement experts are recommending to prevent and resolve issues.

The August newsletter features articles on:
  • The New/Updated Purchasing R12: PO Approval Analyzer Diagnostic Script
  • NEW 12.1.3 Rollup (RUP) specific for Approvals
  • Recommended Patching for the Buyer Work Center in Release 12  

And there is much, much more!

Access the newsletter now:  Doc ID 111111.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)

Tuesday Jul 16, 2013

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!

Wednesday Jul 03, 2013

Attention All Procurement Buyers!

Have you discovered the power of the Buyer Work Center?   Released in Procurement 12.0 the Professional Buyer Work Center (BWC) is a web based interface that provides a central 'launch pad' from which you can efficiently perform your daily tasks, including: 
  • You can manage your requisitions and create them to Purchase Orders (like manual autocreate)
  • Create new standard purchase orders, blanket purchase agreements, or contract purchase agreements
  • Create and maintain supplier information
  • If Oracle Sourcing is licensed and implemented, you can create buyer's auctions or sourcing RFQs
  • If Oracle Services Procurement is licensed and implemented you can create and maintain purchase orders for complex work payments
  • If Oracle Procurement Contracts is licensed and implemented you can handle author contract terms and manage deliverables

Globally for the BWC:

  • Create and personalize your own document views including list of columns, where conditions and sort sequences.
  • You can additionally use predefined document views.

Accessed from the Purchasing responsibility as we see in the screenshot here, the Buyer Work Center has links to launch to the areas you want to access.

Buyer Work Center

See these documents for more information on the BWC:

Doc ID 1301969.1: FAQ - Buyer Work Center

Doc ID 1394392.1: Assistant: Oracle Purchasing Purchasing Buyer Work Center Search Helper.

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.


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 2016