Monday Feb 10, 2014

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

New Form to Identify Unexpected Tax Errors For Transactions and Ability To Rectify Through Concurrent Program!

Development have created a new form that will allow users with Unexpected Tax Errors to be able to run, via the familiar user interface, a diagnostic to determine the problem.  

This new functionality, which converts data detection and data fix scripts into packaged procedures, is made available with the application of patch 18108467:R12.ZX.B

The new form contains access to the following diagnostic programs:

• Transaction Tax Data Diagnostic
• Populate Legal Establishment
• Synchronize Summarization Column Values
• Rectify Tax Distributions
• Populate Regime to Rate Details
• Populate Recovery Rate Details
• Remove Orphan Tax Lines
• Remove Orphan Transaction Lines
• Create Missing Transaction Lines
• Create Missing Tax Distributions for Purchase Orders
• Update Configuration Owner
• Upgrade Missing Transaction Tax Data
• Set Migrated Tax Lines as Overridden
• Synchronize Migrated Tax Distributions Amounts
• Synchronize Tax Repository

Users can run the diagnostic detection process for a specific date range or for a specific transaction and they can run in either in "Analyze" or "Analyze and Fix" Mode.

The output can be viewed as a concurrent request output file and will make it much easier for end users to quickly run diagnostics on their erroneous tax transactions.

Note: It is recommended that you first run "Analyze" Mode and check the Data and then run in "Analyze and Fix" mode to rectify the issue.

All R12.1 customers should use this form when facing 'Unexpected Tax Errors' and submit all the data detection diagnostics on the transaction data.  The output can then be reviewed to determine recommendations and steps to resolve.

For full details please review the following My Oracle Support document:

R12.1.X: Tax Diagnostic Framework (Doc ID 1621617.1)

Friday Feb 07, 2014

Reminder: Service and Depot Repair Customer Advisory Board Meeting

A reminder that the 2014 EBS Service and Depot Customer Advisory Board Meeting from Tuesday will be held March 25th through Friday, March 28th at the Oracle Conference Center in Redwood Shores, CA.

If you are planning to attend, please let us know what topics are of greatest interest and benefit to you so we can craft an agenda that best suits our attendees.

As with past CAB meetings, we'll cover a number of different Service family products during the course of the week and can also invite representatives from non-Service family products that are of interest.

We're hoping to see you in Redwood Shores in March, 2014!

Please RSVP at the earliest by contacting us:

Sanjeev Sahni, Director, Service Product Management,
Lee Sacco, Sr. Director, Depot Repair Product Management

Webcast: Configurator - An Introduction to Server Administration and Remote Publication Process

Webcast_icon.jpgWebcast: Configurator - An Introduction to Server Administration and Remote Publication Process

Date: February 18, 2014 at 11:00 am ET, 9:00 am MT, 4:00 pm GMT, 9:30 pm IST

This Advisor Webcast provides an overview of Configurator developer server administration and Publication process. This one-hour session is recommended for technical and functional users who have a basic implementation knowledge of Product Configurator Developer.

Topics will include:

  • General Overview - Configurator, Servers and Publications
  • Setups
  • Table Structures and Troubleshooting SQL
  • Commonly reported errors and resolution
  • Push Notifications in Campus Mobile

Details & Registration: Doc ID 1607766.1

Thursday Feb 06, 2014

Attention Oracle UK Payroll Customers: Year End 2013 / Year Begin 2014 Patches Have Been Released!

On completion of this year's UK Early Adopter Programme (EAP) the following Oracle UK Payroll Year End 2013 / Year Begin 2014 patches are now available to download and apply via My Oracle Support:

R11i Patch 17964873 - This is an HRGlobal patch

This patch will provide the changes required for processing the UK 2013-2014 Year End returns. It delivers the following changes:
  • P60 Changes
  • FPS fixes.
Post Install Steps need to be run after patch installation. The patch Readme has important installation, setup instructions and guidelines.

Doc ID 472794.1: UK Payroll Mandatory Patches (11i) has been updated with this information.

R12.0 Patch 18100149:R12.PAY.A - This is an HRGlobal patch
R12.1 Patch 18100149:R12.PAY.B - This is an HRGlobal patch

These patches will provide the changes required for processing the UK 2014 Year End returns and the legislative updates from 6th April 2014. These patches also include Real Time Information changes for April 2014. It delivers the following changes:

  • Autumn Statement Changes
  • Student Loan Changes
  • Start of Year Changes
  • Real Time Information Changes
  • Employer Payment Summary
  • Full Payment Summary
  • P60 Changes
  • EAP Bug fixes.

Post Install Steps need to be run after patch installation. The patch Readme has important installation, setup instructions and guidelines.

