Friday Aug 21, 2015

New White Paper on Using Web ADI Spread Sheet in the Buyer Work Center Orders (BWC)

See this just released white paper for the BWC covering the following topics:

1.    Overview
2.    Limitations
3.    Prerequisites
4.    Demo Test Cases
       a.    Update existing PO lines, shipments, pay items, and distributions
       b.    Adding New Line to Exiting PO
5.    Technical changes
6.    Troubleshooting
7.    Known issues

Any questions? Start a discussion in the Procurement Community.

Thursday Aug 13, 2015

Have you used R12: Master Data Fix Diagnostic to Validate Data Related to Purchase Orders and Requisitions?

Check out the Master Data Fix Diagnostic to Validate Data Related to Purchase Orders and Requisitions for Release 12!

This diagnostic will allow you to address many data integrity issues without requiring you to log a Service Request with support. The script produces an html output of known problems relating to the purchasing transactions created in the specified date range.  It additionally nicludes information on notes and/or data-fix patches, which may already be available to resolve the data issues.

Use it proactively to scan all transactions in the specified date range and head off potential issues. This script may be run in production safely at any time. No data is created, updated, or deleted.

Run this diagnostic prior to logging a Service Request when you suspect there is data corruption, or if you simply want to proactively verify the data integrity of your transactions.

For more information on Master Data Fix Diagnostic to Validate Data Related to Purchase Orders and Requisitions, please see Doc ID 1474734.1.

For a list of available Generic fixes, see Oracle Purchasing Generic Datafix Index Doc ID 1348821.1.

Sunday Aug 02, 2015

Procurement Analyzers

Have you discovered the E-Business Suite Product Based Support Analyzers? From Doc ID 1545562.1 scroll down to the Procurement section and see these valuable offerings.  Each analyzer is specialized to help you diagnose issues before logging a Service Request, click on ACT for direct access.  What makes analyzers special is they not only provide you with errors found, but provide solutions as well. The analyzers are safe to run in Production and can be setup as a concurrent requests so all your users can access the valuable output.  Check them out today!

As new analyzers are created we will add them to Doc ID 1545562.1 so don't forget to bookmark the document!

Wednesday Jul 08, 2015

Does the Approval Analyzer show "Authentication failed" in the Output?

An issue has been reported for some customers that after running the Procurement Approval Analyzer and saving the html output, the output file shows: 

"Authentication failed."

The cause of this issue is linked to the Temp ID given to the report output.  The source data for the page becomes cached, so is no longer valid.  This invalid state fails the page source data build, so when going to save the page data, there is no source data present to generate the saved file.  The way this is prevented is to force a page rebuild each time, so the cached state does not occur.

So what is the solution?

For Firefox: enter the following string into the URL location box in the Firefox browser


Click through warning dialog box
•  Search for "browser.cache.check_doc_frequency"
•  Change the value to "1"
•  Exit the browser session window to save

For Internet Explorer:

•  In the IE Browser go to "Tools" => "Internet Options"
•  Select the "General" tab => "Browsing History" => "Settings"
•  Set "Check for newer versions of Stored Pages" to "Every time I visit the webpage"
•  Exit Tools section to save setting change

Still have questions?  Click here to post your question.

New to the Procurement Accounting Space - Introducing the EBS iProcurement Change Request Analyzer!

Newly released in the Procurement Accounting space is the EBS iProcurement Change Request Analyzer for Release 12!

The single document provides all the information needed to troubleshoot the problem with the change request process.

The analyzer scans your iProcurement footprint, configuration, environment, and transactional data.   For areas of concern, the output will provide recommendations to prevent future issues and point to existing solutions for uncovered problems.  Most existing solutions can be implemented without logging a Service Request.

Checks include:

  • Lists existing change requests associated to the document and the workflow processes involved
  • Provides change order tolerances, related archive tables and data collection
  • Document Validations include:
    • Supervisor Hierarchy and Approver List Validations
    • PO with Pending Changes that are In Process
    • Purchase Orders that are not Open/Approved or Shipment Level Open
    • Non-Catalog Requisition Prices Change
    • Purchase Order is Partially Received or Billed
    • Requisition is on a Complex Purchase Order
    • Requisitions with pending Receiving transaction
    • Allow Price Override is not checked
    • Accrue on receipt flag is Y
    • Purchase Order Shipments do not correspond to the same requisition line

Simply run the analyzer as a SQL script or as a concurrent request, by following EBS iProcurement Change Request Analyzer, Doc ID 1917475.1

Previous suggestions and feedback were used to develop the analyzer.  Now you have the ability to drive us in your direction.  Post your comments to improve the usefulness of this tool in your environment by adding a reply here.

Try this analyzer before logging  a Service Request when you are experiencing change request issues.

Monday Jul 06, 2015

Need Help with PO Output for Communication Issues?

See our data collection for everything you need to know:

 Doc ID
 Title  Purpose
1535771.1 POXPOPDF: PO Output for Communication Collection of Known Code Issues and Patch Fixes Divided into Releases from through12.2 see supports list of recommended patching.
1532387.1 Frequently Asked Questions POXPOPDF: PO Output for Communication Visit the FAQ which provides answers to questions ranging from  basic setup to attachment issues to customization tips and tricks, and more!
1377764.1 Troubleshooting Assistant: Oracle Purchasing PO Output for Communication / Supplier Notification Issues Use the assistant by selecting your symptoms and be guided to supported solutions.
1375082.1 Master Troubleshooting Guide for POXPOPDF: PO Output for Communication Providing targeted steps for troubleshooting, try these before logging a Service Request.

 Still have questions?  Start a discussion in the Procurement Community.

Thursday Jun 25, 2015

Just Released! Version 200.2 of the iProcurement Item Analyzer

What's new in version 200.2?

We've added additional profiles to the iProcurement Specific Profile Options section:
   - POR : Amount Based Services Line Type
   - POR : Goods Line Type
   - POR : Rate Based Services Line Type

New Patch Checks are included along with a check is now made for custom packages.  Additionally we have added the Procurement Code level section for 12.0.x, 12.1.x, 12.2.x and some code changes for EBS Framework version 3.0.25.

Download it today at Doc ID 1586248.1!

Do you have additional questions or feedback?  Well post them here.

Wednesday Jun 10, 2015

New version 200.5 of the 12.1.3 Procurement Approval Analyzer Just Released!

Like a fine wine we keep getting better over time! Download the new version 200.5 of the 12.1.3 Procurement Approval Analyzer today here.

Improvements include:

1. Bug fix for the request ending up in warning
2. Change of wfstat signatures that were defined backwards - results should be the same as before
3. Added the following signatures to the DX summary: APP_HIER_CHECK1, APP_HIER_CHECK2, APP_HIER_CHECK3, APP_HIER_CHECK4, APP_HIER_CHECK5, APP_HIER_CHECK6

Need more information?  Reply here.

Monday Jun 08, 2015

Important Update on the March 2015 12.1.3 Procurement Rollup Patch

If you haven't heard there is a new replacement for 12.1.3 March 2015 Patch 19602627:R12.PRC_PF.B in Patch 21198991:R12.PRC_PF.B.  For details and complete patching instructions see Note 1468883.1.

Questions or concerns?  Reply here.

Friday Jun 05, 2015

Have you applied the March 2015 12.1.3 Procurement RUP? Or have you seen a problem with the Action History of Requisitions being Deleted?

We have been notified by Procurement Development that there is critical issue where upon deletion of an incomplete Requisition the action history of all requisitions are deleted.  This occurred because of Patch  19289104:R12.ICX.B which has since been set to obsolete, but was already included in the March 2015 RUP.

There has also been an additional symptom seen where a single requisition action history is getting deleted on edit by the approver.

 If you have applied either Patch 19289104:R12.ICX.B or the March 2015 Procurement Rollup Patch (RUP) 19602627:R12.PRC_PF.B in order to prevent this problem, please perform the following:

1. Download Patch 19686669:R12.ICX.B 'This patch resolves the issue of deleted incomplete requisition history in po_action_history table' and Patch 20042118:R12.ICX.B 'This patch resolves the issue of ORA-06512 IN WORKFLOW WHEN USING EDIT REQUISITION'.   Be sure to follow the readmes for any important patching steps.

2. Ensure that you have taken a backup of your system before applying the recommended patches.

3. Apply the patch in a test environment and confirm the following file versions:

patch/115/sql  ICXVUTLB.pls  120.18.12010000.14     
patch/115/sql  ICXVUTLS.pls  120.14.12010000.4     
java/por/req/server  120.9.12010000.15  
patch/115/manualsteps/ad_apply_patch.xml 120.3.12000000.2     
patch/115/sql/PORUTILB.pls 120.20.12000000.41   
patch/115/sql/PORUTILB.pls 120.69.12020000.53   
patch/115/sql/PORUTILB.pls 120.132             
patch/115/sql/PORUTILB.pls 120.28.12010000.62

4. Clear the cache on the server.

a. Responsibility: Functional Administrator
b. Click the Core Services tab.
c. Click the Caching Framework subtab.
d. Click the Global Configuration link on the left side of the page.
e. Click the Clear All Cache button, then click "Yes" to confirm the deletion of the java cache on the server.  Allow this to complete.
f. Log out of the applications.

5. Bounce the iAS/OC4J processes on the applications middle tier(s) in order for the code changes to take effect.

6. Migrate the solution to other environments where 19602627:R12.PRC_PF.B has been applied.

If you have any questions/concerns reply here

Thursday May 21, 2015

Receiving Errors When Validating Invoices? APP-PO-14144: PO_ACTIONS-065 CLOSE_AUTO

Are you getting this symptom when attempting to validate invoices?

APP-PO-14144: PO_ACTIONS-065: subroutine CLOSE_AUTO() returned error

Check out these two references:

Doc ID 1987958.1 Attempting to Validate Invoices: APP-PO-14144: PO_ACTIONS-065

Doc ID 1966826.1 Validate Invoice: APP-PO-14144: PO_ACTIONS-065: Subroutine CLOSE_AUTO() returned error

 Need more information?   Post your question in the Procurement Community here.

Friday May 15, 2015

The Procurement Accrual Accounting Analyzer has been improved!

We just released a new version of the Release 12 EBS Procurement Accrual Accounting Analyzer for Release 12!

Although there has only be one change, its a big one.   Now the analyzer can  identifies write off transactions not transferred to XLA.

Get all the information you need and download the analyzer directly from  Doc ID 1969667.1

And don't forget you have the ability to provide feedback and drive our changes in your direction.  Post your comments to improve the usefulness of this tool in your environment by adding a reply here.

Try this analyzer before logging  a Service Request when you are experiencing accruals issues.

Thursday Apr 30, 2015

Critical Update to the EBS Procurement Approvals Analyzer (Version 200.3)

Today we have released a new version of the EBS Procurement Approval Analyzer.  Its not that we want to keep you dba's busy but there were some critical updates that necessitated this change.

In the new version 200.3 we have modified for the following errors in the analyzer output.

Under the Approver checks:
- Error:This employee is not assigned to any active applications user.
- Error:This employee does not exist in the workflow tables (WF_USERS)
- Warning:There is a loop in the employee/supervisor hierarchy   

In the Document Manager Errors section:
-ORA-01403: no data found error in R12.2 in the "Document Manager Errors" section

Download version 200.3 today here!

Thursday Apr 23, 2015

So really why should I apply the March 2015 12.1.3: Procurement Family Update - Rollup Patch?

Well for one thing there have been great improvements to the Purchasing Document Open Interface (PDOI) for 12.1.3, but additionally check out all the improvements in the iProcurement, Sourcing, Purchasing and SLM areas, as listed below.  Scared applying these big rollup patches?  Well don't be! run the Patch Wizard and you'll most likely find that the impact to your system is far less.  Get all the information on this patch including a link to the patch wizard via Doc ID 1468883.1.

Feature Name Description


Requisition Update API

The Requisition Update API enables users to update multiple requisitions one at a time.  Using the Requisition Update API, users can update requisition information (such as header,lines, distributions) and can also add new lines to the requisition. Users can update incomplete and approved requisitions (provided the approved requisitions are not associated to a purchase order).

Autowrap for Requisition Description

The Requisition Line Details page enables you to enter a Requisition Description. You can enter a long description that will be autowrapped and will be easily readable, instead of your having to scroll to the left or right to see the requisition description.

Content Zone Enhancements

The categories or supplier columns in a Content Zone in iProcurement was previously limited. Users needed to define multiple content zones for this reason. This has now been extended and users can enter or define categories or suppliers in a single Content Zone.

Change Reason added to Change History page

When a Change Order is initiated, the Change History page displays a Reason column to enable the user to enter a reason for the changes made to the requisition.

Search Capability in Smart Forms

The iProcurement Catalog Administrator can search for one or more smart forms using the Search button for Smart Forms. The Search parameters are: Smart Form Name, Operating Unit, Item Type, Stores. The Add Another dropdown enables you to select other search criteria.

Returning Requisition Lines In the Demand Workbench (Oracle Purchasing), if a requisition has multiple lines and the buyer returns a requisition line, only that line is returned instead of the entire requisition. The remaining lines are available to autocreate purchase orders and are available in the Demand Workbench. The returned lines go back to iProcurement.
Reminder Notifications for Requisitions with AME setup The modified Approval Management Engine (AME) Approval process in the Requisition Approval Workflow enables you to send reminder notifications to approvers during the requisition approval process.
Contract Number Parsing in CXML Shopping Cart The system parses 3 new extrinsic elements  (buyerContractLineNumber, buyerContractNumber and  supplierContractNumber) to support the contract numbers in CXML. The supplier is able to send these details in the cXML during Punchout.(similar to the native XML format) so that this item gets linked to the contract in the requisition line created.


GBPAs and POs in Supplier Scheduling Supplier Scheduling enables viewing expected deliveries based on shipping schedules and planning schedules, for the standard purchase orders created that refer to Global Blanket Purchase Agreements (GBPAs).

ASL API Enhancements

The Approved Supplier List (ASL) API enables users to create, update, and delete approved supplier lists in bulk.

Using the API, users can create an ASL with details that include type, commodity, item details and key attributes such as supplier, site, operating unit, and manufacturer. Other ASL attributes that can be created include plan schedule, shipping schedule, delivery calendar, ASL capacity, and tolerance information.

Cancel Backing Requisitions from a Complex PO Users can select or unselect the Cancel Requisition option on the page, and re-create the demand if the backing requisition is not canceled.


Dynamic Questionnaire The Requirements section is used to gather information from the suppliers in a negotiation document. The Requirements section now has a hierarchy, where dependent requirements are included. Based on the supplier response, the subsequent question(s) change dynamically for the supplier. There is a two-level hierarchy of dependent questions for every questionnaire. The advantage is that no superfluous questions are asked of the supplier during the questionnaire. The questionnaire will come up with different question set combinations, depending on how the supplier responds in the initial question(s).
Create Negotiation: Supplier Page Enhancements

The Supplier tab in the Create Negotiation page has been enhanced with the following features:

  • ability to sort by supplier
  • ability to delete some or all suppliers
  • removal of duplicate suppliers when a reusable list is added to the supplier invitation list
Buyers can Edit Approved Negotiation Documents

Approved or Draft Negotiation documents can be edited by buyers.

Buyer's Manager can be Removed from Collaboration Team A buyer can delete his manager who was added to the collaboration team members. This removal can take place when the document has a status of Draft or is Published. Using the Manage Collaboration Team option, buyers can remove their managers from the negotiation approval process.

Supplier Lifecycle Management

Prequalification Template

During the supplier prequalification and registration process, buyers often find that they need to gather further information from the supplier. This can be due to incomplete entry of the registration form, outdated information, inadequate information given by suppliers, attaching a non-specific information gathering form for supplier responses by the buyer, etc.

The Supplier Registration page enables buyers to quickly scan the supplier responses. However, it is cumbersome for buyers to attach a prequalification template that is completely relevant to the supplier's profile. Additionally, only one template can be attached to the Supplier Registration process at a time. In order to address these issues, the buyer can now do the following:

  • The buyer administrator can link one or more questionnaire lists to a profile attribute. Questionnaire Lists are attached to Profile Attributes using the Profile Extension page.
  • When a supplier registers, the system will retrieve the appropriate questionnaire list based on the supplier attributes that are found in the supplier registration page, as part of the supplier responses.
  • The buyer can now select one or more questionnaire lists and send the selected lists to the supplier for gathering supplier responses and further information.
Streamline Supplier Registration Approval Process

