Integrate with Oracle

An Oracle integration, working in conjunction with Loftware Integration - Oracle EBS, enables Spectrum to receive and process print requests initiated by users in Oracle applications.

You can configure as many Oracle integrations as your Spectrum license allows.

Note: For each database, Oracle WMS support can be enabled for only one Spectrum Oracle integration.

Important! Before Oracle integrations can be fully used in Loftware Enterprise SP (including Loftware Cloud Enterprise SP, Spectrum, and Spectrum Cloud), Loftware Cloud, or Loftware NiceLabel LMS, Loftware Integration - Oracle EBS must be installed in the Oracle EBS system database by an Oracle database administrator. For more information, see Getting Started with Loftware Integration - Oracle EBS.

Note: If you have upgraded Spectrum from a version prior to Loftware Spectrum 5.0, then any existing Oracle integrations will continue to process print requests. However, most of their properties cannot be edited. Print requests from any new Oracle integrations cannot be processed until Loftware Integration - Oracle EBS has been installed in the Oracle EBS system database. For more information, see Getting Started with Loftware Integration - Oracle EBS.

To create an Oracle integration in Spectrum that allows Spectrum to receive print requests from Oracle applications via Loftware Integration - Oracle EBS, do the following in Spectrum.

In Integrations , in the ribbon click > Oracle to create an Oracle integration.
In the General panel, configure the following details about Oracle.
1. A different job target folder must be configured for each integration. For Job Target Folder, select a unique folder in Spectrum to which status information about print jobs related to this integration should be directed.
2. For Default Process, select a process that you have created that should be applied to the integration or select the Generic Document Process in the root folder.
3. For Transaction Size, enter the number of labels to allow in a batch. It is recommended to set this value to be greater than the size of any expected batch of print job details you may need to send. For example, if you have a stacked job with 200 labels being printed to the same device, the transaction size should be set to 201 or greater.
4. For Run As, select the Spectrum user account under which print requests from Oracle applications should be run. This user account must have at least the INTEGRATOR role or equivalent permissions.
  Note: The Spectrum user defined in the Loftware Integration - Oracle EBS properties file should not be used as the Run As user for Oracle integrations.
In the Advanced panel, for Wait for Job Complete, either leave the check box cleared to maximize performance, or select the check box to require that the next job is not sent until the current job is complete.
In the Archive Options panel, it is recommended that you clear Archive Original Job File and Archive XML check boxes except during testing. However, for Archive Folder you must enter a UNC path to a shared folder or a path to a local folder on the Spectrum Application Server to which files can be saved if archiving is turned on. For example, \\Server01\Archive or C:\Archive. If the folder does not exist, it is created.
In the Properties pane, enter a description of the purpose of the integration.
Click File > Save or click Save in the toolbar.
1. In the Save dialog box, enter a name for the integration
  Important! For an Oracle integration's print requests to be processed, the integration name in Spectrum must match the integration name specified in Loftware Integration - Oracle EBS by an Oracle administrator. Either the integration or the agent may be configured first.
  Characters permitted in names
  The following characters are permitted in the name: letters, numbers, parentheses, square brackets, ampersands, plus signs, commas, semi-colons, and tildes. Additionally, the following characters are permitted but cannot begin or end the name: spaces, double quotation marks, single quotation marks, hyphens, underscores, periods, and grave accents. For letters, the case that you specify is displayed, but case is ignored when Spectrum interprets a name. If you will be installing the Spectrum application on a computer running Windows Server, and transferring data between Spectrum instances, see the "Transferring Spectrum Data in a Compressed File" section of the Loftware Spectrum Data Transfer Guide.
2. In the left pane of the Save dialog box, select the folder in which to save the integration. You can click a folder to display subfolders.
3. Click OK to save the integration. Creation information is displayed in the Properties pane.
In the ribbon, click Home > Start Integration. If a dialog box is displayed indicating that installation is required, click Yes.
To verify that the integration has started, view the Status in the Properties pane.
Important! Whenever you add a new device, data service, integration, or facility, you must ensure that the service is activated on all Spectrum Application Servers on which it should be available to run and started on at least one. In an environment with only one Spectrum Application Server, these types of services are automatically activated and started when they are created. For more information, see High Availability with Distributed Services.