EDI- Rerun DSNO Program in Oracle apps

DSNO RERUN in Oracle apps

Sometimes we need to regenerate the DSNO file again, usually we perform this activity for troubleshooting purpose-

Steps below depicts how to run DSNO program again.


When a customer is enabled for EDI DSNO transaction where in we define the EDI setups in e-commerce responsibility.
We then ship an order using shipping transaction form
in Request SRS - we see program getting fired as Outbound Triggering process(Triggering Process Outbound) program. This is DSNO generator program which generates DSNO file into file directory (E-Commerce profile)


So in concurrent program we don't see any such program exists as Outbound Triggering process rather exists Triggering Process Outbound
Assign Triggering Process Outbound to desired responsibility


Run the Triggering Process Outbound program with parameter as
File name in the first argument#1 as Pickup Stop ID


you can get the Pickup Stop ID from below sqls


SELECT
   fcr.request_date "Date Released"
  , fcr.argument2 "DSNO_file"
  , wdl.delivery_id "Delivery"
  , fcr.argument5 "Pickup Stop ID"
  , usr.user_name "User ID"
     FROM
    FND_CONCURRENT_REQUESTS fcr
  , wsh_new_deliveries wnd
  , wsh_delivery_legs wdl
  , fnd_user usr
    WHERE
    fcr.argument5           = TO_CHAR (wdl.pick_up_stop_id)
    AND wdl.delivery_id = wnd.delivery_id
    and fcr.argument2 like 'DSNO%'
    and fcr.requested_by = usr.user_id
    order by 1 desc, 2, 3, 4;




SELECT
fcr.argument2 "DSNO_file"
, fcr.request_date "Date Released"
, wdl.delivery_id "Delivery"
, wdl.pick_up_stop_id "Pickup Stop ID"
, wts.trip_id
, wnd.asn_seq_number
, wnd.confirmed_By "User_ID"
, wnd.organization_id
, mp.organization_code
FROM
FND_CONCURRENT_REQUESTS fcr
, wsh_new_deliveries wnd
, wsh_delivery_legs wdl
, wsh_trip_stops wts
, mtl_parameters mp
WHERE
wnd.delivery_id = wdl.delivery_id
and wdl.pick_up_stop_id = wts.stop_id
and TO_CHAR (wdl.pick_up_stop_id) = fcr.argument5
AND fcr.argument2 LIKE 'DSNO%'
and wnd.organization_id = mp.organization_id;