Tuesday Jul 19, 2016

An In-Depth Look At Fixed Assets Additions

For an in-depth look at additions in Fixed Assets, you may want to take a look at a newly-published white paper.  This white paper can be found in Doc ID 2160859.1 - Fixed Assets (FA) - Additions Data Model White Paper (R12).  This white paper was written to provide a comprehensive look at the many forms of additions in Fixed Assets, including:Plusses

  • Quick Additions
  • Detailed Additions
  • Addition of Expense Assets
  • Addition of CIP (Construction In Process) Assets
  • Addition from Accounts Payables
  • Addition from Projects
  • Addition via WebADI
  • Addition via API

The paper covers both the functional and the technical sides of the addition processes.  It includes setups that need to be done, how the transactions flow using different forms of addition, as well as table-level details and accounting information.

EBS Sales Order Analyzer

The EBS Sales Order Analyzer is a self-service health-check script that reviews one Sales Order and its' related data. It will collect and analyze information related to a sales order, its pricing adjustments, shipment lines and workflow status and provide feedback and recommendations as needed. Analyzers may also be used as data collection tools by Support Engineers. Your application data is not altered in any way when you run this analyzer. 

Benefits Include the following:
  • Immediate analysis and output of OM Sales Order data from a particular environment
  • Identifies OM system setup and configurations
  • Provides recommended actions and best practices
  • Runs as a standalone or Concurrent Request
Please refer to the following document for additional information: EBS Order Management Sales Order Analyzer (Doc ID 2038363.1)

Monday Jul 18, 2016

Oracle Advisor Webcast on EBS CRM: Trade Planning and Offer Execution Flow

Register NOW to Join us for a CRM Oracle Advisor Webcast on
EBS CRM: Trade Planning and Offer Execution Flow

Details & Registration: Doc ID 1455786.1

Join us for this one-hour advisor webcast, recommended for technical and functional users of

Oracle Channel Revenue Management.
This presentation covers the various Trade Management Offer Types

and the Accrual Offer creation flow in detail.

We’ll cover topics including:
* Trade Planning Offer Types
* Offer Creation Flow
* Q&A Session

