The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How is the sequence number (AUDIT_EVENT_ID column) generated on the ITG_AUDIT_EVENTS table?

Highlighted
Roger Ares
Occasional Advisor

How is the sequence number (AUDIT_EVENT_ID column) generated on the ITG_AUDIT_EVENTS table?

Can anyone tell me how the sequence number for the AUDIT_EVENT_ID column on ITG_AUDIT_EVENTS table is generated in PPM 9.12?  I found an Oracle sequence called ITG_AUDIT_EVENTS_S, however this sequence does not appear to be the sequence that is being used to generate the values in the AUDIT_EVENT_ID column, because the numbers being populated in the column are much higher than the nextval of that sequence.  Any assistance would be much appreciated.

 

Roger

1 REPLY
Jason Nichols K
Honored Contributor

Re: How is the sequence number (AUDIT_EVENT_ID column) generated on the ITG_AUDIT_EVENTS table?

According to the 9.13 Data Model Guide, that's the correct sequence for that table.
//Add this to "OnDomLoad" event