Java.lang.NullPointerException Errors In Allocation (Doc ID 2134851.1)

Last updated on MAY 07, 2016

Applies to:

Oracle Retail Allocation - Version 13.2.4 to 13.2.8 [Release 13.2]
Information in this document applies to any platform.

Symptoms

Problem Description

JAVA.LANG.NULLPOINTEREXCEPTION errors appear while working on Allocation interface

Instructions to Re-create

1. Update multiple records on alloc_detail table with some values on column qty_transferred, qty_distro, qty_selected and qty_received. This is an intermittent issue where mass records were updated by process.
2. Observe that the unwanted locks are created on the alc_alloc table
Actual: alc_alloc table is locked and application throws null pointer exception.
Expected: No lock should be created by the triggers and no error should be recorded.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms