Auto generation of customised Documentt numbering

[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

[admin]

Only numerics are allowed. thanks

[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

[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