My Oracle Support Banner

How to use API wsh_picking_batches_pub.create_batch ? (Doc ID 1290692.1)

Last updated on AUGUST 26, 2024

Applies to:

Oracle Shipping Execution - Version 12.1.1 to 12.2.9 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Goal

One would like to use release sales order for picking through API and
also use the following API, instead one sees the same error:


1 CREATE OR REPLACE PROCEDURE APPS.cust_create_batch (
2 errbuf OUT VARCHAR2,
3 retcode OUT VARCHAR2,
4 p_delivery_id NUMBER
5 )
6 AS
7 l_return_status VARCHAR2 (1);
8 l_msg_count NUMBER (15);
9 l_msg_data VARCHAR2 (9999);
10 l_count NUMBER (15);
11 l_msg_data_out VARCHAR2 (9999);
12 l_mesg VARCHAR2 (9999);
13 p_count NUMBER (15);
14 p_new_batch_id NUMBER;
15 l_rule_id NUMBER;
16 l_rule_name VARCHAR2 (2000);
17 l_batch_prefix VARCHAR2 (2000);
18 l_batch_info_rec wsh_picking_batches_pub.batch_info_rec;
19 BEGIN
20 l_batch_info_rec.delivery_id := p_delivery_id;
21 l_rule_id := 1006;
22 l_rule_name := 'Default: Order Number';
23 l_batch_prefix := NULL;
24 fnd_global.apps_initialize (1090, 20559, 300);
25 ------------------------------------------------------------------------
26 -- API Call to Create Batch -
27 ------------------------------------------------------------------------
28 wsh_picking_batches_pub.create_batch (p_api_version_number => 1.0,
29 p_init_msg_list => fnd_api.g_true,
30 p_commit => fnd_api.g_true,
31 x_return_status => l_return_status,
32 x_msg_count => l_msg_count,
33 x_msg_data => l_msg_data,
34 p_rule_id => l_rule_id,
35 p_rule_name => l_rule_name,
36 p_batch_rec => l_batch_info_rec,
37 p_batch_prefix => l_batch_prefix,
38 x_batch_id => p_new_batch_id
39 );
40* END;
41 /


Warning: Procedure created with compilation errors.

 

Solution

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
Goal
Solution


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