1. Tables and Views for SCM
  2. CSE_ASSETS_GT_DEBUG

CSE_ASSETS_GT_DEBUG

This debug table catures the global temporary table data that is used in the processing for genealogy integration.

Details

  • Schema: FUSION

  • Object owner: CSE

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CSE_ASSETS_GTD_PK

GTT_ASSET_ID, DEBUG_STAGE

Columns

Name Datatype Length Precision Not-null Comments Status
GTT_ASSET_ID NUMBER 18 Yes The internal primay key to be used in the current session for the asset that is to be processed.
DEBUG_STAGE VARCHAR2 30 Yes The stage when the debugging is triggered. It is a free format developer handle.
API_NAME VARCHAR2 120 The api from where the debugging is initiated.
PARENT_GTT_ASSET_ID NUMBER 18 Reference to an in process asset that is also avaialble in this session.
GTT_TXN_ID NUMBER 18 The transaction reference of the asset that is being processed in this same session.
GTT_REF_DOC_ID NUMBER 18 A recerence document identifier of the asset.
GTT_SRC_DOC_ID NUMBER 18 A source document identifier of the asset.
GTT_GROUP_ID NUMBER 18 The group id that groups the assets that is being processed in this session.
TRANSACTION_QTY NUMBER The transaction quantity of the asset.
QTY_PER_PARENT NUMBER The quantity per parent. This is used in the sales order fulfillment processing.
ASSET_TRACKED_FLAG VARCHAR2 1 The asset tracked flag from the item master, denormalized here for processing.
ENABLE_GENEALOGY_TRACKING_FLAG VARCHAR2 1 The genealogy tracking flag from the item master, denormalized here for processing.
PRIMARY_UOM_CODE VARCHAR2 3 The primary unit of measure code from the item master, denormalized here for processing.
ASSET_ID NUMBER 18 Unique identifier and Primary Key for the asset. System Generated using the Fusion Global Unique ID generator
ASSET_OVN NUMBER 9 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.
ASSET_NUMBER VARCHAR2 80 An user identifier for the asset object. This is the user primary key for the asset. If user does not enter a value then it is system generated using the Asset Document Number Sequence.
ASSET_TAG VARCHAR2 240 Asset Tag. This is an additional way of identifying the asset.
BOM_ITEM_TYPE NUMBER The bom item type as defined in the item master, denormalized here for processing.
PICK_COMPONENTS_FLAG VARCHAR2 1 The pick components flag as defined in the item master.
REPLENISH_TO_ORDER_FLAG VARCHAR2 1 The replenish to order flag as defined in the item master.
ITEM_ID NUMBER 18 Item identifier of the asset that is being processed.
ITEM_ORGANIZATION_ID NUMBER 18 The organization id where this product instance is instantiated. This is usually the context organization when done from the workarea landing page. However transactional instantians will inherit the organization context of the transaction.
ITEM_REVISION VARCHAR2 18 The current revision of the product. As captured from the latest transaction.
SERIAL_NUMBER VARCHAR2 80 The Serial Number of the product. Which uniquely identifies the product instance that is either manufactured as an end assembly product or as components bought from the supplier.
LOT_NUMBER VARCHAR2 80 The unique lot number at the product instance level that tracks the batch of assemblies that are manufactured or procured from supplier.
GEN_OBJECT_ID NUMBER 18 Genealogy Object Identifier. The foreign key to the genealogy object.
QUANTITY NUMBER Product Instance Quantity. It is always 1 for the serialized product instance. For the lot, it is the lot quantity at the tracked location.
UOM_CODE VARCHAR2 3 The primary unit of measure that tracks the product instance quantity.
SECONDARY_QUANTITY NUMBER This is the secondary quantity captured when the item supports dual units of measure.
SECONDARY_UOM_CODE VARCHAR2 3 The unit of measure code for the secondary quantity. This is captured only when the item supports dual units of measure.
STATUS_CODE VARCHAR2 30 The status of the Asset. Product instance when tracked in the Inventory or WIP location may not have a status to be tracked.
ACTIVE_END_DATE TIMESTAMP The date when the asset is to be terminated or end dated.
CURRENT_LOCATION_CONTEXT VARCHAR2 80 The current location context. This identifies the asset being located in the work center, inventory, wip job or in a customer location.
CURRENT_LOCATION_ID NUMBER 18 Current Location Identifier. The address location identifier.
LOCATION_ORGANIZATION_ID NUMBER 18 The organization id where the asset is located now. This works in conjunction with the other location columns like the work_center_id and the subinventory and locator.
SUBINVENTORY_CODE VARCHAR2 30 Subinventory Identifier. The inventory warehouse location.
INVENTORY_LOCATOR_ID NUMBER 18 The inventory item locator identifier. Unique locator in the subinventory.
WORK_ORDER_ID NUMBER 18 Work Order Reference when the component is issues to the work order.
WORK_ORDER_OPERATION_ID NUMBER 18 Work Order Operation Identifier for Work Order based processing.
WORK_CENTER_ID NUMBER 18 Work Center Identifier. The foreign key to the work center entity.
PARTIALLY_FINISHED_FLAG VARCHAR2 1 Flag indicating whether the assembly serail is still a partially finished assembly.
UNASSIGNED_FLAG VARCHAR2 1 A flag that indicates whether the asset is assigned to the parent during the manufacturing process.
SORDER_SOURCE_SYSTEM_TYPE VARCHAR2 30 The sales order source system where the order is captured..
SALES_ORDER_SOURCE_SYSTEM VARCHAR2 30 The source sales order system from which the order is captured.
SALES_ORDER_NUMBER VARCHAR2 120 The user key to the sales order business object
SALES_ORDER_ID NUMBER 18 Sales Order Identifier. Foreign key to the FOM Sales Order Entity.
SALES_ORDER_LINE_NUMBER VARCHAR2 120 The user key to the sales order lines entity.
SALES_ORDER_LINE_ID NUMBER 18 Sales Order Line Identifier. Foreign key to the FOM Sales Order Lines entity.
FULFILL_LINE_ID NUMBER 18 The distributed order orchestration fulfillment line reference.
OM_MAP_ID NUMBER 18 The mapping identifier from the user configured service map for processing asset data from order fulfillments.
PARENT_FULFILL_LINE_ID NUMBER 18 The parent fulfillment line reference in the context of the asset that was fulfilled by distributed order orchestration's fulfillment line.
ROOT_PAR_FULFILL_LINE_ID NUMBER 18 The root parent fulfillment line identifier.
PARENT_ORDER_LINE_NUMBER VARCHAR2 120 The order line number of the parent order line. When assets are created from om integration, the parent order line reference is provided, we capture that against the asset.
PARENT_ORDER_LINE_ID NUMBER 18 The order line identifier of the parent order line. When assets are created from om integration, the parent order line reference is provided, we capture that against the asset.
RMA_SOURCE_SYSTEM_TYPE VARCHAR2 30 The return order source system type where the return order is captured.
RMA_ORDER_SOURCE_SYSTEM VARCHAR2 30 The return order source system where the order is captured.
RMA_ORDER_NUMBER VARCHAR2 120 The return sales order number from the order capture system.
RMA_ORDER_ID NUMBER 18 The return sales order identifier from the capture system.
RMA_ORDER_LINE_NUMBER VARCHAR2 120 The return sales order line number from the capture system.
RMA_ORDER_LINE_ID NUMBER 18 The return sales order line identifier from the capture systekl.
RMA_FULFILL_LINE_ID NUMBER 18 The return sales order fulfillment line identifier.
RMA_PAR_FULFILL_LINE_ID NUMBER 18 The return sales oder fulfillment line identifier's parent.
RMA_ROOT_PAR_FULFILL_LINE_ID NUMBER 18 The root parent fulfillment line identifier of the return sales order fulfillment line.
RMA_PAR_ORDER_LINE_NUMBER VARCHAR2 120 The parent line of the return sales order line.
RMA_PAR_ORDER_LINE_ID NUMBER 18 The parent line identifier of the return sales order line.
INSTALLED_LOCATION_CONTEXT VARCHAR2 80 The installed location context. The type of location where the asset is installed.
INSTALLED_LOCATION_ID NUMBER 18 Installed Location Identifier. Foreign key to either the hr location or hz location.
SHIPMENT_DATE DATE Date when the asset is shipped to the customer.
INSTALLED_DATE DATE Date when the asset is installed.
IN_SERVICE_DATE DATE Date when the asset is placed in service.
PURCHASE_DATE DATE Procurement Date. Date when the asset is procured from the Supplier.
ORIGINATION_DATE TIMESTAMP The original creation date of the Lot Number or Serial Number.
SOLD_BY_BUSINESS_UNIT_ID NUMBER 18 Sold By Business Unit Identifier. This is usually populated from the order fulfillment flow.
REGISTERED_FLAG VARCHAR2 1 Flag to indicate if the customer asset is registered or not.
CUSTOMER_ASSET_START_DATE TIMESTAMP The date when the customer asset was instantiated. Either during the creation of the asset when the item was set to track customer assets only or updated to the customer asset when the item is enabled for lifecycle tracking.
CUSTOMER_ASSET_END_DATE TIMESTAMP The date when the asset is no longer a customer asset. Either during the return of the asset back to the enterprise for good or when manually terminated from being a customer asset.
CUSTOMER_ID NUMBER 18 Customer Identifier. This is the sold to party id for which the asset is sold to. Sales order issue inventory transaction populates this value by reading this from the shipping details table.
CUSTOMER_SITE_PARTY_ID NUMBER 18 The ship to party identifier captured at ths shiment transaction.
CUSTOMER_SITE_ID NUMBER 18 Customer Site Identifier. This is the ship to party site id of the customer that bought the customer asset.
CUSTOMER_BILLING_PARTY_ID NUMBER 18 The billing party identifier of the customer.
CUST_BILLING_PARTY_SITE_ID NUMBER 18 Customer's billing party site identifier.
CUSTOMER_ACCOUNT_ID NUMBER 18 The billing customer account identifier.
CUSTOMER_ACCOUNT_SITE_ID NUMBER 18 The customer account site identifier.
CUST_ACCOUNT_SITE_USE_ID NUMBER 18 Customer's account site use identifier.
SUPPLIER_ID NUMBER 18 Supplier Identifier. The supplier from whom the asset was purchased.
SUPPLIER_SITE_ID NUMBER 18 Supplier Site Identifier. The primary key of the supplier site.
NEW_WO_ALLOWED_FLAG VARCHAR2 1 This flag denotes whether the asset is maintainable or not. When the asset is not maintainable (New WO Allowed Flag = 'N'), a new work order cannot be created for the asset.
DFLT_WO_TYPE VARCHAR2 30 The work order type captured at the asset for the purpose of defaulting in the work order when created.
DFLT_WO_SUB_TYPE VARCHAR2 30 The work order sub type captured at the asset for the purpose of defaulting in the work order when created.
MAINTAINABLE_FLAG VARCHAR2 1 Flag indicating whether the asset is used to drive maintenance management functions.
OWNED_BY VARCHAR2 1 Who is the owner of the asset. Values are 'E' for Enterprise and 'C' for Customer.
USED_BY VARCHAR2 1 Who is the user of the asset. Values are 'E' for Enterprise and 'C' for Customer.
LOGICAL_FLAG VARCHAR2 1 Flag to indicate if this asset is for the purpose of logically grouping the tangible or software assets underneath the option class or model to project a sales view of the asset tree. More specifically to present the "As Sold" view.
REGISTRATION_DATE DATE Date when the asset is registered as a customer asset.
SPLIT_FROM_ASSET_ID NUMBER 18 For non serial assets, when assets are split during partial return, the new asset created with the remaining quantity will have the split from asset reference.
SHIPMENT_ID NUMBER 18 From Outbound Shipments, the delivery_id is captured in this. From Inbound Receipts, the shipment_lind_id is captured here. This is an internal column used for processing.
EXTERNAL_LOCATION VARCHAR2 240 An external location which is defined in the third party system and is not a defined location either in TCA or HR fusion system is captured in this column. A free format non translatable value is captured.
CURRENCY_CODE VARCHAR2 15 currency code for the extensibility
CORP_CURRENCY_CODE VARCHAR2 15 corporate currency code for extensibility
CURCY_CONV_RATE_TYPE VARCHAR2 30 currency conversion rate type for extensibility
IOT_ENABLED_FLAG VARCHAR2 1 This flag indicates whether the asset is enabled to be synced to the IOT application. IOT enabled assets will be automatically synced to the IOT application when the SCM cloud env is wired to the native Oracle Asset Monitoring IOT app.
BOM_EXPLOSION_FLAG VARCHAR2 1 This flag indicates whether this root asset is exploded to create the component assets using the primary item structure of the item at the root asset. This flag is only applicable at the root asset.
COMPONENT_SEQUENCE_ID NUMBER 18 The Bill Of Material Compenent Sequence Identifier. This will be populated when component assets are created using a bom explosion.
QUANTITY_PER_ASSEMBLY NUMBER When this asset is created as a component asset as part of BOM explosion, the quantity per assembly from the item structure is captured here. Asset will be created with the extended quantity for the item structure component.
EXT_SYSTEM_PACKING_UNIT VARCHAR2 150 The external system packing unit.
DESCRIPTION_ASSET_FLAG VARCHAR2 1 Flag indicating whether the asset created is based just on the description and not an item or product. It is a free format way of defining an asset by not associating it to a product.
COMPETITOR_ASSET_FLAG VARCHAR2 1 Flag indicating that this asset is created in the repository just as a competitor asset to aid in the cross selling and up selling functional flows in CRM.
RETURN_ORDER_ID NUMBER 18 The return order header identifier. Populated internally by the rma receiving transaction.
RETURN_ORDER_LINE_ID NUMBER 18 The return order line identifier. Populated internally by the rma receiving transaction.
RETURN_ORDER_FULFILL_LINE_ID NUMBER 18 The return order fulfillment line identifier. Populated internally by the rma receiving transaction.
ASSET_QTY NUMBER Asset Quantity. This is an interim column used in the processing logic.
SPLIT_FROM_GTT_ASSET_ID NUMBER 18 The split from asset id that is recorded in the interim session based processing.
ACTION_CODE VARCHAR2 120 The action code as identified by the preprocessor.
SERIAL_CONTROL_CODE NUMBER The serial control policy of the item, denormalized here for processing.
LOT_CONTROL_CODE NUMBER The lot control policy of the item, denormalized here for processing.
ITEM_SUB_TYPE_CODE VARCHAR2 120 The item sub type code as derived by the fulfillment engine.
LINE_TYPE_CODE VARCHAR2 120 The sales order line type code to identify if the sales order is outbound or inbound.
SRC_DEST_TYPE_CODE VARCHAR2 1 The flag indicating whether the temp asset is used as a source asset or destination asset.
FOREIGNKEY_GTT_ASSET_ID NUMBER 18 A reference to another asset that is being processed in this session.
CONFIG_INVENTORY_ITEM_ID NUMBER 18 Configured Item's identifier which is captured in the ATO flow.
MATCH_FOUND VARCHAR2 1 This flag indicates whether a match is found already or not.
SHIPMENT_NUMBER VARCHAR2 30 The shipment number that is used as the handle in the movement of products from one organization to another using an intransit stop.
TRANSACTED_ASSET_ID NUMBER 18 The foriegn key to the intersection entity cse_transacted_assets. This entity is a many to many entity that links transactions and assets.
EVENT_RAISED_FLAG VARCHAR2 1 Flag indicating whether an asset event was raised or not.
CONFIGURATOR_PATH VARCHAR2 2000 Configurator runtime representation of the Inventory Item Id path to the component. Path format is "." Separated inventory item id. For multi-instantiable components instances are denoted by [<instance number>].
CONFIG_HEADER_ID NUMBER 18 Header identifier of the configuration.
CONFIG_REVISION_NUMBER NUMBER 18 Revision number of the configuration.
CRITICALITY_CODE VARCHAR2 30 The criticality of the asset. Maintenance activities and performance metrics are defined based on the criticality of the asset.
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Code for the country of manufacture used to stripe Inventory transactions
INV_PROJECT_ID NUMBER 18 Identifier of the project used to stripe Inventory transactions Active
INV_TASK_ID NUMBER 18 Identifier of the task used to stripe Inventory transactions Active
INV_STRIPING_CATEGORY VARCHAR2 40 Segment used to identify the descriptive flexfield application context for Inventory striping attributes
INV_RESERVED_ATTRIBUTE1 VARCHAR2 150 Reserved for future Inventory striping related functionality
INV_RESERVED_ATTRIBUTE2 VARCHAR2 150 Reserved for future Inventory striping related functionality
INV_USER_DEF_ATTRIBUTE1 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE2 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE3 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE4 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE5 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE6 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE7 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE8 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE9 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE10 VARCHAR2 150 Reserved for user-definable Inventory striping information
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
CSE_ASSETS_GTD_U01 Unique Default GTT_ASSET_ID, DEBUG_STAGE