Skip to main content
Question

Create a pick list from shop order operations


Forum|alt.badge.img+10
  • Hero (Customer)
  • 118 replies

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

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1142 replies
  • January 31, 2024

@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.


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 118 replies
  • January 31, 2024

@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


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1142 replies
  • January 31, 2024

@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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings