Thursday Apr 24, 2014

So I heard about the R12.1.3+ EBS Wide RPC, how is that different than the 12.1.3 Procurement Rollup Patches?

For 12.1.3 most of us follow Doc ID 1468883.1 and apply the current Procurement Rollup Patch (RUP) listed, but lately there has been a lot of information being circulated about the Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 1 (RPC1).

The last RUP for Oracle Procurement was released in January 2014 (18120913:R12.PRC_PF.B) and the good news it is included in the new RPC1!  So if you are running R12.1.3 but have not yet applied the January 2014 RUP that is specific for Procurement then you can instead choose to apply this latest R12.1.3+ patch.  RPC1 includes rollup patches for many of our Product Family groups in the EBusiness Suite like ATG, CRM, HRMS, Supply Chain Management and more!

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)

Thursday Mar 20, 2014

Want to See a Use Case for the iProcurement Item Analyzer – Read on!

A user reported they could not find Item f1000 when searching in iProcurement:

So they ran the iP Item Analyzer and we see that the Item did not have the Purchasable field enabled. The results below show the error and the document with the steps to fix it.

Within minutes issue resolved!

This is just one of the many uses of the iP I tem Analyzer, so don’t delay apply it today! Doc ID 1586248.1

Tuesday Mar 18, 2014

Check Out the ERs Included in the 12.1.3 January 2014 Rollup Patch (RUP) 18120913!

Click here to see all the Enhancement Requests (ERs) that have been included in the 12.1.3 January 2014 Rollup Patch (RUP) 18120913:R12.PRC_PF.B.

 Following is just a little snippet from the link:

Tuesday Mar 11, 2014

Planned Enhancement Requests for Inclusion in the Procurement Application Suite

The Procurement Development team is pleased to announce the first round of 'PLANNED' Enhancement Requests (ERs) for inclusion in the Procurement Suite of Applications.  Development selected these ERs based on Community Voting, number of Customers attached to the ER as a result of Service Requests (SRs) logged, and feasibility for implementation. The SRs were used in this selection process since this ER Community is only 4 months new.  Future ER selection will be based solely on the 'Voting' contained within this community space. 

To see a list of these ERs and for more information : click here

Thursday Mar 06, 2014

Did You Know? Here’s just a few reasons why you should apply the new 12.1.3 Procurement RUP Patch

The new 12.1.3 Procurement Rollup Patch (RUP) 18120913:R12.PRC_PF.B offers so much more than just a cumulative collection of bug fixes.   Here’s just a few reasons you should apply this patch:

•    Extensive improvements to the Buyer Work Center (BWC) searching, preferences and Blanket Purchase Agreement (BPA) Lead Time are included
•    Enhancements to the Purchasing Document Open Interface (PDOI) in the area of document creation and referencing, Advance Pricing and more
•    Includes all fixes for iSupplier Portal, Sourcing & Supplier Lifecycle Management (SLM) Rollup Patch :17525552:R12.PRC_PF.B detailed in Note 1591198.1
•    Includes all the fixes for the Purchasing Approvals Rollup Patch : 16932593:R12.PO.B which includes AME and is detailed in Note 1567464.1

For all the information you need to know about the new RUP see Doc ID 1468883.1.  Now I know RUPs contain several hundred files, but the impact on your system is most likely far less. Patches contain hard-prerequisites that are intended to make a patch work on a very low code baseline.  So in this note there is a link to the Patch Wizard which will provide a detailed impact analysis for the RUP. The analysis gives you an idea of how the patch application will impact your environment.

So don’t delay apply Patch 18120913:R12.PRC_PF.B Today!

Monday Feb 10, 2014

Urgent! Change in the HTTP Proxy Service Used for OSN - Oracle Supplier Network Starting February 16th

Oracle Supplier Network currently uses the HTTP Proxy service - - for document delivery.  The proxy service is due to be decommissioned on 16th Feb 2014 at 10:00 AM GMT and a new proxy service hosted by Oracle Managed Cloud Services - - will be used instead.

What does this mean for Oracle Supplier Network customers?

Outbound requests from Oracle HTTP Server mid-tiers should go through the OnDemand HTTP proxy services, and, which are the BIG-IP virtual servers that load balance the actual physical devices.

