Differences Between Transfer and TransferExact in PeopleSoft
What are differences Between Transfer and TransferExact in PeopleSoft.
When you do a transfer, the first thing the system checks is whether all the key field values for the target component are provided.
If all the keys aren’t provided, the search page is displayed. In this scenario, TransferExact and Transfer are the same.
If all the keys are provided, a Select is done against the search record for that component using those keys.
-
If you use the Transfer function, a LIKE operator is used in the Where clause of that Select for each key.
-
If you use the TransferExact function, the equals operator is used in the Where clause for each key. Using equals allows the database to take full advantage of key indexes for maximum performance.
Example Code
|
1 2 3 4 5 |
If %Page = Page.TEST_TRANSFER Then Transfer( False, @("MENUNAME.ROLE_EMPLOYEE"), BarName.HOME, ItemName.TEST_TRANSFER, Panel.TEST_TRANSFER, "U", &YEAR,&QUATER); End-If; |
Ref:https://docs.oracle.com/cd/E80738_01/pt854pbh2/eng/pt/tpcl/langref_PeopleCodeBuilt-inFunctionsAndLanguageConstructs_T.html#topofpage