oracle库存模块考试,在Oracle库存模块中进行帐龄分析

不经意间发现还有这样一个功能点： (Enable profile INV:FIFO For Receipt Date)

一但这个Profile开启，系统的现有量表中就会记录最早入库的时间。如果一个Item两次入库到同一个货位，则表中的记录就会有两行。虽然在界面中只会看到一条记录。

如果这个Profile关闭，系统中的最早入库时间就是最后一次事务处理时间。如果一个Item两次入库，表中只有一行汇总记录。

下面是简单的测试记录。

====================================

Defined a new item TEST001FIFO.PROJET

Step1: PO# 10188 purchased 100 Unit

---------------

Step2: 2009-8-26 8:55:59 Receive-Deliver 87 Unit to locator APSA.A.0001.99080050.1

Step3: Transfer 13 Unit form APSA.A.0001.99080050.1 to locator APSA.B.0001.99080050.1

Step4: 2009-8-26 9:20:51 Receive-87-Deliver-50 Unit to locator APSA.B.0001.99080050.1

On-hand Result

QUANTITY LOCATOR_ID Locator orig_date_received

13 266 locator APSA.B.0001.99080050.1 2009-8-26 8:55:59

50 266 locator APSA.B.0001.99080050.1 2009-8-26 9:20:51

74 264 APSA.A.0001.99080050.1 2009-8-26 8:55:59

We can see the original received date, but we cannot trace back to a certain PO#.

---------------

Step5: Transfer 3 Unit form locator APSA.B.0001.99080050.1 to APSA.A.0001.99080050.1

Step6: Issue 7 Unit from APSA.A.0001.99080050.1

Step7: Issue 8 Unit from locator APSA.B.0001.99080050.1

On-hand Result

QUANTITY LOCATOR_ID Locator orig_date_received

2 266 locator APSA.B.0001.99080050.1 2009-8-26 8:55:59

50 266 locator APSA.B.0001.99080050.1 2009-8-26 9:20:51

70 264 APSA.A.0001.99080050.1 2009-8-26 8:55:59