Question

Create a pick list from shop order operations

  • 31 January 2024
  • 3 replies
  • 35 views

Userlevel 2
Badge +9

Hello.

We have an issue on a custom menu we made to generate a pick list from a list of shop order operations.

In our developement, we have this :

IF (p_user_language_ = 'FR') THEN

    v_consolidate_ := 'Entrepôt';

ELSIF (p_user_language_ = 'EN') THEN

    v_consolidate_ := 'Warehouse';

ELSIF (p_user_language_ = 'PT') THEN

    v_consolidate_ := 'Warehouse';

END IF;

 

--v_order_no_BP_ contains a list of ORDER_NO with ; as separated value, the length of v_order_no_BP_ is 287 characters

message_ :='!

$ACTIVITY_SEQ=0

$COM_PART=%

$CONSOLIDATE='||v_consolidate_||'

$CONTRACT=ABCDE

$DEPARTMENT=%

$FROM_REQ_DATE=

$INCLUDE_MATERIAL=TRUE

$INVENTORY_PART=%

$ISSUE_FROM_LOC=%

$LOCATION_GROUP=%

$MAX_ORD_PER_PICK_LIST=0

$ONLY_COMPLETE_LINES=FALSE

$ONLY_COMPLETE_ORDERS=FALSE

$OPERATION_NO=0

$ORDER_NO='||v_order_no_BP_||'

$ORDER_TYPE=%

$PHANTOM_PART_NO=

$PRINT_PICK_LIST=0

$PRODUCTION_LINE=%

$PROJECT_ID=%

$RELEASE_NO=%

$SEQUENCE_NO=%

$SHOP_ORDERS_KEY_LIST=%

$START_DATE_FROM=

$START_DATE_TO=

$TO_REQ_DATE=

$WAREHOUSE_PICK_LIST=FALSE

$WORK_CENTER=%

';

Shop_Material_Pick_Util_API.Create_So_Consol_Impl__(message_);

 

The problem we are having is about the call of the procedure, saying there is a out of space problem on a variable. 

What can we do to fix this issue?


3 replies

Userlevel 6
Badge +15

@romsar  could you paste the error message? Also after having a look at the code it seems v_order_no_BP_ is not given any value.

Userlevel 2
Badge +9

@Marcel.Ausan the v_order_no_BP_  is not empty, I left a comment saying that it contains a total of 287 characters

I got a screenshot of the error message but it’s in french, but it’s the ORA-06502 error code

Userlevel 6
Badge +15

@romsar OK, that was too subtle for me 😁.

When I look at the underlying implementation of this procedure I can see that the order_no goes into sel_order_no field which is VARCHAR2(120). So if your v_order_no_BP_  has 287 characters → that’s a problem. You would need to find a way to call the procedure multiple times and each time with an order_no of max 120.

 

Reply