no data in wsh_locations

our customer run pick release report, when he got the output file in pdf, but can't open the file. as we checked, there is no data return in the report:

 

 

 

select wdd.source_line_id , ola.ship_to_contact_id, ola.invoice_to_contact_id,wda.delivery_id
     -- into oe_line_id, shp_to_contact_id, bill_to_contact_id
      from apps.wsh_delivery_details wdd,
           apps.wsh_delivery_assignments wda,
           apps.oe_order_lines_all ola
     where wdd.delivery_detail_id = wda.delivery_detail_id
       and nvl(wdd.container_flag , 'N') = 'N'
        and wda.delivery_id is not null
       and  wdd.source_code = 'OE'
       and  wdd.source_line_id = ola.line_id
      and wdd.source_line_id=XXXXX
       and  rownum < 2;

 

 

SELECT ps.location_id
   -- INTO  bill_to_loc_id
    FROM   apps.hz_party_sites ps,
      apps.hz_cust_acct_sites_all ca,
      apps.hz_cust_site_uses_all su
      , apps.oe_order_lines_all ola
  WHERE  ola.line_id    = XXXXXX

  AND    su.site_use_id = ola.invoice_to_org_id
  AND    su.cust_acct_site_id = ca.cust_acct_site_id
  AND    ca.party_site_id = ps.party_site_id;

 

 

SELECT * FROM  apps.wsh_locations
WHERE wsh_location_id = XXXX

 

For the third query, there is no data in apps.wsh_locations
.

Do the following to verify that the business event subscriptions are working as they should.

1. As either Accounts Receivable user or Order Management Super user (customers standard form. is
owned by Accounts Receivable but is accessible from the OM super user), please find any location
in the customer's standard form. and change this location's bill-to address.

2. Use help->diagnostics->examine; Select the Block as "ADDR" and Field as "PARTY_LOCATION_ID". Note the values returned.

3. Wait about 5 minutes or so (depending on how often your business events are triggered. If you need help, consult with your DBA on this)

4. From a SQL*Plus session connected to the same instance having the address you changed, please execute the following queries:

select * from wsh_locations where trunc(creation_date) = trunc(sysdate);
select * from wsh_locations where wsh_location_id = &party_location_id;

For &party_location_id, use the value you noted from step 2.

If these two queries return data and the second query shows the updated (changed) address, your business events are setup and functioning properly.

Note:  The setup of business events will initiate synchronization between Accounts Receivable and Shipping Execution going forward, but it will not update wsh_shipping_transactions for past updates to locations in accounts receivable. To resolve this issue, please run the Import Shipping Locations concurrent request:

1.   Navigate to shipping->interfaces->run
2.   Choose 'Import Shipping Locations" 
3.   In the parameters box, select
      Map Regions = Yes
      Location Type = Process both Internal and External Locations
4.   Submit the request.

This request may run for several hours, depending on how many locations you have defined. You may wish to consider submitting this request before you leave work in the evening, and reviewing the status of the request the following morning when you return to work.

 

with Metalink suggestion, just run 'Import Shipping Locations" , then run the report again, there have data return.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15225049/viewspace-741685/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15225049/viewspace-741685/