Inventory Standard Datafixes

richardliu1123

FAQ: Inventory Standard Datafixes [ID 568012.1]

In this Document
  Goal
  Solution
     -- A. STANDARD DATAFIXES
     1. Reservations
     2. Move Orders
     3. Zero Onhand
     4. Inventory Items
     5. Duplicate Bills of Material (BOM)
     6. Inventory Manager
     
     -- B. SR DATAFIXES
     1. MMT MOQD Mismatch
     2. Closed Move Orders
     3. Missing Move Orders
     4. Marked Serial Numbers
     5. Serial number with leading/trailing spaces
     6. Lot number with leading/trailing spaces
     7. Corrupted Onhand related to Lots
     8. Physical Inventory Adjustment Errors
     9. Sales Order reservations created with Zero demand header
     10. Error while costing Material transactions
     11. Incorrect Demand header id
     12. Onhand records with locator populated when sub inventory is not locator controlled
     13. Locator stamped on onhand record is different from the one existing in mtl_item_locations for the subinventory
     14. Onhand have records with Null Locator when Sub inventory is locator controlled
     15. The Update Standard Costs program is failing with the following error:Invalid value for intransit_owning_org_id in table MTL_SUPPLY
     16. Stuck transaction with 'Error occurred while relieving reservations' due to incorrect or negative availability
     17. Duplicate transactions in MTI already posted in MMTT and MMT and in MMTT already posted into MMT
     18. View material transactions screen raise error APP-FND-00756:CANNOT FIND COMBINATION CCID=40225 CODE=MKTS
     19. Negative TRANSACTION_SOURCE_ID in the inventory transactions table (MTL_MATERIAL_TRANSACTIONS)
     
     -- C. Other Datafix Related Notes
     -- D. Bills of Material / PLM
  References

Applies to: Oracle Inventory Management - Version: 11.5.8 to 12.1.3 - Release: 11.5 to 12.1
Information in this document applies to any platform.
This document includes all versions of 11i and R12 and later GoalAre there standard datafixes for inventory?


SolutionYes, there are a number of standard datafixes available for the inventory application. There is also a set of standard identification scripts in Note 330284.1. Suggest you run those for your specific area like serial numbers. We will continue to grow this note listing them. Some are available directly for customers and others require logging a Service Request to get the datafix. We will try to keep this page updated going forward.

 WARNING: Remember to NOT ONLY apply the datafix but any related root cause patch to avoid the issue going forward! Also periodically review the Recommended Patch List (RPL) via the Patches and Updates tab on MyOracleSupport. This lists patches for your environment that Oracle Development recommends applying. Also note that you can find the latest Inventory Rollup (RUP) in Note 726226.1.

-- A. STANDARD DATAFIXES** These standard datafixes are available via patches or download:
1. Reservations
2. Move Orders
3. Zero Onhand
4. Inventory Items
5. Duplicate Bill of Materials
6. Inventory Manager

Standard Datafix Scripts
1. Reservations
Note 199887.1 I2471362.sql - Remove old reservations. See the note for more details about the datafix and root-cause patches by version. Here is a quick overview of some patches available: In R12.1.1, Patch 9252341:R12.INV.B (as forward port for patch 8826082) was released with INVVRVAB.pls 120.12.12010000.6. In R12.0.x, Patch 8826082 was released with INVVRVAB.pls 120.12.12000000.4 for one cause of orphan reservations. In R11.5.10, this issue was fixed with one-off Patch 6121372 INVRSV3B.pls 115.129.115100.14. This version was already included in INV RUP5 and above. In 11.5.9, this issue was fixed with Patch 3827307 INVRSV3B.pls 115.106.11590.7.
2. Move Orders
Purge Move Orders: For 11.5.10 and above, there is a purge move order concurrent program. The purge will remove older move orders. However, it does not remove orphan move orders. Note 169677.1 INVCLRMOv115.5.sql or INVCLRMO.sql - Clear old orphan move orders. Avoid the issue in the future with Patch 5958760 from the recommended patch list. (We also have an Internal bug logged to investigate any new occurences of this issue in RCA Bug 9137821 for R12 and Bug 9293096 for R11.5.10.) Note 301524.1 INVINBUP.sql to create missing move order lines. See section B-3: Missing Move Orders for new notes on this for identification and fixes.
3. Zero Onhand
Note 267272.1 invzmoqd.sql - Clear onhand records with zero Note 353345.1 Consolidate onhand and clear onhand that adds to zero
4. Inventory Items
Note 245100.1 INVItemerr.sql to find spaces specific items causing FRM-40654: Record has been updated. Requery block to see changes.
5. Duplicate Bills of Material (BOM)
There are two notes related to multiple bills of material (BOM) found for the same item. The first attempts to correct the bill and delete using standard bill forms. The second uses the Oracle Diagnostics to check for the duplicates. The Oracle Diagnostics provide the delete. The second note also provides the root-cause patch to prevent the issue in the future. Note.357785.1 Duplicate Bills Of Material Can Be Created Same Item/Org/Alternate Designator Combination Note.370841.1 Find Two Bills of Material (BOM) for the Same Item (BOMFDBOM)
6. Inventory Manager
Note 740039.1 Timeout is 45 minutes but expect it to be 0 minutes. Note provides fix.

