Previous Announcement

In September of 2014 we announced the release of an important new enhancement in Oracle Payables that would allow you to transparently upgrade upstream 11i transactions from periods which had not been upgraded for Subledger Accounting (SLA), and which would negatively affect the accounting of dependent downstream transactions--without needing to apply the SLA Hot Patch or run the SLA: Upgrade Historical Subledger Transaction Accounting program.

The details and important benefits of that critical release and how it works can be found in detail in this blog post from back in Nov-14.

The only limitation to the functionality released back then was that it was only available when accounting transactions in "Online Mode". Now we are happy to announce that the second phase of this enhancement is also available.

Release of Phase 2

On 06-Feb-2015, the "Batch Mode" version of this enhancement was released via patch 20427746.  This patch introduces an entirely new concurrent process: "Payables Upgrade SLA Distributions for Historical Referenced Transactions". This process should be run in tandem with the "Create Accounting" program. It can be run independently prior to running "Create Accounting", or they can be run together as a request set.

The parameters of the new program are similar to those used by the "Create Accounting" process to identify unaccounted events to process.

•  Ledger
•  Process Category
•  Start Date
•  End Date
•  Batch Size

When run, the new program will identify all of the historical upstream transactions which would affect your unaccounted events, and upgrade them on the fly as required to prevent any errors when the "Create Accounting" program subsequently runs.

The original note describing the online version of the enhancement "R12: Important Enhancement ON-THE-FLY Upgrade of Historical SLA Distributions" (Doc ID 1938253.1) has been updated to provide additional information about the batch mode version of this enhancement.

If you have any questions or comments on this new functionality please post in the dedicated Payables Community thread. 

Oracle E-Business Suite (EBS) Financials Development has just released February 2015 Recommended Patch Collections (RPCs) for the following products:

• Cash Management
• Collections
• E-Business Tax & E-Business Tax Reporting Ledger
• Financials Common Modules
• Financials for India
• Fixed Assets
• General Ledger & FSG Drill Down
• Internet Expenses
• iReceivables
• Loans
• Payables
• Core, Non-Federal
• Core, Federal
• iSupplier
• Workflow & Pcard
• Payments
• Receivables
• Sub-Ledger Accounting
• Treasury   
  

For details and the complete list of available RPCs for Oracle EBS Financials, please see Doc ID 954704.1, EBS: R12.1 Oracle Financials Recommended Patch Collection (RPC). 

Webcast: Oracle Time and Labor (OTL) Timecard Layout Configuration

Date: February 25, 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 OTL Webcast provides you with general guidance related to timecard layout customization with detailed examples from some of Oracle Support’s finest HCM support analysts. This one-hour advisor webcast is recommended for technical users, functional users and system administrators who are working in Oracle Time and Labor.

Examples:
1. How to add new LOV field to Payroll Timecard
2. How to Remove a Custom/Seeded Field from the Timecard
3. How to add new Choice List filed to Payroll Timecard

Registration: Interested in attending? Visit the My Oracle Support HCM Webcast Note: 1455851.1 to sign up for this webcast.

View the Advisor Webcasts: Current Schedule and Archived Recordings here.

Changes to quantity and dates on an Internal Sales Order are allowed in 12.1.1+. These changes are automatically propagated to the corresponding Internal Requisition.

Similarly, cancellations on Internal Sales Orders are propagated to the corresponding Internal Requisition and priorities are propagated from Internal Requisition to Internal Sales Orders.

You can also assign different order types to an Internal Sales Order, while creating it from an Internal Requisition.  You can also leverage the Defaulting Rules of Order management to default a suitable Order Type, according to your business process.

For a complete detailed flow from setup to process, review New Features 12.1.1 Internal Requisition Internal Sales Order Change Management, Doc ID 854051.1.

Webcast: Setup and Integration of Work in Process with Oracle Quality

Date: February 25, 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 advisor webcast is recommended for technical users, functional users, system administrators, database administrators who want to learn more about the setup and integration of Oracle Work In Process and Oracle Quality. During this one hour session you will create a collection plan, enable it for move transactions, create a discrete job, and perform the move transaction for the job by entering Quality results, reviewing the Quality results, Closing the work order and reviewing the material transactions. The summary will include additional resources related to this topic.

Registration: Webcast: Setup and Integration of Work in Process with Oracle Quality

View the Advisor Webcasts: Current Schedule and Archived Recordings here.

The new Shipping Execution Analyzer has been released to assist you with errors in the Shipping Execution application!  It is a 'Health Check' script which you can proactively use at any time to review the data relating to Shipping, including :

• Trips
• Trip Stops
• Deliveries and Assignments
• Delivery Details
• Freight Setup
• As well as lists Open Inventory Periods & WMS/OPM Enabled Warehouses

The script may be run safely at any time.   No data is created, updated, or deleted by this script.

To download the script, go to R12: Shipping Execution (WSH) Analyzer Diagnostic Script, Doc ID 1947935.1.  To see what others are saying about the script or to add a comment / request on the script, go to its' community thread. 

Check out this upcoming Advisor Webcast for Oracle Time and Labor!

ADVISOR WEBCAST:  OTL Timecard Layout Configuration

Wednesday, February 25, 2015 - 8:00 am PT, 4:00 pm GMT Time (London, GMT), 9:30 pm India Time (Mumbai)

This OTL Timecard Layout Configuration Webcast provides you with general guidance related to Timecard Layout Customization with detailed examples.  This one-hour advisor webcast is recommended for technical users, functional users and system administrators who are working in Oracle Time and Labor.

