Friday May 30, 2014

Oracle Service Contracts – Calculate Estimated Tax with Higher Accuracy

On a Service Contract the tax rate and its effectivity can change over the contract duration.  Hence, service organizations need to provide an accurate picture of the estimated tax that the customer might end up paying. 

Prior to Release 12.1.3+, the Oracle Service Contracts application calculated the estimated tax based on the line/ sub line start date.  With Release 12.1.3+ (via Patch 16601269:R12.OKS.B) , new functionality provides users with an option to calculate tax at contract billing schedule level, thereby considering the changes in tax rate effectivity at that level.

A new profile option 'OKS: Calculate Tax at Schedule' has been introduced which can be used to control whether the existing or new functionality is used.  If the profile is set to 'Yes' the application calculates tax at the billing schedule level for all lines/ sub lines.  For more details on the implementation steps and functionality, please refer to Doc ID 1676700.1: Oracle Service Contracts – How To Calculate Estimated Tax with Higher Accuracy.

Thursday May 29, 2014

Fixed Assets Recommended Patch Collections

After the introduction of the Recommended Patch Collections (RPCs) in late 2012, Fixed Assets development has released an RPC about every six months.  You may recall that an RPC is a collection of recommended patches consolidated into a single, downloadable patch, ready to be applied.  The RPCs are created with the following goals in mind:

  • Stability:  Address issues that occur often and interfere with the normal completion of crucial business processes, such as period close--as observed by Oracle Development and Global Customer Support.
  • Root Cause Fixes:  Deliver a root cause fix for data corruption issues that delay period close, normal transaction flow actions, performance, and other issues.
  • Compact:  While bundling a large number of important corrections, the file footprint is kept as small as possible to facilitate uptake and minimize testing.
  • Reliable:  Reliable code with multiple customer downloads and comprehensive testing by QA, Support and Proactive Support. 

There has been a revision to the RPC release process for spring 2014.  Instead of releasing product-specific RPCs, development has released a 12.1.3 RPC that is EBS-wide.  This EBS RPC includes all product-recommended patches along with their dependencies.

To find out more about this EBS-wide RPC, please review Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 1 (RPC1) (Doc ID 1638535.1).

Procurement and E-Business Suite Product Analyzers .. Can you use this tool to resolve your SR?

Procurement and E-Business Suite Product Analyzers (Doc ID 1545562.1).

Analyzers are Query/Read only tools with easy to read html output. The tools are delivered by EBS Support via My Oracle Support documents ids for ease of use. The Analyzer scripts are meant to be part of your Production maintenance program by your Sysadmin, or to designated end users. The result set is an easy to read html output that provides recommendations, solutions and early warnings to of items that should be reviewed and correct. Each analyzer can be ran on demand or scheduled for repeatability and emailed to critical reviewers.

There are several Analyzers available for E-Business Suite Applications Technology Group, Financials, and Manufacturing including some of the following topics.  Review them all at (Doc ID 1545562.1).

    • Workflow
    • Concurrent Processing
    • Clone Log Parser Utility (Rapid Clone)
    • Invoices, Payments, Accounting, Suppliers and EBTax
    • Validate Data before Period Close
    • EBTax Setup
    • Payables Trial Balance
    • Internet Expenses
    • AutoInvoice Post-Process
    • ASCP Performance
    • PO Approval
    • iProcurement Items

For the Procurement specific Analyzers access them directly at:

R12 IP Item Analyzer Diagnostic Script (Doc ID 1586248.1)

R12: PO Approval Analyzer Diagnostic Script (Doc ID 1525670.1)

Wednesday May 28, 2014

Webcast: AutoInvoice Overview & Data Flow

Webcast_icon.jpgWebcast: AutoInvoice Overview & Data Flow

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

This one-hour session is part one of a three part series on AutoInvoice and is recommended for technical and functional users who would like a better understanding of what AutoInvoice does, required setups and how data flows through the process. We will also cover diagnostic scripts used in with AutoInvoice.

Topics will include:

  • Why Using AutoInvoice?
  • AutoInvoice Setups
  • Data flow
  • Diagnostic tools

Details & Registration: Doc ID 1671931.1

Process Manufacturing (OPM) Actual Costing Analyzer Diagnostic Script

The OPM Actual Costing Analyzer is a script which you can use proactively at any time to review Setups and pieces of data which are known to affect either the performance or the accuracy of either the OPM Actual Cost process, or Lot Costing.

Each topic reviewed by this report has been specifically selected because it points to the solution used to resolve at least two Service Requests during a recent 3-month period.

You can download this script from Doc ID 1629384.1, OPM Actual Costing Analyzer Diagnostic Script.

Tuesday May 27, 2014

Your Feedback on Oracle Asset Tracking

Oracle Asset Tracking Development strives to improve customer satisfaction with our Oracle Asset Tracking product.  In this context, they are very interested in getting your feedback about the Oracle Asset Tracking module.

