My Oracle Support Banner

Using F11 Re-query Function Using GL Date Causes Error On AP Invoice Form (Doc ID 2426838.1)

Last updated on JULY 24, 2018

Applies to:

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

Symptoms

1. DESCRIPTION OF THE LOSS OF FUNCTIONALITY
------------------------------------------------------
In Oracle Payables, when a user attempts to re-query invoice with the F11 using the invoice workbench form (APXINWKB.fmb) the following error occurs:

ERROR
-------
ORA-01403 no data found


2. BUSINESS IMPACT
----------------------
Due to this issue, users cannot pay supplier on-time. Late payments affect the payment terms established by suppliers and consequently disrupts the business continuity of the organization. Moreover, the current payables accounting period cannot be closed. Problematic transactions will have to be swept to the following period, which is not in agreement with the date in which the transactions occurred.


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. Enter search criteria (Invoice amount and GL Date using wildcard %JAN 18%

4. Search invoice

5. Invoice is displayed.

6. Click F11 to enter query mode.

7. Error is displayed.


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 requery invoice without receiving the error.


6. WHAT IS WORKING
-----------------------
This information is not required for further clarification.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.