MSCA Account Alias Receipt with Serial DFF Attribute Origination_Date Errors:Transaction failed:ORA-06550: line 1, column 13: PLS-00306:wrong number or types of arguments in call to 'INSERT_SER_TRX' ORA-06550 (Doc ID 3041398.1)

Last updated on AUGUST 15, 2024

Applies to:

Symptoms

When a serial number is received in MSCA with the DFF enabled for the serial attribute Origination_date, the below error occurs on the mobile form

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. Press any key to continue.

The issue can be reproduced at will with the following steps:

1. Login to MSCA
2. Navigate to Whse Mgmt-->Warehousing-->Inventory-->Receipts-->Alias Receipt
3. Populate the required details including the DFF for Origination_Date attribute
4. Save the record
5. Encounter the error on the mobile form

Cause

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