How You Integrate Cycle Counting With an External Application
This topic discusses how to integrate cycle counting with an external application.
You can:
-
Import count sequences
-
Export count sequences
-
Review count interface records
Importing Count Sequences
You can import an external application's count sequence records to process them in Oracle Inventory Management using the Cycle Count Open Interface. You might want to do this if, for example, your company runs Oracle Fusion Cloud Applications, but your company's inventory organizations are managed by a third-party warehouse that uses a different system.
After the records are imported to the Cycle Count Open Interface's tables, cycle count
adjustments can be processed using an open API, a concurrent program such as
GenerateCountSchedules or GenerateCountSequences,
or the Oracle Inventory Management cycle counts user interface.
INV_MATERIAL_TXNS_TEMP table, you must run the Manage Inventory
Transactions scheduled process manually to process the cycle count adjustments.Exporting Count Sequences
You can export count sequences to populate an ADFdi-enabled Excel spreadsheet. You can use this spreadsheet to:
-
Review count interface records.
-
Serve as the data source for importing count sequence records from Oracle Inventory Management to an external application's database.
After the records are imported, you can edit count sequence data using the third-party application.
Reviewing Count Interface Records
When you review count interface records, you view and make changes to cycle count sequences in an ADFdi-enabled spreadsheet rather than in the Oracle Inventory Management cycle counting user interface.
Before you can review count interface records, you must first export count sequences.