To ensure continued connectivity, the subnets for the new proxy service must be allowed access in customer's firewall.  Please see 'What are the IP Addresses for OSN' (Doc ID 435409.1) for a listing of the required subnets.  You may open the firewall to receive requests from the subnets mentioned in the note.

These configuration changes need to be done by 16th Feb 2014, 10:00 AM GMT.  If you do not complete these changes before the mentioned time, the documents delivered by Oracle Supplier Network might fail to reach your ERP system."

For more information see the Procurement Community thread: 'Urgent!!! FAQ - Change in the HTTP Proxy Service Used for Oracle Supplier Network (Doc ID 1620906.1)'.

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'.

Wednesday Jan 29, 2014

New Release of the PO Approval Analyzer – Now Includes AME!

Version 120.15 has just been released for the Approval Analyzer in Doc ID 1525670.1.  It now includes improvements to formatting, with your document information listed first and proactive information following.  Most importantly, if you are using the Approval Management Engine (AME), the analyzer now includes checks for both Purchase Orders and Requisitions.   Get information you would normally have to obtain from the AME Test Workbench to include:
  •     AME Setup information
  •     Rules (including Conditions and Actions)
  •     Attributes and  Action Types
  •     User friendly error messages will be displayed on the AME Approvers list (when there are setup issues); for example:

AME error message

AME package versions are included and much more.  Obtain the PO Approval Analyzer at Doc ID 1525670.1.

Still have questions on the Analyzer?  Post your comment in the Procurement Community thread here: New Release of the PO Approval Analyzer – Now Includes AME!

Wednesday Jan 22, 2014

R12 Master Generic Data Fix Diagnostic for Purchase Orders and Requisitions

Do you wish you could proactively check your Purchasing documents for known data integrity issues or is there a Purchasing document you are having problems with?

Well, visit Doc ID1474734.1 for the R12 Master Generic Data Fix Diagnostic for Purchase Orders and Requisitions.  Running this one script identifies known data integrity issues within the Purchasing application (for example errors with cancel and close and unit of measure issues) where there are often generic data fixes (GDFs) already available.  The script will produce an HTML output report of all known problems relating to the purchasing transactions created in the specified date range, along with information on notes and/or data-fix patches which are already be available to resolve the data issues.

The following data checks are included:
  • Document type records with null ORG ID.
  • Synchronization issues with archive tables.
  • Quantity billed/amount billed mismatch in purchase order shipments and distributions.
  • Purchase orders with a mismatch of quantity billed or amount billed between the shipment or distribution and the invoice distribution.
  • Purchase order shipments eligible to be closed.
  • Outstanding supply/demand for non-existing or cancelled requisition lines.
  • Fully received internal requisitions continue to show as pending supply.
  • Approved requisitions not available in Autocreate form after associated purchase order is deleted.
  • Purchase orders with unit of measure (UOM) mismatch between Lines and Shipments.
  • Canceled purchase orders in Requires Reapproval status.
  • Tax exception 023 (ORA-00001: unique constraint (ZX.ZX_LINES_DET_FACTORS_U1) violated) when approving.
  • Purchase order with authorization_status = 'REQUIRES_REAPPROVAL' rather than 'REQUIRES REAPPROVAL'.
  • Foreign currency autocreated purchase orders have inverse rate.
  • Purchase order ship-to organization does not match distribution deliver-to organization.
  • Requisition distribution line associated to multiple PO distribution lines.
Don’t delay make Doc ID1474734.1 part of your routine Procurement procedures today!

Thursday Jan 16, 2014

Procurement Accounting - Don’t Delay, Be Proactive and Apply These Necessary Patches

Are you using procurement accounting processes?  Then don’t delay, be proactive and apply these necessary patches to avoid known issues.

So many known issues have been resolved by applying the collection of recommended patches in Doc ID 1594111.1.  Procurement, Costing, Payables and SLA Development teams have collaborated to give you this consolidated list.  Now I know you're thinking that it requires a lot of effort to apply big patches, but while a patch may contain several hundred files, the impact on your system is most likely far less.  Patches contain hard prerequisites that are intended to make a patch work on a very low code baseline, so there is a link to the Patch Wizard so you can perform an impact analysis.   So if you are using Procurement Accounting Flows (Encumbrance and Accruals) make sure and review the note where the steps are clear and to the point:

