Page 1 of 1
Auto generation of customised Documentt numbering
Posted: Mon Mar 31, 2008 4:35 am
by Muhammad Shah
Hi Gurus,
I'm using R12, OS=Linux x86 version=es4
Can we define Alfa-numeric document numbers that can appear on the interface of each doc's entry form? (eg-Invoice number, Transaction no, Receipt no and JV no. etc).
Regards,
Muhammad Shah
Posted: Mon Mar 31, 2008 5:07 am
by admin
Only numerics are allowed. thanks
Posted: Mon Mar 31, 2008 5:27 am
by Muhammad Shah
Dear Admin,
I'm delighted to have your prompt reply. but we'vea requirement from our client they want to generate Alfa-Numeric Sequencing on the interface. They say it is quite possible through Customization.
Will you plz tel lme that on GL Interface table we've columns called "Reference-1 to Reference-4" What are these and what is there pupose?
Can they be populated for Alfa numeric Documents numbers?
My Best Regards,
Muhammad Shah
Posted: Mon Mar 31, 2008 8:50 am
by admin
As you know EBS is with source code so nothing is impossible but the question is what is standard which is preferred to use. Oracle sequences will be of number type so what you will have to do to create a sequence and then append the character(s) with it.
SQL> create sequence t;
Sequence created.
SQL> select 'YYY' || lpad(t.nextval,8,0) from dual;
'YYY'||LPAD
-----------
YYY00000001
SQL> /
'YYY'||LPAD
-----------
YYY00000002