LOT number seqence generation

Summary:

Lot Number autogeneration based on combination of Year and Month sequentially

Content (please ensure you mask any confidential information):

Is it possible to have Lot number generation (system generated automatically) with the combination of Year+Month+Consecutive number at item level while performing Inventory transactions like Receipts, WO completion, Transfer order etc,. where all these combination needs to be changed based on year, month of transactions. If not is there any suggested approach in oracle cloud PIM/Inventory management. Your response highly appreciated. This is possible scenarios in Pharma/Chemical industries.

Version (include the version you are using, if applicable):