Recently, we have seen more and more customers using OAT and we would like to know for example:
  • Have you have encountered any product gaps that need to be addressed?
  • Are there business flows that do not suit your requirements?
  • What new features you want to see in the product?
Please share your feedback with us and we will discuss it with Oracle Asset Tracking Development and Product teams to improve the product.

To share your feedback either post to the dedicated thread in the MOS Install Base Community here OR add a comment to this blog post (note that the blog comment you enter won't immediately be visible in the blog).

DCOGS Balance Breakup Diagnostic in OPM Financials

Purpose of this diagnostic (OPMDCOGSDiag.sql) is to identify the sales orders which constitute the Deferred COGS account balance.

This will help to get the detailed transaction information for Sales Order/s Order Management, Account Receivables, Inventory and OPM financials sub ledger at the Organization level.  This script is applicable for various scenarios of Standard Sales Order, Return Orders (RMA) coupled with all the applicable OPM costing methods like Standard, Actual and Lot costing. 

OBJECTIVE: The sales order(s) which are at different stages of their life cycle in one spreadsheet at one go.

To collect the information of:

  • This will help in:
    • Lesser time for data collection.
    • Faster diagnosis of the issue.
    • Easy collaboration across different modules like  Order Management, Accounts Receivables, Inventory and Cost Management.

 You can download the script from Doc ID 1617599.1 DCOGS Balance Breakup (SO/RMA) and Diagnostic Analyzer in OPM Financials.

Friday May 23, 2014

Troubleshooting Enterprise Asset Management Transactions

New whitepaper!!  The objectives of this white paper are to provide an overview of how to resolve pending or errored transaction issues in Enterprise Asset Management. This paper will cover the following topics:
  • Consider the type of transactions affected
  • Specify the tables involved
  • Look at resource transaction errors and consider the  cause, validate if there is a root cause solution and explain how to fix these errors (including datafixes).
  • Look at material transaction errors and consider the  cause, validate if there is a root cause solution and explain how to fix these errors (including datafixes).

You can download the whitepaper from Doc ID 1672312.1 Troubleshooting Stuck/Errored Transactions in Enterprise Asset Management.

Thursday May 22, 2014

Email Center Training Available

Email Center forms part of Oracle's Interaction Center family of products.  It is a complete solution for managing email interactions with customers, partners, suppliers, employees, and other entities that interact with an organization.  It classifies incoming e-mails and routes them to qualified agents and automatically suggests one or more responses. 

Based on their experience of resolving customer queries on Email Center, EBS Support have now produced a series of training videos to help Email Center users and implementers understand how the application works, how to set it up and how to use it.  The training is structured into three different levels: Level 1/Foundation, Level 2/Intermediate, Level 3/Advanced. 

The Foundation level training is now released in Doc ID 1581119.1: Email Center (Level 1 / Foundation) Training [Video].  This foundation/Level 1 training note will give the reader a basic understanding of Oracle Email Center's functionality and components and will take around one hour to complete, including the attached videos which will show Email Center in action. The Intermediate/Level 2 and Advanced/Level 3 training will build on the knowledge gained in this training, taking the Email Center implementation possibilities to a higher level, with details on auto-processing and auto-acknowledgements, intent analysis, tagging, auto-creating Service Requests and lots more.

Wednesday May 21, 2014

Wishing There Was More Information on Oracle Contract Lifecycle Management (CLM) for Procurement?

Well wait no longer!  Check out this wealth of information just released for CLM:

 Doc ID
FAQ: CLM - Contract Lifecycle Management Reports
1601060.1 FAQ: CLM Warrants and Electronic Signatures
FAQ: CLM for Public Sector Workload Assignments and PALT - Procurement Action Lead Time - Tracking
1624262.1 FAQ: CLM Modifications Enhancements
Contract Closeout Enhancements
1641747.1 FAQ: CLM for Public Sector FPDS-NG, Funding a Modification From a Requisition
1601521.1 FAQ: CLM Vendor Eligibility Check - EPLS
1601538.1 FAQ: CLM Use of Clause Logic Service on Solicitations
1638766.1 FAQ: CLM for Public Sector - WDOL Integration
1628199.1 FAQ: CLM for Public Sector - Undefinitzed Contract Actions
1633472.1 FAQ - CLM: Payment Instruction and Payment Term
FAQ - CLM: Event Base Delivery
FAQ - PAR - Post Award Requests
FAQ: CLM Use of Contract Closeout
FAQ - MIPR - Military Interdepartmental Purchase Request
FAQ: CLM Protest Tracking
FAQ: CLM Workflow Assignments and Option Enhancements
FAQ: CLM Implement and Use Autocreate Grouping and PR Line With No Distributions
FAQ: CLM Concurrent Modifications
CLM for Public Sector - Contracts File
CLM for Public Sector - Enhancements to Procurement Contracts
CLM for Public Sector - Integration with EDA and ACRN Support
FAQ: CLM for Public Sector - Interface With External System: ORCA
FAQ: CLM for Public Sector - Interface With External System: FedBizOpps
FAQ - CLM Line Type and Structure Changes
FAQ: CLM Novation and Multi-Modifications
FAQ: CLM Support for Global Change and GL Date Defaulting
FAQ: CLM System Generated Description
FAQ: CLM Contract Lifecycle Management for Public Sector Solicitation Offer and Enhancements
Troubleshooting - CLM Contract Lifecycle Management for Public Sector Solicitation Offer
FAQ: CLM Contract Lifecycle Management for Public Sector - Umbrella Program
FAQ: Contract Lifecycle Management (CLM) - Unsolicited Lines

Monday May 19, 2014

Troubleshooting iStore Order Placement

If you use iStore then you won't want to miss our latest Integration Troubleshooting note: Integration Troubleshooting : iStore to Order Management (Doc ID 1621430.2). 

iStore is used for the entering of Sales Orders of both standard and configurable items.  It integrates with Order Management, via the Order Capture APIs, to create, update, and process Sales Orders. 

The purpose of Doc ID 1621430.2 is to aid in the diagnosis and troubleshooting of issues in the integration flow between:

  • iStore
  • Order Capture APIs
  • Order Management.

The document includes information about the business flow, integrations, important tables and troubleshooting throughout the iStore business process. Where iStore integrates with other applications, links to the information centers for those other products are listed as well.

Take a look at Doc ID 1621430.2 and let us have some feedback on what you like and what can be improved!

Payables Subledger Accounting Explained!

Subledger Accounting can be complex but if you follow the advice in our white paper you will be on the road to success!

Subledger Accounting (SLA) is a rule-based accounting engine that centralizes accounting for Oracle E-Business Suite products in R12. Subledger Accounting is not a separate product in itself. 

Together with the new ledger support, Subledger Accounting enables support of multiple accounting requirements concurrently in a single instance. Different accounting regulations can be satisfied by maintaining and applying different sets of rules to different sets of transactions, or accounting for the same transaction with multiple methods. Subledger accounting options define how journal entries are generated from subledger transactions at the subledger application level. 

Note: SLA replaces the different accounting engines available in 11i e.g., the AP accounting engine, FA accounting engine, Global Accounting Engine (AX), and so forth. 

This white paper that was recently updated is very comprehensive and describes the setup of the Payables Subledger Accounting feature that is available in Release 12.  It includes a step by step guide on how to configure the SLA feature for business transactions. 

Payables SLA allows users to personalize their accounting setup according to business needs and this updated white paper now includes 8 test cases together with setup demonstration and results.

Find out all about SLA setup and configuration by reviewing the white paper: 

Subledger Accounting Setup for Oracle Payables (with examples) (Doc ID 1612433.1)

Friday May 16, 2014

OPM LCM Transactional Data Diagnostics

New OPM LCM Transactional Data Diagnostics, Doc ID 1664499.1!!

This document give the overview of  Landed Cost Management (LCM) integration with Oracle Process Manufacturing Financials (OPM) Types of usage of LCM (as Service and Pre-Receiving), Sequence of operations involved in execution of end-to-end Procure to Pay cycle for both the LCM usages, Data flow and associated table relations.

The script attached to this document: OPM_LCM_TransDataDiag.sql, extracts the transactional data from all the relevant tables in the Procure to Pay Cycle with OPM LCM integration for a selected Purchase Order. This helps to analyze and understand the root cause, in case of any issue with the item costs and the journal line amounts.

Thursday May 15, 2014

May 28th Webcast: Oracle Product Hub - Publication & Webservices

Webcast_icon.jpgWebcast: Oracle Product Hub - Publication & Webservices

Date: May 28, 2014 at 1:00 pm ET, 12:00 pm CT, 11:00 am MT, 10:00 am PT, 6:00 pm, GMT Summer Time (London, GMT+01:00)

This one-hour session is recommended for technical and functional users who are trying to understand, What are the OPH web services available, how these help with integration and the way these are implemented in Product Data Hub. Publishing and web services are the two concepts that help integrate the OPH to other systems. Publishing provides for means to convey messages to interested target systems and web services can be used to extract the relevant information.

This presentation covers both Publication Web Service available from Integrated SOA Gateway and ODI Based web services (Item, Structure, Item Catalog Category and ValueSet web services). It covers the setup of these web services, how to publish information and invoke web services to extract information.

Topics will include:

  • Overview
  • Setup
  • Process Flow
  • Troubleshooting
  • References
  • Additional Information

Details & Registration: Doc ID 1290983.1

Webcast: Processing Payments in Order Management R12

Webcast_icon.jpgWebcast: Processing Payments in Order Management R12

Date: May 20, 2014 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 8:30 pm, India Time (Mumbai, GMT+05:30)

This one-hour session is recommended for technical and functional users who intend to know about the how payments are handled in Order Management.

Topics will include:

  • Mandatory Setups
  • Process Flow for payment methods
  • Discuss Common Error Messages regarding payments in OM
  • Run through Test Cases

Details & Registration: Doc ID 1641228.1


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



« May 2014 »