Category Archives: Order Management

Order Management Related

Sterling OMS Custom Table Creation

Sterling OMS Custom Table Creation In this post we are going to see how to do Sterling OMS Custom Table Creation Sterling OMS Custom Table Creation Requirement: Create custom table with given below data structure Other Table Creation Requirements 1) Table should have history table 2) Table should have audit records for insert, update, delete… Read More »

Sterling OMS Random Useful Query and Tips

Sterling OMS Random Useful Query and Tips Wish you happy new year every one. After long break we are coming with post. Here is few useful tips. Please share your feedback. Sterling OMS Random Useful Query and Tips How to find associated transactions to given agent server ? select distinct yt.TRANNAME,yt.PROCESS_TYPE_KEY from YFS_AGENT_CRITERIA yac, yfs_server… Read More »

Sterling oms taskq based agent server

Sterling oms taskq based agent server In Sterling OMS we have 2 type of servers Agent Server TaskQ based Non TaskQ based Integration Server Please read this post to get different between agent and integration servers In this post we are going to see how to create simple TaskQ based agent. Sterling OMS TaskQ based… Read More »

Sterling OMS Health Monitor

Sterling OMS Health Monitor Sterling OMS Health Monitor In this post we are going to see how Sterling OMS uses health monitor process. Database Table name YFS_HEARTBEAT Command To start health Monitor startHealthMonitor.cmd For application health monitor and reporting we are having various tools in market. Here is few mainly used tools for health monitor.… Read More »

Sterling OMS How to test Java Code using HTTP Client

Sterling OMS How to test Java Code using HTTP Client Requirement : For given Organization ID (Matrix) print payment processing is enabled or not ? Write Java Class with Method return type as boolean.

What all the required parameters to solve the requirement ? Need the valid Organization ID Which Environment we are going to validate… Read More »

Sterling OMS Windows local Oracle Common Issue

Sterling OMS Windows local Oracle Common Issue If you are doing development using windows and have local Oracle Installation might seen “The Network Adapter could not establish the connection” issue very frequently after windows machine restart. In this post we are going to see how to address “The Network Adapter could not establish the connection” error.… Read More »

Sterling OMS Writing First Dynamic Condition

Sterling OMS Writing First Dynamic Condition Sterling OMS Writing First Dynamic Condition Before going to this session hope you had chance to read about Condition and Sterling OMS Static Condition. If not please click here and read about Sterling OMS Static Condition Why do we need Dynamic Condition ? Using Static Condition, we will be… Read More »

How to enable trace and debug Sterling OMS

How to enable trace and debug Sterling OMS What is the use of tracing in OMS? When really not getting the required result or need to find what exactly happening in newly created service or API we should enable trace and debug. Tracing provides detailed message what the calls been made in process/transaction. Specially able… Read More »

How do I turn off Oracle password expiration

How do I turn off Oracle password expiration Login to Oracle database (Oracle 11g Express Edition) using SQL developer with system user id and password Run below query’s alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited; alter profile DEFAULT limit PASSWORD_LIFE_TIME  unlimited; Run below query’s : To reset password one more time alter user <OMS DB User… Read More »