Wednesday, 27 June 2012

How to print LPN lables with custom component that is not on mobile device?

Its Normal practice to invoke RTP via
fnd_request.submit_request() function'

But... the main difference is of parameters that we pass...

When we want to invoke the LPN lable printing request then we should use the following parameters in the function call:

fnd_request.submit_request(application => 'PO'
,program => 'RVCTP'
,description => NULL
,start_time => NULL
,sub_request => FALSE
,argument1 => 'BATCH'
,argument2 => v_group_id
,argument3 => g_org_id);


If we are not interested in LPN lables then we can use the above request without following 2 parameters:

1) argument2 => v_group_id
2) argument3 => g_org_id


How To Install (Register) a New Font Using XML Publisher [ID 373377.1]

I have tried to make the barcode output according to the above document ID.
I also got success in printing the barcode in XML output file.
This approach does not take any profile option in consideration.

You need to change the font in RTF file itself. As I did in RTF for LOT Number field.
Please follow this approach.

How to retrieve rules query from database?


  • To retrive the Rule ID:


select * from wms_rules where name = 'Rule Name'





  • To retrieve the exact name of package created by the rule:

select * from all_objects where object_name like '%RULE_ID%'  -- (Rule ID retrived from above query)




  • By default the rule package name is

wms_rule_(RULE_ID)
For eg:
wms_rule_10045