My Oracle Support Banner

Requisition Import Errors With POCIRM-222 For Min-Max Requisitions (Doc ID 464573.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Purchasing - Version 12.0 to 12.0.3 [Release 12]
Information in this document applies to any platform.
This problem can occur on any platform.
POCIRM

Symptoms

On Release 12.0.2 when attempting to run requisition import for min-max planning, the following error occurs.

ERROR
Concurrent program POCIRM returned error
Cause: POCIRM encountered an internal error. Parameters: REQIMPORT,INV,,ITEM,,N,Y,
Action: Note both this error number and the actions you are trying to perform. Contact your
system administrator.
POCIRM-222: ORA-06502: PL/SQL: numeric or value error: character string buffer too
Cause: A SQL error has occurred in POCIRM. The SQL error is &LSQL_ERR.

Steps to Reproduce:
1. Submit Min-max Planning report with Restock option as Yes.
2. Submit Requisition Import concurrent program with following parameters:
Import Source : INV
Group By : Item
Multiple Distribution : No
Initiate Approval after reqimp : No
3. Program completed with error.

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.