Skip to main content

We have a Custom RMB using the following PL/SQL Block on Issue Material Using Pick List (for Shop Orders)

&AO.Inventory_part_barcode_API.Create_and_print(&CONTRACT, &PART_NO, &CONFIGURATION_ID, &LOT_BATCH_NO, &SERIAL_NO, &ENG_CHG_LEVEL, &WAIV_DEV_REJ_NO, &ORIG_QTY_ASSIGNED, &ACTIVITY_SEQ, &QTY_ASSIGNED)

 

The (almost) same code does not work on Report Picking of Pick List Lines (for Customer Orders) - changing the “&ORIG_QTY_ASSIGNED” to “&QTY_ASSIGNED” even though the code runs successfully in PLSQL developer … 

SELECT 

CONTRACT, PART_NO, CONFIGURATION_ID, LOT_BATCH_NO, SERIAL_NO, 
ENG_CHG_LEVEL, WAIV_DEV_REJ_NO, QTY_ASSIGNED, ACTIVITY_SEQ, QTY_ASSIGNED

FROM CREATE_PICK_LIST_JOIN_MAIN 

 

Directly in the application (APPS9) it errors as follows:

Encountered the symbol "." when expecting one of the following:

   ( begin case declare exit for goto if loop mod null pragma

   raise return select update while with <an identifier>

   <a double-quoted delimited-identifier> <a bind variable> <<

   continue close current delete fetch lock insert open rollback

   savepoint set sql execute commit forall merge pipe purge

   json_exists json_value json_query json_object json_array

The symbol "<an identifier>" was substituted for "." to continue.

 

Does anyone have any thoughts/suggestions/ideas/handy hints & tips I could try, please, to get this print barcode working?  

Any feedback gratefully received!

Thanks

Linda

Be the first to reply!

Reply