ADVISOR WEBCAST: Understanding Trading Community Architecture (TCA) Customer Entities & User Interface

Date:  March 26, 2014 at 9:30 am ET, 6:30 am PT, 1:30 pm GMT

This one-hour session is recommended for technical and functional users who use the Customer Standard User Interface in Release 12. Join us to gain an understanding of the Trading Community Architecture (TCA) Customer Standard function for maintaining customer data including party relationships, customers, organizations, and locations that belong to the commercial community in the TCA Registry.

Topics will include:

• Main entities in the Customer Data Model
• Customer Standard User Interface (UI) HTML pages
• Data Quality Management (DQM) functionality in the Customer UI
• Multiple Organization Access Control (MOAC) in the Customer Standard UI
• Trading Community Architecture (TCA) diagnostic scripts

For more details and how to register see Doc ID 1612925.1.

The Procurement Development team is pleased to announce the first round of 'PLANNED' Enhancement Requests (ERs) for inclusion in the Procurement Suite of Applications.  Development selected these ERs based on Community Voting, number of Customers attached to the ER as a result of Service Requests (SRs) logged, and feasibility for implementation. The SRs were used in this selection process since this ER Community is only 4 months new.  Future ER selection will be based solely on the 'Voting' contained within this community space. 

To see a list of these ERs and for more information : click here

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

Webcast: Reconciliation of Receiving Inspection Account

Date: April 15, 2014 at 3:00 pm, GMT Summer Time (London, GMT+01:00) / 10:00 am, Eastern Daylight Time (New York, GMT-04:00) / 7:30 pm, India Time (Mumbai, GMT+05:30) / 4:00 pm, Egypt Time (Cairo, GMT+02:00)

The one-hour session is recommended for technical and functional users who wish to know about Receiving Inspection Account reconciliation process. This webcast discusses the best practices to be followed for reconciling and troubleshooting steps in case of any data discrepancies.

Topics will include:

• Receiving Inspection account reconciliation process
• Troubleshooting steps
• Demonstration

Don’t delay sign up today!

Details and Registration: Doc ID 1633070.1

Three new Order Management Diagnostic Tests available for 12.1.1+ via Patch 18013753 (Please visit E-Business Patching (MOSC) to request the initial password to download).

The Apps Check Diagnostic is now available via the Oracle Diagnostic Framework.  This is the same as what is executed from the Concurrent Program.  Executing the Diagnostic Test via the Diagnostic Framework 'Applications Diagnostics > Diagnose' offers a user friendly execution experience and HTML output that is validated and can be directly uploaded to a Service Request.  Please see Doc ID 1631911.1 for details.

Duplicate Lines From OE Drop Ship Sources, is new to the Diagnostic Framework.  This Diagnostic Test selects all duplicate lines from OE Drop Ship sources table.  Please see Doc ID 1632022.1 for details.

RMA Lines Stuck At Awaiting Return Or Disposition, is new to the Diagnostic Framework.  This Diagnostic Test selects all the RMA lines that are stuck at Awaiting Return or Awaiting Return Disposition status, even after the order lines had been fully received and fully or partially delivered.  Please see Doc ID 1632024.1 for details.

The new 12.1.3 Procurement Rollup Patch (RUP) 18120913:R12.PRC_PF.B offers so much more than just a cumulative collection of bug fixes.   Here’s just a few reasons you should apply this patch:

•    Extensive improvements to the Buyer Work Center (BWC) searching, preferences and Blanket Purchase Agreement (BPA) Lead Time are included
•    Enhancements to the Purchasing Document Open Interface (PDOI) in the area of document creation and referencing, Advance Pricing and more
•    Includes all fixes for iSupplier Portal, Sourcing & Supplier Lifecycle Management (SLM) Rollup Patch :17525552:R12.PRC_PF.B detailed in Note 1591198.1
•    Includes all the fixes for the Purchasing Approvals Rollup Patch : 16932593:R12.PO.B which includes AME and is detailed in Note 1567464.1

For all the information you need to know about the new RUP see Doc ID 1468883.1.  Now I know RUPs contain several hundred files, but the impact on your system is most likely far less. Patches contain hard-prerequisites that are intended to make a patch work on a very low code baseline.  So in this note there is a link to the Patch Wizard which will provide a detailed impact analysis for the RUP. The analysis gives you an idea of how the patch application will impact your environment.

So don’t delay apply Patch 18120913:R12.PRC_PF.B Today!

ADVISOR WEBCAST: Understanding & Troubleshooting Invoices With Rules & Revenue Recognition

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