For further details, please refer to Doc ID 1610646.1: UK legislative Changes for end of tax year 2013/14, the start of tax year 2014/15 and the Real Time Information changes effective from April 2014.

Doc ID 551753.1: UK Payroll Mandatory Patches (R12.0) and Doc ID 862407.1: UK Payroll Mandatory Patches (R12.1) have been updated with this information.

To assist in planning for additional Year End patches, review Doc ID 1617628.1: Release Schedule for Legislative patches for UK for tax year 2013-2014/2015.

If you encounter any issues with these patches, please raise a Service Request via My Oracle Support with Oracle Payroll Support.

Webcast: Using The New Trial Balance Helper (TBH) To Troubleshoot Payables Trial Balance (APTB) Issues

ADVISOR WEBCAST: Using The New Trial Balance Helper (TBH) To Troubleshoot Payables Trial Balance (APTB) Issues


This one-hour webcast shows you:

- Trial Balance Overview
- Troubleshooting Accounts Payables Trial Balance (APTB)
- Using the Trial Balance Helper (APTB) diagnostics for smoother reconciliation

This session will help customers to understand and use the TBH and generic troubleshooting tips on APTB for smoother reconciliation                     

Topics will include:

  • The proactive approach in reconciling AP with the effective usage of the diagnostics available

A short, live demonstration (only if applicable) and question and answer period will be included.

Oracle Advisor Webcasts are dedicated to building your awareness around our products and services. This session does not replace offerings from Oracle Global Support Services.

WebEx Conference Details:

Topic: Using The New Trial Balance Helper (TBH) To Troubleshoot Payables Trial Balance (APTB) Issues

Date and Time:

Thursday, March 13, 2014 3:30 am, Mountain Daylight Time (Denver, GMT-06:00)
Thursday, March 13, 2014 3:00 pm, India Time (Mumbai, GMT+05:30)

Thursday, March 13, 2014 5:30 am, Eastern Daylight Time (New York, GMT-04:00)

Thursday, March 13, 2014 9:30 am, GMT Time (London, GMT)

Event number: 596 428 540


For more details and how to register see Doc ID 1620914.1 - Using The New Trial Balance Helper (TBH) To Troubleshoot Payables Trial Balance (APTB) Issues.

Wednesday Feb 05, 2014

Flow Manufacturing White Paper

Oracle Flow Manufacturing, also called Lean Manufacturing, is a manufacturing approach that aligns production with customer demand. Oracle Flow Manufacturing employs Just-In-Time (JIT) concepts such as :
  • Manufacturing to demand versus forecast
  • Production lines for families of products versus process layout
  • Pull material using Kanbans versus push material
  • Back flush material and costs upon completion versus at each operation.   

A new white paper gives an overview of Flow Manufacturing and summarizes the concepts and basic setups.  It then describes a typical process flow using a screenshot example.  The white paper can be downloaded from note:

Basic Setup and Process Flow in Flow Manufacturing using example, Doc ID 1618984.1.

Tuesday Feb 04, 2014

Allow Assemble-To-Order (ATO) Items in Pick-To-Order (PTO) Models and Kits

This feature supports the business scenario of including mandatory ATO items in PTO Models and Kits in the customer's orders, thereby enriching the Order Fulfillment process with additional functionality.

Currently, while ATO items are supported as optional/non-mandatory items in PTO models, they are not supported as included/mandatory items in PTO Models or Kits. In Release 12.2, ATO items are supported as included/mandatory items in PTO Models as well as Kits. Thus, for the ATO items that are identified as included/mandatory items in the Bill of Materials of the PTO Model or Kit, the application selects the ATO flag and populates the corresponding ATO attributes at the time of sales order line creation.

To enable this functionality, you must set the value of the profile options, OM: Allow Standard ATO Items as PTO/Kit Included Components and BOM: Allow ATO item in a KIT or as mandatory in a PTO Model to Yes at the site level. 

For more information regarding this new ATO in PTO Models and Kits functionality in Release 12.2, please refer to the Oracle Order Management Release Notes for Release 12.2.2, Doc ID 1377743.1.

ER Implemented - New Supplier Update API's Supported in R12 Oracle Payables!

Well we have great news for you! 

In 11i there were API's (Update_Vendor, Update_Vendor_Site and Update_Vendor_Contact) but they were not supported in R12 due to integration with Multiple product teams. The reason being was that the entities Supplier, Sites and Contacts had representations in multiple products like TCA, IBY, ZX etc and all these representations needed to be in sync.

However, most of our customers have huge volumes of supplier data which they need to be able to control programmatically so the fact that they no longer had access to these API's was frustrating.

