Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Reporting on Commitments for History and Auditing
Chris Pfeifer
Rank 5 - Community Champion
Need to be able to report on historical commitments (including internal/external and requisitions) at any point in time.
Per research the PJC_COMMITMENT_TXNS is a transitory table and does not keep commitment information once the commitment has been lifted.
Need to find subject area(s) and/or tables can be used to create reports that answer these questions:
What audit tables keep the history of changes to this table (PJC_COMMITMENT_TXNS)?
What were my commitments at the end of last year?
Where do I see the history of commitment transactions?
1