The staging control table is used to indicate to XAI that there is a file or table with
a collection of records to be uploaded. The special Staging Control
Receiver periodically reads the staging control table to process
new records.
The XAI staging control table may be populated in one of the following
ways:
- To process a specific sequential input file, manually create a
staging control record and indicate the location and name of the file
and the XAI inbound service to use for processing. Use this mechanism
to process ad-hoc uploads of files.
- If a file is received periodically, you may define a File
Scan Receiver, which periodically checks a given file directory
for new files. The file scan receiver creates a new staging control
record to process this file.
- The XML
File Receiver processes a file containing a collection of XML
messages to be uploaded. The XML file receiver creates a staging control
record and creates records directly into the XML upload table. The
staging control record is automatically set to a status of Complete and is used to group together
the XML upload records. Refer to Processing Staging Upload Records for a Staging Control for
more information.
- To upload records from a database, manually create a staging control
record and indicate an appropriate XAI inbound service, which contains
the information needed by the system to access the appropriate table.
Use this mechanism to process ad-hoc uploads of files.
Note: To upload records from a database table, you must create a staging
control record. There is no receiver that periodically looks for records
in a database table.
- Whenever an XAI upload staging record is created, an XAI staging control
record is created as well.
Fastpath: Refer to
Batch scenarios for more information about configuring the system to populate the
staging control with requests from external files.
Copyright © 2007, 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.5.2016 10:21:45 [T1_1454696505000]