A Appendix: Oracle APEX

This section covers the following topics:

• What is Oracle APEX?

• Suggested APEX Usage in Store Inventory Operations Cloud Service

• APEX Users, Administration

• EICS Specific Configuration

• Database Objects

What is Oracle APEX?

Oracle Application Express (abbreviated APEX, previously named Oracle HTML DB) is a web-based software development environment that runs on an Oracle database. Application Express is a minimal code web application development tool for the Oracle database which enables end users to design, develop and deploy visually pleasant, responsive, database-driven applications, either on-premises or in the cloud.

Using only a web browser and limited programming experience, a user can rapidly develop and deploy professional applications that are both fast and secure for any device from desktop to mobile. Oracle Application Express combines the qualities of a minimal code tool such as productivity, ease of use, and flexibility, with the qualities of an enterprise development tool such as security, integrity, scalability, availability and built for the web.

The following are just a few advantages for the customer using APEX:

• Easy to create mock-up screens using pre-built themes.

• Rich GUI components available for data representation.

• Scalable

• Easy to deploy and configure.

• HTML / Browser based database experience for end user.

Suggested APEX Usage in Store Inventory Operations Cloud Service

We suggest using Oracle APEX as a bolt-on piece so customers (that is, retailers) can browse the database for transactions and create their own reports, BI dashboards.

Oracle APEX components applicable to EICS includes:

• SQL Workshop

  This component allows a user to perform SQL operation on the database. Please refer to the SQL Workshop section for more details.

Note: APEX has other capabilities but those are not applicable for SaaS deployed products such as EICS.

SQL Workshop

The SQL Workshop provides tools that enable users to view database objects. Users can run queries on the database but will be restricted from running DDL and DML scripts on the EICS schema or creating any reference to the tables from EICS schema. This would be controlled via database privileges assigned to an APEX schema user. An APEX schema user will have only select privileges on the business / transaction tables of the EICS database schema.

The following key features are provided by this Oracle APEX component:

• Object Browser

  Object Browser enables a tree control to view object properties and create new objects.

• SQL Commands

  The SQL Commands tool enables a user to execute ad hoc SQL on the APEX schema.

• SQL Scripts

  SQL Scripts enables a user to store and run scripts on the APEX schema.

• Query Builder

  Query Builder enables a user to create join queries using drag and drop.

• Create Object Wizard

  Create object wizard provides a user-friendly interface for the user to create various database objects. This helps the user create tables, view, sequence, packages and so on, on the current APEX schema.

Figure A-1 SQL Workshop

APEX Users, Administration

There are three (3) types of users:

• Customer APEX Schema User

• APEX Administrator

• APEX Customer Admin/Developer

Customer APEX Schema User

This is the database schema (example RTLWS01) user that gets created when EICS is installed.

APEX has a concept of workspace to which the user logs in. To access the EICS tables there would be a schema user who has read only privileges on production and read/write privileges on non-production database tables listed in Table A-1.

This user will be configured on the workspace, so after the customers access APEX they can query the EICS database tables.

APEX Administrator

This user (APEXADMIN) gets created during APEX installation at the time of EICS provisioning.

This user is the Oracle Cloud Operations who will create a workspace and provision the initial Customer Admin user.

APEX supports SSO, however the user needs to be created within the application and should exist on LDAP as well (that is, authentication is external but authorization is internal).

This user will provide the necessary privileges to the customer users and block the unwanted features from APEX (REST Service, Team Development and so on.)

This user will be the sole admin user to manage the APEX configuration.

The user is responsible for the following:

1. Managing instance configuration.

2. Managing workspace creation and schema assignment.

3. Managing the customer service requests.

4. Monitoring the user activity if enabled.

5. Provisioning the user account.

On EICS APEX Installation, APEX Administrator will create a workspace and provision the APEX schema for the workspace which has been created via EICS database installer. The Administrator is required to provision users to have access to the workspace.

APEX Customer Admin/Developer