Don’t delay check out Doc ID 1594111.1 today!

Monday Jan 13, 2014

Don’t Miss the February 18th Webcast for iProcurement With Oracle Endeca Integration


Webcast: Enhance User Experience in iProcurement with Oracle Endeca Integration

Date: February 18, 2014 at 2:00pm GMT, 9:00am EST, 7:00am MST, 4:00pm Egypt

Oracle Endeca combined with Oracle E-Business suite provides best-in-class technology and applications for unstructured data management, guided navigation solutions, business intelligence and web commerce.  In this webcast we will see an overview of the technical and functional architecture of Oracle Endeca with the Oracle Manufacturing modules. A demonstration will show how this integration enhances the user experience in manufacturing modules such as iProcurement.  A case study using iProcurement and Oracle Endeca Guided Search will show how a Requestor can contribute to increased cost-savings by expanding negotiated prices, handling huge data volume, value additions, productivity improvement and minimizing time for Procurement while procuring goods .

Topics will include:

  • Help the business in Simplicity of Search Facted Navigation Visual Analytics
  • Walk-up easy to use - derived from 10 years of e-commerce user experience
  • Easy to use huge volume of data with minimal infrastructure
  • Eliminate customization and minimize the time to procurement process

Don’t delay sign up today!


Details and Registration: Doc ID 1611242.1

Thursday Jan 02, 2014

Do you Deal with Supplier Profile Management flows?

Do you Deal with Supplier Profile Management flows?  Well if so, you will want to read this…..

There have been a lot of changes in Release 12 and higher with the integration of Trading Community Architecture (TCA), where supplier data is part of the parties architecture.

See these important references to get the full picture:

  • Doc ID 1591187.1-*Upgrade Issues* Supplier Data Model, Upgrade Scripts and Patches For Data Issues In The Upgrade To 12.X: this note provides a compilation of important references for this data model change (including manuals).
  • Doc ID 1607664.1- Diagrams of TCA - Trading Community Architecture - Data Models Showing Logical Design as Used in Supplier Management:  diagrams showing the data models in 11i and R12 for Supplier Management are shown here.  These diagrams are useful for comparing differences between the releases and understanding the logical data model.  The ERD - Entity Relationship Diagrams - are also provided to clarify the models further.
  • Doc ID 1596801.1- UPGRADE Supplier Data Model From 11i to R12 - List and Description of Scripts Used During Upgrade: obtain details of upgrade scripts used for upgrading supplier data from 11i to R12 to comply with the new data model for supplier data in R12.  This data is used by products from Oracle Applications like iSupplier, Purchasing, iProcurement, Sourcing, Payables, etc.
  • Doc ID 1591190.1- *Upgrade Issues* Supplier Data Issues After Upgrade to 12.X and Generic Data Fix Patches: this document lists the data issues after the upgrade and the generic data fix patches available.

Still have Questions? Access this Procurement community post and, using the reply link, put in your question/comment.

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!

Tuesday Dec 10, 2013

Seeking Feedback: Procurement Mobile Applications: What features would you like to see included in a Mobile Solution?

As development works to enhance and expand the Procurement Suite of applications, we are interested in getting your thoughts around some of the features under discussion currently within the Development organization for Procurement mobile applications. 

Please note: these solutions are currently NOT available and will NOT be included in the immediate Roadmap.

Development would simply like to hear from you on whether a Mobile Solution makes sense for your business, and if it does, what would you be looking for in a Mobile solution?

Go to the link here to read more information and post your comments: Seeking Feedback: Procurement Mobile Applications: What features would you like to see included in a Mobile Solution?

Please share with us, we want to hear from you!  Let's get a discussion going on Mobile!!!

Monday Dec 09, 2013

Recommended Patching for Release 12 Procurement Accounting Processes

Not sure what patches you need to apply to optimize your Procurement Accounting processes and avoid known issues?  Well Doc ID 1594111.1 makes it easy for you.  Follow the steps in the ‘Recommended Patching Steps’ section to get the patches for all product groups including Purchasing, Payables, SLA and Costing that impact your Procurement Accounting Flows.   The note additionally provides information on who should apply the patching and how to perform an impact analysis, as well as any known issues you should be aware of.


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