My Oracle Support Banner

EAR9.2: Letter of Credit Summary Page Errors With Wide Open Search. (Doc ID 2017839.1)

Last updated on MAY 16, 2019

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When searching wide open, no criteria entered, on the Billing > Manage Billing Worksheet > Letter of Credit Summary page,
the following error occurs.

ERROR
-----------------------
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'ORDER'.
Error in PeopleCode ScrollSelect processing. (2.213) BI_LOC_SUMMARY.Activate PCPC:503 Statement:9


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Access Billing > Manage Billing Worksheet > Letter of Credit Summary page;
  2. Click on Search without typing anything.

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.