This user will be the customer service administrator who will get access to the RETAILWORKSPACE at the time of provisioning. This initial user will be required to login to the ORDS (Apex Data Viewer) URL (https://<eics_external_load_balanced_address>/ords) in order to add other customer users to the workspace.

This user can also query data / build reports and so on.

The user will not have access to any admin features of APEX. This role accesses SQL-Workshop component.

An APEX Administrator could:

1. Manage Instance

   Oracle Application Express instance level configuration will be available under this component. The following configurations can be configured under this component:

   • Feature Configuration

     Allows control of the feature components.

   • Security

     Allows setting of Security Configuration, Authentication Control, Password Policy and so on.

   • Instance Setting

     Allows setting instance level parameter that is, Storage Settings, Email, Report Printing.

   • Manage Logs and Files

     Manages logs and feature component user activity. These features will be disabled by default and need to be enabled if monitoring is required.

   • System Message

     Can set custom login messages for the user.

2. Manage Request

   This feature is used to authorize user's request for the account and workspace access.

3. Manage Workspace

   A workspace is a virtual private database allowing multiple users to work within the same Oracle Application Express installation while keeping their objects, data and applications private. Each workspace has a unique ID and name. An Oracle Application Express administrator can create a workspace manually or have users submit requests.

   On EICS APEX Installation, Administrator (Oracle Cloud Operations) will create a workspace and provision the APEX schema for the workspace which has been created via EICS database installer. The Customer Apex Administrator is required to provision users to have access to the workspace.

4. Monitor Activity

   This feature component allows the administrator to monitor user activity. The activity can be monitored for an application created by user, for a workspace or for specific days.

EICS Specific Configuration

The following configuration is required for the EICS APEX Environment.

Configuration Type	Configuration Name	Value
Manage Instance\Feature Configuration	Enable RESTful Services	No
Manage Instance\Feature Configuration	Enable Service Requests	No
Manage Instance\Feature Configuration	Enable Team Development's File Repository	No
Manage Instance\Security	Authentication Scheme	Single Sign On / LDAP
Manage Instance\Instance Setting	Auto Extend Tablespaces	No
Manage Instance\ Component Availability	Custom Create Workspace
Manage Workspaces\ Component Availability	Enable App Builder	No
Manage Workspaces\ Component Availability	Enable SQL Workshop	Yes
Manage Workspaces\ Component Availability	Allow PL/SQL Editing in SQL Workshop	Yes
Manage Workspaces\ Component Availability	Enable Team Development	No
Manage Workspaces\ Component Availability	Enable Packaged Application Installation	No

APEX, for example, RTLWS01

Database user who have READ privilege on EICS business data tables. The privileges granted to user: alter session, create session, create table, create view, create sequence, create procedure The EICS master schema objects access is granted to the objects directly instead of EICS data set role base of following reasons: The APEX database user needs to create views or stored procedures which requires grant read permissions to database objects owned by EICS master schema owner. For list of objects the user has access to, see SIM_BUSINESS Database Object List

Database Objects

The list of database objects available on APEX as synonyms to be used for querying on the Application Builder is shown below:

Tables

Table A-1 Tables

Name	Description
ACTIVITY_DELIVERY	This table holds store activity information for receiving.
ADDRESS	This table holds the various addresses for the entities that is, store, supplier, finisher and warehouse along with their types.
ARV_ACTIVITY_HIST	This table holds archived data from user activity table.
ARV_EXPORT	This table contains last export archive activity info.
ARV_ITEM_UIN_HIST	This table contains item UIN archived data.
ARV_RFID_HIST	This table contains RFID transactions archived data.
ARV_STORE_ITEM_STOCK_HIST	This table contains store item stock transaction archived data.
ARV_TICKET_HIST	This table contains ticket history archived data.
CODE_DETAIL	This table holds the defined available code along with their type descriptions that are used in the system.
CODE_TYPE	This table contains one row for each different set of codes used by the system. The specific codes are defined in the CODE_DETAIL table.
CUSTOM_ATT_ADMIN	This table contains the list of custom attributes configured for the transactions.
DELIVERY_SLOT	This table is delivery slot master table, values are from RMS. (Reserved for future use.)
DIFFERENTIATOR	This table will hold all possible sizes, size combinations, colors, flavors, scents, patterns, and so on, along with their associated NRF industry codes. For example, include blue for a differentiator type of color, large for a differentiator type of size, and lavender for a differentiator type of scent.
DIFFERENTIATOR_TYPE	This table holds the available differentiator types that an item can contain. For example, Size, Color, Scent, and so on.
DSD	This table holds one row for each direct supplier delivery (DSD) that is received in the system.
DSD_ADJUSTMENT	This table holds direct supplier delivery (DSD) adjustments.
DSD_CARTON	This table holds one row for each carton that a direct supplier delivery (DSD) contains.
DSD_CARTON_CDA	This table contains the values for the custom attributes associated to a vendor delivery carton.
DSD_CARTON_CFA	This table contains the list of custom flex attribute associated to the vendor delivery carton.
DSD_CDA	This table contains the values for the custom attributes associated to a vendor delivery.
DSD_CFA	This table contains the list of custom flex attribute associated to the vendor delivery.
DSD_LINE_ITEM	This table holds one row for each item that is in the carton of a direct supplier delivery (DSD).
DSD_LINE_ITEM_ATT	This table holds extended attributes associated to direct supplier delivery (DSD) line items.
DSD_LINE_ITEM_UIN	This table holds the specific UIN information associated with the direct supplier delivery (DSD) line items.
FUL_ORD	This table holds store fulfillment orders.
FUL_ORD_BIN	This table holds bins created for picks of store fulfillment orders.
FUL_ORD_CDA	This table holds the values for the custom attributes associated to a fulfillment order.
FUL_ORD_CFA	This table contains the list of custom flex attribute associated to the fulfillment order.
FUL_ORD_DLV	This table holds deliveries created for store fulfillment orders.
FUL_ORD_DLV_CDA	This table contains the values for the custom attributes associated to a fulfillment order delivery.
FUL_ORD_DLV_LINE_ITEM	This table holds the fulfillment order delivery line items.
FUL_ORD_DLV_LINE_ITEM_ATT	This table holds extended attributes associated to line items of deliveries for store fulfillment orders.
FUL_ORD_DLV_LINE_ITEM_UIN	This table holds the UINs of line items for deliveries of store fulfillment orders.
FUL_ORD_LINE_ITEM	This table holds store fulfillment order line items.
FUL_ORD_PICK	This table holds picks created for store fulfillment orders.
FUL_ORD_PICK_CDA	This table contains the values for the custom attributes associated to a fulfillment order pick.
FUL_ORD_PICK_LINE_ITEM	This table holds line items associated to a pick created for store fulfillment orders.
FUL_ORD_RV_PICK	This table holds reverse picks created for store fulfillment orders.
FUL_ORD_RV_PICK_CDA	This table contains the values for the custom attributes associated to a fulfillment order reverse pick.
FUL_ORD_RV_PICK_LINE_ITEM	This table contains line items associated to fulfillment order reverse picks.
GROUP_SCHEDULE_EXTRACT	This table holds the data populated via batch processes for today's process to do. The data will be cleared out at the end of the run.
INV_ADJUST	This table holds the inventory adjustment records.
INV_ADJUST_CDA	This table holds the values for the custom attributes associated to inventory adjustments.
INV_ADJUST_LINE_ITEM	The table holds the item associated to the inventory adjustments.
INV_ADJUST_LINE_ITEM_ATT	This table holds extended attributes associated to line items of inventory adjustments.
INV_ADJUST_LINE_ITEM_UIN	This table holds the UIN associated to inventory adjustments.
INV_ADJUST_REASON	This table holds the defined reason codes that are available for attaching to a stock inventory adjustment. Each reason code contains a disposition.
INV_ADJUST_TEMPLATE	The table holds defined the inventory adjustment templates.
INV_ADJUST_TEMPLATE_ITEM	This table holds the line item associated to the defined inventory adjustment templates.
ITEM	This table contains one record for each item defined for the company. It contains the base information for an item that is consistent across all locations.
ITEM_BASKET	This table stores data about Item Basket transactions.
ITEM_BASKET_CDA	This table contains the values for the custom attributes associated to an item basket.
ITEM_BASKET_HIERARCHY	This table holds one row for each level of the hierarchy that is assigned to the item basket.
ITEM_BASKET_LINE_ITEM	This table contains items on an Item Basket.
ITEM_CFA	This table contains the list of custom flex attribute associated to the item.
ITEM_COMPONENT	This table defines all the items contained within a simple or complex pack item. For a simple pack there will be only one record for the pack item listing its member item and a complex pack will have more than one record denoting pack component listing.
ITEM_DESCRIPTION	This table contains item descriptions and their associated locales. Item description for system integration locale is maintained in item table.
ITEM_HIERARCHY	This table holds merchandise hierarchy information.
ITEM_HIERARCHY_ATTRIB	This table holds extended attributes assigned to item hierarchies at a store.
ITEM_IMAGE	This table holds the item image information.
ITEM_PRICE	This table holds one row for each price change. These can either be created by EICS, if the store is allowed to control the pricing or they are loaded in from an external system (that is, RPM).
ITEM_PRICE_HISTORY	This table holds historical archive of the retail-selling unit price at which a given item is being sold.
ITEM_QR_CODE	This table contains the item QR code image information.
ITEM_UDA	This table holds all the User Defined Attribute (UDA) entries associated with a specific item.
ITEM_UIN	This is the primary UIN table holding detailed information about a specific UIN, most significantly its current status.
ITEM_UIN_HISTORY	This tables holds records of each alteration or action taken upon the ITEM_UIN table with basic auditing information added.
ITEM_UIN_PROBLEM	This table holds a list of UIN state transformations that failed for some reason. There is an old and new status to help determine what the issue is. This list can be viewed and updated in the UIN Resolution screen.
MPS_STAGED_MESSAGE	This table holds the staged inbound and outbound messages from and to external systems. Note: APEX limitation on CLOB columns: For clob column types, users need to write their query to display first 4000 characters. For example: [select id, business_id, DBMS_LOB.SUBSTR(MESSAGE_data,4000) as message_data, DBMS_LOB.SUBSTR(MESSAGE_ERROR,4000) as message_error from mps_staged_message;]
NONSELLABLE_TYPE	This table holds the non-sellable quantity types.
NOTES	This table holds user-defined notes for different transactions.
PARTNER	This table holds partner information.
PARTNER_ITEM	This table holds items at partner site.
POS_TRANSACTION	This table will hold the details of the POS transaction header and the line items in the transaction.
POS_TRANSACTION_LOG	This table holds the POS transaction processing logs.
PRICE_CHANGE_WORKSHEET	This is a working table that holds the new prices to be extracted into item price table.
PRODUCT_BASKET	This table stores data about product basket transactions.
PRODUCT_BASKET_STORE	This tables holds one record for each store that is assigned to the product basket.
PRODUCT_GROUP	This table holds all product groups that are created within the system. Product Groups are used to schedule events within the system that need to occur at certain times. Product Groups are used for item requests, stock counts (including unit, unit and amount and problem lines), replenishment and wastage.
PRODUCT_GROUP_HIERARCHY	This table holds one row for each level of the hierarchy that is assigned to the product group.
PRODUCT_GROUP_ITEM	This table holds one row for each item that has been added to the product group. It holds items that are added to the product group via the item, supplier or promotion options. For supplier and promotion (which is only used for item request type product groups), only those items that have a replenishment type of SO are added. For the item option, any item specified will be added to the product group.
PRODUCT_GROUP_SCHEDULE	This table holds the defined schedule for any product group of how often the batch program should process the items that belong to the product group.
PRODUCT_GROUP_SCHED_STORE	This table holds one record per store that belongs to the defined product group schedule.
PROD_GROUP_ITEM_BKDN	This is a temporary table that holds product group schedule items breakdown details defined by the product group schedule or product group hierarchy. It is used in product group related event generation.
PURCHASE_ORDER	This table holds one row for each purchase order per location that has been placed by the company. The purchase order may have been created via a merchandise system message or when a user starts to process a direct store delivery (DSD).
PURCHASE_ORDER_CFA	This table contains the list of custom flex attribute associated to the purchase order.
PURCHASE_ORDER_LINE_ITEM	This table holds items that are associated with respective purchase orders.
RELATED_ITEM	This table contains related item information.
RELATED_ITEM_TYPE	This table holds relationships of related items.
REPLENISH_GAP	This table holds one row per replenishment gap.
REPLENISH_GAP_CDA	This table contains the values for the custom attributes associated to a replenishment gap.
REPLENISH_GAP_LINE_ITEM	This table hold one row per item associated with replenishment gap.
RFID	This table holds the RFID information.
RFID_ADJUST	This table contains the RFID adjustment information.
RFID_HISTORY	This table contains the RFID history information.
RFID_ZONE	This table holds the RFID zone information.
RTV	This table holds header level information of a vendor return document.
RTV_CDA	This table contains the values for the custom attributes associated to a vendor return.
RTV_CFA	This table contains the list of custom flex attribute associated to the vendor return.
RTV_LINE_ITEM	This table hold one record per item associated with vendor return documents.
RTV_SHIP	This table holds one record of header level information for each RTV Shipment.
RTV_SHIP_CARTON	This table holds RTV Shipment Container associated with the respective RTV Shipment record.
RTV_SHIP_CARTON_CDA	This table contains the values for the custom attributes associated to a vendor shipment carton.
RTV_SHIP_CDA	This table contains the values for the custom attributes associated to a vendor shipment.
RTV_SHIP_LINE_ITEM	This table holds items associated with RTV shipment container per RTV shipment record.
RTV_SHIP_LINE_ITEM_ATT	This table holds extended attributes associated to line items of RTV shipment.
RTV_SHIP_LINE_ITEM_UIN	This table hold associated UIN records for each RTV Shipment line items.
SCAN_BLOCK	This table contains item scan block summary for associated transaction.
SCAN_BLOCK_ITEM	This table contains item detail of scanned items within a block.
SCAN_BLOCK_ITEM_ATT	This table contains extended attributes associated to an item of a scan block.
SCHEDULE_GROUP_ITEM	This is a temporary table that holds the items associated with the store product group schedule.
SEQUENCE_ADMIN	This table contains information about sequence settings for integration.
SHELF_ADJUST	This table holds one record for each shelf adjustment transaction.
SHELF_ADJUST_CDA	This table contains the values for the custom attributes associated to a shelf adjustment.
SHELF_ADJUST_LINE_ITEM	This table holds line item details of the items in a shelf adjustment list.
SHELF_REPLENISH	This table holds one record per shelf replenishment transaction.
SHELF_REPLENISH_BKDN	This table temporarily holds shelf replenishment item breakdown depending on the UI limit parameter.
SHELF_REPLENISH_CDA	This table contains the values for the custom attributes associated to a shelf replenishment.
SHELF_REPLENISH_LINE_ITEM	This table holds one record per item associated with respective shelf replenishment.
SHIPMENT_BOL	This table holds bill of lading records.
SHIPMENT_CARRIER	This table holds delivery carriers.
SHIPMENT_CARRIER_SERVICE	This table holds delivery service types.
SHIPMENT_CARTON_DIM	This table hold the delivery carton dimension information.
SHIPMENT_REASON	This table holds the shipment reasons.
SHIPMENT_WEIGHT_UOM	This table hold shipment weight UOM information.
STOCK_COUNT	This table will hold one row for each stock count in the system. It defines the stock count instances of a stock count schedule. These records are generated by the batch processes using the stock count schedules defined.
STOCK_COUNT_CDA	This table contains the values for the custom attributes associated to a stock count.
STOCK_COUNT_CHILD	This table holds a row for each location that is being counted for the stock count.
STOCK_COUNT_EXPORT	This table holds the stock count line item to be exported to external system.
STOCK_COUNT_IMPORT	This table holds the third-party file information for a third party stock count. The file must follow the RGIS file layout definition.
STOCK_COUNT_LINE_ITEM	This table holds the one record per line item counted on the respective stock count. Each row holds the complete details of the snapshot, counted, recounted (when applicable) and authorized quantities and timestamp.
STOCK_COUNT_LINE_ITEM_ATT	This table holds extended attributes associated to line items of stock counts.
STOCK_COUNT_LINE_ITEM_RFID	This table contains the RFID data for stock count line items.
STOCK_COUNT_LINE_ITEM_UIN	This table holds all the UINs that are assigned to a particular line item on a stock count. It also contains whether the UIN is counted, recounted, or authorized. It is de-normalized to include the UIN description for performance.
STOCK_COUNT_REJECTED_ITEM	This table contains rejected items from third party stock count.
STOCK_COUNT_SALE	This table will hold the details of the POS transaction header and the line items in the transaction with open stock counts.
STORE	This table holds defined stores within the organization that hold items.
STORE_AUTO_RECEIVE	This table holds mapping of defined stores that will automatically receive stock transfers in from another store.
STORE_GROUP	This table holds the mapping of buddy store relationship for all stores in the system.
STORE_ITEM	This table holds the items which are ranged to a store.
STORE_ITEM_CFA	This table holds the list of custom flex attribute associated to the item for the ranged store.
STORE_ITEM_STOCK	This table holds the current inventory numbers for items on a location basis. The types of inventory buckets that are held include available for sale, unavailable for sale, in transit, and reserved for a pending stock inventory event.
STORE_ITEM_STOCK_HISTORY	This table holds the store item stock transaction history.
STORE_ITEM_STOCK_NONSELL	This table holds non-sellable store item stock information.
STORE_ITEM_STOCK_PUBLISH	This table holds stock adjustment information for external messaging. Records are deleted when processed.
STORE_ORDER	This table contains store order header information.
STORE_ORDER_CDA	This table contains the values for the custom attributes associated to Store Order.
STORE_ORDER_CFA	This table contains store order custom flexible attribute information.
STORE_ORDER_LINE_ITEM	This table contains store order line item information.
STORE_PRINTER	This tables holds the associated printers with the retail stores in which the printers are installed.
STORE_SEQUENCE_AREA	This table holds a floor and an area on a floor inside a retail store that is explicitly identified for tracking inventory, sales activity and other business activities that are important to measuring a stores performance.
STORE_SEQUENCE_ITEM	This table defines a map of an item to a location and what order the item is in within the location.
STORE_SHIP_NETWORK	This table defines the stores that are excluded from shipping-to location for transfer documents and transfer shipments.
STORE_TRANSFER_ZONE	This table holds all transfer zones defined for a given company. Each store can be assigned one transfer zone which limits which locations can move inventory between them.
STORE_UIN_ADMIN_DEPT	This table holds the UIN specific attributes of an item at a store by department and class.
STORE_UIN_ADMIN_ITEM	This table holds all the UIN specific attributes of an item at a store (such as type and label). This overrides the values in STORE_UIN_ADMIN_DEPT table value.
SUPPLIER	This table holds all the external sources for merchandise items offered for sale for the company.
SUPPLIER_CFA	This table holds the list of flex attribute associated to the supplier.
SUPPLIER_ITEM	This table holds one row for each item/supplier combination within the system.
SUPPLIER_ITEM_CFA	This table contains the list of custom flex attribute associated to the item for supplier.
SUPPLIER_ITEM_COUNTRY	This table holds one entry for each country associated with an item/suppler. It is used to determine what the case size of an item will be for a particular supplier in the same country as the store.
SUPPLIER_ITEM_COUNTRY_DIM	This table holds dimensions for each item, supplier, supplier country and dimension object combination.
SUPPLIER_ITEM_MANUFACTURE	This table hold country of manufacture for a given item-supplier.
SUPPLIER_ITEM_UOM	This table holds the item supplier data. It also contains the suppliers UOM information.
SUPPLIER_ORGANIZATION	This table holds supplier organization information.
TICKET	This table contains tickets.
TICKET_EVENT	This table contains ticket events to generate tickets.
TICKET_FORMAT	This table contains ticket formats.
TICKET_FORMAT_BASKET	This table contains tickets format and item basket assignment information.
TICKET_FORMAT_BASKET_STORE	This table contains stores assigned to a ticket format and item basket assignment record.
TICKET_HISTORY_UDA	This table contains UDAs linked to the ticket item.
TICKET_HISTORY	This table contains ticket history data.
TICKET_ZPL	This table contains ticket formats.
TOLERANCE	This table holds one row for each ad hoc stock count that is initiated at a store.
TRANSLATION_DETAIL	This table will hold one row for each translated value in the system.
TRANSLATION_KEY	This table contains the list of text strings, keys that can be translated within the system.
TRANSLATION_LOCALE	This table contains one row for each language that the system can be translated into.
TRANSLATION_TEMP	This table is used to process translation.
TRAN_EVENT	This table contains transaction event header information.
TRAN_EVENT_ATTRIBUTE	This table contains transaction event attribute information. The attribute value will be populated depending on the associate transaction event type.
TRAN_EVENT_COMPONENT	This table contains components assigned to the transaction event information.
TRAN_EVENT_EXTRACT	Batch process will populate this table with today's process to do and will clear out at the end of the run.
TRAN_EVENT_ITEM_BKDN	Temporary table holds transaction event items breakdown details defined by the transaction event. This table is used in transaction event related batch generation.
TRAN_EVENT_STORE	This table contains transaction event store association information.
TSF	This table contains the transfer document which captures the request for a transfer to a store, warehouse, or finisher.
TSF_ALLOCATION	This table contains transfer stock allocated to the locations.
TSF_CDA	This table contains the values for the custom attributes associated to a transfer.
TSF_CFA	This table contains the list of custom flex attribute associated to the transfer.
TSF_DELV	This table hold one row for each transfer delivery transaction. The header level information for the delivery is captured on this table.
TSF_DELV_CARTON	This table holds one row for each transfer delivery carton received for the respective transfer delivery transaction record.
TSF_DELV_CARTON_CDA	This table contains the values for the custom attributes associated to a transfer delivery carton.
TSF_DELV_CARTON_CFA	This table contains the list of custom flex attribute associated to the transfer delivery carton.
TSF_DELV_CDA	This table contains the values for the custom attributes associated to a transfer delivery.
TSF_DELV_CFA	This table contains the list of custom flex attribute associated to the transfer delivery.
TSF_DELV_LINE_ITEM	This table holds one row for each item received on the containers associated to respective transfer delivery transactions.
TSF_DELV_LINE_ITEM_ATT	This table holds extended attributes associated to line items of transfer delivery transaction.
TSF_DELV_LINE_ITEM_UIN	This table holds UINs associated to line items of transfer delivery transaction.
TSF_LINE_ITEM	This table holds one row for each item associated with the transfer document.
TSF_SHIP	This table holds one row for each transfer shipment transaction. The header level information for the shipment is captured on this table.
TSF_SHIP_CARTON	This table holds one row for each transfer shipment carton to be shipped for the respective transfer shipment transaction record.
TSF_SHIP_CARTON_CDA	This table contains the values for the custom attributes associated to a transfer shipment carton.
TSF_SHIP_CDA	This table contains the values for the custom attributes associated to a transfer shipment.
TSF_SHIP_LINE_ITEM	This table holds one row for each item to be shipped on the containers associated to respective transfer shipment transactions.
TSF_SHIP_LINE_ITEM_ATT	This table holds extended attributes associated to line items of transfer shipment transaction.
TSF_SHIP_LINE_ITEM_UIN	This table holds UINs associated to line items of transfer shipment transaction.
UDA	This table holds all the User Defined Attributes (UDAs) available to items.
UDA_LOV	This table holds all valid values associated with a User Defined Attribute (UDA) of UDA Type of LOV (List of Value)
UIN_ATTRIBUTE_IMPORT	This table holds the UIN Attributes for store.
UIN_LABEL	This table holds all the labels that are available in the system for a UIN.
UOM_CLASS	This table is used to save all the uoms created in siocs. This table contains columns like uom, uom_class and uom_desc.
UOM_CONVERSION	This table holds all of the scientific conversions from one unit of measure to another within a class.
WAREHOUSE	This table holds warehouse information.
WAREHOUSE_ITEM	This table holds items ranged to a warehouse.
WAREHOUSE_VIRTUAL	This table contains all warehouses in the system, including virtual and physical warehouses.

Views

Table A-2 Views

Name	Description
CUST_ORDER_MGMT_LIST_V	This view load data for respective transaction which is been associated with store fulfillment order. Transaction queried for this view are DSD, Purchase Order, Transfer Receiving, Transfer, Transfer Shipment and Customer Order Delivery.
ITEM_DIFFERENTIATOR_V	This view loads one row for each item to which contains has associated differentiator data. All the differentiators for an item, its types and description are selected as a single row.
ITEM_HIERARCHY_ATTRIB_V	This view loads mapping of extended attribute to the item hierarchy.
ITEM_LIST_V	This view loads minimal or summary information for an item.
ITEM_PRICE_V	This view loads minimal or summary information about the price changes for an item.
ITEM_UDA_V	This view loads information for the user defined attribute (UDA) for an item.
LOCATION_V	This view loads data for all the location entity available in system that is, Supplier, Store, Warehouse and Finisher.
PRODUCT_GROUP_SCHEDULE_V	This view loads data containing Product Group Schedule information.
PROMOTION_V	This view loads data related to Price Promotion for each store.
RPRT_DSD_DISCREPANT_ITM_V	This view is used for populating the data on Direct Delivery Discrepant Items report.
RPRT_DSD_V	This view is used for populating the data on Direct Delivery Report.
RPRT_FUL_ORD_BIN_V	This view is used for populating the data on Customer Order Bin Label.
RPRT_FUL_ORD_DLV_BOL_V	This view is used for populating the data on Customer Order Delivery BOL Report.
RPRT_FUL_ORD_DLV_V	This view is used for populating the data on Customer Order Report.
RPRT_FUL_ORD_PICK_DISC_V	This view is used for populating the data on Customer Order Pick Discrepancy Report.
RPRT_FUL_ORD_PICK_V	This view is used for populating the data on Customer Order Pick Report.
RPRT_FUL_ORD_RV_PICK_V	This view is used for populating the data on Customer Order Reverse Pick Report.
RPRT_FUL_ORD_V	This view is used for populating the data on Customer Order Report.
RPRT_INV_ADJUST_V	This view is used for populating the data on Inventory Adjustment Report.
RPRT_ITEM_DETAIL_V	This view is used for populating the data on Item Detail Report.
RPRT_ITEM_ORDER_QTY_V	This view is used for populating the order quantities on Item Detail Report.
RPRT_PURCHASE_ORD_V	This view is used for populating the data on Purchase Order Report.
RPRT_REPLENISH_GAP_V	This view is used for populating the data on Scan List Report.
RPRT_RFID_HISTORY_V	This view is used for populating the data on RFID History Report.
RPRT_RTV_SHIP_BOL_V	This view is used for populating the data on RTV Shipment BOL Report.
RPRT_RTV_SHIP_V	This view is used for populating the data on RTV Shipment Report.
RPRT_RTV_V	This view is used for populating the data on RTV Report.
RPRT_SHELF_ADJUST_V	This view is used for populating the data on Shelf Adjustment Report.
RPRT_SHELF_REPLENISH_V	This view is used for populating the data on Shelf Replenishment Report.
RPRT_STOCK_COUNT_NOF_V	This view is used for populating the data on Stock Count Rejected Items Report.
RPRT_STOCK_COUNT_V	This view is used for populating the data on Stock Count related reports.
RPRT_STORE_ORDER_V	This view is used for populating the data on Store Order Report.
RPRT_TRANSFER_V	This view is used for populating the data on Transfer Report.
RPRT_TSF_DELV_V	This view is used for populating the data on Transfer Receiving related reports.
RPRT_TSF_SHIP_V	This view is used for populating the data on Transfer Shipment related reports.
STOCK_ITEM_V	The view selects required item related attribute and inventory information to which represent a complete Item.
STORE_AUTO_RECEIVE_V	This view loads the mapping for stores which are defined to auto receive the stock transfer from a give store.
STORE_GROUP_V	This view loads the buddy store related information.
STORE_SHIP_NETWORK_V	This view has details about store hipping network.
SUPPLIER_ITEM_COUNTRY_V	This view load item supplier country information for which item supplier mapping exists.
TICKET_FORMAT_BASKET_V	The unique identifier for the ticket format and item basket assignment record.
TOLERANCE_V	This view loads the tolerance related information for Ad hoc Stock Count (topic = 0) and Customer Order Picking (topic = 1)
UIN_TYPE_V	This view loads the UIN related information about an item for a specific store.

Packages

Table A-3 Packages

Package Functions	Parameters	Description
DATE_UTILS. PRINT_TIMESTAMP	inDate IN timestamp	This function print timestamp.
DATE_UTILS. CONVERT_TIME_ZONE	I_date IN timestamp I_from_time_zone IN varchar2 I_to_time_zone IN varchar2	This function converts date from one time zone to another time zone. If the from time zone is not provided, DB time zone will be used as default.
DATE_UTILS. GET_DATE_AT_START_OF_DAY	I_date timestamp I_time_zone varchar2	This function returns a current day resets to midnight in the current time zone.
DATE_UTILS. GET_DATE_AT_END_OF_DAY	I_date timestamp I_time_zone varchar2	This function returns a current day resets to midnight in the current time zone.
DATE_UTILS. GET_CURRENT_GMT	NA	This function returns current GMT timestamp.
DATE_UTILS. GET_CURRENT_GMT_NUMERIC	NA	This function returns current GMT timestamp in numeric.
TRANSLATION_UTIL. TRANSLATE	i_localeId IN number i_key IN varchar2	This function returns the translated text for given key if exists on translation tables.
DATE_UTILS. PRINT_TIMESTAMP	inDate IN timestamp	This function print timestamp.
DATE_UTILS. CONVERT_TIME_ZONE	I_date IN timestamp I_from_time_zone IN varchar2 I_to_time_zone IN varchar2	This function converts date from one time zone to another time zone. If the from time zone is not provided, DB time zone will be used as default.
DATE_UTILS. GET_DATE_AT_START_OF_DAY	I_date timestamp I_time_zone varchar2	This function returns a current day resets to midnight in the current time zone.

Use the links to get an in-depth knowledge about Oracle APEX features / components / configuration:

APEX Documentation List

APEX Installation

Application Builder User's Guide

SQL Workshop Guide

>End User's Guide

To get started with and explore the feature on Oracle Application Express (APEX), visit the following site (free signup): https://apex.oracle.com