Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 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