Unable To Unload Object From HD Using The Functionality Within OTM (Doc ID 1286708.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

When try to Unload Object a confirmation is given by the system, with Time Stamp. After unloading when fetching the details of the same Object ID, one is still seeing the same.

EXPECTED BEHAVIOR
-----------------------
One expect not to see the same Object ID in FTI

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Login OTM as admin user
2. Navigate Transportation Intelligence> Power Data > Unload Object from HD
3. Click on New and create a new record as follows:
a. selected Object type as Shipment
b. Enter the Object ID as the OLTP Shipment Gid desired
c. Click finished
4. Run the ETL process

5. Navigate to Transportation Intelligence> Ad Hoc Query
a. Click on Create a new request icon under Catalog tab
c. Click on Fusion Transportation Intelligence
d. Expand Shipment Analysis >OLTP Shipments
e. Click on Shipment Gid
f. on the right hand section add a filter for Shipment (desired GID in 3.b above) and click Ok
g. Results still showing the GID of concern exists in HD

Cause

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