My Oracle Support Banner

Spares Management: No Reservation Created After (direct) Shipment For Parts Requirement (Doc ID 1958559.1)

Last updated on FEBRUARY 06, 2022

Applies to:

Oracle Spares Management - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Spares Logistics

after patch 16587433 no reservation is created after (direct) shipment for parts req. The patch makes the customization from note 602296.1 no longer necessary and provides a new event subscription that should take care of creating the reservation. But that is not happening
It should do that through even oracle.apps.po.rcv.rcvtxn which calls CSP_TRANSACTIONS_PUB.res_for_rcv_trans. The event subscription is seeded as disabled, it has been enabled before testing.

The issue can be reproduced at will with the following steps:
1. create an SR, with task and parts requirement
2. create an internal order for the parts requirement - using a source organization that will use direct shipping to the destination org (ie not manual receipt required)
3. ship the order
4. Run this script to ensure the business process is fired:

 select wfd.user_data.event_name EVENT_NAME,
  0, '0 = Ready',
  1, '1 = Delayed',
  2, '2 = Retained',
  3, '3 = Exception',
  to_char(substr(wfd.state,1,12))) State,
  count(*) COUNT
  from applsys.wf_deferred wfd
  where wfd.user_data.event_name like '%rcv%'
  group by wfd.user_data.event_name, wfd.state
  order by 3 desc, 1 asc;

  Initially the script would return '0=retained'; meaning that the WF Deferred Agent Listener will pick it up when it awakes. After that listener has run, the row should show 2 = Retained; meaning the row has been processed

5. Requery the parts requirement to notice there is one source line with status 'Fully Received'. There should be an additional one for the reservation that was to be created in the destination subinventory, but that is not there.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.