MSCA Misc Receipt Transaction Fails When DFF - Serial numbers (ATTRIBUTEn) is Enabled

(Doc ID 2342782.1)

Last updated on DECEMBER 24, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Oracle Warehouse Management - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Problem Statement
When attempting to perform Misc Receipt of a Serial Number,
the following error occurs.

Error
Transaction failed:ORA-06550: line 1, column 13:
PLS-00306: wrong number or types of arguments in call to 'INSERT_SER_TRX'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Steps to Reproduce

  1. Item is serial number controlled:
    Serial Generation At Receipt

  2. DFF - Serial numbers:
    ATTRIBUTES10 is Enabled and set to Required.

  3. Misc Receipt the serial number through Form:
    Serial Entry window requests user to enter ATTRIBUTES10.

  4. Misc Issue the same serial number through Form

  5. Misc Receipt the same serial number again through MSCA:
    Mobile page doesn't request user to enter ATTRIBUTES10.

  6. Error occurs

 

There are two types of serial number related DFF in the system.

 
Title     MTL_SERIAL_NUMBERS
(Check eTRM for the details)
FORM MSCA
Serial Attributes     C_ATTRIBUTEn - VARCHAR2(150)
D_ATTRIBUTEn - DATE
N_ATTRIBUTEn - NUMBER   
Supported    Supported   
Serial numbers

ATTRIBUTEn - VARCHAR2(150)

Supported Not Supported   

 

DFF - Serial numbers: ATTRIBUTES10 is Enabled and set to Required.

When receiving a new serial number through FORM, Serial Entry window will request user to enter ATTRIBUTES10. As a result, the receipt succeeds and MTL_SERIAL_NUMBERS - ATTRIBUTES10 is populated.

When receiving a new serial number through MSCA, Serial Entry window will NOT request user to enter ATTRIBUTES10 because it is NOT Supported currently. As a result, the receipt succeeds and MTL_SERIAL_NUMBERS - ATTRIBUTES10 is NOT populated.

The error happens when receiving an existing serial number(status = 4) through MSCA and the same serial number has been received once through FORM (MTL_SERIAL_NUMBERS - ATTRIBUTES10 has been populated).

 

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