'IDN_OAUTH2_ACCESS_TOKEN_AUDIT' Table contains columns with different time zones

[sanethmaduranga]

Description

With the revocation of the access tokens, the tokens are moved to the 'IDN_OAUTH2_ACCESS_TOKEN_AUDIT' table.

1. It contains 'TIME_CREATED' and 'REFRESH_TOKEN_TIME_CREATED' columns are in the UTC/GMT timezone while the 'INVALIDATED_TIME' column is in the timezone of the key manager component. (Eg: IST)

Steps to Reproduce

• Create an application.
• Generate keys for the same application(consumer key and consumer secret).
• Generate an access token.
• Revoke the same access token and check the 'IDN_OAUTH2_ACCESS_TOKEN_AUDIT' table from the 'APIM_DB' database.

Affected Component

APIM

Version

4.0.0

Environment Details (with versions)

No response

Relevant Log Output

No response

Related Issues

No response

Suggested Labels

APIM-4.0.0