Working with Aliases
Post date: Aug 12, 2013 7:15:34 PM
When creating an alias with API Wizard for a loader, I have come across something that everyone should know. Within the where clause, always surround a user parameter with at least one space.
For example, if your alias looks like this (user parameter highlighted):
WHERE UPPER(CONTROL_GROUP_NAME) = UPPER(:APPROVAL_GROUP) AND ORG_ID = (SELECT ORGANIZATION_ID FROM APPS.HR_ALL_ORGANIZATION_UNITS WHERE TYPE = 'OU' AND UPPER(NAME) = UPPER(:ORGANIZATION_NAME))
then it will fail.
However, it will not fail if you include a space around the parameter.
WHERE UPPER(CONTROL_GROUP_NAME) = UPPER( :APPROVAL_GROUP ) AND ORG_ID = (SELECT ORGANIZATION_ID FROM APPS.HR_ALL_ORGANIZATION_UNITS WHERE TYPE = 'OU' AND UPPER(NAME) = UPPER( :ORGANIZATION_NAME ))
This was last tested with:
Server Version: 2.0.3.8.14
Addin Version: 2.0.3_47D-44J