My Oracle Support Banner

When Using GME_API_PUB.scale_batch.sql, Get "Error 306: Wrong number or datatype of arguments in call to "SCALE_BATCH"" (Doc ID 2193428.1)

Last updated on JUNE 30, 2017

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, API Issues

When attempting to use the GME_API_PUB.scale_batch.sql.
the following error occurs.

Error 306: Wrong number or datatype of arguments in call to "SCALE_BATCH"

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

When I tried to compile the form file,

  v_batch_header_rec gme_batch_header%ROWTYPE;
x_batch_header_rec gme_batch_header%ROWTYPE;
x_exception_material_tbl gme_common_pvt.exceptions_tab;
x_scale_message_count NUMBER := 0;
x_scale_message_list VARCHAR2(4000) := NULL;
x_scale_return_status VARCHAR2(1) := 'U';

GME_API_PUB.scale_batch( p_api_version => 2.0
  ,p_validation_level => 100
  ,p_init_msg_list => 'F'
,p_commit => 'F'
,p_batch_header_rec => v_batch_header_rec
,p_org_code => :PARAMETER.ORG_CODE
,p_ignore_exception => 'F'
,p_scale_factor => 1
,p_primaries => 'OUTPUT'
,p_qty_type => 1
,p_recalc_dates => 'F'
,p_use_workday_calc => 'F'
,p_contiguity_override => 'F'
,x_exception_material_tbl => x_exception_material_tbl
,x_message_count => x_scale_message_count
,x_message_list => x_scale_message_list
,x_return_status => x_scale_return_status
,x_batch_header_rec => x_batch_header_rec);


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

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