POZ_SUPP_RISK_PROFILE

This table stores one row per Supplier Risk Analyst run version. Overall display and reporting attributes are stored in relational columns, while the complete rich payload remains in AGENT_RESPONSE_JSON.

Details

• Schema: FUSION

• Object owner: POZ

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
POZ_SUPP_RISK_PROFILE_PK	RISK_PROFILE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RISK_PROFILE_ID	NUMBER		18	Yes	Supplier risk profile identifier.
REGISTRATION_REQUEST_ID	NUMBER		18		Supplier registration request identifier.
VENDOR_ID	NUMBER		18		Supplier identifier when a supplier record exists.
VERSION_NUM	NUMBER		9	Yes	Version number for the generated supplier risk profile.
STATUS	VARCHAR2	30		Yes	High-level processing status of the agent run.
STATUS_CODE	VARCHAR2	60		Yes	Technical/debug code for the agent run, used to identify the processing stage or failure point.
SCORE	NUMBER		5		Overall supplier risk score returned by the agent.
MAX_SCORE	NUMBER		5		Maximum possible score scale for the agent run.
RISK_LEVEL_CODE	VARCHAR2	30			Overall risk level code, such as LOW, MEDIUM, or HIGH.
SUMMARY	VARCHAR2	4000			Overall risk summary used in approval flows and OTBI reporting.
AGENT_RESPONSE_JSON	CLOB				Complete supplier risk agent response payload in JSON format.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table	Foreign Table	Foreign Key Column
POZ_SUPP_RISK_PROFILE	poz_suppliers	VENDOR_ID
POZ_SUPP_RISK_PROFILE	poz_supplier_registrations	REGISTRATION_REQUEST_ID
poz_supp_risk_prof_categories	poz_supp_risk_profile	RISK_PROFILE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
POZ_SUPP_RISK_PROFILE_N2	Non Unique	Default	VENDOR_ID
POZ_SUPP_RISK_PROFILE_U1	Unique	Default	REGISTRATION_REQUEST_ID, VERSION_NUM
POZ_SUPP_RISK_PROFILE_PK1	Unique	Default	RISK_PROFILE_ID