My Oracle Support Banner

Error "SQL statement buffer overflow; unable to build statement" when Running Create Counting Event (INPCCREA) Process (Doc ID 2757098.1)

Last updated on DECEMBER 02, 2024

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Error "SQL statement buffer overflow; unable to build statement" when Running Create Counting Event (INPCCREA) Process

The issue can be reproduced at will with the following steps:
1. Navigate : Inventory > Inventory Counts > Prepare Counting Event > Setup Counting Event
Create data for BU US001
General Tab
a. Zero Qty Transaction History is checked
b. Blind Count is checked

Count Options Tab
Cycle Count is selected with "Due to Count" option
Zero Quantity Option : Include All

Utilization Types Tab
Utilization Type : A
Cycle Interval (days) : 90

2. Navigate : Inventory > Inventory Counts > Prepare Counting Event > Create Counting Event
BU : US001
Run INPCCERA process
Issue : Receive an error

 

Changes

Not Applicable 

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


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