User login
Sponsored links
Recent blog posts
- AJAX XML - The JavaScript code
- AJAX XML - The PHP Page code
- Peoplecode Trace in a File.
- Display pdf file , image, website on peoplesoft page using html area.
- Ren Server -- Over View
- SQR Code
- AP PO Tables - Some imp Query.
- PeopleSoft XML Publisher - Report Development
- Debugging Functionality in Peoplesoft
- Steps for Creating an XML Export File with PeopleSoft
PeopleCode to AutoIncrement an AlphaNumeric Transaction Number
Tue, 08/26/2008 - 1:12pm — Larry
I have code to auto-increment an alphanumeric field, using SQL calls. It is specific to a 4-character field, but can easily be adapted to different length fields.
SQLExec("SELECT decode(substr(oldvalue,2,3),'ZZZ', TRANSLATE(UPPER(SUBSTR(oldvalue,1,1)),'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', '123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ0'),substr(oldvalue,1,1)) ||decode(substr(oldvalue,3,2),'ZZ',TRANSLATE(UPPER(SUBSTR(oldvalue,2,1)), '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', '123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ0'),substr(oldvalue,2,1))||decode(substr(oldvalue,4,1),'Z', TRANSLATE(UPPER(SUBSTR(oldvalue,3,1)), '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', '123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ0'),substr(oldvalue,3,1))||TRANSLATE(UPPER(SUBSTR(oldvalue,4,1)), '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', '123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ0') FROM dual, (select :1 as oldvalue from dual)", &priorvalue, &newvalue);
If &newvalue = "0000" Then
&bOverrun_Error = True;
End-If;
If &newvalue = "0000" Then
&bOverrun_Error = True;
End-If;
Bookmark/Search this post with:
Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| Abs Mgmt: How can Abs rule pro-rate contractor's last month's entitlement (need help urgently) | PeopleSoft Functional | 03/10/2010 - 9:21pm |
| Can we user LONG datatype as a search option in PeopleSoft | PeopleSoft Technical | 03/10/2010 - 11:22am |
| special caracters are not translated correctly when ftp from windows to unix | Programming | 03/09/2010 - 3:23pm |
| How to view the employees from particular country in peoplesoft? | PeopleSoft Technical | 03/03/2010 - 1:56am |
Stay updated
CompShack is a user driven Dev2Dev IT community. Developers can ask questions, help answer questions, or just browse code and articles contributed by users. No registration required.
You can register if you want to contribute code samples, share your knowledge at your own blog, and become adored in the community!
About Larry
Job title
Consultant
IT skills
Peoplesoft (everything from v2.4 on) - Tools, HR, Ben, Fin, Custom, SQL, Unix, HTML, Javascript, Dreamweaver, COBOL, Fortran , FOCUS, lotsa other stuff
Poll
New forum topics
- Abs Mgmt: How can Abs rule pro-rate contractor's last month's entitlement (need help urgently)
- Can we user LONG datatype as a search option in PeopleSoft
- special caracters are not translated correctly when ftp from windows to unix
- SQR Code for converting the data from .CSV into Peoplesoft Tables
- how to hide a cancel button in a DOMODEL page
- How to view the employees from particular country in peoplesoft?
- PeopleSoft, How to Disable Advanced Search or Saving Search Criteria for Component
- PeopleSoft Security 8.8
Recent comments
- Re: SQR Code for converting the data from .CSV into ...
16 hours 50 min ago - Re: Upgrading to PeopleSoft HCM 9.1 and PeopleTools 8.5
2 days 9 hours ago - Re: how to hide a cancel button in a DOMODEL page
6 days 20 hours ago - Re: PeopleSoft Security 8.8
1 week 23 hours ago - Re: Check Email id on signin and if no email id then ...
1 week 23 hours ago - Re: format the message text such as BOLD or change of colour ...
1 week 1 day ago - Re: Approval Workflow Engine (AWE)
1 week 1 day ago - Re: component Interface to insert data using PeopleCode
1 week 2 days ago - Re: format the message text such as BOLD or change of colour ...
1 week 2 days ago - Re: format the message text such as BOLD or change of colour ...
1 week 2 days ago
Comments
Larry as your SQL works fine I'm just curious on what kind of requirement derived such code. I find it odd to increment an alpha numeric character :) - none the less, your SQL works perfect.
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Have an alphanumeric field, ACTIVITY_ID. Was given requirements to create a Mass Add page, allowing user to auto-generate a large number of Project_Activity rows given a starting point within an alphanumeric range, along with the # of new rows desired, along with other common field values. Tried to get user to agree to only numeric incrementing, but they insisted upon alphanumeric. Go figure.
In Inventory the MSR no gets generated automatically.
Could that PeopleCode logic will also work for your requirement?
Post new comment