Monday Apr 29, 2013

New! Purchasing R12: PO Approval Analyzer Diagnostic Script

We are pleased to announce the release of the Purchasing ‘PO Analyzer’ diagnostic that can be used proactively to check a group of purchasing documents or reactively if you have problems on specific ones.  The PO Analyzer script can be run on one specific document that perhaps is stuck in an ‘in process’ or ‘pre-approved’ status where more information is needed, or it can be run for all documents within a specific date range.  It’s non-invasive (no update or delete statements are used) so it can be run it in a Production environment.

The images below show sample output from the script - the contents section and a detail report section:

PO Analyzer Report Output

PO Analyzer Sample Output

For download and steps to run the PO Analyzer see Doc ID 1525670.1.

We are also providing a Webcast on the Analyzer on May 28th.

Sign up now at Doc ID 1456150.1 .

Webcast: Field Service - Third Party Service Providers and Supplier Contacts


Subject: Field Service - Third Party Service Providers and Supplier Contacts - Setup and Scheduling

Date: May 29, 2013 at 11 am ET, 10 am CT, 9 am MT, 8 am PT, 4 pm, GMT Summer Time (London, GMT+01:00), 8.30 pm, India Time (Mumbai, GMT+05:30)

This webcast looks at the 12.1.3 'Field Service Third Party Service Provider' (TPSP) functionality and compares and contrasts this new functionality with the 'Supplier Contacts' functionality available in previous EBS versions.  TPSP allows the modeling of resources with infinite capacity to perform tasks and scheduling of tasks to these resources.

Topics will include:

  • Overview of the Third Party Resource functionality.
  • Overview of the Supplier Contact functionality
  • Setup steps to implement both types of resource.
  • Scheduling Tasks to both types of resource.
  • Troubleshooting most common issues with this functionality.

Details & Registration: Doc ID 1545428.1

Thursday Apr 25, 2013

Webcast: Oracle E-Business Tax (EBTax) Setup and Data Integrity Analyzer


Subject: Oracle E-Business Tax (EBTax) Setup and Data Integrity Analyzer

Date: May 30, 2013 at 11.00am ET, 10.00am CT, 09.00am MT, 08.00 am PT, 4.00 pm, GMT Summer Time (London, GMT+01:00), 8.30 pm, IST (Mumbai, GMT+05:30)

This one-hour session is recommended for technical and functional users of Oracle E-Business Tax (EBTax) who would like an introduction to the EBTax Setup and Data Integrity Analyzer.  The session will highlight how to use the diagnostic script Tax_Setup_detect_pkg.sql to identify known data integrity issues within your EBTax Setup during Migration/Upgrade.

Topics will include:

  • Review of the EBTax Setup and Data Integrity Analyzer
  • How to use the tool
  • Resolution and prevention of issues
  • Case study

Details & Registration: Doc ID 1545719.1

Tuesday Apr 23, 2013

Did You Know Applying the Latest Procurement Family 12.1.3 Rollup Patch Will Prevent/Resolve Encumbrance Issues?

The Procurement Family 12.1.3 Rollup Patch 15843459:R12.PRC_PF.B was released at the end of March.  It includes a large number of bug fixes including the fixes below which will help to prevent or resolve encumbrance issues.

 Bug Issue
 Bug 14525049 In Oracle Purchasing, for a purchase order with budgetary control enabled project, if baselined cost budget is not available proper message is not shown.
 Bug 14229705 Error in PSA_BC_XLA_PUB.Budgetary_Control when reserving or checking funds on a purchase order with foreign currency
 Bug 13610367
In Oracle Purchasing during the Reserve action on a Federal PO (with backing Requisition), the backing Requisition's Encumbered Flag and Encumbered Amount are not updated to correct values
Bug 12972273 Unable to Reserve Purchase Orders Due To Error DO_ACTION-070: ORA-01400
 Bug 12824154 Generic error message 'Procedure PSA_BC_XLA_PUB.Budgetary_control returns an error without any details to the calling procedure' for encumbrance actions.

See the above fixes, along with many others in Doc ID 1468883.1.

Applying the RUP is recommended for all Procurement 12.1.3 customers.  RUP patches go through a full quality assurance testing and therefore increase the overall stability of the products when compared to one-off patches. 