This one-hour session is recommended for technical and functional users who would like to understand how invoices with rules and revenue recognition work. In addition to providing an overview of invoicing and accounting rules and revenue recognition, we will review underlying table data, revenue rates, deferred revenue, and provide troubleshooting tips.

Topics will include:

• Overview of Invoicing and Accounting Rules
• Underlying table information for Invoicing and Accounting Rules
• Daily Revenue Rate for All Period and Partial Period
• Deferred Revenue
• Underlying table information for Revenue Recognition
• Illustration of impact of running Revenue Recognition
• Troubleshooting Tips

For more details and how to register see Doc ID 1612600.1.

Cash Management SR Options Have Changed!

You might recall in an earlier blog entry that we changed the options you have when logging a Payables SR in MyOracleSupport to try and help you get your SRs to the right engineers - first time.  We hope you are finding the new options beneficial and getting your issues resolved faster.  

The good news is that we have now extended this change to include Cash Management SRs.

Next time you create an SR for Cash Management you will notice different options available to you to ensure you get shown the most appropriate content for your problem area.  If the recommended solutions don't resolve your issue, then we ensure we ask relevant questions that will help the support engineer get to the root of your issue faster. We have also revised the diagnotics that we will request from you to further aid the resolution of your issue.

The new options available are structured as follows:

Patch Application Issues For E-Business Patching Community
Reconciliation/Clearing and Accounting	Receipt Issues
	Payment Issues
	Accounting Issues
	Reconciliation and Clearing
Bank Statement	Accounting
	Load/Import
	Bank Balances
Internal Bank Accounts
Bank Account Transactions	Bank Account Transfers
	Sweep
	Cashflows
Report Issues	GL Reconciliation Report
	Other Reports
Cash Pools/Forecasting/Positioning	Cash Pools
	Cash Forecasting
	Cash Positioning
Localization Issues	Oracle Financials for EMEA
	Oracle Financials for the Americas
	Oracle Financials for Asia/Pacific
	Oracle Financials for India
Performance Issues
Other Cash Management Issues

We hope these new options are useful and help you log your problem with the correct team - the first time.

Let us know what other topics you want to hear about on the Payables Blog by updating the thread on the Payables Community that was created for your feedback.  

Working together, Oracle Proactive Support and Demantra Product Management Organization deliver thirteen excellent whitepapers and a new sizer announcement!   These white papers touch on some difficult functional and technical areas: New Product Introduction (NPI), Business Logic Engine (BLE), Business Application Language (BAL) , modeling techniques, Application Programming Interface (API), Configure to Order (CTO) integration, plus more!   Take a look, you might find some valuable ideas.  Don't forget the Sizer Announcement at the bottom of the article!

• Configuring an Audit Log in Demantra Using Database Triggers Doc ID 1629974.1
• Demantra Configure to Order (CTO) Integration EBS Model BOM Example How To Doc ID 1630040.1
• Demantra APIs to Facilitate Integration with External - Third Party Source Systems Doc ID 1630505.1
• Demantra Indirect Modeling, Lift Decomposition, Definitions and Issues Doc ID 1630545.1
• Demantra Indirect Customer Modeling, Customer Scenarios, Modeling Approaches Doc ID 1630604.1
• Demantra PTP – Shipment vs. Consumption Forecasting Doc ID 1630628.1
• Demantra Database Best Practices Doc ID 1627586.1
• Demantra Customizations and BAL Upgrade Doc ID 1627590.1
• Demantra New Product Introduction (NPI) - Pooled Time Series (PTS) Doc ID 1627623.1
• Demantra Platform or Application Upgrading - Program Manager Recommendations Doc ID 1627664.1
• Demantra How Caching can be Leveraged to Potentially Reduce Performance Doc ID 1627652.1
• Level Member Caching Purpose Performance Guidance Doc ID 1627689.1
• Demantra BLE Mechanism Explanation and Details Doc ID 1627716.1

Announcement:
Replacement of APS Sizer with Value Chain Planning Reference Sizing Tool (RAS) Doc ID 1630684.1

Our blog entry CRM: Payments - ISO Direct Debit Consolidated Patch back in November told you about EPA ISO Direct Debit Patch 17016197:R12.IBY.B.  This patch has been superseded and replaced with SEPA ISO Direct Debit Patch 18053306:R12.IBY.B.  Any customers that have previously applied Patch 17016197:R12.IBY.B should ensure they apply the replacement Patch 18053306:R12.IBY.B.

For details about the patch, including the new and changed features see Doc ID 1600137.1: R12: SEPA White Paper - ISO20022 Direct Debit support in Oracle EBS.

A useful resource an all things SEPA is the SEPA Information Center:  Doc ID 1594441.2: R11i/12: AP/AR/IBY: Setting Up, Using, and Troubleshooting SEPA Payments in Oracle.

We have created a new Troublehshooting Assistant for Oracle Fixed Assets for the Create Mass Additions process.  This process (also known by its short name in Assets as FAMACR and in Payables as APMACR) is used to bring addition and adjustment lines from Accounts Payable into Fixed Assets via the mass additions interface.  There have been a number of changes to the process and enhancements made in recent releases.

Troubleshooting Assistants are resources created to help you find a resolution to an issue by guiding you from the problem, through the possible scenarios, and to the proposed solution.  These troubleshooting assistant types of resources were formerly called Search Helpers.  Called by either name, they are designed to provide a path through various topics related to a process and, based on the selections you make, provide suggested solutions. 

The troubleshooting assistant for create mass additions includes solutions for these issues, and more: 

• Addition lines that were not transferred from Payables to Assets
• Addition lines that were transferred into Assets but should not have been 
• Merging of addition lines 
• Transferring freight, tax or miscellaneous lines
• ORA-30926 errors
• Performance issues

You can access this troubleshooting assistant in Troubleshooting Assistant: Create Mass Additions From Payables (AP) to Fixed Assets (FA) (Doc ID 1609542.2)

Oracle eBusiness Suite OTM Analyzer Version 1.04 is now available!

This version of Oracle Transportation Management's analyzer includes new features such as collapsible sections, file name includes time, subsections with Show More are limited to 200 rows and improved formatting.

There are four new sections: Agent Health Checks, System Health Checks, System Transaction Checks and Process Control Request/History Check. Each contain several subsections of information with warnings.

Download the latest version from OTM Analyzer script for Analysis and Performance Monitoring, Doc ID 1579683.1.

The Demantra Setup and Performance Analyzer is a Self-Service Health-Check script which reviews the overall footprint, analyzes the current configurations and settings for the environment providing feedback and recommendations on Best Practices.  This is a non-invasive script which provides recommended actions to be performed on the instance it was run on.  For production instances, always apply any changes to a recent clone to ensure an expected outcome.  

Benefits:

• Immediate Analysis and Output of your Demantra Environment
• Reveals Current Environment
• Delivers Known Recommendations and Solutions
• Perform Sanity Checks for Known Issues
• Easy to add Tool for regular Maintenance
• Execute Analysis anytime to compare current environment 
  

Audience:

• DBA's / System Administrator's should run the script and review the output
• Output usually will be reviewed by technical application DBA or super user
• This script was designed for 7.3.1 and later.

Where to Run the Script & How to fix Items Identified:

You may run the script on a Production environment as it's non-invasive.  We recommend fixing items identified from the output first in a clone of production to test/verify the expected outcome.  Visit Doc ID 1618885.1 to download the script and view a complete output example. 

Proactive Support has created another great tool for you to use when facing Invoice Validation issues!

There are  many Troubleshooting Assistants available to help customers find solutions to their issues faster but we have just added another assistant for Invoice Validation because customers continue to have problems in this area and we wanted a quick way to help them find their answers.

Check out the new Troubleshooting Assistant: Oracle Payables (AP) Invoice Validation (Doc ID 1616563.2).

You will also see this tool when raising an SR for validation issues and you should defintely give it a try as it's been created from common issues and takes you directly to the known solutions.

You can interact with the tool to locate specific common error messages, review by symptoms or dig right into the issues we are aware of with the online validation or batch processing sections.  There is even some EBTax common problems included.

We also address corruption in the assistant, because often corruption can be the cause of your problem.  Why waste time trying to figure out what's wrong when you can run a simple request and find out?  

R12: Master GDF Diagnostic (MGD) to Validate Data Related to Invoices, Payments, Accounting, Suppliers and EBTax [VIDEO] (Doc ID 1360390.1) 

The MGD (Master Generic Data Fix) concurrent request can be ran for a date range or for a single transaction and the output will tell you exactly what is wrong with that transaction and tell you what you need to do to fix it. This is the reason why under the data corruption topic we refer to the MGD as your solution!  

It should ALWAYS be the first thing you check any time you have a payables issue so if you aren't aware of it, please read up on Payables #1 problem solving document or watch the video and get your data corruption issues fixed and prevent those headaches at month end.

References

EBS: Assistant (Search Helper) Index (Doc ID 1501724.1) 

So next time you have an Invoice Validation problem give the Troubleshooting Assistant a try and you might be surprised how easy it was to resolve!