PeopleCode is written using the Application Designer. The code can exist on a record, a button, an action, or, possibly, an Application Engine batch program. SQR has a robust report-writing environment with complex procedural logic built in. You can combine database retrieval and row processing.
Application Engine focuses on set-based SQL logic and goes to a much deeper level of the underlying application definitions. Application Engine has been pretty popular and is a part of Oracle Fusion as well?
SQL has the advantage of being a little bit more independent of the applications. Since SQR is application independent, so the drawbacks include its inability to work with Trees, effective dating, setids, row-level security, related language records, etc.
For example, users who enter data in Japanese require functionality that enables them to enter proper nouns such as names or descriptions both in Kanji and by using a phonetic double-byte character set, such as Zenkaku Katakana.
To accomplish phonetic sorting in PeopleSoft HRMS, configure your system so that the user can enter Japanese proper nouns twice: once in double-byte Kanji and once phonetically using Katakana or Hiragana. JPN For Japanese users, it is important to determine a consistent method for entering phonetic character set information.
If a Katakana Ma character is included in the sort, it is sorted after a Katakana Mi character and appears only after all the Hiragana characters are sorted.
For certain names, addresses, and description fields in PeopleSoft HRMS, there is a corresponding alternate character field that is part of the record. This architecture enables the same field to be used differently for different language codes.
The following table lists the alternate character fields and the global pages with which they are associated in PeopleSoft HRMS. The following reports in PeopleSoft Enterprise Human Resources sort on the Name field or on the Alternate Character Name field when the system base language and the report language are configured as shown:.
Before you can enter double-byte characters and implement alternate character functionality in PeopleSoft HRMS, you must be using a Japanese-enabled database and a double-byte-enabled operating system. When you enable alternate character functionality for a user, the system displays the alternate character button to the right of all the fields on the Global menus that have an associated Alternate Character field. When you click the Alternate Character button, the system opens a page where you enter or display the field value in the alternate character set.
Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox.
Newsletter Topics Select minimum 1 topic. Incorrect Topics: Broad or inaccurate topics. Spam: Link or advertisement for a product. Not in English: Content in a different language. Not a Helpful Response: Does not address question. Images Need Explanation: Image-only or meme answer.
Incomplete Attribution: Copied text without blockquote and source. Missing Affiliations: Undisclosed relationship to topics. Other: Other flag. Follow Us. Download Our App. Sign In. UserName, Email or phone.
0コメント