How to submit concurrent program from command prompt /shell

We can submit concurrent programs from OS command / shell prompt using CONCSUB utility. Syntax:

CONCSUB <APPS username>/<APPS password>
<responsibility application short name>
<responsibility name>
<username>
[WAIT=N|Y|<n seconds>]
CONCURRENT
<program application short name>
<program name>
[PROGRAM_NAME=”<description>”]
[REPEAT_TIME=<resubmission time>]
[REPEAT_INTERVAL= <number>]
[REPEAT_INTERVAL_UNIT=< resubmission unit>]
[REPEAT_INTERVAL_TYPE=< resubmission type>]
[REPEAT_END=<resubmission end date and time>]
[NLS_LANGUAGE=<language of the request>]
[NLS_TERRITORY=<territory of the request>]
[START=<date>]
[IMPLICIT=< type of concurrent request>
[<parameter 1> … <parameter n>]

Examples:

Active Users
CONCSUB apps/[apps_pwd] SYSADMIN “System Administrator” SYSADMIN WAIT=N CONCURRENT FND FNDSCURS

Prints Environment Variables
CONCSUB apps/[apps_pwd] SYSADMIN “System Administrator” SYSADMIN WAIT=N CONCURRENT FND FNDPRNEV APPL_TOP

Supplier Payment Method and Delivery Mail query

select
hou.name "OU_NAME",
aps.segment1 "SUPPLIER_NUMBER",
aps.vendor_name,
assl.vendor_site_code,
--iepa.ext_payee_id,
--assl.party_site_id,
ieppmh.payment_method_code "PAYMENT_METHOD_SITE", 
iepah.remit_advice_delivery_method  "DELIVERY_METHOD_HEAD",
iepah.remit_advice_email "REMIT_ADVICE_EMAIL_HEADER",
ieppm.payment_method_code "PAYMENT_METHOD_SITE", 
iepa.remit_advice_delivery_method  "DELIVERY_METHOD_SITE",
iepa.remit_advice_email "REMIT_ADVICE_EMAIL_SITE"
from
hr_operating_units hou,
AP_SUPPLIERS aps,
AP_SUPPLIER_SITES_ALL assl,
iby_external_payees_all iepah,
iby_ext_party_pmt_mthds ieppmh,
iby_external_payees_all iepa,
iby_ext_party_pmt_mthds ieppm
where
aps.VENDOR_ID = assl.VENDOR_ID
and hou.ORGANIZATION_ID = assl.ORG_ID
and assl.ORG_ID = iepa.ORG_ID
and iepa.payee_party_id    = aps.party_id
AND aps.enabled_flag     = 'Y'
AND iepa.org_id              = assl.org_id
AND iepa.supplier_site_id    = assl.vendor_site_id
AND iepa.ext_payee_id = ieppm.ext_pmt_party_id
and ieppm.PRIMARY_FLAG ='Y'
and ieppm.PAYMENT_METHOD_CODE='WIRE'
and iepa.REMIT_ADVICE_DELIVERY_METHOD='EMAIL'
and iepah.payee_party_id    = aps.party_id
and iepah.PARTY_SITE_ID is null
AND iepah.ext_payee_id = ieppmh.ext_pmt_party_id
and ieppmh.PRIMARY_FLAG ='Y'
--and aps.segment1 ='E52029'
and ieppmh.PAYMENT_METHOD_CODE='WIRE'
and iepah.REMIT_ADVICE_DELIVERY_METHOD='EMAIL'

How to add concurrent program in ship confirm or pick release?

By using the Document set

Navigation:

OM Super User : setup : shipping : Documents : Document Set