This content has been marked as final. Show 5 replies
I beleive, if you choose manual entry then only you can create numeric and alphanumeric document numbers.With automatic entry, i don't think so you will be able to create alphanumeric like A-001,A-002 etc.Also if you have a multi-org set up,the numbering is operating unit specific and not inv org specific.
Try out by doing form personalisation to generate the sequence you desire.
Edited by: Bala.S.R. on Sep 1, 2008 1:05 PM
As per Oracle seeded functionality, system will not allow alha Numeric numbering...
As we know, PO works on OU level, so i don't think so it is possible to have two different sequence for two different inventory organization under same operating unit. But as you said, you client is insisting on the same. so better you store that alpha numeric sequence according to the client requirement in the attribute (DFF) of po headers. and in purchase order printing also, can customize accordingly. where as standard sequence let it be as it is that is numeric.
i hope this will work for you.
Thanks & regards,
You can achieve this by little a custmo trigger on PO_HEADERS table, Modify the SEGMENT1 before insert based on your requirement
So I have seen this done, but none of it was standard. You would leave your normal numbering system in place, but then have a SQL guy create a custom script to upload PO directly into your system. Typically with these loaders you can script in the use of any PO numbering scheme that you designate. If you migrated Oracle from a previous system you may have some of these tools especially if you had your historical data uploaded prior to going live. We used to call these PO Loaders, but the function operates in a similar fashion to a requisition loader which takes a flat file and uploads it directly into the system.