免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 6638 | 回复: 0

Inventory Standard Datafixes [复制链接]

论坛徽章:
0
发表于 2011-12-20 09:48 |显示全部楼层


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

    显示附件 附件


     


     

    var rateArticleSuccess = "您的评级已发送到 Oracle"; var rateArticleFailure = "无法为文档评级"; checkArticleRatingStatus(); <!--568012.1</EMMOS_CONTEXT_STRING>-->
    您需要登录后才可以回帖 登录 | 注册

    本版积分规则 发表回复

    SACC2021中国系统架构师大会

    【数字转型 架构重塑】2021年5月20日-22日第十三届中国系统架构师大会将在云端进行网络直播。

    大会为期3天的议程,涉及20+专场,近120个主题,完整迁移到线上进行网络直播对会议组织来说绝非易事;但考虑到云端会议的直播形式可以实现全国各地技术爱好者的参与,也使ITPUB作为技术共享交流平台得到更好的普及,我们决定迎难而上。
    http://sacc.it168.com/


    大会官网>>
      

    北京盛拓优讯信息技术有限公司. 版权所有 16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122
    中国互联网协会会员  联系我们:huangweiwei@itpub.net
    感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

    清除 Cookies - ChinaUnix - Archiver - WAP - TOP