CINS Fields Clarification

(Doc ID 2362102.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 8.0.0 and later
Information in this document applies to any platform.

Goal

Qn1:I see there is a column in the CINS file called active_total.  this I assume is all stock in active locations, and includes allocated units not yet picked. Then, how do I get the total of IBLPN's that are sellable?  Is this the (iblpn_available + iblpn_allocated) field? On what criteria is an IBLPN determined to be "available"?
Qn2:Question - if the Lock code is allocateable , will this be included in the Available IBLPN totals?

Then, SUP is currently on Web service integration and they receive their CINS in XML format.

Is it possible to enable a job that will send it in XML to them as is currently happening, but then also sends a flat file format with "|" pipe delimited to the sftp web reports folder?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms