My Oracle Support Banner

KK_TRANS_LOG.EXPIRED_YEAR for PO line closed set back to 'N' after update another open PO Line (Doc ID 2779421.1)

Last updated on MAY 25, 2021

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

KK_TRANS_LOG.EXPIRED_YEAR for PO line closed set back to 'N' after update another open PO Line

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

Setup
1. Installation Options. Entry Event tab. Check Upward/Downward Adjustment;
2. Purchasing Business Unit Definition. Setup Business Unit Event: POEntry Event = 'PO_COMB';
3. Setup Entry Event Process Definition 'POPOST'. Add Entry Event Step: 'PODN';
4. Setup Event Code Definition: PO_COMB. Add Entry Event Steps: 'POUP' and 'PODN';

Steps
1. Create two line PO in year 2021 And Validate Budget Check;
2. Run Entry Event the PO;
3. Query:
Select A. CLOSED_VALUE, A.EXPIRED_YEAR, A.* From Ps_Kk_Trans_Log A Where Kk_Tran_Id In (Select Kk_Tran_Id From Ps_Kk_Source_Hdr Where Business_Unit = 'US001' And Po_Id = '0000000444');
4. Close line 1 via Buyer workbench. Override the PO to close and select the accounting date to 2022 and update Budget date equal to Accounting date;
5. Go back to PO and Budget check PO. Got the error;
6. Override error message;
7. Go back to PO. Budget Status = ‘Valid’;
8. Query:
Select A. CLOSED_VALUE, A.EXPIRED_YEAR, A.* From Ps_Kk_Trans_Log A Where Kk_Tran_Id In (Select Kk_Tran_Id From Ps_Kk_Source_Hdr Where Business_Unit = 'US001' And Po_Id = '0000000444');
PO Line 1 is set:
CLOSED_VALUE = ‘Y’
EXPIRED_YEAR = ‘Y’
9. Update PO line 2. Increase quantity to 4;
10. Budget check PO;
11. Query:
Select A. CLOSED_VALUE, A.EXPIRED_YEAR, A.* From Ps_Kk_Trans_Log A Where Kk_Tran_Id In (Select Kk_Tran_Id From Ps_Kk_Source_Hdr Where Business_Unit = 'US001' And Po_Id = '0000000444');

At this point, the EXPIRED_YEAR flag on KK_TRANS_LOG is set to N for line 1 (for seq 3) and the CLOSED_VALUE is still 'Y'. The EXPIRED_YEAR flag on KK_TRANS_LOG for line 1 seq 3 should be 'Y'.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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