E1: 41: Cycle Count Update (R41413) Does Not Update the Item Location File (F41021), Item Ledger File (F4111) and Account Ledger (F0911) for All Items in the Cycle Count (Doc ID 2727157.1)

Last updated on APRIL 01, 2024

Applies to:

Symptoms

When running Cycle Count Update (R41413) for a cycle count with multiple items, it creates PI document in P4111 and P0911 and updates F41021 only for one item. Same issue happens when run the process for single item and multiple locations. Only one location has corresponding records in those three tables. On the pdf is displayed the "Error occurred writing transaction" (Error ID 2592) for all items in the cycle count, but no errors found in work center.

The issue can be reproduced at will with the following steps:

1. Have 2 items.
2. R41411 - Select Items for Count for those items.
3. Enter counted quantities for both of them in Cycle Count.
4. Approve Cycle Count.
5. Update Cycle count - status moved to 50.
6. Check R41413 - got Error occurred writing transaction for both items.
7. Check Item Availability - only one item has been updated.
8. Check P4111 and P0911 - PI containing the variance for only one item.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.