Automatic invoice numbering

Summary:

Generatic TRX_NUMBER automatically for Receivables and for Project

Content (required):

Our need is to insert automatically a value in TRX_NUMBER, from manual transaction inserted directly.

We should insert into TRX_NUMBER value of DOC_SEQUENCE_VALUE with "year" suffix.

Example:

DOC_SEQUENCE_VALUE = 191

TRX_DATE = 10/2/2023

TRX_NUMBER should be valued, automatically: 191/2023

Is it possibile?

The user should not be able to modify TRX_NUMBER.

Thanks in advance

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

Oracle Fusion Cloud Applications

23B (11.13.23.04.0)

Code Snippet (add any code snippets that support your topic, if applicable):