With the streamlined supplier registration approval process, users can:

  • Ask suppliers to provide more information by selecting the Use the Supplier to Provide Details action in the actions drop down list in the Supplier Request Review page.
  • Use the New Supplier Registration Process page to register a new supplier. Three new buttons are available on this page: Cancel, Save and Continue, Send Invitation to Supplier. Users can click Save and Continue to save the supplier information and take the requester to the next page (New Supplier Request) where the user can enter additional information and select actions such as Register, Save, Cancel. Send Invitation to Supplier saves the information and sends an invitation notification to the supplier to register. The status of the request is now Supplier to Provide Details.
  • Enter profile attributes: Buyers and suppliers are required to enter User Defined Attributes (UDA).  When the requester selects the Send Invitation to Supplier action in the request review page, all the mandatory UDA attributes to be entered by the user are validated and appropriate errors message will be displayed to the requester in case he has missed any such UDA.
  • Send the Pre-Qualification Questionnaire: The user sends an invitation to register to the supplier. Then the Action Required: Please fill out the Supplier pre – qualification questionnaire notification is sent to the supplier.
Update Submitted Evaluation The system enables buyers to update previously submitted evaluations. Additionally, a warning message is sent to the evaluation team member who attempts to update an evaluation for an Assessment, for which the scoring is locked.
Also users can send email notifications to various stakeholders (including evaluation teams) using Online Discussions, so that the administrator can inform / remind the team members of important dates such as Lock Scoring Date, date of completion of Assessment, etc.
Oracle iSupplier Portal: Supplier Registration related Enhancements

The following enhancements are related to the supplier registration process:

  • The prospective supplier registration approval notification page displays status history and notification history. When the buyer approves or rejects a prospective supplier, the system notifies the supplier. If rejected, the system informs the supplier the reason for rejection, which is captured in Note to Supplier. In this scenario, rejection is permanent and cannot be revoked. If the administrator does not want to reject and would like to send it back to the supplier to update their request / enter additional information, administrators can use Return to Supplier after entering a note to the supplier.
  • As a buyer you can add a new approver or an FYI approver during the supplier registration process, using the Manage Approvals action. As a current approver you can also add a new approver or an FYI approver during the supplier registration approval process, using the Manage Approvals action. Both buyer and current approver need to note that they can only add a new approver or an FYI approver only after current approver group(s), and not before or between current approver group(s).
  • The Approval History link in the Supplier Profile page (Quick Update page), displays the supplier registration approval history. If there is no approval history for the supplier, an appropriate message displays to tell the user that no approval history has been found for the supplier. The Approval History page enables internal users to track the history of supplier records, such as who approved or rejected the supplier and when.
Oracle Supplier Lifecycle Management Enhancements

Several improvements have been made to the Supplier Lifecycle Management (SLM) user interface, functions and features. Key reasons for improving and enhancing the SLM product:

  • Ease of use for users and administrators
  • Removal of unrequired Sourcing flows and functions
  • Streamlining of SLM flows with simplified user interfaces and logical arrangement of tabs/sub-tabs/menus/functions

Major changes include:

1. Functionality changes: The Supplier Qualification and Evaluation menu is now removed from the Supplier Management Administrator/User responsibility. This menu enabled the user to navigate to the Sourcing home page, where the user could select the relevant option to create an RFI. Now, using the Supplier Management Administrator responsibility, the user can see the pages/regions belonging to the Supplier Qualification and Evaluation menu. This is visible to users by selecting the Supplier Home menu option that opens the Home page > Suppliers tab. The Home page now retain the existing features related to supplier search and supplier creation.

2. Nomenclature changes: New terminology introduced that is specific to SLM. Examples of such changes in all pages including notifications are:

  • Negotiation is now called Assessments
  • Requirements are now called Questions
  • Requirement Lists are now termed Questionnaires

Assessment creation now requires a template.

The Enable as Supplier button is available on the Supplier’s Home page.

The Register New Supplier button is available only if either iSupplier Portal is installed and/or Supplier Lifecycle Management is enabled.

Tuesday Apr 21, 2015

Whats New in the Procurement Approval Analyzer - Version 200.2

So you may be wondering why there has been a new version of the Procurement Approval Analyzer so soon?  Well version 200.2 contains fixes for the following  two issues:

  • Blank output was occurring when running the analyzer in 12.2 instances.  
  • Potential error with the Approval Management Engine (AME) enabled:

Error: ORA-06502: PL/SQL: numeric or value error: dbms_sql.describe_columns overflow, col_name_len=39. Use describe_columns2
Error in run_stored_sig procedure for sig_id: AME_ACTION_TYPES
Error: ORA-06531: Reference to uninitialized collection

Since the Analyzer is required output for logging Approvals Service Requests it was necessary to get this fix out quickly.

Questions or feedback?  Post your comments here.


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



« August 2015