FOS_SYSTEM_OPTIONS

FOS_SYSTEM_OPTIONS contains the parameters you define for operating Supply chain Financial Orchestration. This table contains only one row. This table is used for getting runtime data.

Details

• Schema: FUSION

• Object owner: FOS

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
FOS_SYSTEM_OPTIONS_PK	SYSTEM_OPTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SYSTEM_OPTION_ID	NUMBER		18	Yes	Key used to identify a system option.
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.
VALIDATION_ORGANIZATION_ID	NUMBER		18		Item Validation Organization used for agreement identification and task layer.
NATIVE_SYSTEM_CODE	VARCHAR2	30			Native System's Code referred from HZ_ORIG_SYSTEM_B.
NATIVE_SYSTEM_ID	NUMBER		18	Yes	Native System's ID referred from HZ_ORIG_SYSTEM_B.
SERVICE_ITEM_ID	NUMBER		18		Item used in task layers as Documents like PO may not have items for services.
PAYLOAD_SIZE	NUMBER		18		Maximum number of records processed in event enrichment and orchestration.
MULTI_FTR_FLAG	VARCHAR2	1		Yes	A flag to indicate if multiple financial trade relationships can exist for a single primary trade relationship or not.
TRA_TAX_FLAG	VARCHAR2	1		Yes	A flag to indicate if taxes need to be calculated for Trade Receipt Accrual Transaction.
IGNORE_BILL_ONLY_FLAG	VARCHAR2	1			Indicates whether or not to ignore all the fulfillment line close events for bill only sales order lines.
PROCESS_RMA_AS_UNREF_FLAG	VARCHAR2	1			Flag that captures if referenced returns should be processed as unreferenced when a forward flow doesn't exist in SFO
PARTY_TAX_REGN_OVERRIDE_FLAG	VARCHAR2	1		Yes	A flag to indicate if the first and third party tax registration from financial route will be passed to AR and AP invoices and the value for tax determinant coming from the Receipt or Shipment transaction will be ignored or not.
DESC_GPO_SERVICE_ITEM_FLAG	VARCHAR2	1			A flag to indicate if service item should be considered for descriptive global purchase order processing.
ENTERPRISE_ID	NUMBER		18	Yes	Identifier of Enterprise, used for multi-tenancy partitioning.
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
FOS_SYSTEM_OPTIONS_U1	Unique	Default	SYSTEM_OPTION_ID
FOS_SYSTEM_OPTIONS_U2	Unique	Default	NATIVE_SYSTEM_ID