Sterling OMS Custom CommonCode Types
In this post we are going to learn about out of the box getCommonCodeList API.
Understanding Standard Common Codes
Common
Codes are values that help the user to choose from a list of options. Common
codes are available as Drop down lists in the Sterling Console Screens. Common Codes
are system and user defined codes.
Example: The list of Instruction Types below are the list of common codes.

1 2 |
Database Query: select * from yfs_common_code where code_type='INSTRUCTION_TYPE' and document_type='0001'; |
Understanding Custom Common Codes
Besides system defined standard Common Codes, we can create custom common codes for an Enterprise.
We can configure Custom Common Code Types and Common Code Values directly in the Configurator. So, what is the difference between having the property values in the Properties files (like Customer_Overrides.properties file) and using the Custom Common Codes?
The difference is that if we change the Properties files, we have to do the Build and Deploy whereas, if we use the configurator to create the Custom Common Codes, we don’t have to build and deploy again and we can access the values immediately.
How to Configure the Custom Common Code ?
Configure Custom Common Code Type : Carrier
Application Manager-> Application Platform-> Presentation->Custom Common Code Types

Click the Plus sign to add a new Custom Common Code Type with description.

Configure Custom Common Codes:


How to Access the Custom Common Codes?
Using getCommonCodeList API:
The getCommonCodeList
API
retrieves all CommonCodes
which
match the input criteria.
Associated With Table: YFS_COMMON_CODE.
Test using APITester?
Call API : getCommonCodeList
Input XML
<CommonCode CodeName=”” CodeShortDescription=”” CodeSymbol=”” CodeType=”PAYMENT_TYPE_GROUP” OrganizationCode=”DEFAULT”><LocalizedAttributes/></CommonCode>

Returns: An XML document that contains a list of all common codes that match the input criteria.
Important Points
- Value of the new common code type Maximum length is 15 characters.
- This value is automatically appended with ‘.ex’ extension so that it does not conflict with the Standard common codes.
- This value must be passed to the getCommonCodeList() API.
- Custom common codes are inherited from the parent enterprise and cannot be modified by the child enterprise
Any question please email to support@activekite.com
good work and your explanation is simple and elaborative