Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create Personalize in form receipt : Generate column receipt number automatic

2913299Aug 19 2015 — edited Aug 19 2015

Hi all..

i want to create personalize for this case.

If i click receipt method, example i select Bank Transfer, then in column Receipt Number automatic disable and generate number, for example : If i select Bank Transfer, Receipt number will generate number "BT15080001".

i will explain for this Receipt Number :

"BT15080001"

-> BT for method Bank Transfer. If method Cash, code = CS, if method Giro&Check, code = GC

-> 15 for year (sysdate)

-> 08 for month (sysdate)

-> 0001 sequence number

So, receipt number will generate automatic and column disable after i select receipt method.

Can i do it using Personalize.

If i can, How ?

Thanks all..

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 16 2015

Added on Aug 19 2015

#forms, #moved-from-devops

1 comment

722 views