E1: 31B: P31B66 VBT Movement Allows Importing in the Grid and Saving the Record With Barrels Filled From Other VBT (Doc ID 2805715.1)

Last updated on AUGUST 02, 2023

Applies to:

Symptoms

P31B66 VBT Movement allows importing in the grid and saving the record with barrels filled from other VBT.

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

1. (if necessary, create one T2B opertation to fill up a barrel) In Databrower, F31B03 [Barrel Master Table] find any Barrel which has vessel ID assigned. It means barrel is full in that VBT.
2. In F31B101 [VBT Detail] check that barrel details to make sure that barrel is full, if there is no blank lot record with that VBT, then that barrel is actually attached to that VBT.
3. Create ONE CSV file as below, using same barrel ID
4. ,BDX,ANB/19/3, , ,209,1,VIEW,RED,ACT
5. The first T2B operation must be closed before trying to fill the same barrel through import option in new operation.
6. In P31B94 Operation Search - Search For Operations, now create one T2B operation and move some volume from Tank.
   Click on Generate VBT and then click on calculate move and then Edit VBT details.
   Press calculate move.
   Click on Edit VBT.
   Press on import grid.
   Click on Import barrel option and then click on browse.
   Click on browse again.
   Select that CSV file and click on Open.
   Click on Upload and then click on continue.
   Scroll down and click on Apply.
   Barrel got imported now click on continue .
   Barrel got added.
   Now click on save and close.
   Actual barrel got updated.
   Now click on save and close.
7. Check F31B03 Barrel master table again and find the new VBT number got assigned. Check F31B101 VBT detail table and find the same barrel is appearing in 2 VBTs at the same time.

Cause

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