My Oracle Support Banner

Event Creation (INPCCREA) Process Fails with Error 'Dynamic SQL statements - the buffer area is not large enough' (Doc ID 2808322.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

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

Symptoms

Event Creation (INPCCREA) Process fails to run with statement with error

ERROR
'Dynamic SQL statements such as SELECT and INSERT have been built into the program, however, the buffer area in the program allocated for such statements is not large enough.'

Steps to Reproduce the Issue:
1. Run Create Counting event
Navigation Inventory / Inventory Counts / Prepare Counting Event / Create Counting event
Enter Unit ,
Count Options = Cycle Count.
2. In the Cycle Count Options tab, select
Cycle Count Options = Manual Count.
Error is in the message log.

Changes

 n/a

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.