Monday Mar 24, 2014

Get Help to Verify Your General Ledger Balances Anytime!

General ledger is the core of accounting information summarizing all financial transactions into accounts and gathering all data into balances that will be used to prepare financial statements or for various other reporting purposes. 

  • Maintaining correct balances is crucial for reporting purposes
  • Financial users may want to verify balances periodically to make sure they are accurate 

In order to gather information needed for analyzing problems related to General Ledger balances, in addition to the usual period closure activities such as running specific diagnostics from Doc ID 1416402.1 that would spot balances issues, you should also consider our Glbalfix - Gl Balances Corruption Script.

We have gathered all the useful information related to Glbalfix script, from installation to detailing all checks performed, preparation and execution along with potential errors and suggestions to spot and eliminate the root cause prior to performing any fix, in this new document:

Glbalfix: GL Balances Corruption Script - Master Note (Doc ID 1563019.2).

Once installed, the script can be safely submitted to run anytime in report mode, to verify the balances only - here's a sample output:

Glbalfix output sample

Remember, running the script does not mean it would change any data, you can use it just to verify the balances are correct! If a problem is detected, you decide further if and when to fix it!

Why don't you give Glbalfix a try?

Friday Mar 21, 2014

Purging Order Management Workflow

For maintaining a healthy workflow environment, the "Purge Order Management Workflow" concurrent request should be scheduled regularly. 

Purge Order Management Workflow Concurrent Program purges workflow items associated with Oracle Order Management, such as OM Order Line and OM Order Header. Unlike the Purge Obsolete Workflow Runtime Data program provided by Oracle Workflow, the Purge Order Management Workflow program purges workflows of closed sales order lines even if the sales order header is still open. It tries to close open workflows in a few very specific cases to make more workflow items eligible for purge. Use this purge program to reduce the size of workflow tables and improve high volume order processing performance.

Information on the use of "Purge Order Management Workflow" concurrent program, to purge closed workflows, specific to Order Management can be found in document: How To Purge Order Management Workflow, Doc ID 878032.1.

Important Message for Australia Oracle Payroll Customers


 As in previous years Oracle will endeavor to have the minimal number of patches over the months leading up to 30 June. However this year as there are a couple of large legislative changes there will be more than in past years.

Changes from 1 July 2014  (Only available on 12.0 & 12.1+ )

 As in previous years there will be a patch released around the end of May early June with changes from 1 July 2014. As these changes are dependent on the May budget exact timing cannot be provided till after the budget.

Current known changes (pending changes in budget) change to Medicare Levy rate and SGC rate (this may delayed for 2 years)

Gender Equality Reporting (Only available on 12.1+ )

An off cycle patch for Gender Equality reporting is scheduled to be available at the end of March. A white paper will be available on My Oracle Support at the same time.

SuperStream (Only available on 12.1+ )

 Oracle has decided to release two patches for SuperStream to allow customers as much time as possible to complete data capture and update their current solution.

Patch 1 – scheduled end of April. This will include data capture and superannuation processing in payroll. A high level solution overview for data capture and processing will be available in the next week or so to provide customers with as much information as possible before patch release.

Patch 2 – scheduled late June. This will include generation of XBRL file. (One XBRL file per super fund will be required)

A white paper will be available on My Oracle Support on the complete SuperStream solution around the end of April

Software developers and super clearing houses/super funds are currently working on a standard CSV file format. If this is finalized in time Oracle will also be providing a CSV file format which will be accepted by a large number of clearing houses and funds. However, the CSV file format can only be accepted for the transitional period by funds. If customers wanted to continue using this format past the transitional period they would require a third party to convert the information to the new SuperStream format.

Please contact your super funds  and clearing houses to see if they will be accepting this file format. The delivery of this is unable to be determined at this point as the ATO is still defining the file format. This may not be available in Oracle till after 1 July 2014.

Oracle will continue to communicate to customers as we move forward. As previously stated customers should be working with their super funds and super clearing houses as SuperStream delivery relies on them as well.

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

New Whitepaper - Discrete Job Interface (WIP Mass Load)

The objective of this Whitepaper is to discuss the Work Order Interface which is used for importing Discrete Job and Repetitive Schedule information, and Discrete Job Operations, Material,  Resource, and Scheduling information from any source, using a single process.

Summary of contents :
  • Basic WIP Mass Load features
  • Sample scenarios for understanding the behavior
  • Providing clear understanding on what columns need to be fed based on requirement
  • Common interface errors

The Whitepaper can be downloaded from document: Whitepaper - Discrete Job Interface (WIP Mass Load), Doc ID 1618613.1.

Wednesday Mar 19, 2014

References for Creating Personalization in EBS CRM

Are you trying to find information about personalization in a CRM Family product?  Feeling frustrated? When CRM Users are trying to find information regarding personalizations, it is often frustrating since most information about personalizations are located in product areas other than the one you are searching in.  Personalization information from other products can be helpful in understanding how to apply a change in your page/form of interest.  

Doc ID 1616769.1: References for Creating Personalization in EBS CRM has been created to attempt to help you find relevant information.  Take a look at the note and we suggest you bookmark it for future reference as it will be updated as new pesonalization information becomes available.

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:

Monday Mar 17, 2014

Need Assistance With A POST Mass Additions Issue?

In the last entry to the EBS Fixed Assets Support Blog, the Troubleshooting Assistant for the Create Mass Additions process was highlighted.  We also have a Troubleshooting Assistant for the POST Mass Additions process (also known by its short name of FAMAPT).  The Post Mass Additions process is the process used to post mass additions lines, making assets from those addition lines.  Alternatively, you might be making cost adjustments to assets or adding CIP assets using the Post Mass Additions process.  1610669.2

To assist with issues that you might encounter in the Post Mass Additions process, we have a new Troubleshooting Assistant (or Search Helper) to help you identify typical problems and obtain the solutions for those problems. 

  • You might have an error in the process
  • Perhaps you have encountered a performance issue
  • Maybe you are trying to merge addition lines
  • Is the list of values (LOV) for the book empty? 

Select the appropriate issue(s) in the selection window of the Troubleshooting Assistant and possible solutions will appear on the right side once you make your selection(s).

You can access this Troubleshooting Assistant by reviewing Troubleshooting Assistant: FAMAPT - Post Mass Additions (Search Helper) (Doc ID 1610669.2).

Wednesday Mar 12, 2014

Meet the Payables Period Close Analyzer!

See Doc ID 1489381.1 in My Oracle Support to learn all about our latest analyzer script "ap_pclose_detect_pkg.sql".  This script was created just for EBS: Payables, and is designed to find transactions that may be blocking the period close process from closing normally, and offers corrective actions you can take to resolve the problems yourself -- eliminating the need to contact Oracle Support for help! 

Below is an example of the HTML output produced by the Payables Period Close Analyzer (PCA):


To learn more about Global Data Fixes (GDFs) and what GDFs are available for Oracle Payables, along with information about the Period Close process in Oracle Payables, and access to other Payables PCA users, see the following:

R12: What is a Generic Datafix Patch (GDF) and what GDFs are available for Payables? [VIDEO] DocID 874903.1

R12: Master GDF Diagnostic (MGD) to Validate Data Related to Invoices, Payments, Accounting, Suppliers and EBTax [VIDEO] DocID 1360390.1

Best Practices for E-Business Suite Payables Period Close (one hour webcast)

The "Period Close Analyzer" thread on the Payables Community

Webcast: Understanding Trading Community Architecture (TCA) Customer Entities & User Interface


ADVISOR WEBCAST: Understanding Trading Community Architecture (TCA) Customer Entities & User Interface

Date:  March 26, 2014 at 9:30 am ET, 6:30 am PT, 1:30 pm GMT

This one-hour session is recommended for technical and functional users who use the Customer Standard User Interface in Release 12. Join us to gain an understanding of the Trading Community Architecture (TCA) Customer Standard function for maintaining customer data including party relationships, customers, organizations, and locations that belong to the commercial community in the TCA Registry.

Topics will include:

  • Main entities in the Customer Data Model
  • Customer Standard User Interface (UI) HTML pages
  • Data Quality Management (DQM) functionality in the Customer UI
  • Multiple Organization Access Control (MOAC) in the Customer Standard UI
  • Trading Community Architecture (TCA) diagnostic scripts


For more details and how to register see Doc ID 1612925.1.

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

New Diagnostic for Oracle Asset Tracking

In January our blog entry 'Troubleshooting Asset Tracking Pending Transactions' we told you about a new note to help you resolve problems with Oracle Asset Tracking (OAT) pending transactions.  Now we're happy to announce a new diagnostic script which will do a lot of the hard work for you!  

The new Oracle Asset Tracking Pending Transactions Diagnostic Program collects information related to pending transactions in Install Base and also some generic information that can be useful for the investigation of the issue at hand. This program will collect and display information for a given Inventory Item ID (either serialized or non-serialized) and can help in identifying the problems with pending transactions for any IB Trackable item. 

The program output report has the following sections:

  •     Item Definition
  •     Inventory Material Transaction Details (MMT)
  •     Install Base Error Transaction Details
  •     Install Base Pending Transaction Details
  •     Instance History Details for Pending Transactions
  •     Instance-Asset Details for Pending Transactions
  •     Project Details
  •     Fixed Asset Details
  •     Install Base Parameters information
  •     Asset Location Mapping in Install Base
  •     Asset Book and Category Set up in FA
  •     CSE Profile Option Setups

The diagnostic toDoc ID 16168591.ol consists of a self-contained PL/SQL code package which will be executed as a concurrent program.

For more details on how to install and use this program, please refer to: Oracle Asset Tracking Pending Transactions Diagnostic Program (Doc ID 1616859.1).

Monday Mar 10, 2014

Mark Your Calendar for April 15 Webcast Reconciliation of Receiving Inspection Account!


Webcast: Reconciliation of Receiving Inspection Account

Date: April 15, 2014 at 3:00 pm, GMT Summer Time (London, GMT+01:00) / 10:00 am, Eastern Daylight Time (New York, GMT-04:00) / 7:30 pm, India Time (Mumbai, GMT+05:30) / 4:00 pm, Egypt Time (Cairo, GMT+02:00)

The one-hour session is recommended for technical and functional users who wish to know about Receiving Inspection Account reconciliation process. This webcast discusses the best practices to be followed for reconciling and troubleshooting steps in case of any data discrepancies.

Topics will include:

  • Receiving Inspection account reconciliation process
  • Troubleshooting steps
  • Demonstration

Don’t delay sign up today!


Details and Registration: Doc ID 1633070.1

Friday Mar 07, 2014

Three New Order Management Diagnostic Tests

Three new Order Management Diagnostic Tests available for 12.1.1+ via Patch 18013753 (Please visit E-Business Patching (MOSC) to request the initial password to download).

The Apps Check Diagnostic is now available via the Oracle Diagnostic Framework.  This is the same as what is executed from the Concurrent Program.  Executing the Diagnostic Test via the Diagnostic Framework 'Applications Diagnostics > Diagnose' offers a user friendly execution experience and HTML output that is validated and can be directly uploaded to a Service Request.  Please see Doc ID 1631911.1 for details.

Duplicate Lines From OE Drop Ship Sources, is new to the Diagnostic Framework.  This Diagnostic Test selects all duplicate lines from OE Drop Ship sources table.  Please see Doc ID 1632022.1 for details.

RMA Lines Stuck At Awaiting Return Or Disposition, is new to the Diagnostic Framework.  This Diagnostic Test selects all the RMA lines that are stuck at Awaiting Return or Awaiting Return Disposition status, even after the order lines had been fully received and fully or partially delivered.  Please see Doc ID 1632024.1 for details.

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!


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