EAP: AP_SDN_VAL fails at Step AP_SDN_VAL.MAIN.Step04 (PeopleCode), Error "Search Exception: Failed to parse query [OR] (262,2018)".
(Doc ID 3003307.1)
Last updated on APRIL 10, 2024
Applies to:
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When the AP_SDN_VAL process is run for a particular vendor/supplier, where the supplier name contains the SQL keywords "OR"/"AND", the process fails with an error at Step AP_SDN_VAL.MAIN.Step04.
Steps to Replicate:
1. Download the SDN file from the US treasury site.
2. Import the SDN file.
Banking > Financial Sanctions > Import Financial Sanctions List
3. Run the Financial Sanctions Validation process for a particular supplier.
Suppliers > Supplier Information > Maintain > Financial Sanctions Validation.
The process fails with the above error.
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |