I need to know if the column PO_RELEASES_ALL.RELEASE_NUM can be modified. I have a requirement to create releases and have the release number be based on custom logic (6 digit number plus year=10 digit number)
I am leveraging the requisition open interface program to automatically create the releases. They are getting created and approved, but the release_num seems to be max(release_num) from the table. I would like to modify this logic. The goal is to have this number searchable and indexable from the PO Summary/Entry form. Is a DFF the only way to go here?