If you have concerns about the files that will be impacted by applying this patch then remember that you can use the Patch Wizard to do an analysis of impacted files. If you want to know more about Patch Wizard, take a look at Doc ID 1077813.1: Patch Wizard: Overview and Videos.

Tuesday Apr 09, 2013

Register now for these upcoming Procurement Webcasts!

The Procurement team are announcing two upcoming webcasts in April and May. Webcasts are a great way to learn more about detailed topics, direct from the experts.


Subject:  Session Requisition Imported from other Modules (WIP, OM, …)

Date: 23-April-2013 at 2:00 pm, GMT Summer Time (London, GMT+01:00) / 3:00 pm, Egypt Time (Cairo, GMT+02:00) / 06:00 am Pacific / 7:00 am Mountain / 9:00 am Eastern

This one-hour session is recommended for technical and functional users who need to know about how to import requisition from other modules and the setup involved.  In addition troubleshooting and diagnostic steps will be presented.

Topics will include:

  • Introduction to scenarios in other modules from where Requisitions are created
  • Setups involved in each module
  • Requisition Import
  • Demo showing Tables Involved
  • Common Issues & Diagnostic Steps.


For more details and to register go to Doc ID 1456150.1.


Subject: EMD - Earnest Money Deposit in Oracle Sourcing

Date: 14-May-2013 at 2:00 pm, GMT Summer Time (London, GMT+01:00) / 9:00 am, Eastern Daylight Time (New York, GMT-04:00) / 7:00 am, Mountain Daylight Time (Denver, GMT-06:00) / 3:00 pm, Egypt Time (Cairo, GMT+02:00)

This one-hour session is recommended for technical and functional users who would like to utilize the feature of EMD in oracle sourcing. This session will provide the necessary setup steps to be done to enable EMD.  There will be a demonstration along with trouble shooting steps.  Additionally the integration with Oracle Financials will be explained.

Topics will include:

  • Concepts of EMD
  • Setup steps required to utilize EMD in sourcing
  • Demonstration
  • Troubleshooting steps
  • Q&A.


For more details and to register go to Doc ID 1456150.1.

Monday Apr 08, 2013

Check Out The Revamped Procurement Information Centers

Check out the new format in the Procurement Information Center.  From the main page Doc ID 1391332.2, choose the Product Group you are interested in: Purchasing, iProcurement or iSupplier Portal to access the Information Center you are interested in.

For example, drilling down on the Purchasing link we see tabs for each of the Product groups with information provided in a more user friendly format:

Visit the Information Centers for easy access to a wealth of cataloged notes without having to search.  You can access all information centers via the E-Business Suite Product Information Center Index (Doc ID 444.2).

Resolving Autoinvoice Date Issues

We get lots of questions about Autoinvoice and in this blog entry we'd like to offer some advice and help to try and take some of the mystery out of Autoinvoice Dates. 

There are just so many dates and so many ways to derive all the dates!  Receivables Transactions have General Ledger (GL) Date, Transaction Date, Ship Date, Sales Order Date, and Rule Start dates to name a few.  There are also several ways to get your dates, with Autoinvoice you can enter your GL Date and Transaction Date in the columns of RA_INTERFACE_LINES_ALL table or you can allow the AutoInvoice process to derive the dates.

If the dates are not provided in the interface tables they will be derived based on your setups.  Date Derivation of the General Ledger date and Transaction date during the process of AutoInvoice depends on the following date columns in the RA_INTERFACE_LINES_ALL table:


AutoInvoice determines the General Ledger date for invoices using the following criteria:

  • Does a GL date exist for this invoice in the interface table?
  • Does the invoice use rules?
  • What is the setting of the Derive Date option for this Transaction Batch Source (Yes or No)?   (Receivables Responsibility > Setup > Transaction > Sources)
  • What is the setting of the GL Date in a Closed Period option for this Transaction Batch Source (Adjust or Reject)?  (Receivables Responsibility > Setup > Transaction > Sources)

If you elected to derive the rule start date, AutoInvoice first uses the ship date in the interface table. If the ship date does not exist, AutoInvoice uses the sales order date. If the sales order date does not exist, AutoInvoice uses the date you entered in the Run AutoInvoice window.  The following diagram illustrates this process.

