My Oracle Support Banner

Requisition Import Fails With POCIRM-149A ORA-06510: PL/SQL: Unhandled User-defined Exception (Doc ID 1076234.1)

Last updated on JULY 14, 2016

Applies to:

Oracle Purchasing - Version: 11.5.10 to 12.1.1 - Release: 11.5 to 12.1
Information in this document applies to any platform.
ConcurrentProgram:REQIMPORT - Requisition Import
Executable:POCIRM - Requisition Import

Symptoms


Requisition Import (REQIMPORT) is completing with error POCIRM-149A The log file shows:

Concurrent program POCIRM returned error

Cause: POCIRM encountered an internal error. Parameters: REQIMPORT,,,VENDOR,,N,Y,

Action: Note both this error number and the actions you are trying to perform. Contact your system
POCIRM-149a: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APP

Cause: A SQL error has occurred in POCIRM. The SQL error is &LSQL_ERR.


Steps to Reproduce :

1 - Populate the Requisition Interface table. This can be done manually or through another application such as Inventory, Order Management, Advance Supply Chain, etc. The issue can occur if the currency code is null in the interface table.
2 - Run Requisition Import Program

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
      For release 11.5.10
     For release 12.0.6
     For release 12.1.1
  References

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