Wednesday Jan 22, 2014

R12 Master Generic Data Fix Diagnostic for Purchase Orders and Requisitions

Do you wish you could proactively check your Purchasing documents for known data integrity issues or is there a Purchasing document you are having problems with?

Well, visit Doc ID1474734.1 for the R12 Master Generic Data Fix Diagnostic for Purchase Orders and Requisitions.  Running this one script identifies known data integrity issues within the Purchasing application (for example errors with cancel and close and unit of measure issues) where there are often generic data fixes (GDFs) already available.  The script will produce an HTML output report of all known problems relating to the purchasing transactions created in the specified date range, along with information on notes and/or data-fix patches which are already be available to resolve the data issues.

The following data checks are included:
  • Document type records with null ORG ID.
  • Synchronization issues with archive tables.
  • Quantity billed/amount billed mismatch in purchase order shipments and distributions.
  • Purchase orders with a mismatch of quantity billed or amount billed between the shipment or distribution and the invoice distribution.
  • Purchase order shipments eligible to be closed.
  • Outstanding supply/demand for non-existing or cancelled requisition lines.
  • Fully received internal requisitions continue to show as pending supply.
  • Approved requisitions not available in Autocreate form after associated purchase order is deleted.
  • Purchase orders with unit of measure (UOM) mismatch between Lines and Shipments.
  • Canceled purchase orders in Requires Reapproval status.
  • Tax exception 023 (ORA-00001: unique constraint (ZX.ZX_LINES_DET_FACTORS_U1) violated) when approving.
  • Purchase order with authorization_status = 'REQUIRES_REAPPROVAL' rather than 'REQUIRES REAPPROVAL'.
  • Foreign currency autocreated purchase orders have inverse rate.
  • Purchase order ship-to organization does not match distribution deliver-to organization.
  • Requisition distribution line associated to multiple PO distribution lines.
Don’t delay make Doc ID1474734.1 part of your routine Procurement procedures today!

Wednesday Jul 10, 2013

Announcing India Localizations Generic Data Fix

Do you wish you could proactively check your India Localizations data for known data integrity issues?  Take a look at  Doc ID 1542754.1 R12: India Localization Applications Diagnostics and General data Fix Validation (GDF).

Run the Master GDF script prior to logging a Service Request when you suspect data corruption issues in your transaction. The script will validate the data and recommend notes and/or data fix patches which may already be available to resolve the issues with receipts, Receivables invoices, Payables invoices or sales orders.

Wednesday Oct 03, 2012

Announcing Oracle Receivables Generic Data Fix (GDF) for Refunds

Here's the first of what will be a series of Generic Data Fixes (GDF) to be released by Receivables Development.

Generic Data Fix (GDF) are created by development to fix data issues caused by bugs/issues in the application code.  Other Generic Data Fix benefits/features include:

  • Developed for bugs that can cause data issues.
  • Provides a SELECT script that uses an identification/signature query to identify and report all data affected by issue/condition caused by a bug.
  • Allow customers to view and modify what will be fixed.
  • Provides a separate FIX script to fix the data reported by the SELECT script.
  • The FIX script creates backup tables for the data that is fixed/updated.
  • Available on My Oracle Support for download

In Release 12, when creating a refund by either of the following methods:

  • Applied a receipt to the Refund activity - which creates an Invoice in Payables
  • Or you went directly into Payables to create a refund for an open Credit Memo in Receivables

The Invoice in Payables that is associated to the refund is cancelled, the corresponding refund application or credit memo in Receivables is not properly re-instated. For the receipt application, it still remains applied to the Refund whereas this should be automatically unapplied. For the credit memo, it stays closed instead of getting re-opened.

Doc ID 761993.1 includes the patch to make sure this doesn’t happen in the future as well as a GDF script to fix the current data (Script name: ar_std_refund_unapp.sql).  Download the script and run in READ_ONLY_MODE to identify 'refund' applications with this problem.

Stay tuned for more GDF scripts coming soon...

Thursday Jun 02, 2011

Self Service for Payables via Generic Data Fixes (GDFs) and Patching

ADVISOR WEBCAST: EBS Financials: Self Service for Payables via Generic Data Fixes (GDFs) and Patching (Second Session)
PRODUCT FAMILY: E-Business Suites, Financials, Payables

June 16, 2011 at 7 pm PT, 8 pm MT, 10 pm ET, 12:00 Sydney

There are Generic Data Fix patches and code fix patches available for the Payables product that customers can use to fix existing errors or prevent errors from ever occurring. These patches are available for customer download on My Oracle Support and enable customers to truly self service. During this session we will discuss what Generic Data Fix patches are, how to find them, how to detect when they are needed, and how to apply and run them. We will also discuss the importance of staying current on patching and how to find the patches you need for Payables. And we will briefly review how Oracle Diagnostics should be used in the event a Service Request needs to be logged.

TOPICS WILL INCLUDE:
  • How to identify and resolve known data issues pro-actively
  • Avoid delay in period close by pro-actively identifying and resolving such issues

A short, live demonstration (only if applicable) and question and answer period will be included. Oracle Advisor Webcasts are dedicated to building your awareness around our products and services. This session does not replace offerings from Oracle Global Support Services.

Click here to register for this session

-------------------------------------------------------------------------------------------------------------

The above webcast is a service of the E-Business Suite Communities in My Oracle Support.

For more information on other webcasts, please reference the Oracle Advisor Webcast Schedule.

Click here to visit the E-Business Communities in My Oracle Support

Note that all links require access to My Oracle Support.


Self Service for Payables via Generic Data Fixes (GDFs) and Patching

ADVISOR WEBCAST: EBS Financials: Self Service for Payables via Generic Data Fixes (GDFs) and Patching
PRODUCT FAMILY: E-Business Suites, Financials, Payables

June 16, 2011 at 7 am PT, 8 am MT, 10 am ET, 15:00 London

There are Generic Data Fix patches and code fix patches available for the Payables product that customers can use to fix existing errors or prevent errors from ever occurring. These patches are available for customer download on My Oracle Support and enable customers to truly self service. During this session we will discuss what Generic Data Fix patches are, how to find them, how to detect when they are needed, and how to apply and run them. We will also discuss the importance of staying current on patching and how to find the patches you need for Payables. And we will briefly review how Oracle Diagnostics should be used in the event a Service Request needs to be logged.

TOPICS WILL INCLUDE:
  • How to identify and resolve known data issues pro-actively
  • Avoid delay in period close by pro-actively identifying and resolving such issues

A short, live demonstration (only if applicable) and question and answer period will be included. Oracle Advisor Webcasts are dedicated to building your awareness around our products and services. This session does not replace offerings from Oracle Global Support Services.

Click here to register for this session

-------------------------------------------------------------------------------------------------------------

The above webcast is a service of the E-Business Suite Communities in My Oracle Support.

For more information on other webcasts, please reference the Oracle Advisor Webcast Schedule.

Click here to visit the E-Business Communities in My Oracle Support

Note that all links require access to My Oracle Support.



About

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

Twitter

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
5
6
12
13
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today