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

iProcurement

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.

Purchasing

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.

Sourcing

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.


Monday Apr 13, 2015

New to the Procurement Accounting Space - Introducing the EBS Procurement Accrual Accounting Analyzer

Newly released in the Procurement Accounting space is the EBS Procurement Accrual Accounting Analyzer for Release 12!

The Procurement Accrual Reconciliation Analyzer is a script that can be used when encountering accruals issues on Purchasing documents. The single document provides all the information needed to troubleshoot the problem with the accrual reconciliation process.

The analyzer scans your Procurement 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.

Review your instance specific output from the analyzer now!  Simply run the analyzer as a SQL script or as a concurrent request, by following EBS Procurement Accrual Reconciliation Analyzer, Doc ID 1969667.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 accruals issues.

Wednesday Apr 08, 2015

Check Out the EBS Procurement Approval Analyzer

You may have noticed that the EBS Procurement Approval Analyzer has a new version 200.1 with a whole new look and feel.  Available via Doc ID 1525670.1 this analyzer is commonly used for checking Procurement documents (like a single Purchase Order or Requisition) stuck in pre-approved or in process status.  It can also be run on a date range to check all procurement for known issues so it is good to run before/after conversion.  Although it is normally required to be run for Release 12 Approvals Service Requests, we encourage you to run it whenever you are experiencing approvals issues.  Additionally in version 200.1 we have incorporated improvements in the area of:

• Change Request information has been added for POs and Reqs
• Added archive table information (when run on single document)
• Added the document_creation_method for releases

And if the Approval Management Engine (AME) for approvals is used:

• Print an error in case a Line Item Rule is detected
• Listing of rules in order of priority
• Added select * from PO_DOC_STYLE_HEADERS and add style_id to PO Headers section

 Check it out in Doc ID 1525670.1 or join our conversation here.

Release of the EBS Procurement Encumbrance Accounting Analyzer!

Just released the new  EBS Procurement Encumbrance Accounting Analyzer for Release 12!

This analyzer is commonly used when encountering funds related errors, or when noting an incorrect encumbrance value for a Purchasing document.

The EBS Procurement Encumbrance Accounting Analyzer scans your Procurement 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.

Review your instance specific output from the analyzer now!  Simply run the analyzer as a SQL script or as a concurrent request, by following EBS Procurement Encumbrance Accounting Analyzer, Doc ID 1970384.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 to this thread

The EBS Procurement Encumbrance Accounting Analyzer will also be featured at Collaborate 15 in Las Vegas next week on April 14th. Click here for more information.

Wednesday Apr 01, 2015

The EBS iProcurement Item Analyzer Has A Whole New Look and Feel!

We are pleased to announce a new version (200.1) of the EBS iProcurement Item Analyzer has been released.  The iProcurement Item analyzer still provides the best place to discover why items are not available in iProcurement; but now it has a  nicer look and feel, providing a very user friendly output.  Check it out in Doc ID 1586248.1.

The EBS iProcurement Item Analyzer Analyzer scans your 'Product' 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.

 Join our discussion today on the new analyzer and provide your feedback here


Thursday Mar 26, 2015

See the new Purchasing Document Open Interface (PDOI) improvements in 12.1.3!

Did you know that the new release of the 12.1.3 Procurement Rollup Up Patch (RUP) 19602627:R12.PRC_PF.B includes the following Purchasing Document Open Interface (PDOI) improvements:

 Bug #
 Symptom
 19701485
Sourcing Rules were getting created twice (one global and one local) when only a local rule is intended while importing a Blanket Purchase Agreement (BPA).
 19697226 New Items are created when a BPA is imported even though create or update items parameter is passed as ‘Y’ (yes).
 20022541 Supply agreement flag is not honored when importing a BPA.
 19663699 Price breaks were not getting uploaded when a BPA is imported, if the item is not assigned to the inventory organization of the default ship to location of the vendor.
 19479583 Could not import Blanket Purchase Orders.
 19528138 The concurrent program completed in OUT of Memory error when trying to import a Standard PO with more than 10000 lines.
 19288447 The concurrent program failed to import standard POs as variance account generation failed for Shop floor destinations.
 19498303 Import standard Purchase Order program end in error if  the account generator failed with an unexpected error, without showing proper error message.
 18828164 Standard purchase orders could not be imported with multiple shipments.
 2036833 Purchase orders imported are stuck in a status of In-Process though the approved parameter is passed as “APPROVED”.

 For more information on Patch 19602627:R12.PRC_PF.B click here!


Thursday Mar 19, 2015

Just Released!!! March 2015 12.1.3: Procurement Family Update - Rollup Patch : 19602627:R12.PRC_PF.B

We are happy to announce the new March 2015 Rollup Patch (RUP) 19602627:R12.PRC_PF.B has been released for 12.1.3!

Check out the 'Whats New' section of Doc ID 1468883.1 to see all the iProcurement, Purchasing, Sourcing and Supplier Lifecycle Management (SLM) improvements, as well as the PDOI fixes included.

Get all the information you need on this patch; including, how to apply the patch, necessary pre and post patching steps, how to do an impact analyzer, and testing recommendations for your key business flows. Make sure and mark this note as one of your Favorites. Weekly we update the note with any issues found with the patch in the 'Known Issues' section.


Don't delay apply Patch 19602627:R12.PRC_PF.B today!

Need Help? Post your questions to the Procurement Community

Friday Feb 06, 2015

Are you Running the Approval Analyzer and Getting an Error?

Now that the Approvals Analyzer (Doc ID 1525670.1) is being requested on many Procurement Approval Service Requests and we have a new version, some client have reported that they are seeing errors like one of the following:

ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550:
line 1,

