R12: Unable to Enter Price Correction when Query On Invoice Number FRM-40350 (Doc ID 1306865.1)

Last updated on NOVEMBER 06, 2014

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

-- Problem Description
When attempting to to perform Price correction in AP against a PO matched invoice, corresponding base invoice is not available in find documents for correction window during processing of credit memo and the following error occurs.

FRM-40350 : Query caused no records to be retrieved

If the user searches on amount instead of by invoice number, then the correct record is returned.

-- Steps to Reproduce
Create PO by a contingent worker
Create invoice and match to the PO, validate and account
Create CM header
Match action : Purchase Order
Click on correction button
Search for invoice using Invoice Number
Error
Search for invoice using Amount and record is returned

-- Business Impact
Users cannot perform price corrections using invoice number

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