Thursday Oct 29, 2015

Webcast: 12.2.5/ ASCP Enhancements, Part 1 of 2, Nov. 5, 2015 9:00 AM MT

Webcast_icon.jpg12.2.5/ ASCP Enhancements, Part 1 of 2

Date: November 5, 2015 at 11:00 am ET, 8:00 am PT, 3:00 pm GMT, 8:30 pm, India Time (Mumbai)

This one-hour advisory webcast is recommended for technical users, functional users, system administrators, Database Administrators, and other business personnel working in Value Chain Planning area.

Topics will include:

  • VCP 12.2.5 Configuration
  • Enhancements
    • ASCP Collections Filters 
    • ASCP Demand Schedule - Specific Forecast Processing
    • ASCP Maximize Resource Utilization in Day Level Planning 
    • ASCP Purchasing Integration Enhancements

Details & Registration

Tuesday Oct 27, 2015

The new ORAchk release is now available to download

The new ORAchk release is now available to download.

New Features in ORAchk

Create your own checks

Would you find it useful to easily run your own environment or business specific checks?

Now you can use ORAchk to write, execute and report on your own custom user defined checks.

  1. Use the Collection Manager interface to write your checks
  2. ORAchk’s built-in email notification and diff reporting
  3. View the results of your checks in the new “User Defined Checks” section in the ORAchk html report
  4. Collect and easily view all results enterprise wide using the ORAchk Collection Manager

Expanded Oracle Product Support

ORAchk now brings wider and deeper support throughout the Oracle product stack, with newly added support for the following product areas:

  • Oracle Identity Manager
  • Oracle E-Business Suite Customer Relationship Management
  • Oracle E-Business Suite Project Billing
  • Oracle ZFS Storage Appliance
  • Oracle Virtual Networking
  • Oracle PeopleSoft Applications
  • Application Continuity

Easily Run or Exclude Specific Individual Checks

New command line switches have been added so you can easily exclude or run only specific checks.

Shorter ORAchk Execution Time

ORAchk now has the ability to cache discovered databases, meaning database rediscovery is skipped and execution time is faster. If databases change you can simple issue one command to have ORAchk refresh the cache.

Support for Custom EBS APPS User

ORAchk will now dynamically determine the APPS user, enabling all EBS checks to be used even if you have changed the name of the APPS user.

See Document 1268927.2 for further details of the new product support.

Over 100 New Health Checks

This release of ORAchk adds more than 100 new checks for some of the most impactful problems seen to Oracle Customer Support specifically in the areas of:

  • Database best practices for patching, performance, scalability and high availability.
  • Oracle Identify Management pre-install settings, post-install configuration and runtime environment.
  • E-Business Suite best practice configuration settings for Human Resources and CRM (forecast, payment worksheets and service contracts).
  • E-Business Suite early detection of incompatible configurations in Project Billing.
  • Oracle ZFS Storage Appliance best practice configuration for performance and resilience.
  • Oracle Virtual Networking best practice configuration settings.
  • PeopleSoft Applications database best practices.

For more details and to download the latest release of ORAchk see Document 1268927.2

Monday Oct 26, 2015

Have You Seen 'Allow Cross Project for Pick Wave Allocation'?

Are you on EBS 12.1.3 or above? Do you use Project Manufacturing (PJM)? If yes, you already have the options to 'Allow Cross Project Issues' and 'Allow Cross Unit Number Issues'. Now you can also choose to select the 'Allow Cross Project Pick Wave' in the Project Manufacturing Parameters window. This will enable cross project sales order or internal order pick wave allocation.

With the enhancement, you can still 'Allow Cross Project Issues' to other move order types and transactions (WIP jobs, etc), but Users now also have the ability to decide whether to allow cross project issue based on the move order type – pick wave or others.

For more information on the the patches required to get the enhancement, and the enhancement itself, see notes:
*PJM - R12 - Pick Release Unexpectedly Allocating Common or Different Project Stock For Hard Pegging Items (Doc ID 1613522.1)
*PJM - R12 - Pick Release Failing to Allocate Project Sales Orders After Applying Inventory Management Rollup Patch (Doc ID 1613656.1)
*Oracle Project Manufacturing Release Notes for Release 12.2.4 (Doc ID 1912375.1)

Thursday Oct 22, 2015

EBS Release 12.1.3+ RPC4 is Available!

Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 4 (RPC4) Doc ID 2053709.1

Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 4 (RPC4) combines recommended patches that were released after Release 12.1.3 into a single, integrated and regression-tested patch to ensure successful installation.

Patches included in Oracle E-Business Suite Release 12.1.3+ RPC4 are also available individually, and may contain conditions and prerequisites relevant to their application. RPC4 includes all the recommended patches, along with their dependencies. Applying this patch in a single downtime patching window saves effort and time, rather than applying each recommended patch individually.

JRE 6, 7, and 8 now certified with EBS 11i, 12.1, and 12.2

All JRE 6, 7, and 8 codelines are now certified with Oracle E-Business Suite Release 11i, 12.1, and 12.2 for Windows desktop clients! Our standard policy is that all E-Business Suite customers can apply all JRE updates to end-user desktops. Click below for more information…

JRE 1.8.0_65/66 Certified with Oracle E-Business Suite
JRE 1.7.0_91 Certified with Oracle E-Business Suite
Java JRE 1.6.0_105 Certified with Oracle E-Business Suite

Tuesday Oct 20, 2015

Oracle E-Business Suite 12.2.5 is Now Available!

This is a recommended release for all EBS 12.2 Customers, so make sure you take a look at the following links to see what’s new:

Monday Oct 19, 2015

NEW! BI Publisher (BIP) Analyzer for EBS (Doc ID 2032715.1)

The BIP Analyzer for E-Business Suite (EBS) is a self-service health-check script that helps customers deliver XML based output and generated reports.
  • Check BIP related data
  • Configurations
  • Environment settings
Script checks for:
  • OPP configuration
  • Java Heap settings
  • Process and Thread setting
  • BIP runtime properties


  • Quick and comprehensive analysis of the integrated BIP environment
  • Ensure Business Reporting needs are met

Download it from: BI Publisher (BIP) Analyzer for E-Business Suite (Doc ID 2032715.1)

Oracle Property Manager – Introduction – Overview


Oracle Property Manager is part of the Oracle Real Estate Management solution. It is designed as a property database for organizations with large property management portfolios. It provides you with tools to manage real estate tasks, such as property administration, space allocation, and most importantly, lease management. Landlords as well as tenants can use Oracle Property Manager to manage lease clause information and critical real estate dates and milestones for property leases and space administration. This dual perspective enables Oracle Property Manager to address the needs of corporate real estate management, commercial property management, retail or franchise operations, and investment real estate companies to manage their real estate portfolios efficiently.

This module is widely used by real estate companies owning/leasing buildings and/or land, mall administration companies leasing retail space and any other company that rents buildings or space to a third party.

Key Features:-

Lease Management / Administration

Lease Management is the center of real estate management function. With Oracle Property Manager you can amend, edit and track your lease information's, calculating lease amounts, scheduling payments / receipts, exporting invoices to Oracle Payables and Oracle Receivables, setting up milestones etc. 

In addition to that we can also automate the process of rent increases based on fixed percentages or specific indexes such as the Consumer Price Index (CPI). We can also  calculate rent rent based on variable factors such as sales volumes. This module can be effectively used for collecting common area maintenance (CAM) expenses also.

Space Management

The Oracle Property Manager module has an inbuilt hierarchy starting at the top by grouping properties within regions and office parks. You can define / track details like regions and office parks, building, floors and offices etc.  It also helps to ensure that each employee or customer is assigned with appropriate space and it also helps to ensure that all available space is assigned in the most effective manner possible.

We can also track space usage at any level by employee, cost center or both. Managing space efficiently enables landlords to keep occupancy rates high to ensure proper return on investment.


Oracle Property Manager integrates with Oracle applications such as Payables, Receivables, General ledger, Human resources etc. This helps to use Oracle Property Manager records as the source of payments and billings.


Oracle Property Manager provides a set online inquiry windows and standard reports for reporting purpose. Using online inquiry window we can easily access information such as lease amends and edits, payment and billing information as well as rentable, usable, and vacant area etc.

In addition to that there are many standard reports which will help to review rent schedules, lease provisions, rent schedules, space allocation and utilization.

If you have any question on Oracle Property Manager or if you are interested in knowing more about it, you can post your questions in Communities

Friday Oct 16, 2015

EBS 12.2.5 Release Update Pack Available (Patch 19676458)

Announcement: EBS 12.2.5 Release Update Pack Available (Patch 19676458)!

Check out the list of EBS Product Specific Release notes in Doc ID 2049015.1 

Thursday Oct 15, 2015

AD and TXK Delta RUP 7 patches are available for download!

Announcement: AD and TXK Delta RUP 7 patches are available for download!

If you are on Oracle E-Business Suite Release 12.2, we strongly recommend that you apply both of these two newly-released patch collections at your earliest convenience:

Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 (Doc ID 2033780.1)

Webcast: How to Create Bank Statements & Reconciliations in Oracle Cash Management

Webcast_icon.jpgHow to Create Bank Statements & Reconciliations in Oracle Cash Management

Date: October 28, 2015 at 11:00 am ET, 8:00 am PT, 3:00 pm GMT, 8:30 pm, India Time (Mumbai)

