Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 20 Oracle Analytics Lounge
- 247 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 91 Oracle Analytics Trainings
- 16 Oracle Analytics and AI 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