-- B. SR DATAFIXES** These datafixes all require service requests:

Why log an SR?
Oracle Development requires that you log an SR to get the datafix even though it is a standard fix. This is because Oracle wants to ensure that the root-cause patches are suggested to each customer to avoid the issue in the future. Also, if you already have the root-cause patches, Oracle wants to capture information that might help identify the new root-cause situations so that too can be fixed. Oracle does not want customers constantly running datafixes as this is not going to promote satisfaction with the product. Instead, Oracle wants to fix the cause of the data corruption. This is why the note requests you to log an SR to get the datafix.

1. MMT MOQ Mismatch
2. Closed Move Orders
3. Missing Move Orders
4. Marked Serial Numbers
5. Serial number with leading/trailing spaces
6. Lot number with leading/trailing spaces
7. Corrupted Onhand related to Lots
8. Physical Inventory Adjustment Errors
9. Sales Order reservations created with Zero demand header
10. Error while costing Material transactions
11. Incorrect Demand header id
12. Onhand records with locator populated when sub inventory is not locator controlled.
13. Locator stamped on onhand record is different from the one existing in mtl_item_locations for the subinventory
14. Onhand have records with Null Locator when Sub inventory is locator controlled
15. The Update Standard Costs program is failing with the following error:Invalid value for intransit_owning_org_id in table MTL_SUPPLY
16. Stuck transaction with 'Error occurred while relieving reservations' due to incorrect or negative availability
17. Duplicate transactions in MTI already posted in MMTT and MMT and in MMTT already posted into MMT
18. View material transactions screen raise error APP-FND-00756:CANNOT FIND COMBINATION CCID=40225 CODE=MKTS

Identification Scripts	** Datafix Script: Require an SR	Root Cause (RCA) Fixes	Fix  Included In	Fixed Files	New RCA Bugs	Applicable to R12	Last Update Date
1. MMT MOQD Mismatch
See Note 279205.1 for more details. Here is a summary: 1) Run the query <A title=mmt_moqd_mismatch_at_sublevel.sql href="https://support.oracle.com/CSP/main/<<INLINE_ATTACHMENT%20568012.1:datafix1>>" target=_blank>mmt_moqd_mismatch_at_sublevel.sql to check whether the mismatch exists at the subinventory level. * This does NOT currently account correctly for logical transactions that cause transaction history but NOT onhand quantity. If you have logical transactions, this script will not help as of now. Only if the above query returns records follow the below steps: 2) Run the scripts in Patch 7304685 (Older version in Patch 5126787 and Patch 4047528 should no longer be used) and check the temp_disc_inv_cg* tables. Pre-requisite for the mismatch is ct. should not have purged the MMT table.	1) Run the scripts in Patch 7304685 (You do not need to run again if just run to identify the issue.) 2) Apply script revloc_mismatch_fix.sql to fix the revision and locator mismatch in MMT and MOQD. 3) Re-run the sql script invmtmqd.sql from Patch 7304685. 4) Run script datafix_final.sql The script is applicable only for inventory organizations. The script would insert/update/delete the onhand data to correct the discrepancies. Note: Refer to Note 400088.1 for suggestions on finding the DISTRIBUTION_ACCOUNT_ID used in the datafix.	Apply Patch 9241879. Older patch was Patch 5085603.	11.5.10 INV RUP19+	QtyManager.java 115.106.115100.35+	R12 BUG 9279555 R11i Bug 8201601	Yes (Only for Discrete Org with no dual UOM controlled item)	23-Mar-10
2. Closed Move Orders
Use the script ClosedMO to check for Closed Move orders where the corresponding delivery lines are still open.	Use script OpenMO.sql.	Apply Patch 3615755 and Patch 4582052.	11.5.10+	INVTOTRX.fmb 115.207.11590.30+ INVMOBOB.pls 115.16.11590.10+ INVRSV3B.pls 115.106.11590.15+ INVTOTXB.pls 115.74.11590.21+ INVMTXFH.pld 115.212.11590.34+	R12 Bug 9402378 R11i Bug 9402362	Yes	31-Dec-08
3. Missing Move Orders
Use Script Missing Move Orders to identify if a transaction is failing because of missing move orders.(Remember a count of zero means the issue is present unless you already applied the new code.)	Script invinbup_inv_orgs.sql is no longer needed. See Note 301524.1.	See Note 301524.1.	11.5.10 INV RUP19+	See Note 301524.1.	R12 Bug 9402419 R11i Bug 9402403	Yes	11-Jun-2010
4. Marked Serial Numbers
Use Script Identify_SerialMark.sql to identify serials incorrectly marked. This could run for a very long time if you have a lot of serial numbers so you might want to instead run for specific serials as described in Note 309710.1.	Use script markedserial_backup.sql to create the backup tables. Once successful, use script markedserial_datafix.sql to correct the marking problem.	Apply Patches: Patch 5382432 , Patch 5898163, Patch 5504875 and Patch 8494231. (More Notes on Patches / Versions)	All the patches except Patch 8494231 are included in 11.5.10 INV RUP5+	RCVCOTRX.pld 115.201.11510.30+ RCVTXVTX.pld 115.33.11510.4+ INVSLENT.pld 115.141.115100.37+ INVPOIGB.pls 115.0.115100.2+ INVPOIGB.pls 115.0.115100.2+ WSHDDICB.pls 115.50.11510.5+	R12.0 Bug 8598083 R11.5.10 Bug 9286511	Yes	22-Nov-09
5. Serial number with leading/trailing spaces
(1) Run the script identify.sql to check whether there any serial number exists with leading or trailing spaces. (2) Only if the above script returns records then run the script invtrimsn-bakup.sql first with inventory_item_id for which date correction is required thisscript will take back of relevant tables before making any changes.	If script invtrimsn-bakup.sql is run successful then only run script invtrimsn.sql with same inventory_item_id for which data backup is taken. This script will correct the data for given inventory_item_id.	Apply patch Patch 4764047 and Patch 6156209 or equivalent patch on your patchset level.	INV RUP5+	INVSLENT.plx 115.141.115100.34 INVTXGGB.pls 115.32.115102.21 INVTXGGS.pls 115.4.115100.3 INVLIBR,INCTM 115.71.115100.12 SerTrxManager.java 115.144.115100.21 LotSerialFListener.java 115.85.115100.5 SerialNumberLOV.java 115.78.115100.4	R12 Bug 9402459 R11i Bug 9402447	Yes	31-Dec-08
6. Lot number with leading/trailing spaces
(1) Run the script lot_identify_issue.sql to check whether there any lot number exists with leading or trailing space. (2) Only if the above script returns records then run the script invtrimlot-bakup.sql. This script will take back of relevant tables before making any changes.	If script invtrimlot-bakup.sql is run successful then only run script invtrimlot.sql.This script will correct the data.	Apply Patch 5740945, Patch 5884285, and Patch 6156209 or an equivalent patch on your patchset level.	N/A	INVIDITM.fmb 115.365.115100.67 INVSDOIO.fmb 115.177.115100.16 INVTTMTX.fmb 115.239.115100.31 INVTTELT.fmb 115.55.115100.10 INVLTENT.pld 115.95.115100.28 INVTXGGB.pls 115.32.115102.27 INVPAG2B.pls 115.37.115100.6 INVLIBR,INCTM 115.71.115100.13 LotSerialFListener.java 115.85.115100.5 SerialNumberLOV.java 115.78.115100.4	R12 Bug 9402481 R11i Bug 9402471	Yes	31-Dec-08
7. Corrupted Onhand related to Lots
If the item is lot controlled but onhand doesn't have lot numbers use Onhand without Lot.	Use script itemlotcontrl_moqdnolot_per_org.sql.	Patch 6603375 Fixes the root cause. * A new root-cause patch will be included in INV RUP20 and higher though this is NOT yet released.	INV RUP5+ initially, and then INV RUP20 for latest fix coming soon.	INVTTMTX.pld 115.92.115100.18 INVMTXFH.pld 115.267.115100.51 And new files: BaseTransaction.java 115.235.115100.58 TrxProcessor.java 115.130.115100.45	R12 Bug 9402575 R11i Bug 9402562	Yes (Only for Discrete Org with no dual UOM controlled item)	16-Jul-09
If the item is not lot controlled but onhand has lot numbers use Onhand with Lot.	Use script itemnolot_moqdlot.sql.	ApplyPatch 4413586 which would prevent the item controls to be changed when there are open sales orders.	N/A	INVIDITM.fmb 115.365.115100.29 INVIDI3B.pls 115.48.115100.6 INVUPD2B.pls 115.61.115100.13	R12 Bug 9402596 R11i Bug 9402591	Yes (Only for Discrete Org with no dual UOM controlled item)	31-Dec-08
8. Physical Inventory Adjustment Errors
Physical Inventory Adjustments Report errors out.	Use script fix_physical_inv_error.sql to Reject the erroneous Adjustments and delete the corresponding records in temporary tables.	Root cause patch will be updated soon.	N/A	N/A	R12 Bug 9402635 R11i Bug 9402625	Yes	31-Dec-08
9. Sales Order reservations created with Zero demand header
Use script Is_rsv_0_header_id.sql to find demand and reservations that have zero demand_source_header_id	Use script update_rsv_0_header_id.sql to to update the demand_source_header_id .	For 11.5.10, apply Patch 4642711. For R12.0.4, apply Patch 6726199. For R12.0.6, fixes were already included in this release.	N/A	OEXUSCHB.pls 115.153.11510.18 OEXUSCHB.pls 120.36.12000000.16	R12 Bug 9412378, R11i Bug 9412346	Yes	31-Dec-08
10. Error while costing Material transactions
Sub-inventory/Direct Org-transfer transactions in MMT error out with CST_INVALID_TXFR error	Use script update_mmt_subtrx_subloc.sql to resolve the issue .	None available.	N/A	N/A	R12 Bug 9412438, R11i Bug 9412418	Yes	31-Dec-08
Account Alias transactions in MMT error out while getting costed with missing transaction source. Also see Note 428403.1 and use script <A href="https://support.oracle.com/CSP/main/<<INLINE_ATTACHMENT%20568012.1:IdentifyScript10>>" target=_blank>identify scriptto identify the issue.	Use script populate_mmtsrcid_for_accntalias.sql to resolve the issue .	Apply Patch 5998987 to stop MMT being populated with NULL transaction source.	10G: 10.2.0.4	N/A	R12.1 / 11G Bug 9270461, R12 Bug 9412451, R11i Bug 9412445	Yes	31-Dec-08
11. Incorrect Demand header id
Use Script is_incorrect_demand.sql to get the reservation details for sales orders which have incorrect demand_source_header_id	Use script update_demand_source_header_id.sql to resolve the issue.	Fixed in Patch 6314703 but not released. Patch 6192873 includes fix.	N/A	OEXUSCHB.pls 115.153.11510.38+	R12 Bug 9412515, R11i Bug 9412488	Yes	31-Dec-08
12. Onhand records with locator populated when sub inventory is not locator controlled
Refer bug 4264580 for steps to identify the issue	Use script subnoloc_moq_loc.sql	For R12, see Note 604251.1. For 11.5.10, apply root cause patch 3778483 and patch 4113020 or equivalent patches on their patchset level as mentioned in RPL.	12.0.7+, 11.5.10+	INVMTXFH.pld 120.40.12000000.17+ RCVRCERL.pld 115.110.1158.3 RCVTXERT.pld 115.68.1158.2 IssueTrxFListener.java 115.74.11580.7	R12 Bug 9277481 R11i Bug 9277465	Yes (Only for Discrete Org with no dual UOM controlled item)	31-Dec-08
13. Locator stamped on onhand record is different from the one existing in mtl_item_locations for the subinventory
Refer bug 4264604 for steps to identify the issue.	Use Script subloc_moqmismatch.sql	For R12, see Note 604251.1. For 11.5.10, apply root cause patch 3969714, patch 3462946, patch 3703919, patch 4170327 or equivalent patches on their patchset level as mentioned in RPL before running the data fix script.	12.0.7+	INVMTXFH.pld 120.40.12000000.17+ RCVRCERL.pld 115.117.1159.12 RCVTXERT.pld 115.80.1159.3 INVTXMGB.pls 115.77.11590.28 INVADPTE.pld 115.33.11590.6 IssueTrxFListener.java 115.89.11590.11	R12 Bug 9277481 R11i Bug 9277465	Yes (Only for Discrete Org with no dual UOM controlled item)	31-Dec-08
14. Onhand have records with Null Locator when Sub inventory is locator controlled
Refer bug 4264563 for steps to identify the issue.	Use scripts subloc_moqdnoloc.sql subloc_moqdnoloc_itm.sql	Apply root cause patch 3778483.	11.5.10+	RCVRCERL.pld 115.110.1158.3 RCVTXERT.pld 115.68.1158.2	R12 Bug 9277481 R11i Bug 9277465	Yes (Only for Discrete Org with no dual UOM controlled item)	31-Dec-08
15. The Update Standard Costs program is failing with the following error:Invalid value for intransit_owning_org_id in table MTL_SUPPLY
Refer bug 4234883 for steps to identify the issue.	Use script mtl_supply_4234883.sql	Apply Patch 4473106 for the root cause	INV RUP4+	RcvTrxManager.java 115.51.115100.4	R12 Bug 9412616, R11i Bug 9412598	Yes	31-Dec-08
16. Stuck transaction with 'Error occurred while relieving reservations' due to incorrect or negative availability
Refer bug 4286036 for steps to identify the issue.	Use scripts i2471362.sql, INVCLRMO.sql	Apply root cause patch 2755209	11.5.10+	INVTXMGB.pls 115.44.11580.15	R12 Bug 9413202, R11i Bug 9413192	Yes	31-Dec-08
17. Duplicate transactions in MTI already posted in MMTT and MMT and in MMTT already posted into MMT
See Note 294391.1 for more details. Refer bug 4286083 for steps to identify the issue. (Often find transaction_mode 8 in MMTT)	Use script Duplicates_for_mmt_mti_mmtt.sql.	R12.0 - Apply 12.0.6 that fixes Bug 5748351, R11i patch 2640488 (11.5.8 patch) and Patch 5935177 for 11.5.10	12.0.6 / 11.5.10	R12: TrxProcessor.java 120.10.12000000.4+ BaseTransaction.java 120.39.12000000.2+ INVTXMGB.pls 120.25.12000000.3+ INVTRXWB.pls 120.34.12000000.11+ R11.5.10: BaseTransaction.java 115.235.115100.36+ R11.5.8: BaseTransaction.java 115.111.11580.5+	R12.0 Bug 8857390 R11i Bug 9270328	Yes	31-Dec-08
18. View material transactions screen raise error APP-FND-00756:CANNOT FIND COMBINATION CCID=40225 CODE=MKTS
Refer bug 5008181 for steps to identify the issue. (Also discussed in Note 315946.1).	Use script mmt_txn_src_mismatch.sql	Apply one of the root cause patches -- Patch 4182913 for 11.5.9, Patch 4455715 for 11.5.10 on your patchset level as mentioned in RPL before running the data fix script.	11.5.10 INV RUP3+	INTORDTransaction.java 115.18.115100.4+	R12 Bug 9413260, R11i Bug 9413256	Yes	31-Dec-08
19. Negative TRANSACTION_SOURCE_ID in the inventory transactions table (MTL_MATERIAL_TRANSACTIONS)
Use ident script (ident_negative_TRANSACTION_SOURCE_ID_in_MMT.sql) to identify the issue. Also see Note 803790.1.	Use update script to fix the issue.	N/A	N/A	N/A	R11i Bug 8523316	Yes	08-Oct-10

 

Note:
As a test, the identification scripts from Section B were merged into one file. This is only for a test of a merged script and is only referenced here for testing. Here is a <A href="https://support.oracle.com/CSP/main/<<INLINE_ATTACHMENT%20568012.1:CLUBBED2>>">sample script and here is a <A href="https://support.oracle.com/CSP/main/<<INLINE_ATTACHMENT%20568012.1:CLUBBED1>>">sample output.

 

-- C. Other Datafix Related NotesYou might also find these other datafix related notes helpful:

Note	Error / Situation
Note 264372.1 MTL_MATERIAL_TRANSACTIONS records with different TRANSACTION_DATE and ACCT_PERIOD_ID	The transaction date and period do not match in the interface table.
Note 803790.1 MTL_MATERIAL_TRANSACTIONS records with Negative Source ID	Still working this via RCA Bug 8523316. There are triggers available to prevent and help identify the cause of this issue. See note for identification scripts.
Note 438935.1 for details of the datafix and Note 452970.1 for the root-cause patch.	Consigned Inventory with Transaction Source NULL: Datafix 6085031.sql stamps the TRANSACTION_SOURCE_ID on MTL_MATERIAL_TRANSACTIONS for Consigned Inventory Transactions When the source Is Null.
Note 268973.1	Identify Duplicate Transactions
Note 282480.1	Locator Datafixes
Note 312293.1 Ora-01422: Exact Fetch Returns More	Duplicate locators
Note 178166.1	Locator ID -1
Note 370309.1	Serial Number Status 6
Note 330284.1 Note 402574.1	Serial Number vs. Onhand Mismatch Suggest running 'serial_diagnostic.sql' from Note 330284.1.
Note 306394.1 Note 275755.1	Duplicates in WIP
Note 108185.1	Spaces at the start or end of a column may cause the error "FRM-40654 :Record Has Been Updated". We have a standard datafix to fix this issue: Use $FND_TOP/sql/afchrchk.sql that includes an identification and correction utility from Note 108185.1
Note 311242.1 Error In Inv_logical_transactions_pub.Create_logical_trx_wrapper Note 819554.1 Transaction Open Interface Error Note 303698.1 Interface Trip Stop Fails With error.. in	Error: INV_LOGICAL_TRANSACTIONS_PUB.create_logical_trx_wrapper oracle.apps.inv.transaction.utilities.InvTrxException * Multiple causes but most common is period is closed in destination organization of an internal order.
Note 981792.1 Nonshippable Item Stuck	Find that a Sales Order Issue tries to issue non-shippable material. The material gets stuck in the MTI with 'Oracle error' and a duplicate record is created in MMTT. The trip stop (WSHINTERFACE) completes in warning.
Note 1230896.1 How To Identify Duplicate Lot Numbers for Lot Uniqueness Across Items Setup	Working on RCA Bug 10164831. Bug contains file "MSCA 2 Different PO Receipt Concurrently-2.doc", please ask your customer to follow steps and check if issue is reproducible.

