Cancelled Po Line, But Po/Req Encumbrance Amount Still Remains For Billed Qty (Doc ID 731451.1)

Last updated on AUGUST 11, 2022

Applies to:

Symptoms

Whenever iP requisitions have multiple distributions (even in 1 requisition line), cancelling its AutoCreated PO line creates the incorrect distribution in the requisitions.
Req and PO distribution for 700.00 Encumbrance Amount is not released from encumbrance when its PO line was cancelled.

1 PO line for 1000.00 (2 distributions - 700.00 and 300.00) was cancelled.
700.00 billed, 300.00 unbilled.
Encumbrance Detail Report ran for Req - shows both 700.00 and 300.00,
Same for PO -- shows only 700.00.

300.00 in Req is okay:
PO not showing 300.00 is okay, since it's cancelled and went to Req
--> It will be used for the future PO.

700.00 in Req and PO seem to be the problem -- expecting 0.00:
This $ in Req went to PO -> so Req should be 0.
This $ in PO should be offset with Invoice matched.

This issue happens with only multiple distributions in 1 Req and PO line.
If only one distribution exists in 1 PO line, there is no problem, after cancellation.

This issue with one distribution was resolved with <patch 6508988>, but multiple
distributions issue was not fixed.

Additional information
-------------------------------
GL_Encumbered_Period_name =DEC-08
FY08 spans from 01-Apr-2007 to 30-Mar-2008

Sample Req 14459/PO C14459:

- Requisition Summary form:
Total = 1000.00
Line Quantity Amount Line Distribution Quantity Amount
1 700 700.00 1 1 700 700.00
2 300 300.00 1 2 0 0.00
2 1 300 300.00

- PO Summary form (PO C14459 )

Amount = 700.00, Matched Amount = 700.00

Line   Quantity   Amount
1        700         700.00

Line    Shipment    Quantity     Quantity Billed    Quantity Received    Quantity Cancelled
1         1                 1000           700                   700                          300

Line  Ship’t   Dist     Quantity Ordered    Quantity Delivered   Quantity Billed   Quantity Cancelled
1          1         1         700                                 700                  700                    300

Number    Line     Shipment     Distribution    
C14459        1        1                 1              

Quantity Ordered Quantity Delivered/Billed Quantity Cancelled Encumbered Amt Amt   Amt Billed
700                       700                                 0                             700.00         700.00   700.00
300                           0                             300                                0.00          300.00      0.00

Requisition # 14459 in iP shows:
Line 1: Qty = 700 with Order = C14459
Line 2: Qty = 300 with Order = null
Line 1: Details
112.32181.34265.6001.3200000.000 percent = 100
Receipt # 28181, Invoice # a002

Line 2: Details
12.32181.34267.6001.3200000.000 percent = 100

Requisition will now have two lines: completed line 1 (700) and newly
created line 2 (300)
o Line 1 has 2 Distributions: 100 % to Dist 1, 0 % to dist 2
Line Qty = 700, Encumbered Flag = N
§ Dist 1: Encumbered Flag = Y, Encumbered Amount = 700
§ Dist 2: Encumbered Flag = N, Encumbered Amount = 0
o Line 2 has 1 Distribution: 100 % (to account from Line 1 Dist 2)
Line Qty = 300, Encumbered Flag = Y
§ Dist 1: Encumbered Flag = Y, Encumbered Amount = 300
- Encumbrance for 700 shows against line 1, distribution 1; this amount was
already received and billed; encumbrance cannot be relieved.

EXPECTED BEHAVIOR
-----------------------------------
Expected result for requisition after cancel action:
Line 1: Dist 1 Amount = 700, Encumbered Amount = 0
Line 1: Dist 2 Amount = 0, Encumbered Amount = 0
Line 2: Dist 1 Amount = 300, Encumbered Amount = 300

Results for this scenario:
Line 1: Dist 1 Amount = 700, Encumbered Amount = 700
Line 1: Dist 2 Amount = 0, Encumbered Amount = 0
Line 2: Dist 1 Amount = 300, Encumbered Amount = 300

700.00 in Req and PO seem to be the problem -- expecting 0.00:
This $ in Req went to PO -> so Req should be 0.
This $ in PO should be offset with Invoice matched.

STEPS TO REPRODUCE THE PROBLEM
-----------------------------------------------
The issue can be reproduced at will with the following steps:

1. In iP responsibility, created Req # 14459  -- approved.

Line 1: Q=1000, amount = 1000 CAD.   Dist 1: Q=700, Dist 2: Q=300

2. AutoCreated PO # C14459 

3. PO form -- approved PO # C14459 => @Approved, Reserved.

4. In iP responsibility, received Q=700. (Auto-delivered )

5. In AP responsibility, created invoice # a002 for Q=700.  Validated/Initiated approval.

6. PO form. Q Billed, Received, Delivered = 700
Line 1 (Q=1000) -- cancelled (Cancel Requisition check box left null)

Now, Q Billed, Received, Delivered = 700; Q cancelled = 300 ==> correct
(700 can not be cancelled, since billed / received)

7. In iP responsibility, Req # 14459

Line 1: Dist1 -- Q=700 with C14459 (AutoCreated PO is linked).
- Dist 2 -- Q=300 without C14459 == > correct

8. Cancelled PO line for Q=1000

Changes

Upgraded to 11.5.10.2

Cause

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