Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

Unique Constraint on AFUDC Calculation

edited Oct 21, 2015 10:00AM in Enterprise Service Automation (ESA) - PSFT (MOSC) 1 commentAnswered

When calculating AFUDC in Project Costing, a unique constraint error is occurring because an erroneous deptid was added to a journal in GL.  The functional fix would be to reverse the journal entry and re-enter the journal with the correct ChartFields.  Unfortunately, this correction seems to only continue the error.  The app-engine, PC_INTEREST, in Section: 10000000, Step: INSERT1, Action: SQL, builds a temporary table based on "A.PROJECT_ID %Concat A.ACTIVITY_ID %Concat A.BUSINESS_UNIT_GL %Concat A.CALC_TYPE".  On the surface this appears as fine, but any error in other 'required' ChartFields used by the business will create a unique constraint error that can only

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