July 7, 2017

Status Types

In OTM, transactions objects like Order Release, Shipment, etc have 'Status' button on the header screen that will have values to give information about current status of that object in the transaction life cycle.



For example, if you want to track the tender status of a shipment, you can review shipment status 'SECURE RESOURCES' and it's values at each stage in the tender life cycle to track the progress. When shipment is originally created, it might have status like 'SECURE RESOURCES_NOT STARTED'. Once we tender it to carrier, this status changes to 'SECURE RESOURCES_TENDERED'. Once carrier accepts tender, status changes to 'SECURE RESOURCES_ACCEPTED' and so on. So these status values give good information to the user on what are next actions to be taken on that transaction.

Status values are of two types: Internal statuses and External Statuses.

Internal statuses like 'SECURE RESOURCES' on the Shipment are standard OTM application statuses. OTM product code maintains these statuses. Ideally we should avoid doing any custom SQL DML statements on such internal status type values to avoid conflicts with OTM standard code flow.

However, if consultants want to add new status types, they can create external statuses based on their client specific requirements. To create external status, follow below steps:

  • Configuration and Administration Data > Power Data > General > Status Types > New
  • Enter Status Type ID(Some qualifier/name and the same appears when you click 'Status' button)
  • Enter Object Type(E.g. 'Shipment' if you are creating external status on the 'Shipment' etc)
  • Enter Status Values(Naming convention you follow is Status Type ID value followed by underscore and status value). Add all possible values here and mark one of the values as 'Initial Value'. This will be default value when the transaction is created. You can update these values with SQL DML through Agents etc based on standard or custom events. 



3 comments:

  1. What is the status on order base when created

    ReplyDelete
  2. Hi,
    what is the end to end process from order releases.....
    1. Defining Locations and Corporations for the source and destinations.

    2. Creation and Assignment of a Calendar to the location.

    3. Defining a Contact and assigning it to the location

    4. Create a Commodity , Item and associate the Item to the Commodity

    5. Create a Equipment Group, Equipment Group Profile and associate the
    Equipment Group to the profile

    6. Defining of Service Providers

    7. Create Rate Service

    8. Associate Rate Service to the Rate Offerings

    9. Create a Rate Record associated to the Rate Offerings

    10. Create a Itenary for scenario

    11. created ordered Base

    12. created ordered releases

    13. Create Buy Shipments

    14. Create Tender (Observe Status: SECURE_RESOURCES_TENDERED)

    15. Accept Tender ( Observe Status: SECURE_RESOURCES_ACCEPTED)

    16. Create an Invoice

    what is the next step to complete the process. Can you please help.

    Regards,
    Yuvaraj

    ReplyDelete
    Replies
    1. Hi Yuvaja, please refer to my latest post that answers your question:
      https://www.oracle-otm.com/2020/06/basic-otm-configurations.html

      Delete