Issues with %Language_User in Application Engine PeopleCode/PeopleSoft

A recent requirement was to obtain the sign-in language of a user while running an Application Engine  process and use it to fetch non-english language characters. Tried a host of %Language variants in Application Engine PeopleCode, but none of them seemed to work

1. %Language_User

2. %Language_Data

3. %Language_Base

Put these system variables in an online page involving PeopleCode and it would work like a charm. The same was not the case with using in these in an Application Engine PeopleCode. Reason being, the online PeopleCode is different from the Application Engine being executed on the Process Scheduler. So, it takes the default user language and returns it. As a workaround, I used the following SQLs in obtaining the language code:

 select LANGUAGE_CD from PSOPRDEFN where OPRID = <your OPRID goes here> 
 select LANGUAGE_CD from PS_PRCSRUNCNTL where OPRID = <your OPRID goes here> and RUN_CNTL_ID = <your run control ID goes here> 

Hope this helps 🙂



About Manikandan Surendren

A PeopleSoft Techno-functional Consultant. An engineering graduate in Computer Science. Technology Enthusiast. Movie freak. Gadget geek.
This entry was posted in Code, Oracle, PeopleSoft, SQL and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s