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