R11.5: AP: Matching Invoice to PO Errors FRM-40505: ORACLE error: unable to perform query (Doc ID 271967.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle Payables - Version 11.5.10.0 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

The form APXPMTCH.fmb generated runtime error "FRM-40505: ORACLE error: unable to perform query."

FRM-40505: ORACLE error: unable to perform query when matching Invoice to PO

1. Enter standard Purchase Order for Supplier and approve it.
2. Enter standard invoice for the same supplier, click on Match button.
In Match to Purchase Order Form enter Purchase Order number, click on Find button.
Run time error message
FRM-40505: ORACLE error: unable to perform query. pops up.

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