Error when creating a new record in Freight Route Mapping bucket

Open Freight Route Mapping in Master Data

·         Click new button

       Enter the required fields and click finished

Read More

How to send OTM Shipment Cost to SAP/EBS/Fusion/external system

1.       Validation whether the Shipment Exists in OTM or Not.

·         To be done by OTM consultant by writing a query for the selected shipment

Select count(*) from shipment where shipment_gid in ()

1.       Validation whether the Accessorial Code ID is updated for the Shipment or Not

·         It has to be done by OTM consultant by writing a query for the selected shipment

·         OTM Consultant should try to identify the reason for missing the accessorial Code ID.

To Update the Accessorial Code ID, Consultant should run Agent: - TEMP_COST_SEND for the selected set of shipment. This Agent will update the Accessorial Code ID on the Shipment Cost Line,

Select count(*) from shipment_cost where accessorial_code_gid is null and shipment_gid in ()

Group by shipment_gid

Having count(accessorial_code_gid)=1

1.       Validation of the Shipment Cost, no Shipment Cost line should be duplicated for the same Accessorial Code ID

·          It has to be done by the OTM consultant by writing a query for the selected shipment.

· Agent:- TEMP_COST_SEND will perform below actions:-

                                                         i.      Update the Accessorial Code ID

                                                       ii.      Sum up the Shipment cost with Same Accessorial code ID

2.       Creation/Modification of the Saved Query for the list of Shipment for which cost needs to be interfaced.

3.       Post saved Query Creation, the consultant needs to trigger the Agent to send the Shipment Cost to SAP. Two Agent is created to send the Shipment in creating & modify mode as below:-

·         Domain name_TEMP_SEND_COST_CREATE

·         Domain name_TEMP_SEND_COST_MODIFY

4.       Below are the steps to trigger the Agent to Interface Shipment Cost to SAP:-

·         Navigate to Path: - Business Process Automation > Process Management > Business Process Automation > Data Query.

·         Select “Data Query Type” as “Shipment”

·         Consultant will selected the Saved Query created above in the “Based on” Field and the Agent Event to be triggered to send the Shipment Cost to SAP.

·         After that the click the Submit button.

Read More

how to creat user in OTM cloud dashboard R19c,18c

open OTM cloud dashboard which you have


step 1 :- open dashboard

Step 2 :- click on user

Step 3 :- click on add and provide required information

Step 4 :- go to user manager and create the user and click to finish

Read More

Issues in webserver

I have installed OTM 6.4.1 on Linux 64 bit.

High level steps i followed are as follows:-

Installed DB 12C
Installed DB Client
Installed Java
Installed Fusion middleware
Installed OHS
Applied patch 17968606
Created ADF utility using RCU
Installed OTM software
Created gc3 tablespaces
Created glog users
Executed create_all.sh script.


Everything completed successfully.
But unable to access the login page.

When logged in to WebLogic console following message is displayed "Pending changes exist. They must be activated to take effect". On clicking on Activate changes get following error message:-

"[J2EE:160149]Error while processing library references. Unresolved application library references, defined in weblogic-application.xml: [Extension-Name: adf.oracle.domain, exact-match: false], [Extension-Name: oracle.jsp.next, exact-match: false]".

In Environment --> Servers : Only gc3web-<domain> as admin server is showing.

Have i missed any step?

Please help to resolve this issue.

Read More