This content has been marked as final. Show 5 replies
You can have alphanumeric numbers for po. But it wont solve your purpose.
You can start the PO numbers for every org with different digit and keep the lenght of PO number large enough so that number will not overlap in near future (say PO number with 8 digits)
You can set the numbering to Alpha Numeric for PO in Purchasing Options and for each Operating Unit prefix OU_Short_code to the Automatically Generated Number just before showing it on the PO.
This way you can use the automatically generated number and still have the uniqueness.
But that would mean tweaking Oracle Purchasing Code.
Do you know how that might be possible. I would like to prefix a letter to our requisition numbers to make them unique.
Same approach can be done for requisition number also. There will a sequence that generates the PO/requisition number. Find the sequence and see where in the pls code the sequence is generated and use your logic there.