Wednesday, August 10, 2016 at

  • 08:00 AM (US Pacific Time)
  • 11:00 AM (US Eastern Time)
  • 05:00 PM (Central European Time)
  • 08:30 PM (India Standard Time

Wednesday Jul 13, 2016

Secure Your Mobile Telnet And Smartphone Now!

Everyone in the software industry and beyond understands the critical importance of technological security. Oracle Warehouse Management Systems (WMS) and Mobile Supply Chains Applications (MSCA) using Telnet connections over TCP/IP, provide security via basic user/password authentication, tied directly to standard Oracle Applications menu security. But there are additional options. There is a very helpful white paper in MOS document, Securing MWA Telnet Communication using Network Encryption (Doc ID 1493091.1).

Doc ID 1493091.1 contains a white paper detailing the SSH (Secure Shell) open standards to provide encryption and security of all traffic between the mobile device and the application, as well as information on securing connections for smartphone devices. This information could be critical to complete your security strategy.

Keep in mind that the information in the white paper involves non-Oracle components, so Oracle can make no warranty on the information provided, but it is still valuable information to increase your security options. Take advantage of Doc ID 1493091.1 now and see if it can help you expand your security!

Tuesday Jul 12, 2016

UK: New National Insurance Prefix

As of  July 4th 2016,  a new prefix ‘KC’ was brought into use for National Insurance (NI) numbers. 

Unfortunately, the HMRC (Her Majesty's Revenue & Customs) systems for Real Time Information (RTI) submissions has not been not updated to accommodate this new prefix.  The specifications provided to the HMRC software developers were not amended to include this in the list of valid prefixes for NI numbers. 

As a result of this, any RTI submissions which include a NI number with the prefix of ‘KC’ would be rejected by the HMRC systems. 

HM Revenue & Customs are aware of this and are currently working on a resolution.  Please see the following update from HMRC:

Pay As You Earn (PAYE): Service Availability and Issues

Once HM Revenue & Customs (HMRC) has resolved the issue and provides further guidance, Oracle will take the appropriate action to ensure customers can process the 'KC' prefix correctly. 

In the meantime, please follow the advice given by the HMRC in Pay As You Earn (PAYE): Service Availability and Issues

Monday Jul 11, 2016

Released ! Netherlands Legislative Patch for PGGM Data Capture Changes Effective 01-Jan-2017

Starting in 2017, PGGM wants all software vendors to use the new file format (UPO), including using the corresponding new processes to create the file.
The UPO file is a general pension file that can be used by a large group of pension funds.

This patch delivers data capture changes required for generating the PGGM report in the new file format.

The following patches have been released via MyOracleSupport for the following:

Post Install Steps need not be run after patch installation.

The following MyOracleSupport notes have been updated:

If you encounter any issues with these patches, please raise a Service Request via MyOracleSupport

Webcast: Oracle Receivables Transaction Maintenance Deep Dive

Webcast_icon.jpgOracle Receivables Transaction Maintenance Deep Dive

Date: July 21, 2016 at 11 am ET, 8 am PT, 5 pm CET, 8:30 pm IST

This one-hour Advisor Webcast is recommended for functional or technical Oracle Receivables users who want to better understand the maintenance of imported and manually created transactions in Oracle Receivables. We will review System and Profile options, what is considered activity, and what changes can be made to transactions at any point in time. Note, we will not cover updating tax information in this webcast.

Topics will include:

  • Profile & System Options
  • What constitutes activity?
  • Header, Lines and Freight
  • Sales Credits
  • GL Accounts (distributions)
  • Delete and other options

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast on 21-Jul-16: Oracle Receivables Transaction Maintenance Deep Dive

Sunday Jul 03, 2016

Get Help to Reconcile Primary - Secondary Ledgers: SQL Diagnostic

The Secondary Ledgers store additional accounting representations of the information present in the Primary Ledger. There are different levels of detail in which this information is stored, which are called Conversion levels. Even though Secondary Ledgers are optional, they are intensively used in order to fulfill various business needs. 

Secondary Ledgers can differ from Primary Ledgers in one or more of the following components: 

  • Chart of Accounts
  • Accounting Calendar / Period Type Combination
  • Currency
  • Subledger Accounting Method
  • Ledger Processing Options

Reconciliation is performed usually at period end, users attempt to verify the balances or transactions transferred between ledgers. Depending on setup differences between Primary and Secondary Ledgers, setup complexity, especially where the Chart of Accounts is different between ledgers, also depending on the volume of data and summarization options, Reconciliation process can be difficult and time-consuming.

To support such activities, we have released a New Diagnostic that would help point out the main issues that could cause differences in balances between Primary and Secondary Ledgers.

Relevant validations are performed, suggestions to resolve the reported issues offered.

Find it here: Primary Ledger to Secondary Ledger Diagnostics with Pointers to Reconciliation (Doc ID 2137066.1)

Very helpful SQL Diagnostic, download it today!

Friday Jul 01, 2016

Attention: US Q2 Statutory Update Now Available

The United States (US) Second Quarter (Q2) Statutory Update, 2016 has been released!  

Patch numbers*:

  • 11i - 23511847**
  • 12.1 - 23503387:R12.PAY.B:  Q2 2016 SQWL & JIT STATUTORY UPDATE FOR 121
  • 12.2 - 23503387:R12.PAY.C:  Q2 2016 SQWL & JIT STATUTORY UPDATE FOR 122

This Q2 2016 Statutory Update patch contains the following:

  •  New and Changed Features
  •  JIT and School District Updates
  •  Important Note - Disabling of Puerto Rico Youth Wage Exemption Calculation
  •  Q2 Known Issues
  •  Additional Software Updates
  •  Change Record

For additional information on new features and changes in Q2 2016: SPWL & JIT STATUTORY UPDATE FOR 12X, please refer to the readme on My Oracle Support.

  • Doc ID 2154492.1 - 2nd Quarter 2016 Statutory Patch Readme for Release 12.1.x 

*Note: The Q2 2016 Statutory patch requires the End of Year 2015 Phase 3 patch as a prerequisite. Note also that it requires the post install steps of running the data installer and hrglobal.drv. Please be sure to carefully read all the readme's before beginning to install this patch, to ensure successful processing.

**Note: The Release 11i Q2 2016 Statutory Update patch is only available to those customers who purchased continuing legislative support for the US HRMS localization. There is an FAQ available for all E-Business Suite customers which contains critical information as to when regulatory/statutory support endson Release 11i (as well as 12.1 and 12.2) plus other details that can help US Payroll customers with planning upgrade activities. Please see Section C.

Thursday Jun 30, 2016

Get a Better Understanding of GL Mass Allocations Across Ledgers

Mass allocations make a wonderful tool to be used for quick generation of journal entries for a group of cost centers, departments, divisions, ledgers. Instead of creating many manual journals to transfer amounts from one account to others based on specific business rules, users can create one allocation formula that will generate all these journals directly. 

It is That Easy! Define

  • Allocation Pool
  • Allocation Formula
  • Target and Offset Account

Run it! 

Mass Allocations help generate a variety of allocations - such as:

  • Net Allocations
  • Step-Down Allocations 
  • Rate-Based Allocations
  • Usage-Based Allocations
  • Standard Costing Allocations

You can group Mass Allocation formulas into batches even when they refer to different ledgers. 

The setup required to run Mass Allocations across ledgers is more complex; available features allow to enter a ledger or ledger set for the accounts, run based on entered currency or ledger's currency and more. 

We have prepared a Whitepaper for you that includes real business cases, examples, known issues and more - share it with the business users today:

Mass Allocation Across Ledgers in Release12 (Doc ID 2137586.1

Get the Latest ! A New Version of the HCM Person Analyzer 200.25 was Released!

We are pleased to announce that we have released a new version of our Person Analyzer.
Version 200.25 is the latest, containing new formatting and bug fixes.

As you may be aware, Analyzers are designed by Oracle support to proactively assist you to better diagnose and maintain your Oracle Application environments.

The HCM Person Analyzer has these following areas where we review and analyze your data and setup with a resulting error, warning or passed notification

  • Overall Instance details
  •  Person details
  • System Person / Assignment types
  • Terminations
  • Salary Administration 
  • Person Payroll Details
  • Workflow

Some of the benefits obtained by using this Person Analyzer are:

  •         Immediate analysis and output of Person data from a particular environment
  •         Patching status
  •         Person complete information & Common information
  •         Provides recommended actions and best practices
  •         Runs as a standalone or Concurrent Request

* This is a non-invasive script - the Analyzer does not perform any INSERTs, UPDATEs or DELETEs to your data; it just reports on it.
* Our Per.sql scripts will be decommissioned soon, in 2016

Please be aware that instructions to run analyzer were changed and documented in Note 1675487.1 EBS Human Capital Management (HCM) Person Analyzer

To run from sqlplus:

1)  create package
SQL> @hcm_person_analyzer.sql

2) run script for one person_id

SQL> @hcm_person_analyzer_from_sql

To run as concurrent request:

1) create package

SQL> @hcm_person_analyzer.sql

2)  create concurrent request (one time setup)

FNDLOAD apps/<appspw> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct PERSONAZ.ldt CUSTOM_MODE=FORCE

- assign concurrent request to needed responsibilities(one time setup)

- run process / request

If you have any feedback in regards to this analyzer, please use the feedback link found in EBS Human Capital Management (HCM) Person Analyzer (Doc ID 1675487.1)

A Glimpse on Space Assignments Functionality

Knowing how you currently utilize your space and where you have vacancies is a key element in making informed decisions when managing your real estate. Oracle Property Manager streamlines space assignments, tracks occupancy and vacancies, and monitors capacities in each defined space. Facilities managers and space planners have access to this information online (rather than having to visit each space), dramatically reducing the cost of space administration. For landlords, tenants are automatically assigned to space as leases are finalized, providing real time vacancy information.

 Using Oracle property Manager you can track the following information

  • Availability of space in a building
  • Usable space in a building
  • Space that has been assigned
  • Amount of vacant space
  • If the space is a common area

The difference between reading a report and seeing the same data laid out graphically can have a significant impact on decision making process. Visualization in real-time of space attributes, utilization, and occupancy greatly enhances the ability to manage your real estate holdings. Oracle Property Manager provides Public Views that enable you to layer space attributes, utilization, and occupancy information into CAD drawings through the Web. Using the open interfaces like PN_LOCATIONS_ITF and PN_EMP_SPACE_ASSIGN_ITF the property information can be imported / exported.

Using the Space Assignments window, we can

1. Assigning Space to Employees and Cost Centers and Customers – Via space assignment window one can assign space to employees or directly to cost centers. Whether it is an individual office, a group of offices, a floor, or an entire building to an employee or to a cost center. We can also assign a single office to a single employee or to several employees if employees are to share the same space.

A location / building is automatically assigned to a customer when you create a revenue lease with Location and customer details.

2. Modifying Space Assignments –In Oracle property manager space assignment details can be modified / updated when you change the location area, or, when you change tenancy assigned area in lease form or by manually updating in space assignments form.

In space assignment form, you can make corrections or update information. If you choose to correct information, the old information is not saved. If you choose to update information, such as moving an employee from one office to another or changing a cost center number, the old information is preserved including the dates it was effective, when the new information is saved.

If the Use SYSDATE to Record Space Assignment system option is set to Yes, you can modify employee or cost center space assignments only if they are currently active. Also, all modifications must be as of the current date. If you specify an As of Date other than the current date in the Find Space Assignments window, the information in the Space Assignments window is read-only.

3. Synchronizing Employee Cost Centers  with Oracle Human Resource

When you create an employee space assignment, the Cost Center field is automatically populated with the cost center assigned to the employee in Oracle Human Resources. Thereafter, space assignments are not updated automatically to reflect changes to employee cost center assignments in Oracle Human Resources. You must use the Cost Center Synchronization with HR concurrent program to update cost center information in employee space assignments.

For more details on other benefits of space assignment functionality refer Property Manager user's guide.

Now Available: General Ledger Health Check Analyzer

EBS Analyzers are complex Diagnostics provided by Oracle to help troubleshoot issues, identify any problems and proactively help resolve any situation reported. The result is presented as an easy-to-read html page outlining items that need to be reviewed and adjusted, along with confirmation of correct validations for existing setups. You can execute the Analyzer via SQL script or Concurrent Request.

In the world of EBS Analyzers there is a NEW one available:  General Ledger Health Check Analyzer!

Perform immediate health check analysis, get proactive recommendations for:

  • Misclassified Accounts
  • Overlapping Child Accounts
  • Duplicate Rows in GL Tables
  • Period Closing
  • Calendar Overlapping periods or Gaps data
  • Budgetary Control 

In addition, find in the same output: 

  • Instance Overview
  • Proactive and Preventive Recommendations
  • Diagnostics Apps Check 

Use the power of almost All our GL Diagnostics by running a single Analyzer!

Download it now and find out more about this tool in: 

EBS General Ledger Health Check Analyzer (Doc ID 2117528.1)

Tuesday Jun 28, 2016

Debug Mode for RTI - Full Payment Submission (FPS)

Oracle E-Business UK Payroll is announcing the delivery of  Debug Mode Submission for Real Time Information (RTI) - Full Payment Submission (FPS). 

To simplify the process and reduce the time required to produce the log and output files, the RTI process - Full Payment Submission Process (FPS) 2016/17 now includes two new parameters which will restrict the output only for the employee whose name is selected for the parameter "Person Name".

  1. Debug Mode (LOV with values Yes and NO) – default set to No
  2. Person Name (LOV detailing the person names processed in the selected prepayment)

The following patches have been released via My Oracle Support:

      • R12.1 : 23311175:R12.PAY.B -  ENABLING OF DEBUG MODE FOR FPS PROCESS
      • R12.2 : 23311175:R12.PAY.C -  ENABLING OF DEBUG MODE FOR FPS PROCESS

Please refer Debug mode for RTI - Full Payment Submission Process (FPS) 2016/17 (Doc ID 2150440.1) , which can be located in My Oracle Support (MOS).
The patch Readme has important installation, setup instructions and guidelines.

TYE-16: Direct Earnings Attachment Reference Number Changes

Attention:  TYE-16: DIRECT EARNINGS ATTACHMENTS 2016 CHANGES have been released for Public Sector Payroll

The Social Security (Overpayments and Recovery) Amendment Regulations 2015, which came into force in April 2015, introduced a number of changes to the DEA calculation which require changes to the existing Oracle functionality. 

The R12.1 patch has been released as a legislative patch and is generally available on My Oracle Support (MOS).  R12.2 is to be released soon.

  • R12.1: 23172765:R12.PQP.B   TYE-16: Direct Earnings Attachments 2016 Changes


This patch is different from all other statutory updates as it  includes all hrglobal changes and any prerequisites.  You do not need to download the latest hrglobal patch, but MUST run DataInstall and hrglobal.drv after applying this patch to load  the statutory content.

Patch Readme (MOS Note (Doc ID 2072952.1) has important installation, setup instructions and guidelines.


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



« July 2016