column 7:
PLS-00201: identifier 'PO_APPRVL_ANALYZER_PKG.MAIN_CP'
must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ERROR at line 27:
ORA-06550: line 27, column 3:
PLS-00201: identifier 'PO_APPRVL_ANALYZER
_PKG.MAIN_SINGLE' must be declared
ORA-06550: line 27, column 3:
PL/SQL: Statement ignore
FDPSTP failed due to ORA-06550: line 1,
column 7:
PLS-00306: wrong number or types of arguments in
call to 'MAIN_CP'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


The errors above simply mean that the concurrent program definition and Analyzer code are not in sync.

To resolve this error merely download and install the current version po_approval_analyzer.sql from the 'Download Now' button in .(Doc ID 1525670.1). Load the latest version of the concurrent program definition using podiagaa.ldt, then rerun the concurrent program.  Issue resolved!

And while we are talking about the Approval Analyzer remember to provide the correct document type when running it. Take a careful look at the parameters that return in the list of values after choosing the Single Mode.  It must match your document!

If you forget to choose the correct Document Type you will find errors in the output like the following:

For additional questions or comments on the Approval Analyzer click here.



Thursday Jan 29, 2015

See the New and Improved Buyer Work Center (BWC) Assistant

Need information about the Buyer Work Center (BWC) or solutions to issues?  See the new and improved BWC Assistant here!

  • New solutions have been added for known Release 12.1.X and 12.2 issues.
  • There is now a link to the Frequently Asked Questions information
  • Under Miscellaneous > General see a link to Recommending Patch, ERs, Tracing and further diagnostics as shown below:


So don't delay and check out Doc ID 1394392.2 today!

Friday Jan 09, 2015

Check out the New and Improved R12 Approval Analyzer Diagnostic Script!

A new version of the R12 Approval Analyzer (120.22) has just been released.  Improvements include:

  • The Procurement Code level is included in the output. There is no longer a need to run separate sql queries to get your code level when submitting Service Requests.
  • We added a new wrapper so that the analyzer can be run on a single document or all documents. If run on a single document the wfstat information will be automatically included.
Wrappers:

Analyze_single.sql: Intended to be run on a single document type and number.  May be required to provide this output on a representative document, when logging an SR.

Analyze_all.sql: All mode is used on a routine basis to check ALL documents within a specific date range, or used before or after an upgrade.

  • We have additionally provided the simple steps on how to setup the Analyzer as a concurrent process, so users can run it on the front end from the Purchasing Responsibility Reports>Run  (then the wrappers are only necessary if run from SQL*Plus).

The Analyzer tools are the most impactful tools available for troubleshooting an issue!  They can analyze hundreds of problem signatures and tie them directly to known solutions.  When run on a single PO document, it provides you with comprehensive data to quickly resolve your issue.  

Get all the information you need to know from Doc ID 1525670.1 and download today! Run the quick video in the note to get the full steps on downloading, setting up and running the Analyzer.

Want more information?  Click here to the Procurement Community Post.

Thursday Jan 08, 2015

Are you occasionally getting complaints that the Purchase Order pdf file is not making it to the Supplier or Approver?

When the output format for a Purchasing document is in PDF format, a concurrent request is submitted during the approval of the document to generate the PDF.  On occasions this process may fail which results in the Approver and/or Supplier not receiving the PDF file.

Need help on finding these failed processes and the Purchase Orders they correspond to?

See Doc ID 1955731.1 'Aid to Returning Purchasing Documents that have Failed in the PO Output For Communication (POXPOPDF) Concurrent Request' which provides a quick sql script that can be run to identify these transactions.

Run this on a routine basis to check for failed items or when a user or supplier is reporting they didn't receive the document.

Need more help? Reply at this link with any questions.

Monday Jan 05, 2015

Want to take a look (and replay) our 2014 Procurement Webcasts?

Wish you could see a Procurement webcast you missed in 2014 or replay one you found of value?  Goto Doc ID 1456150.1 and click on the 'Archived 2014' tab.  Then you can click on the 'Recording' link to replay any of our webcasts or choose the '.pdf; link to review the slide deck.

Don't miss these valuable presentations from our Subject Matter Experts!

Monday Dec 15, 2014

Procurement Code Level added to the Approval Analyzer Output!

Hi, I just wanted to let everyone know about a recent addition to the Approval Analyzer.  We have included the Procurement Code level in the output.

First open  Doc Id 1525670.1 and download (and apply) the new version 120.19.

After running the analyzer review the .html output and scroll down to the 'Patches Applied' section.  You will see something like the following:

So don't forget download the new version today!

Questions or comments? Click here to join our discussion.



Friday Dec 12, 2014

We're Nearing Year End and Here's a Procurement Activity I would Recommend

Planning for Year End? For those in Release 12 I would highly recommend running your data through the Approvals Analyzer at Doc ID 1525670.1.  This analyzer is not just for approvals issues but will report on workflow errors, data corruption issues, critical patching, invalids and more.  And more importantly it will provide you with solutions on the problems reported.  When you run the analyzer at the parameter 'Document Type' choose ALL and then it will report on all your Purchasing documents including Purchase Orders, Requisitions, Agreements and Releases.  Then at the parameter 'Documents Created Since'  maybe just run it for the last few months or the last year.  What a great way to clean house and start the New Year Fresh!

Questions on the Approval Analyzer? Join our conversation here.

About

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

Twitter

Search

Archives
« April 2015
SunMonTueWedThuFriSat
   
4
5
6
11
12
15
18
19
22
24
25
26
27
28
29
30
  
       
Today