Wednesday Jan 01, 2014

What Is So Special About The Payables #1 Document - The Master GDF Script?

So by now you know that our #1 document of 2013 was the Master Generic Data Fix script, otherwise known as the MGD.  If you are already familiar with our MGD then great, but if you aren't sure what it is or you are unclear on when and how you use this fantastic script, then read on...

What is the MGD?

Doc ID 1360390.1 - R12: Master GDF Diagnostic (MGD) to Validate Data Related to Invoices, Payments, Accounting, Suppliers and EBTax [VIDEO] was created because a significant amount of data corruption had been reported by customers and we needed a way to quickly identify all transactions that were affected so we could:

a ) fix the corrupt data

b) fix the code to prevent future corruption

Doc ID 1360390.1 also contains a link to watch the webcast video that fully explains the usage of this script and includes a demo of how it is used.  Just click on the video link as shown in the following screenshot:

This script may be safely run at any time.  It can be used in the following ways:

a) reactively - when you are experiencing errors when performing a particular action that is invoice, payment, or supplier related
b) proactively
- to scan all transactions in a date range or an operating unit and head off potential issues.  

The script will produce an HTML output of all known problems relating to the transactions you specify along with information on notes and/or data-fix patches which may already be available to resolve the data issues. 

No data is created, updated, or deleted by this script and it is fully supported by Oracle Development and Support.

You should always run this script prior to logging a Service Request when you suspect there is data corruption or if you simply want to proactively verify the data integrity of your transactions.

Want to give it a try?

1) Query Doc ID 1360390.1, and click the Download Now button to save the  Unzip this and you will see this contains three files:
a) ap_gdf_detect_pkg.sql: the package definition file 
b) single_trx.sql: This script can be used to submit the validation procedure for a single transaction.
c) date_range.sql: This script will submit the validation procedure for a range of dates within specified operating units
2) Run ap_gdf_detect_pkg.sql as the APPS user to create the package definition.

3) Run the appropriate SQL file to submit the detection procedure:
a) In order to validate a single invoice, payment, or supplier run single_trx.sql which will prompt for an invoice id, check id, and supplier id.  You must supply at least one of these values, but you can any combination of two, or even all three.
b) To validate all invoices, payments, or suppliers in a date range for specified operating units, run date_range.sql  This script will prompt you for your date range, operating unit (or operating units), and the type of transactions to be validated.  Dates for the date range must fall in open periods.  To indicate more than one operating unit, separate values with a comma.  If operating unit is left blank the process will run for all operating units (though this is generally not recommended for performance reasons).  The transaction type specified should be either INVOICE, PAYMENT, SUPPLIER, or ALL to validate all three types.
3) The detection procedure will create an output file of the format AP-GDF-<timestamp>.html  and will indicate the location of this file and the log file.   Review this output and follow the instructions highlighted to resolve your corruption issues.

What if you aren't technical?  

Great news, the script can also be installed by the DBA as a concurrent program as detailed in Doc ID 1361255.1 so that monthly usage is simplified and functional users can run and alert the DBA if they find a problem.  The output doesn't require any SQL knowledge as the script provides a nicely formatted HTML output, highlighting any issues that were detected, and points the user to the solution document needed to resolve each issue detected.

Simple!  What are you waiting for? 

Still got questions?  

Please let us know by updating the Master GDF Diagnostic Thread in the Payables Community.


Tuesday Dec 17, 2013

Payables Most Frequently Used Knowledge Content of 2013

So how was 2013 for you?  For the Payables Proactive team it was a busy year as we were working on all sorts of wonderful projects, trying to make life a little easier for you.  

Here’s a rundown of some of the major knowledge that we created or improved this year that has had the biggest impact on you.  You keep FINDING it, READING it and most importantly USING it to resolve your issues without the need to log a Service Request.

So what documents made it onto the 'Most Frequently Used Documents' list of 2013?  

The following list shows you the knowledge content that you, the reader, found in My Oracle Support over the last 12 months, ranked by the total number of hits.  Sorry, but there are no prizes for guessing which amazing script came in the #1 spot because, let's face it, that would just be far too easy...  

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

When to use it? Monthly to identify known data integrity issues within your Payables application and learn exactly how to fix those issues – all without the need for a service request.  

#2 - Information Center: Using Oracle Payables [Doc ID 1417577.2]

When to use it?  When you want to quickly see an overview of all our KM content for a particular functional area of the product such as EBTax, Workflow or Prepayments information.

#3 - R12.1: Payables Recommended Patch Collection (AP RPC), Sep 2013 [Doc ID 1397581.1]

When to use it?   This is a one time application which will provide you with all the important fixes since the release of 12.1.3.  Many of these fixes affect Critical Business Processes such as Period Close and are observed as reoccurring very often in the Installed Base. 

#4 - Information Center: Oracle Payables Accounting R12 [Doc ID 1476284.2]

When to use it?  This is a sub-document that can also be accessed from our #2 document, and the use of it would be in the same way, selecting the accounting tab from the Using Payables Information Center brings you directly to this document which highlights the accounting documents that are most useful to you.

#5 - Troubleshooting Assistant: R12 Payables Prepayments (Search Helper) [Doc ID 1559751.2]

When to use it?  Anytime you have a prepayment question or issue and you want to find the solution fast.  This interactive assistant will guide you through to the solutions that resolved issues for others customers experiencing the same symptoms.

#6 - Information Center: Oracle Internet Expenses [Doc ID 1381228.2]

When to use it?  Anytime you want to learn more about OIE, or troubleshoot an issue.  This index of content is invaluable for fnding your way around the OIE content quickly and easily.

#7 - Troubleshooting Assistant: R12 Oracle Payables (AP) Accounting [Doc ID 1573154.2]

When to use it?  Like in #5, troubleshooting assistants are always useful when you have a specific issue, you know the error message or the symptoms that cause the problem and you are trying to quickly find the common solutions for that specific issue.

#8 - R12: Information Center: Troubleshooting Payments to Suppliers and Other Creditors using Oracle Payables (AP) and Oracle Payments (IBY) [Doc ID 1383396.2]

When to use it?  This information center is your central point of resource for all things related to supplier payments.  

#9 - Information Center: Oracle Payables for Suppliers [Doc ID 1363041.2]

When to use it?  This is your central resource for payables supplier issues ranging from issues with employee suppliers to general setup and usage of suppliers. A great resource to use when you have questions or errors related to suppliers.  

#10 - Troubleshooting Assistant: R12 Suppliers (Search Helper) [Doc ID 1410773.2]

When to use it?  Whether you have issues with merging a supplier or you are unable to import or update a supplier, this troubleshooting assistant has your answer.  

Note: Please bear in mind that these might be the top 10 documents that you found when searching on MOS but this is dependent on the volume of incoming searches, so this list is missing some amazing articles in the smaller functional areas.  

For a full listing of all the available Assistants (Search Helpers) please review EBS: Assistant (Search Helper) Index [Doc ID 1501724.1]

For a full listing of all the available Information Centers please review E-Business Suite Product Information Center Index [Doc ID 444.2]

Happy Holidays!


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