-- D. Bills of Material / PLM

1. Steps to cancel ECO via interface for both Engineering and PLM- link.
2. Duplicate Bills of Material (BOMs)
   See details in Note 370841.1 or Note 357785.1
3. Uncommon a Bill
   Unfortunately, not available in the application. See Note 878976.1 for details.
4. FRM-40735 SPECIAL12 trigger raised unhandled exception ORA-20002
   Note 406148.1 for an identification script. If it returns rows, log a service request to get a datafix to reset the workflow.

@ http://myst.oraclecorp.com/wiki/index.php?n=Templates.InvODM#toc25

ReferencesNOTE:605044.1 - Tom's Top Inventory FAQ Notes 2009
NOTE:726226.1 - INV/WMS/RCV Family Patch Release History / Patchsets / RUPs

附件 CancelEcoViaInterface.txt (1.04 KB) CancelEcoViaInterface2.txt (1.24 KB) Details about patches and file versions for marked serials. (9.86 KB) Identify Script (302 B) Identify Serials Incorrectly Marked (1.14 KB) Is_OpenMO.sql (977 B) 0 means cannot find move order so need datafix. (1,008 B) Is_itemlotcontrl_moqdnolot_per_org.sql (664 B) Is_itemnolot_moqdlot.sql (672 B) Is_rsv_0_header_id.sql (827 B) Warning (242 B) Serial Spaces Identification Script (1.84 KB) Lot space backup (12.65 KB) Lot space datafix (18.99 KB) Serial Space Backup Script (12.12 KB) Serial space datafix. (22.82 KB) is_incorrect_demand.sql (183 B) Lot space identification (2.49 KB) mmt_moqd_mismatch_at_sublevel.sql (1.82 KB) RevLoc mismatch datafix (8.1 KB) Under Construction (12.61 KB)

 

 

var rateArticleSuccess = "您的评级已发送到 Oracle"; var rateArticleFailure = "无法为文档评级"; checkArticleRatingStatus(); <!--568012.1</EMMOS_CONTEXT_STRING>-->