1. Tables and Views for Sales, Fusion Service, and Field Service
  2. FFS_APPLICATION

FFS_APPLICATION

Contains applications to be used to access API.

Details

  • Schema: FUSION

  • Object owner: FFS

  • Object type: TABLE

  • Tablespace: DATA

Primary Key

Name Columns

FFS_APPLICATION_PK

APP_ID

Columns

Name Datatype Length Precision Not-null Comments
APP_ID NUMBER 10 Yes Unique identifier of the application.
NAME VARCHAR2 1020 Application name. Used as application label for binding application with plugins, properties, etc.
STATUS VARCHAR2 8 Application status. Possible values - 'active', 'inactive'.
CLIENT_ID VARCHAR2 1020 Application ID. Used as username in HTTP Basic auth.
CLIENT_SECRET VARCHAR2 255 Application secret. Used as password in HTTP Basic auth.
REALM VARCHAR2 8 All applications migrated from user types or newly created ones belong to customer realm. Internal realm is reserved for OFSC built-in services, for example Mobility Position Upload.
TOKEN_SERVICE VARCHAR2 8 Which token service is used to get access tokens for the application to auth.
ACCESS_TOKEN_CERT VARCHAR2 4000 X.509 certificate used by OFSC token service to authenticate external IdP (IdP public key).
ASSERTION_CERT VARCHAR2 4000 X.509 certificate used by OFSC API to authenticate application (application public key).
TOKEN_EXPIRE_TIME NUMBER 10 Yes Seconds. Tokens issued using this app, will expire after this time.
DISPLAY_PROFILE_ID NUMBER 10 Yes FK display_profile.profile_id. Define application layouts.
WHITE_LIST VARCHAR2 4000 Restrict the list of IP adressess from which application is allowed to auth in OFSC. If empty - allow access from any IP. Same format as login_policy.white_list. Newline-separated list.
APPLICATION_COMMENT VARCHAR2 1020 Optional comment which describes the purpose of the application.
USER_ID NUMBER 18 FK security_user.uid. Internal user used by application for the puprose of logging.
CORS_DOMAIN_LIST VARCHAR2 1020 Contains list of domain names separated by newline, e.g. 'https://my.cors.host.com.nz<NL>https://example.com'.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
FFS_APPLICATION_PK Unique DATA APP_ID
FFS_APPLICATION_U1 Unique DATA CLIENT_ID