For more examples and diagrams see the 'Determining Dates' section of our  Oracle Receivables User Guide.

Sunday Apr 07, 2013

Master Troubleshooting Guide for PO Output for Communication Is Revamped

See our revamp of Purchasing Doc ID 1375082.1 the Master Troubleshooting Guide for POXPOPDF: PO Output for Communication which includes:

The document includes sections with the following information:

Setup checks 1. Setup checks. The five key items to check to avoid errors and confirm your settings.
Targeted patching 2. Targeted Patching. A detailed analysis was done of all known defects related to 'PO Output for Communications' and the patches and file versions they have been fixed in. Check this section for recommending patching.
Common Issues 3. Common Issues. In this section a list of commonly reported errors that are not patch related are included and their resolution.   There is also a link to Frequency Asked Questions.
Troubleshooting 4. Steps are included here for additional troubleshooting help.

Check out the solutions provided before logging a Service Request. Don't forget that you can add a comment to the note if you want to see something added or improved.

Thursday Apr 04, 2013

Don’t Delay, Apply the New 12.1.3 Procurement Rollup Patch

A new critical rollup patch (RUP) has just been released by Development for our 12.1.3 Procurement customers.  This new Patch 15843459:R12.PRC_PF.B contains important fixes for Purchasing, Internet Supplier Portal (iSupplier), Sourcing  and iProcurement (Web).   Development and support advise customers on Release 12.1.3 to download and apply the latest patch.

Go to My Oracle Support and enter Document ID 1468883.1 in the Knowledge Base search. This note contains information on who should apply the patch, how to apply the patch, critical fixes and important new features.

Wednesday Apr 03, 2013

ATG Webcast Program For April

E-Business Suite Applications Technology Group (ATG) -  Advisor Webcast Program -  April 2013


Webcast: Get Proactive – What is Available for Concurrent Processing & Workflow?

In April we want to bring to your attention the Workflow- and Concurrent Processing-Analyzer Utilities, which have been developed by the Proactive Support area.

Agenda :

•    CP-Analyzer Overview
•    CP-Analyzer Demo
•    WF-Analyzer Overview
•    WF-Analyzer Demo
•    Q&A session

We are driving 2 sessions at the same day now, to give our attendees globally the chance to join the session which fits best for their timezone.

Date : Tuesday, 9th April 2013

EMEA Session :

US Session :


Webcast : EBS Diagnostics Overview & Troubleshooting

In this session 2 Support Engineers will give you an overview of the Diagnostics available in the E-Business Suite and they will give you some diagnostic and troubleshooting advice based on their experience in dealing with Diagnostics SRs.

Agenda :

•    What are EBS Diagnostics
•    Useful EBS Technology Diagnostics (Top 5)
•    Diagnostics Demonstration
•    How to verify EBS Diagnostics
•    Troubleshooting Diagnostics
•    RDA - How to automatically check OS prerequisites for EBS
•    Q&A

We are driving 2 sessions at the same day, to give our attendees globally the chance to join the session which fits best for their timezone.

Date : Tuesday, 23rd April 2013

EMEA Session :

US Session :

If you have any question about the schedules or if you have a suggestion for an Advisor Webcast to be planned in future, please send an E-Mail to Ruediger Ziegler.

New Master Troubleshooting Guide (MTG) for India Service Tax Release 12

Do you have questions about service tax for India Localizations or want to know the latest information about this functionality?  Check out the improved Master Troubleshooting Guide (MTG) for India Service Tax Release 12 (Doc ID 1459341.1) for a wealth of information to help you avoid and resolve problems.

The document includes sections with the following information:


1. Setup of service tax – this section contains viewlets that explain the setups related to service tax and transaction cycles

2. Documentation on service tax – Visit this section to review detailed documentation about service tax on accrual basis and reverse change mechanism

3. Resolving errors – this section contains recommended patches and documents with solutions for specific errors

4. Reconciliation queries – Consolidated queries that help in reconciling different scenarios

 See also our new note R12 : Frequently Asked Questions on Service Tax Functionality - Financials for India (Doc ID 1538419.1) for frequently asked questions about service tax.


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 2013 »