Monday, January 7, 2019

How to fix a Requisition Sourcing issue

How to fix a Requisition that has Sourcing as - "In Process" or "Source Complete" but there is no PO Created.

First check Req Header - REQ_HDR table if following is true:
IN_PROCESS_FLG = N (no) + HOLD_STATUS = N (no)+ BUDGET_HDR_STATUS = V (valid);

Fix - Step 1: REQ_LINE table -- Reset following field value flags to :
 IN_PROCESS_FLG = 'N’ & SOURCE_STATUS = 'A'

Fix - Step 2: REQ_LN_DISTRIB  table:

a. Reset followign flags or fields data: QTY_OPEN = 1, DISTRIB_LN_STATUS = 'O', QTY_OPEN_STD = 1
b. QTY_OPEN > 0 or AMT_OPEN > 0 (depends on if the requisition is distributed by quantity or amount)

No comments:

Post a Comment