Monday Nov 24, 2014

How to Create Custom Invoice Charges Matching Validations for LCM

In R12.2.4 Landed Cost Management and Oracle Payables development teams are delivering Invoice Matching Enhancements which will not only expose the LCM information at the time of invoice matching but they are also creating hooks for users to write their own code for validating from a LCM perspective.

A white paper has been written to help the technical teams understand how validations could be written, including sample code.

The following are supported by those public APIs:

  • Validate a match to an individual receipt line, under LCM perspective, and decide if the match should be allowed or not, depending on the validation results
  • Validate the whole invoice, under LCM perspective, and decide if the invoice should be put on hold or not, depending on the validation results

For more information please review How to Create Custom Invoice Charges Matching Validations for LCM (Doc ID 1678192.1)


Friday Sep 05, 2014

Invoice Validation Parallel Processing New Functionality Available

What has changed?

The Invoice Validation concurrent program is now equipped to spawn multiple child requests based on the Purchase Order matched invoice load and the newly seeded profile "AP:Maximum Invoice Validation Child Requests".

The user continues to submit a single Invoice validation program with his/her preferred parameters but internally the program groups the invoices matched to same Purchase Orders and ensures that each such group is processed by a single child request.

Whereas for invoices that are not matched to any Purchase Orders, the system distributes these invoices equally amongst the maximum number of child requests spawned (as per the value set by the user in the aforementioned profile).

Why the change?

1) The current invoice validation concurrent program was not scaling up for high volume of invoices.

2) If multiple requests of the invoice validation concurrent program are submitted and invoices matched to the same Purchase Orders are processed by two or more requests then there are possibilities of lock contention errors on PO_HEADERS_ALL in any of the requests that concurrently attempts to update the PO object.

3) To avoid conflicts, user had to wisely select the parameters at the time of submitting the concurrent program or have conflict domains defined that constrained the program to execute serially.

4) Submitting multiple requests of the program causes an overhead of reviewing multiple log files and outputs.

More Information

R12: New Functionality Invoice Validation Parallel Processing (Doc ID 1917614.1)

If you have any questions on this new functionality please use the community thread


Tuesday Jul 01, 2014

New Troubleshooting Help for Holds Applied at Invoice Validation

Understanding why holds are applied at Invoice Validation time has always posed challenges for customers.  Now there is new help available in the form of a Troubleshooting Causes and Solutions document:

R12: Main Invoice Holds placed during Invoice Validation process: troubleshooting and solution (Doc ID 1682809.1)

Use this document to find causes and solutions for the following common Invoice Holds:

  • CANT FUNDS CHECK
  • INSUFFICIENT FUNDS
  • ENCUMBRANCE ACCTG FAIL
  • DIST ACCT INVALID
  • DIST VARIANCE
  • FINAL MATCHING 
  • TAX AMOUNT RANGE
  • MAX TOTAL AMOUNT
Please provide feedback on this document and let us know if it helped you resolve your issue by posting in the community post on this topic.

Thursday Feb 20, 2014

Troubleshooting Assistant Now Available for Invoice Validation!

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! 

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
« September 2015
SunMonTueWedThuFriSat
  
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today