Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

Is it possible to "undistribute" transaction rows in PROJ_RESOURCE that are flagged as Distributed t

edited Aug 14, 2019 8:57PM in Enterprise Service Automation (ESA) - PSFT (MOSC) 10 commentsAnswered ✓

We are on PS 9.2.19, PT 8.54

We have several hundred transaction rows in PROJ_RESOURCE that were incorrectly selected to be assigned to an asset via Manual Capitalization. They have not been sent to AM yet, but the rows have AM_DISTRIB_STATUS = 'D'.

I verified that the rows have not been pushed to AM via:

select * from ps_intfc_fin where project_id = '10023255' and system_source = 'BPC';

-- 0 row returned.

select * from ps_intfc_phy_a where project_id = '10023255' and system_source = 'BPC';

-- 0 rows returned.

select * from ps_proj_am where project_id = '10023255';

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