You can import cycle count entries from external systems into Oracle Inventory using the Cycle Count Entries Open Interface. You can also export cycle count requests with this interface to external systems.

   To export cycle count entries:

1. Navigate to the Export Cycle Count Entries window.

2. Select a cycle count header.

3. Choose Find.

   The window displays all cycle count entries that belong to the selected cycle count header.

4. Select the records you want to export or choose Select All from the Tools menu to select all the records.

5. Choose Export to export cycle count entries to the open interface.

   To unexport a cycle count entry:

1. Select the record you want to unexport.

2. Choose Unexport.

   To inquire about or update cycle count entries:

1. Navigate to the Inquiry/Update Cycle Count Entries Open Interface window. The Find Interface Cycle Count Entries window appears.

2. Enter search criteria to query cycle count entries for which you want to view or update cycle count entry information. Choose Find to start the search and display the information in the Inquiry/Update Cycle Count Entries Open Interface window.

3. In the Processing tabbed region, view or update the following information:

   Item: The item number.

   Action: Choose one of the following options:

   Validate: Validate cycle count header, sequence, and org ID. Choose this option only if you use the open interface API.

   Create: Create an unscheduled cycle count entry.

   Simulate: Simulate the open interface process without committing the entry. This option displays errors found during processing.

   Process: Process the entry.

   Status: The cycle count status.

   Incomplete: The open interface process is incomplete.

   Process completed: The open interface process is complete.

   Simulated: The entry was processed but not committed.

   Group ID: The identification number for entries submitted in batch mode.

   Interface ID: The interface table identification number.

   Header ID: The cycle count header identification number.

   Cycle Count Header: The name of the cycle count header.

   Entry ID: The cycle count entry identification number.

   Process Mode: Choose one of the following options:

   Online: Process open interface online.

   Background: Process open interface in the background.

   Request ID: The concurrent request identification number generated during background processing.

   Process Status:

   Ready: The entry is ready for processing.

   Not Ready: The entry is not ready for processing.

   Note: This field is not updatable.

   Valid Status:

   Yes: The entry is valid.

   No: The entry has errors and is not valid.

   Note: This field is not updatable.

   Lock Status:

   Yes: The entry is locked by another user.

   No: The entry is not locked by another user.

   Note: This field is not updatable.

4. In the Count tabbed region, view or update the following information:

   Sequence: The cycle count sequence. This field is not updatable.

   Count Qty: The count quantity in the primary unit of measure.

   UOM: The primary unit of measure

   Secondary Count Qty: The count quantity in the secondary unit of measure.

   Secondary UOM: The secondary unit of measure.

   Count Date: The cycle count date.

   Counter: The name of the employee who performed the cycle count.

   Reference: Reference information about the cycle count.

   Reason: The transaction reason.

   Interface ID: The interface table ID number. This field is not updatable.

5. In the Item Stocking tabbed region, view the following information:

   Rev: The revision number (if the item is under revision control).

   Subinventory: The subinventory.

   Locator: The locator (if the item is under locator control).

   Lot Number: The lot number (if the item is under lot control).

   Serial Number: The serial number (if the item is under serial control).

   Adjustment Account: The general ledger account charged for the cycle count.

   Interface ID: The interface table identification number.

   Cost Group: The cost group associated with the item. Cost group information is available only if you are in a Warehouse Management enabled organization.

   Parent LPN: The LPN that contains the items to count. LPN information is available only if you are in a Warehouse Management enabled organization.

   Outermost LPN: The outermost LPN if the LPNs are nested. LPN information is available only if you are in a Warehouse Management enabled organization.

6. Save your work.

   To delete cycle count entries:

1. Select the cycle count entries you want to delete.

2. Choose Delete.

   To submit cycle count entries to the open interface:

1. Select the cycle count entries you want to submit to the open interface.

2. Choose Submit.

   To view errors for an entry:

1. Select a cycle count entry.

2. Choose Errors. The Cycle Count Entries Interface Errors window lists the error date and an explanation of the error.

   To open cycle count entry header information:

1. Select a cycle count entry.

2. Choose Open. This window shows information about the individual item.