Topics include:
OTL Timecard Layout Configuration
What can be customized in a Timecard Layout
Examples:
      1. How to add new LOV field to Payroll Timecard
      2. How to Remove a Custom/Seeded Field from the Timecard
      3. How to add new Choice List filed to Payroll Timecard

For Registration information and to view all upcoming and archived Advisor Webcasts, go to the My Oracle Support Note 740966.1.

 

Webcast: How to Process CTO Bills with Warning: The Configured Bills will be Created with Dropped Components

Date: February 18th, 2015 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 5:00 pm CET, 9:30pm IST

This presentation demonstrates how and why the warning message "The configured bill will be created with dropped components" is displayed when configuring an ATO or PTO model in Order Management. A script is provided to help determine the dropped component and its parent bill. In addition, two workarounds are outlined in the event the component was dropped unintentionally.

Topics will include:

• A script will be provided to help determine the dropped component and its parent bill
  
• Two workarounds are outlined in the event the component is dropped unintentionally
• Tips and Troubleshooting

Details & Registration: Doc ID 1290983.1

Webcast: Demystifying Service Items Selling in Order Management

Date: February 17, 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 advisor webcast is recommended for technical users, functional users, system administrators, Database Administrators, who would want to know more about various options available for selling service items from order management including Release 12.2 enhancements.

Registration: Webcast: Demystifying Service Items Selling in Order Management

View the Advisor Webcasts: Current Schedule and Archived Recordings here.

Date: February 19, 2015 at 11:00 am ET, 8:00 am PT, 4:00 pm GMT, 9:30 pm, India (Mumbai)

This one-hour Advisor Webcast is recommended for Receivables users who want to learn more about Aging and Aging Reports in Release 12. How have Aging Reports changed from previous releases? How do they fit into Receivables period close activities? What tables are involved? We will answer these questions and more!

Topics will include:

• Purpose of Aging Reports
• Types of Aging Reports
• What transactions appear on various Aging Reports
• How data flows through to Aging Reports

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast On 19-Feb-15: Everything You Need To Know About Receivables Aging Reports in Release 12

It's a beautiful day. Not a cloud in the sky. It's warm and sunny and everything's right with the world. You leisurely decide to run your Cycle Count Listing Report and oddly enough, the sky starts to darken. Storm clouds gather. The temperature drops. Winds start to blow and...NO DATA FOUND! Nooooo...not the dreaded 'No data Found!' You have an inventory item you know has a scheduled date for today. How can there be no cycle count entry! You feel like the porch light is on but no one is home. Is there a logfile, report, or sql query that can be used to resolve this issue? You wonder where can you find items scheduled for today? How many times was this tested to see if the item should be counted? Are the logfiles annotated? The Inventory Blog Team answers your questions with a yes, Yes, and again, YES! We have the MOS note for you, Investigating Cycle Counting Scheduling Issues (Doc ID 1912738.1). Note 1912738.1 provides information like the constraints placed on creating cycle count entries.



Use the video demonstrations, presentations, and sql scripts in troubleshooting Note 1912738.1, to once again turn those grey skies blue, in your cycle counting day!

Now that the Approvals Analyzer (Doc ID 1525670.1) is being requested on many Procurement Approval Service Requests and we have a new version, some client have reported that they are seeing errors like one of the following:

ORACLE error 6550 in FDPSTP Cause: FDPSTP failed due to ORA-06550: line 1, column 7: PLS-00201: identifier 'PO_APPRVL_ANALYZER_PKG.MAIN_CP' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

ERROR at line 27: ORA-06550: line 27, column 3: PLS-00201: identifier 'PO_APPRVL_ANALYZER _PKG.MAIN_SINGLE' must be declared ORA-06550: line 27, column 3: PL/SQL: Statement ignore

FDPSTP failed due to ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'MAIN_CP' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

The errors above simply mean that the concurrent program definition and Analyzer code are not in sync.

To resolve this error merely download and install the current version po_approval_analyzer.sql from the 'Download Now' button in .(Doc ID 1525670.1). Load the latest version of the concurrent program definition using podiagaa.ldt, then rerun the concurrent program.  Issue resolved!

And while we are talking about the Approval Analyzer remember to provide the correct document type when running it. Take a careful look at the parameters that return in the list of values after choosing the Single Mode.  It must match your document!

If you forget to choose the correct Document Type you will find errors in the output like the following:

For additional questions or comments on the Approval Analyzer click here.

Get 2015 off to a spectacular start by making sure your system is patched with the latest Critical Patch Updates.

• Learn which patches address security vulnerabilities in Oracle E-Business Suite Releases 11i and 12 (12.2, 12.1, and 12.0).  

• Find out which patches are necessary in order to run other Oracle Products alongside Oracle E-Business Suite.

Go to the following document for more information:

Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (January 2015) DocID 1954250.1

Do you need some assistance when loading counter readings into Install Base?

We have recently updated the following document to provide you with instructions on how to complete the process.

How to Upload Meter Readings Using the Install Base - Counter Readings Open Interface (CSICTRML) Doc ID 1909396.1

This also has an example template on how to populate mandatory fields in the CSI_CTR_READINGS_INTERFACE table.

The following fields are mandatory and must be populated:

• counter_interface_id
• batch_name
• source_transaction_date
• process_status
• counter_id
• last_update_date
• last_updated_by
• creation_date
• created_by
• source_transaction_type_id
• counter_name

Once you have loaded the data into the interface table run the Install Base - Counter Readings Open Interface program.

Note: DO NOT accept the default date ranges.  By default they are set to the same value therefore will not find any records.

If you require further assistance on this topic, please log a Service Request with Oracle Global Support.