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