Tuesday Mar 11, 2014

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

Wednesday Jan 22, 2014

R12 Master Generic Data Fix Diagnostic for Purchase Orders and Requisitions

Do you wish you could proactively check your Purchasing documents for known data integrity issues or is there a Purchasing document you are having problems with?

Well, visit Doc ID1474734.1 for the R12 Master Generic Data Fix Diagnostic for Purchase Orders and Requisitions.  Running this one script identifies known data integrity issues within the Purchasing application (for example errors with cancel and close and unit of measure issues) where there are often generic data fixes (GDFs) already available.  The script will produce an HTML output report of all known problems relating to the purchasing transactions created in the specified date range, along with information on notes and/or data-fix patches which are already be available to resolve the data issues.

The following data checks are included:
  • Document type records with null ORG ID.
  • Synchronization issues with archive tables.
  • Quantity billed/amount billed mismatch in purchase order shipments and distributions.
  • Purchase orders with a mismatch of quantity billed or amount billed between the shipment or distribution and the invoice distribution.
  • Purchase order shipments eligible to be closed.
  • Outstanding supply/demand for non-existing or cancelled requisition lines.
  • Fully received internal requisitions continue to show as pending supply.
  • Approved requisitions not available in Autocreate form after associated purchase order is deleted.
  • Purchase orders with unit of measure (UOM) mismatch between Lines and Shipments.
  • Canceled purchase orders in Requires Reapproval status.
  • Tax exception 023 (ORA-00001: unique constraint (ZX.ZX_LINES_DET_FACTORS_U1) violated) when approving.
  • Purchase order with authorization_status = 'REQUIRES_REAPPROVAL' rather than 'REQUIRES REAPPROVAL'.
  • Foreign currency autocreated purchase orders have inverse rate.
  • Purchase order ship-to organization does not match distribution deliver-to organization.
  • Requisition distribution line associated to multiple PO distribution lines.
Don’t delay make Doc ID1474734.1 part of your routine Procurement procedures today!

Friday Dec 06, 2013

Diagnostic: HCM Technical Analyzer Now Available!

The HCM Proactive Support Delivery Team is introducing the HCM Technical Analyzer, a Health-Check script which reviews your overall HCM footprint by analyzing your current configurations and settings for your HCM environment.  The HCM Technical Analyzer is a non-invasive script which is designed to provide proactive feedback and recommendations associated with the HCM instance on which the analyzer is executed.

This Analyzer / Health Check / Data Collection tool is a PL*Sql script which will check the E-Business Suite environment and can be executed on all currently released / supported application versions  (i.e. 11.5.10.2, 12.0, 12.1, and 12.2).   As the process executes, it will output diagnostics advice and proactive recommendations within an .html output file.

When reviewing the analyzer output, you can immediately see where issues are identified as they are displayed in red (errors), orange (warnings) or blue (best practices), so that they can be easily seen.  In addition to identifying areas of concern, the analyzer will also identify My Oracle Support (MOS) articles which can be utilized to resolve the issue.

The Analyzer can be executed using one of two 'Run Type' parameters: 

  • Run Type = ISSUES, which will execute the Analyzer / Health Check with the output geared to customer problem resolution. This option will display only those sections where an issue or potential issue is identified so that you the customer can proactively address them.
  • Run Type = ALL, which will execute the Analyzer as a Data Collection tool which can be used to assist an Oracle Support Engineer in resolving an issue.

 The Analyzer is designed specifically to be used with the Human Capital Management (HCM) products, which is driven by the following input parameter values:

  • BEN - Benefits
  • HR - Human Resources
  • IRC - iRecuitment
  • OTL - Oracle Time and Labor
  • PAY - Payroll
  • SSHR - Self Service Human Resources
  • ALL - All HCM products above.

When the Analyzer is executed an environment review is performed and feedback provided on: 

  • Performance related setups and checks
  • Invalid objects, disabled triggers, and database issues
  • Profile settings
  • Packages and java classes version
  • Patching status.

It is recommended that this script be setup as a concurrent request from the E-Business Suite interface so that it maybe executed by either Functional or Technical representatives from your business.

  • How to run the HCM Technical Analyzer as a Concurrent Request (Doc ID 1575663.1)


Download the HCM Technical Analyzer Script (Doc ID 1562530.1) Today, and Provide us your Feedback!

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 2014
SunMonTueWedThuFriSat
  
1
5
6
12
13
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today