Auto Plan Release From XML

[cunninghamg]

I am trying to send in an Order Release, via xml integration, and I want the OR to automatically Plan.

I know this is possible From sending in an OB with a Processing Code of PLN..

Is there a way to Plan the OR Automatically?

Thanks
Gary

[krishna.kk]

Re: Auto Plan Release From XML

Gray ,

An agent can help you out .

You can create an agent which creates a Buy shipment or sell shipment once the OR is created .

Rgd
kishore

[cunninghamg]

Re: Auto Plan Release From XML

Thanks for the suggestion - I already knew about the Agent Workflow solution though.

I was looking for something that is put into the XML

For those interested... I now have the solution..

Just add the following element to the bottom of your OR xml..

<GLogXMLElement>
<Topic>
<TopicAliasName>BuildBuySideShipments</TopicAliasName>
<TopicArg>
<TopicArgName>savedQuery</TopicArgName>
<TopicArgValue>NEWORDERRELEASE</TopicArgValue>
</TopicArg>
</Topic>
</GLogXMLElement>

Gary

[njoyotm]

Re: Auto Plan Release From XML

Hi,

I understand that NEWORDERRELEASE is a SAVED QUERY'S name.
Can you kindly share the SQL query which you have written for NEWORDERRELEASE.

Regards,
njoyotm

[cunninghamg]

Re: Auto Plan Release From XML

The saved query we used is..

SELECT ORL.ORDER_RELEASE_GID
FROM ORDER_RELEASE ORL,
ORDER_RELEASE_STATUS ORLS
WHERE ORL.ORDER_RELEASE_GID = ORLS.ORDER_RELEASE_GID
AND ORLS.STATUS_TYPE_GID = '<DOMAIN_NAME>.PLANNING'
AND ORLS.STATUS_VALUE_GID = '<DOMAIN_NAME>.PLANNING_NEW'
AND TRUNC(ORL.INSERT_DATE)=TRUNC(SYSDATE)

You may wish to extend this to remove the necessity of specifying a Domain Name

Gary

[njoyotm]

Re: Auto Plan Release From XML

Hi Gary,

Thank you very sincerely.
The XML works as expected.
Can you suggest me other possible TopicAliasName other than BuildBuySideShipments,
BuildSellSideShipments?

Regards,
njoyotm

[njoyotm]

Re: Auto Plan Release From XML

Hi all,

The below are the inbuilt TOPIC ALIAS NAME:

CreatBufferOrder
TenderResponse
PlannedShipmentCreated
ShipmentReadyForRetender
TenderWithdrawn
ShipmentReadyForExecution
ShipmentReadyForExecutionAndTransport
ShipmentReadyForTransport
ShipmentStatus
ShipmentTracking
TimerTick
Mail
Fax
BulkRating

Thanks and Regards,
njoyotm