It was requested through Enhancement Request Bug 17575099: ENHANCEMENT FOR SUPPORT OF SUPPLIER UPDATE APIS that Oracle Payables provides API's for updating Supplier / Supplier Sites / Supplier Contacts in AP_VENDOR_PUB_PKG in R12.

Well, this functionality is now available and the following new APIs had been created: 

                      - Update_Vendor_Public
                      - Update_Vendor_Site_Public
                      - Update_Vendor_Contact_Public

*** Note: These are the only procedures supported to update suppliers, sites or contacts.

We are sure that this ER being implemented will be welcome news for many.  Enjoy! 

To download the document with additional information about these new procedures please review Doc ID 1618099.1 - New Supplier Update API's in Oracle Payables

Further Information:

R12: What are New Supplier Related Tables/Packages/Programs. APIs Supportability (Doc ID 812918.1

Picture Get Proactive

Monday Feb 03, 2014

Just Released! 12.1.3: Oracle Procurement: Purchasing Roll Up Patch

Just Released! 12.1.3: Oracle Procurement: Purchasing Roll Up Patch 18120913:R12.PRC_PF.B

The focus of this RUP is the Purchasing Document Open Interface (PDOI) and Buyer Work Center (BWC) which accumulate fixes related to the PDOI and BWC for release 12.1.3.  Here are some of the highlights.

Buyer Work Center (BWC)

With this release enhancements to the BWC focus on the following main areas:

  • Session Preferences-enables user to setup session preferences in the BWC
  • BPA Lead Time-if a user updates a GBPA line additional information with lead time information and then creates a PO in the BWC with GBPA reference, with approval of PO the Promise date is derived
  • Search Cleanup-code now validates all Search parameters enabling consistent searching in BWC
  • Multiple Supplier Email Address (now allowed in both BWC and Forms).

Purchasing Document Open Interface (PDOI)

Enhancements to PDOI include:

  • Ability to create Purchase Orders (POs) with Requisition Reference
  • Ability to create a Global Blanket Purchase Agreement (GBPA) and Global Contract Purchase Agreement (GCPA) reference through PDOI
  • Ability to use Advance Pricing in PDOI
  • Importing Contract Agreements through PDOI
  • Utilizing PDOI to autocreate Sourcing/ Consumption Advice/Documentation Flows to create Standard Purchase Order/Blanket Purchase Agreements
  • Ability to include Contract Reference in the Autocreate Form/Document Builder

Create and Update Purchase Orders Using New Business Service Object (BSO) Web Service

With this release, you can use the new Business Service Object web service to create and update Purchase Orders of types: Standard Purchase Orders, Complex Purchase Orders, Global Blanket Purchase Agreements and Global Contract Purchase Agreements. Oracle Purchasing Buyer Work Center functions are supported by this web service.

See Doc ID 1468883.1 today for more information.

New Contracts Billing Troubleshooting Assistant

The Service Contracts billing process often gives rise to lots of questions and issues.  If you've ever searched the MOS knowledge base for service contracts billing issues then you'll know that there are a lot of notes out there and it can be difficult to find exactly what you're looking for.  So, we've created a new Troubleshooting Assistant to try and help you find what you need more quickly. 

Take a look at Doc ID 1608580.2: Troubleshooting Assistant: Service Contracts Billing.  The note allows you to select an area of billing that you are interested in, then you select the symptoms you are seeing or select sub-topics and then presents you with relevant notes based on your selections.

Don't forget that there is also the Information Center: Oracle Service Contracts (Doc ID 1271128.2) which is another way of accessing knowledge documents using topics other than executing a search.

Sunday Feb 02, 2014

MOS Communities Migrate to New Platform!

My Oracle Support Communities: A New Look and Feel

With the latest upgrade, My Oracle Support Community now shares the same platform as Oracle Technology Network (OTN) Community.

This change brings enhanced search capabilities that return answers from discussions, content, and other resources. New sort options allow you to order results by relevance, ratings, dates, and other criteria: helping you find the solutions you need. Added functionality allows you to choose from notification options, like email and RSS feeds, to stay up-to-date. Improve your community interactions with features that strengthen your connections and allow members to share their experience: friend and follow options, @mention, and direct messages. 

Some things won’t change—you can still rely on community moderation by Oracle Support engineers and the ability to leverage your trusted network of Oracle Premier Support customers.

For more information on this change review the following:

  Video Series: 

   Watch the My Oracle Support Community video series.

These short videos target the new features and show you how to navigate the updated My Oracle Support Community.

Live Webcast: 

Register now for Get Proactive Essentials: Using the new My Oracle Support Community Platform.  There are sessions on multiple dates and times and in different languages.


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



« February 2014 »