This one-hour Advisor Webcast is recommended for functional users who want to learn more about importing/creating bank statements & reconciling receipts in Oracle Cash Management. We will review related setups, create bank statements, reconcile receipts and debug bank statement issues.

Topics will include:

  • Setting up Cash Management to use with Oracle Receivables
  • Manual & imported bank statement creation
  • Manual & AutoReconciliation
  • Data Flow
  • Debug bank statement issues

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast on 28-Oct-15: How to Create Bank Statements & Reconciliations in Oracle Cash Management

Sunday Oct 11, 2015

Clean Your Supply/Demand

So you noticed that there is inconsistent data in the Supply/Demand form (INVDVDSD) for a specific item/organization? No need to worry. We have some suggestions that may clear things up.

First, check out note, INVDVDSD - Troubleshooting Issues With The Inventory Supply/Demand Form (Doc ID 286755.1). Then download script 'INVDVDSD_data_check.sql' and run it in sqlplus for the item and organization.

After running 'INVDVDSD_data_check.sql', review the output for data corruption or issues for your specific item/organization. The script output will show different areas that that may need clean-up.

You can also further troubleshoot Supply/Demand by using note, Troubleshooting the Item Supply/Demand Form (Doc ID 404459.1).

As always, use Support tools and diagnostics to help keep you data sparkling clean.

Thursday Oct 08, 2015

OpenWorld sessions for Focus on Oracle EBS Support and Services!

Make sure you attend the Oracle OpenWorld sessions for the Focus on Oracle Support and Services for E-Business Suite!

We will have a huge Support presence at the event and will be engaged in breakout sessions, networking opportunities, and the Support Stars Bar—where customers can talk directly with our Oracle Support experts. Learn about the support best practices, proactive tools, and resources at these sessions.
Focus on Oracle Support and Services for E-Business Suite!

Tuesday Oct 06, 2015

Which Transactions Are Copied Via Fixed Assets Mass Copy?

Which transactions does Fixed Assets copy from the corporate book to the tax book via the Mass Copy process?  Which kinds of transactions do not get copied?  How can you determine which transactions were not copied using the warning messages found in the Mass Copy logfile? 

Let's take a sample message indicating that a transaction could not be copied using Mass Copy:

Asset number 123456
Transaction header id 789789
This adjustment cannot be mass copied.

Cause: Only cost adjustments, salvage value, production capacity or group asset changes can be copied.
Action: Manually adjust this asset in the Tax Book.

Use this data to review the transaction that is NOT Mass Copied from the corporate book.  Note that the transaction header id is used for the Reference Number.

  1.  Login to FA
  2.  Navigate to:  Inquiry > Transaction History
  3.  Select the corporate book from the LOV
  4.  Enter the transaction header id from the logfile into the Reference Number field
  5.  Click FIND

The form will show the transaction type that was not Mass Copied.
Click DETAILS and the Before and After data is shown for the transaction.

Book-specific changes are intentionally NOT Mass Copied such as depreciation method, life, prorate convention, etc.  These fields are not Mass Copied because it is expected functionality that the tax books can have depreciation different from the corporate book.

Refer to the Oracle Assets Users Guide
Chapter:  Tax Accounting > Tax Book Maintenance

So, what does get copied?

The following basic financial information comes from the corporate book:

  •  Cost
  •  Original Cost
  •  Units
  •  Date Placed in Service
  •  Capacity and unit of measure, for units of production assets
  •  Salvage Value, if you choose to Copy Salvage Value for the tax book in the Book Controls window

The remaining depreciation information comes from the default category information for your tax book according to the asset category and the date placed in service.

With credit to Kathleen Herd, Oracle Assets Support

Thursday Oct 01, 2015

EBS General Ledger - Accounting Hub Reporting Cloud Service

Oracle Accounting Hub Reporting Cloud Service provides excellent reporting and analytics capabilities along with real-time access to information and latest accounting numbers. Drilldown to EBS balances, journals and subledger transactions is also available. 

The integration between the Accounting Hub Reporting Cloud Service and E-Business Suite Release12 continuously streams balances from EBS,

  • providing immediate access to updated financial data
  • supporting quick business decisions
  • offering enhanced reporting options with minimal effort, cost or risks
EBS General Ledger setups are loaded automatically to the Accounting Hub Reporting Cloud Service:
  • charts of accounts
  • calendars
  • hierarchies
  • ledgers
  • balances
Sample financial reports are already available!  

We encourage you to benefit and improve your business with Oracle ERP Cloud Service.

Check this Whitepaper today! 

Accounting Hub Reporting Cloud Service for E-Business Suite Customers (Doc ID 2034564.1)
Oracle ERP Cloud Welcome Note (Doc ID 1499539.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



« November 2015