Projects - EBS (MOSC)

MOSC Banner

Historical Funding Patterns and Distribution Values in GMS

edited Aug 26, 2016 12:23PM in Projects - EBS (MOSC) 4 commentsAnswered

I am creating a report to identify transactions and their original funding pattern IDs and distribution values.   I would like to capture the information from the GMS_DISTRIBUTION_DETAILS table.

In AP, when the user distributes the award, the transaction and the funding pattern ID is stored in the GMS_DISTRIBUTION_DETAILS table, but it is immediately deleted when another award is distributed.  It appears the "delete" is based on the GMS_AWARD_DIST_ENG. (Award Distribution functionality).  I am not too sure why.  Why? 

If they delete the transaction in the GMS_DISTRIBUTION_DETAILS table, I was hoping it is stored in the GMS_AWARD_DISTRIBUTIONS. 

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