--- title: Tips & Tricks - Maintaining Item Availability Integrity description: Learn practical tips to maintain item availability integrity, avoid stock issues, and ensure accurate inventory management across platforms. image: https://www.denovo-us.com/hubfs/Blog%20Images/Ask%20Denovo.jpg --- [![DenovoOracleLogo_White-1](https://www.denovo-us.com/hs-fs/hubfs/DenovoOracleLogo_White-1.png?width=264&height=100&name=DenovoOracleLogo_White-1.png "DenovoOracleLogo_White-1")](https://www.denovo-us.com/) # Tips & Tricks - Maintaining Item Availability Integrity Posted: May 1, 2025 Are you getting complaints from your Supply Chain Team that the Commitment or Quantity on Hand Amounts in Item Availability are Inaccurate?  Are you still using SQL to correct discrepancies in F41021?  If so, JDE has standard programs that can help! ***The Basics:*** R42995 – Repost Active Sales Orders – This UBE has multiple functions.  It can re-commit future orders.  It can also reset commitments for active sales orders, but remember it can’t be run to do both at the same time.  Separate versions are needed for each function.   (Oracle Doc ID 625504.1) R43990 – Repost Open Purchase Orders – This UBE will update the purchase order-related Item availability fields.  (Orace Doc ID 631844.1)   R3190 – Repost Open Work Orders – This UBE will update the commitment quantities for the work order-related quantities.  (Oracle Doc ID 1248874.1) ***The Not Well Known:*** R42990 – Refresh Inventory Commitments – New in 9.2, this UBE will refresh the inventory commitments for items not on an open sales order.  Based on the configuration, it can launch the R42995 when it completes.  (Oracle Doc ID 2230896.1) P42210/R42210 – Manual Rollback of the Item Location File (F41021) – this can be used to correct integrity issues when those pesky asynchronous errors pop up during a transaction, such as ship confirm.  Important Note – before using this program, check the F41021WF and remove old records as needed.  Rolling back old records will cause integrity issues.  (Oracle Doc ID 625445.1) ***The Most Recent:*** R41995 – Repost - Update on Hand Inventory – this UBE can be run to update the Item Location Quantity on Hand in the F41021 table based on the Item Ledger.  Important Note - This program has a proof and final mode and is intended to be run only on items with known issues.  This is not a job meant for the scheduler – it should always be run manually.  Ask Denovo covered this UBE when it was first released in Release 23. See the Ask Denovo blog posting [here ](https://www.denovo-us.com/blog/getting-code-current-reason-372-new-on-hand-repost-report-in-inventory-0)for more details. (Oracle Doc ID 2973692.1)   If you want access to our Ask Denovo video series, you can see them all [here](https://www.youtube.com/@DenovoERPExperts)! Always feel free to reach out to the Denovo team if you have questions!   Want to learn more or watch short videos on these updates? Check out [LearnJDE](https://docs.oracle.com/cd/E84502_01/learnjde/release25.html) , click on your area of interest, then click on Product Catalog.   If you need a question answered in the series or just want to subscribe for alerts on future articles, simply fill out the form below! Denovo is here for YOU!   [Ask Denovo](https://www.denovo-us.com/blog/tag/ask-denovo) ### Recent Posts ### Posts by Topic - [Ask Denovo (212)](https://www.denovo-us.com/blog/tag/ask-denovo) - [Infrastructure Managed Services (39)](https://www.denovo-us.com/blog/tag/infrastructure-managed-services) - [Application Managed Services (35)](https://www.denovo-us.com/blog/tag/application-managed-services) - [Denovo Insights (31)](https://www.denovo-us.com/blog/tag/denovo-insights) - [Denovo Consulting (4)](https://www.denovo-us.com/blog/tag/denovo-consulting) ### Annual Archives - [September 2017 (9)](https://www.denovo-us.com/blog/archive/2017/09) - [October 2017 (7)](https://www.denovo-us.com/blog/archive/2017/10) - [November 2017 (7)](https://www.denovo-us.com/blog/archive/2017/11) - [January 2024 (7)](https://www.denovo-us.com/blog/archive/2024/01) - [May 2024 (7)](https://www.denovo-us.com/blog/archive/2024/05) - [July 2024 (7)](https://www.denovo-us.com/blog/archive/2024/07) - [October 2024 (7)](https://www.denovo-us.com/blog/archive/2024/10) - [April 2025 (7)](https://www.denovo-us.com/blog/archive/2025/04) - [October 2025 (7)](https://www.denovo-us.com/blog/archive/2025/10) - [November 2022 (6)](https://www.denovo-us.com/blog/archive/2022/11) - [November 2023 (6)](https://www.denovo-us.com/blog/archive/2023/11) - [February 2024 (6)](https://www.denovo-us.com/blog/archive/2024/02) - [January 2025 (6)](https://www.denovo-us.com/blog/archive/2025/01) - [July 2017 (5)](https://www.denovo-us.com/blog/archive/2017/07) - [April 2018 (5)](https://www.denovo-us.com/blog/archive/2018/04) - [January 2023 (5)](https://www.denovo-us.com/blog/archive/2023/01) - [June 2023 (5)](https://www.denovo-us.com/blog/archive/2023/06) - [August 2023 (5)](https://www.denovo-us.com/blog/archive/2023/08) - [April 2024 (5)](https://www.denovo-us.com/blog/archive/2024/04) - [June 2024 (5)](https://www.denovo-us.com/blog/archive/2024/06) - [August 2024 (5)](https://www.denovo-us.com/blog/archive/2024/08) - [March 2025 (5)](https://www.denovo-us.com/blog/archive/2025/03) - [May 2025 (5)](https://www.denovo-us.com/blog/archive/2025/05) - [June 2025 (5)](https://www.denovo-us.com/blog/archive/2025/06) - [August 2025 (5)](https://www.denovo-us.com/blog/archive/2025/08) - [January 2026 (5)](https://www.denovo-us.com/blog/archive/2026/01) - [April 2026 (5)](https://www.denovo-us.com/blog/archive/2026/04) - [May 2026 (5)](https://www.denovo-us.com/blog/archive/2026/05) - [June 2026 (5)](https://www.denovo-us.com/blog/archive/2026/06) - [May 2018 (4)](https://www.denovo-us.com/blog/archive/2018/05) - [June 2018 (4)](https://www.denovo-us.com/blog/archive/2018/06) - [July 2018 (4)](https://www.denovo-us.com/blog/archive/2018/07) - [October 2022 (4)](https://www.denovo-us.com/blog/archive/2022/10) - [February 2023 (4)](https://www.denovo-us.com/blog/archive/2023/02) - [March 2023 (4)](https://www.denovo-us.com/blog/archive/2023/03) - [April 2023 (4)](https://www.denovo-us.com/blog/archive/2023/04) - [September 2023 (4)](https://www.denovo-us.com/blog/archive/2023/09) - [October 2023 (4)](https://www.denovo-us.com/blog/archive/2023/10) - [December 2023 (4)](https://www.denovo-us.com/blog/archive/2023/12) - [March 2024 (4)](https://www.denovo-us.com/blog/archive/2024/03) - [September 2024 (4)](https://www.denovo-us.com/blog/archive/2024/09) - [November 2024 (4)](https://www.denovo-us.com/blog/archive/2024/11) - [December 2024 (4)](https://www.denovo-us.com/blog/archive/2024/12) - [February 2025 (4)](https://www.denovo-us.com/blog/archive/2025/02) - [July 2025 (4)](https://www.denovo-us.com/blog/archive/2025/07) - [November 2025 (4)](https://www.denovo-us.com/blog/archive/2025/11) - [December 2025 (4)](https://www.denovo-us.com/blog/archive/2025/12) - [February 2026 (4)](https://www.denovo-us.com/blog/archive/2026/02) - [March 2026 (4)](https://www.denovo-us.com/blog/archive/2026/03) - [December 2017 (3)](https://www.denovo-us.com/blog/archive/2017/12) - [January 2018 (3)](https://www.denovo-us.com/blog/archive/2018/01) - [March 2018 (3)](https://www.denovo-us.com/blog/archive/2018/03) - [August 2019 (3)](https://www.denovo-us.com/blog/archive/2019/08) - [October 2019 (3)](https://www.denovo-us.com/blog/archive/2019/10) - [December 2022 (3)](https://www.denovo-us.com/blog/archive/2022/12) - [May 2023 (3)](https://www.denovo-us.com/blog/archive/2023/05) - [July 2023 (3)](https://www.denovo-us.com/blog/archive/2023/07) - [September 2025 (3)](https://www.denovo-us.com/blog/archive/2025/09) - [February 2018 (2)](https://www.denovo-us.com/blog/archive/2018/02) - [August 2018 (2)](https://www.denovo-us.com/blog/archive/2018/08) - [September 2018 (2)](https://www.denovo-us.com/blog/archive/2018/09) - [November 2019 (2)](https://www.denovo-us.com/blog/archive/2019/11) - [May 2021 (2)](https://www.denovo-us.com/blog/archive/2021/05) - [July 2026 (2)](https://www.denovo-us.com/blog/archive/2026/07) - [December 2018 (1)](https://www.denovo-us.com/blog/archive/2018/12) - [January 2019 (1)](https://www.denovo-us.com/blog/archive/2019/01) - [March 2019 (1)](https://www.denovo-us.com/blog/archive/2019/03) - [September 2019 (1)](https://www.denovo-us.com/blog/archive/2019/09) - [January 2020 (1)](https://www.denovo-us.com/blog/archive/2020/01) - [March 2020 (1)](https://www.denovo-us.com/blog/archive/2020/03) - [March 2021 (1)](https://www.denovo-us.com/blog/archive/2021/03) - [April 2021 (1)](https://www.denovo-us.com/blog/archive/2021/04) - [June 2021 (1)](https://www.denovo-us.com/blog/archive/2021/06) - [August 2021 (1)](https://www.denovo-us.com/blog/archive/2021/08) - [September 2021 (1)](https://www.denovo-us.com/blog/archive/2021/09) - [October 2021 (1)](https://www.denovo-us.com/blog/archive/2021/10) - [November 2021 (1)](https://www.denovo-us.com/blog/archive/2021/11) - [December 2021 (1)](https://www.denovo-us.com/blog/archive/2021/12) - [April 2022 (1)](https://www.denovo-us.com/blog/archive/2022/04) - [September 2022 (1)](https://www.denovo-us.com/blog/archive/2022/09) [See all](https://www.denovo-us.com/blog/tips-tricks-maintaining-item-availability-integrity#)