Supply Chain Management - PSFT (MOSC)

MOSC Banner

Orphan PO distribution lines in PO_LINE_DIST_NP

edited Sep 27, 2019 5:09AM in Supply Chain Management - PSFT (MOSC) 5 commentsAnswered

Our sales tax configuration is Non Prorated and we are seeing this issue currently that PO_LINE_DIST_NP table has extra rows for PO distribution lines (and with budget status ="Bypass") that don't exist in PO_LINE_DISTRIB. We suspect that this might trigger when user deletes a distribution lines and switches between sales tax applicability of a line(Makes it tax exempt from tax applicable) but I couldn't replicate it. Has anyone encountered it or any insights?

we are using below sql to identify impacted data -

select * from ps_po_line_dist_np A JOIN PS_PO_HDR B ON A.PO_ID=B.PO_ID where A.budget_line_status = 'B' AND A.DST_ACCT_TYPE = 'STX' AND (A.PO_ID, A.LINE_NBR,A.DISTRIB_LINE_NUM) NOT IN (

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center