Oracle® Retail Store Inventory Operations Cloud Services Implementation Guide Release 19.3 F44223-03 |
|
Previous |
Next |
This section covers the following topics:
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.
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. |
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 help the user create tables, view, sequence, packages and so on, on the current APEX schema.
There are three (3) types of users:
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.
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:
Managing instance configuration.
Managing workspace creation and schema assignment.
Managing the customer service requests.
Monitoring the user activity if enabled.
Provisioning the user account.
On EICS APEX Installation, APEX Administrator will create a workspace and provision the APEX schema for the work space which has been created via EICS database installer. The Administrator is required to provision users to have access to the work space.
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:
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.
Manage Request
This feature is used to authorize user's request for the account and workspace access.
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 work space which has been created via EICS database installer. The Customer Apex Administrator is required to provision users to have access to the work space.
Monitor Activity
This feature component allow the administrator to monitor user activity. The activity can be monitored for an application created by user, for a workspace or for a specific days.
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 are granted to the objects directly instead of EICS data set role base of following reasons: The APEX database user need 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 have access to, see SIM_BUSINESS Database Object List |
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 of 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_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 hold 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 bases. 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 import 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 of 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 |
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. |
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. |
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 load information for the user define 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 load the tolerance related information for Ad hoc Stock Count (topic = 0) and Customer Order Picking (topic = 1) |
UIN_TYPE_V |
This view load 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 return 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 return 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 return 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:
Application Builder 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