Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Transactional Business Intelligence Idea Lab

Reporting on Commitments for History and Auditing

Submitted

Views

Comments

Chris Pfeifer Rank 5 - Community Champion

Jul 7, 2023 8:18PM in Oracle Transactional Business Intelligence Idea Lab

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?

Tagged:

1 votes