OTM 5.5 - Unable to view Buy Shipments from Order Movements screen via smartlinks

[ianlo]

Hi everyone,

I would like to check if anyone has problems viewing Buy Shipments from the Order Movement finder result screen via smartlinks.

When I click on the View Related Buy Shipments smartlink, I see a blank page.

Thanks!
Ian

[bmj_23]

Re: OTM 5.5 - Unable to view Buy Shipments from Order Movements screen via smartlinks

Ian - assuming you have buy shipments related to those order movements, that should work just fine. If you are sure that shipments do actually exist and if you have access to the Oracle Metalink system I would log a SR for that issue.

If you wanted to debug this further before creating an SR, turn on the SQL log and then run the "View Related Buy Shipments" from the Smartlink and see what SQL commands are being issued and then check that those SQL statements should return shipments to the screen.

You may also need to turn on the UIC component of the log to get SQL output for UI related actions. Hope that helps.

[ianlo]

Re: OTM 5.5 - Unable to view Buy Shipments from Order Movements screen via smartlinks

Hi bmj,

I am certain the shipment was generated. I have already submitted an SR as well. Just wondering if you have encountered this before.

Thanks for the UIC tip! Looks like they revamped the Log file interface in 5.5. - for the better.. I will check out the SQL generated there!

Thanks for your help!

Ian

[geetikadua]

Re: OTM 5.5 - Unable to view Buy Shipments from Order Movements screen via smartlinks

HI,

This is a very old thread, but i have a related question., Can we change the query which returns the value of smart link? for example i happen to see the below query to be executed in logs when i check for related order release from shipment screen

select o.order_release_gid, o.order_release_gid from ORDER_RELEASE o where (o.order_release_gid in (select vsor.order_release_gid from SHIPMENT s, VIEW_SHIPMENT_ORDER_RELEASE vsor where (s.shipment_gid=?) and (vsor.shipment_gid=s.shipment_gid))); [T021.6066033] [ExecuteThread: '48' for q]

here, if i am not wrong table VIEW_SHIPMENT_ORDER_RELEASE is a customized view?

Regards
Geetika