SAP Knowledge Base Article - Public

2569205 - OAuth Token Server details

Symptom

Are the OAuth Token Server details stored in any database table which can be referenced?

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions

Resolution

Client Secrets are not stored in the database.

As the description within the OAuth Token Server tab indicate, these details are not recorded anywhere.
The secret key is not stored, so if you lose it, you need to generate another.
When you navigate away from OAuth Token Server page, the secret may disappear from the page.

OAuth Token Server.jpg

For Admin based client secrets:
The hashed value will be stored in PA_USER_PRFL in these 2 columns:(in case you would need to track when it changed and by whom)

  • OAUTH_USER_CLIENT_SECRET_HASH = This column stores Hash for OATH key
  • PASS_RST_TOKEN_HASH = This column stores the hash of the password reset token

For Application based client secrets:

The hashed value will be stored in PA_APP_ADMIN table in the DATA_FLD_1 column

  • OAUTH_TOKEN_SERVER_CLIENT_SECRET_HASH = the APP_ADMIN_ID

Keywords

SAP, SF, SuccessFactors, HCM, LMS, Learning, OAuth Token Server, database, database table, stored, recorded, client, secret, admin , KBA , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-PRD , Plateau Report Designer , LOD-SF-LMS-ODA , LMS Web Services OData , How To

Product

SAP SuccessFactors Learning all versions