噗，我已經管到 INV 模組了，哈
在做 Pick Confirm 的畫面：Transact Move Order 發現兩個問題
1. Move Order 無法正確的 Closed
在資料面系統已經完成所有的 Transaction，但是 Move Order 還是掛在 Move Order LOV 裡面，是不影響整體動作，但是還是怪怪的。幸運的是，在 Metalink 找到相關的修正：
Subject : Move Order Outstanding Reservation for Cancelled or Closed Order Lines
Doc ID : Note:396254.1
A. CORRECT DATA
To implement the solution, please execute the following steps:
1. Ensure that you have taken a backup of your system before applying the recommended solution.
2. Run scripts that remove the reservations and move orders in a TEST environment first.
The script names are i2471362.sql and INVCLRMO.sql. See the following notes for details:
Note 199887.1 For the Reservation Cleanup - i2471362.sql
Note 169677.1 For the Move Order Cleanup - INVCLRMO.sql
3. If you are satisfied with the results, issue a commit.
4. Confirm that the data is corrected when viewed in the Oracle Applications.
5. Migrate the solution as appropriate to other environments.
B. AVOID ISSUE
1. Download and review the readme and pre-requisites for Patch 5037043.
2. Ensure that you have taken a backup of your system before applying
the recommended patch.
3. Apply the patch in a test environment.
4. Confirm the following file versions:
INVVTROB.pls 115.128.115100.19
MOTransaction.java 115.13.115100.2
You can use the commands like the following:
grep '$Header' $INV_TOP/patch/115/sql/INVVTROB.pls
strings -a $JAVA_TOP/oracle/apps/inv/transaction/server/MOTransaction.class |grep '$Header'
5. Retest the issue.
6. Migrate the solution as appropriate to other environments.
2. 不能 Transact Multiple Line
正常的情形下，按下 Transact Button，應該可以把這整張的 Move Order 的 Line 全都 Transact 掉，不過，那是正常的情況
To implement the solution, please execute the following steps:
1. Download and review the readme and pre-requisites for <Patch>.5633132
2. Ensure that you have taken a backup of your system before applying
the recommended patch.
3. Apply the patch in a test environment.
4. Confirm the following file versions:
forms/US/INVTOTRX.fmb 115.256.115100.36
You can use the commands like the following:
strings -a $XX_TOP/INVTOTRX.fmb |grep '$Header'
5. Retest the issue.
6. Migrate the solution as appropriate to other environments.
在做 Pick Confirm 的畫面：Transact Move Order 發現兩個問題
1. Move Order 無法正確的 Closed
在資料面系統已經完成所有的 Transaction，但是 Move Order 還是掛在 Move Order LOV 裡面，是不影響整體動作，但是還是怪怪的。幸運的是，在 Metalink 找到相關的修正：
Subject : Move Order Outstanding Reservation for Cancelled or Closed Order Lines
Doc ID : Note:396254.1
A. CORRECT DATA
To implement the solution, please execute the following steps:
1. Ensure that you have taken a backup of your system before applying the recommended solution.
2. Run scripts that remove the reservations and move orders in a TEST environment first.
The script names are i2471362.sql and INVCLRMO.sql. See the following notes for details:
Note 199887.1 For the Reservation Cleanup - i2471362.sql
Note 169677.1 For the Move Order Cleanup - INVCLRMO.sql
3. If you are satisfied with the results, issue a commit.
4. Confirm that the data is corrected when viewed in the Oracle Applications.
5. Migrate the solution as appropriate to other environments.
B. AVOID ISSUE
1. Download and review the readme and pre-requisites for Patch 5037043.
2. Ensure that you have taken a backup of your system before applying
the recommended patch.
3. Apply the patch in a test environment.
4. Confirm the following file versions:
INVVTROB.pls 115.128.115100.19
MOTransaction.java 115.13.115100.2
You can use the commands like the following:
grep '$Header' $INV_TOP/patch/115/sql/INVVTROB.pls
strings -a $JAVA_TOP/oracle/apps/inv/transaction/server/MOTransaction.class |grep '$Header'
5. Retest the issue.
6. Migrate the solution as appropriate to other environments.
2. 不能 Transact Multiple Line
正常的情形下，按下 Transact Button，應該可以把這整張的 Move Order 的 Line 全都 Transact 掉，不過，那是正常的情況
To implement the solution, please execute the following steps:
1. Download and review the readme and pre-requisites for <Patch>.5633132
2. Ensure that you have taken a backup of your system before applying
the recommended patch.
3. Apply the patch in a test environment.
4. Confirm the following file versions:
forms/US/INVTOTRX.fmb 115.256.115100.36
You can use the commands like the following:
strings -a $XX_TOP/INVTOTRX.fmb |grep '$Header'
5. Retest the issue.
6. Migrate the solution as appropriate to other environments.
Web (1)
{{ article.title }}
