User is getting error "APP-SQLAP-97634" while validating the invoice (Doc ID 2218492.1)

Last updated on DECEMBER 29, 2016

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

1. DESCRIPTION OF THE LOSS OF FUNCTIONALITY
------------------------------------------------------
In Oracle Payables, Invoice is having 'Dist Acct Invalid' hold , cancellation was attempted on this invoice and when user try to validate the invoice ,  getting below error message :

ERROR
-------
 " APP-SQLAP-97634 : the invoice xxxxxxx has an accounting hold and is pending cancellation so you can no linger submit it for validation. To have the system automatically Validate the invoice and complete cancellation
Please either manually release the hold or correct the errors that caused the hold and then cancel the invoice ".


2. BUSINESS IMPACT
----------------------
Due to this issue, users cannot pay supplier on-time and won't able to close the period.


3. STEPS OR EVENTS THAT LEAD TO THE ISSUE OCCURRING
----------------------------------------------------------------
The issue can be reproduced at will with the following steps:

1. Using Payables Manager responsibility

2. Navigate to Invoices : Inquiry > Invoices

3. Query the invoice to and try to validate it


4. ENVIRONMENT IN WHICH ISSUE IS OBSERVED
---------------------------------------------------
Product: Oracle Payable
Release: 12.1.3
Database: No information provided because the issue is not database or platform specific.
Platform: Linux
Instances Affected: Test and Production
System Names: This information is not relevant for the resolution of the issue.
Affecting Certain Users? The issue is consistently observed with all the users.


5. EXPECTED OR ACCEPTABLE RESULT
-----------------------------------------
Able to Cancel or Validate the invoice


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms