Transportation Management

Get Involved. Join the Conversation.

Comments

  • LAKSHMIDEEPAK GADDIPATI

    Hi,

     

    We did pilot in TI and we didn't encounter this issue. TI authentication happens using OTM roles. Is this happening for every user?

  • amiresi sathish

    Seems something wrong with accessing XML info to DB, I just tried same XML in my instance it worked for me.

    </RIQQuery>
                   <RemoteQueryStatus>
                      <RemoteQueryStatusCode>ERROR</RemoteQueryStatusCode>
                      <RemoteQueryStatusSubject>RateActionSession Exception</RemoteQueryStatusSubject>
                      <RemoteQueryStatusMessage>ERROR PROCESSING RATE INQUIRY</RemoteQueryStatusMessage>
                      <StackTrace>[002804] No Valid Rates Found
     

  • Ashok Revuri

    yes, i did :)

  • amiresi sathish
    • posted via email reply September 4, 2019
    • Permalink
     
    
    Not faced this error,  hope you had replace the user name and password in the transmission header
    
  • Ashok Revuri

    Thanks Satish.

    While i try to upload this xml in OTM. i am getting below error. Have you encountered this before?

    glog_error id="[001391]">
        <log_timestamp>2019-09-04 10:22:24.690</log_timestamp>
        <process>
            <machine/>
            <gid>350464</gid>
            <start>2019-09-04 10:22:24.641</start>
        </process>
        <causes>
            <cause>
                <error>java.lang.IllegalStateException: java.lang.IllegalArgumentException: null java.sql.Connection</error>
            </cause>
        </causes>
        <stack_trace>[001391] java.lang.IllegalStateException: java.lang.IllegalArgumentException: null java.sql.Connection
     
    java.lang.IllegalStateException: java.lang.IllegalArgumentException: null java.sql.Connection
    at glog.integration.transmission.TransmissionDBReader.open(TransmissionDBReader.java:57)

     

  • amiresi sathish
    • posted via email reply September 4, 2019
    • Permalink
     
    
    Please find the sample rate inquiry XML
    
    <Transmission>
    
        <TransmissionHeader>
    
            <TransmissionType>QUERY</TransmissionType>
    
            <TransactionCount>1</TransactionCount>
    
            <UserName>PPGTM.SATHISH</UserName>
    
            <Password>******</Password>
    
            <AckSpec>
    
                <ComMethodGid>
    
                    <Gid>
    
                        <Xid>HTTPPOST</Xid>
    
                    </Gid>
    
                </ComMethodGid>
    
                <AckOption>YES</AckOption>
    
            </AckSpec>
    
        </TransmissionHeader>
    
        <TransmissionBody>
    
            <GLogXMLElement>
    
                <RemoteQuery>
    
                    <RIQQuery>
    
                        <SourceAddress>
    
                            <MileageAddress>
    
                                <LocationGid>
    
                                    <Gid>
    
                                        <DomainName>PUBLIC</DomainName>
    
                                        <Xid>NYC</Xid>
    
                                    </Gid>
    
                                </LocationGid>
    
                            </MileageAddress>
    
                        </SourceAddress>
    
                        <DestAddress>
    
                            <MileageAddress>
    
                                <LocationGid>
    
                                    <Gid>
    
                                        <DomainName>PUBLIC</DomainName>
    
                                        <Xid>BDL</Xid>
    
                                    </Gid>
    
                                </LocationGid>
    
                            </MileageAddress>
    
                        </DestAddress>
    
                        <RateOfferingGid>
    
                            <Gid>
    
                                <DomainName>PPGTM</DomainName>
    
                                <Xid>DEFAULT_LTL</Xid>
    
                            </Gid>
    
                        </RateOfferingGid>
    
                        <RateGeoGid>
    
                            <Gid>
    
                                <DomainName>PPGTM</DomainName>
    
                                <Xid>DEFAULT_LTL_US</Xid>
    
                            </Gid>
    
                        </RateGeoGid>
    
                        <RateServiceGid>
    
                            <Gid>
    
                                <DomainName>PPGTM</DomainName>
    
                                <Xid>DISTANCE_DURATION</Xid>
    
                            </Gid>
    
                        </RateServiceGid>
    
                        <TransportModeGid>
    
                            <Gid>
    
                                <Xid>LTL</Xid>
    
                            </Gid>
    
                        </TransportModeGid>
    
                        <UseRIQRoute>N</UseRIQRoute>
    
                        <ShipUnit>
    
                            <ShipUnitGid>
    
                                <Gid>
    
                                    <DomainName>PUBLIC</DomainName>
    
                                    <Xid>123456</Xid>
    
                                </Gid>
    
                            </ShipUnitGid>
    
                            <ShipUnitSpecGid>
    
                                <Gid>
    
                                    <DomainName>PUBLIC</DomainName>
    
                                    <Xid>DEFAULT</Xid>
    
                                </Gid>
    
                            </ShipUnitSpecGid>
    
                            <WeightVolume>
    
                                <Weight>
    
                                    <WeightValue>100.0</WeightValue>
    
                                    <WeightUOMGid>
    
                                        <Gid>
    
                                            <Xid>LB</Xid>
    
                                        </Gid>
    
                                    </WeightUOMGid>
    
                                </Weight>
    
                                <Volume>
    
                                    <VolumeValue>0.5000</VolumeValue>
    
                                    <VolumeUOMGid>
    
                                        <Gid>
    
                                            <Xid>CUFT</Xid>
    
                                        </Gid>
    
                                    </VolumeUOMGid>
    
                                </Volume>
    
                            </WeightVolume>
    
                        </ShipUnit>
    
                    </RIQQuery>
    
                </RemoteQuery>
    
            </GLogXMLElement>
    
        </TransmissionBody>
    
    </Transmission>
    
  • LAKSHMIDEEPAK GADDIPATI

    Hi,

    Thanks for your reply. I believe this is applicable only for Adjustment costs but not for direct approvals. Scenario which i was asking is when user trying to approve a already approved invoice. Note, customer wants to see the details cost section so adding a action check on approval was not the solution. 

  • Karl Baker

    Without delving into the details - I believe the 19B feature below will provide you with a possible solution to the challenge being described.  This feature was delivered in 19B and will be available for you when you upgrade from 19A to 19C.

    INVOICE ADJUSTMENT COST BEHAVIOR ENHANCEMENT

    This feature provides you with a new property that allows you to control how OTM processes invoice adjustments.  Using the new property glog.invoice.adjustments.createNewInvoiceForAdjustments you can now support the following scenarios.

    With glog.invoice.adjustments.createNewInvoiceForAdjustments=true (default): 

    • Given an adjustment to an Approved Invoice the adjustment amount will be captured in a new invoice.
    • Given an adjustment to an Unapproved Invoice the adjustment amount will be added to the existing invoice as a invoice line. 

    With glog.invoice.adjustments.createNewInvoiceForAdjustments=false: 

    • Given an adjustment to an Approved Invoice the adjustment amount will be added to the existing invoice as a new invoice line. 

    STEPS TO ENABLE

    You don't need to do anything to enable this feature.

     

    TIPS AND CONSIDERATIONS

     

    The property default for glog.invoice.adjustments.createNewInvoiceForAdjustments=true (default): 

    • Given an adjustment to an Approved Invoice the adjustment amount will be captured in a new invoice.
    • Given an adjustment to an Unapproved Invoice the adjustment amount will be added to the existing invoice as a invoice line.

     

  • LAKSHMIDEEPAK GADDIPATI

    3-20691520941

  • Maria Matheny

    Hi Ashok -

    In the OTM - ERP Cloud integration, OTM is getting the order lines from OM and creating the planned shipment lines to send to ERP Cloud Shipping (Inventory Clould).  (This is different from how the integration was between OTM and EBS Shipping)

    For more information on this integrated flow, please refer to the Oracle Logistics Cloud to Oracle SCM Cloud Integration | OIC Recipe:  https://cloudmarketplace.oracle.com/marketplace/en_US/listing/30174237

    Regards, Maria

  • LAKSHMIDEEPAK GADDIPATI

    Only reason code selection will be a customization and i am not sure there are any avenues to implement that in SaaS. 

  • Ambroise PHILIP

    I faced exact same requirement in a previous project and I did not found any solution. I have investigated Action Check and external predicates but this was not satisfactory. If you find any workaround solution to make it mandatory I would be interested.

  • Tamil Selvi Esakkiappan

    I checked Action Reasons, it launches Event Reason page where we have flexibility to make Responsible Party, Status, Reason code as mandatory. Decline Tender action is to have only Decline Reason Code listed and using Action Reasons it is not allowing to make only Reason Code as required field

  • LAKSHMIDEEPAK GADDIPATI

    Please check Action Reasons. You should be able to action reasons to prompt reason codes for certain actions.

  • Ambroise PHILIP

    Hi Laura,

    Not sure whether this is still something you're trying to do.

    You need to configure the Consumption in Packaging Reference Units on your Packaged Item. You need to create a Packaging Reference Unit ID and define the consumption. You'll need to define the Application Rule and the Grouping Rule.

    Don't get confused with Repacking, this is something different : you just want to build a Mixed Freight Ship Unit.