Old Pending ISO Shipment Transactions Still Appear In CSTRITVR Intransit Value Report / Although Fully Delivered (Doc ID 1984249.1)

Last updated on JULY 05, 2017

Applies to:

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

Symptoms

On :  12.1.3 version, Receiving Functions

Find some old transactions are appearing in Intransit Value Report / pending for receiving although items of internal requisitions are already received and delivered.

Steps
The issue can be reproduced at will with the following steps:
1) Run CSTRITVR module: Intransit Value Report

Output shows

Sort by Item                            Intransit Value Report                                   As of Date: 19-FEB-2015 17:13:22
Include Shipments and Pending Receipts                                                                                           Page: 1
Category Set: Inventory                                          Detailed

                                                                                                Material           Transfer  
Item                Description      Category     UOM      Quantity      Total Value           Charges       Freight Cost
-----------------  ---------------- ------------  ---      ------------ ----------------   ----------------    ----------------
5C0214C401     CARRIER         42             EA                    5             0.000              0.000                 0.000

  Frm   To                   Owning        Shipment   Ship             Arrival                                              Intransit
  Org   Org  FOB Point  Cost Group   Number     Date             Date               ...       Quantity   Material Value
  ---   ---    ----------   ------------    ----------    ---------       ---------              ...       ---------   ----------------
  T51 T52   Receipt     CG-1001       3941103    13-OCT-12   13-OCT-12                          5               0.000 

Report shows 5 EA Pending for Intransit Shipment  Number 3941103.


2)  Navigate to Receiving / Receiving Transactions Summary form in org T52
Search for Source Type = Internal
Receipt = 116
Shipment = 3941103

Receipt Transaction Summary form shows receive / deliver transactions for internal requisition from Org T51 to T52 /
Sales Order 1232412 / Transaction date 11-DEC-2014 / Item 5C0214C401 / Quantity 5.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms