You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Order Management Extension

edited May 4, 2020 4:19PM in Order Management 2 comments

Summary

Empty groovy rowset

Content

Hi there,

I'm facing an issue trying to get the information of a sales order using the following code in Groovy

 

    //Get the PO Number from original PO
    def headerPVO = context.getViewObject("oracle.apps.scm.doo.processOrder.publicModel.partyMerge.view.HeaderPVO");        
 
    def vc = headerPVO.createViewCriteria();                                                               
    def vcrow = vc.createViewCriteriaRow();                                                              
    vcrow.setAttribute("SourceOrderNumber", 58473);//docRef.getAttribute("DocumentNumber"));                                                       
    vcrow.setAttribute("SourceOrderSystem", "OPS");//docRef.getAttribute("DocumentAdditionaldentifier"));

     
    def rowset = headerPVO.findByViewCriteria(vc, -1);                                                     
    def headerPRow = rowset.first();   

 

Although I know the sales order exists, no way to retrieve the information getting always an empty row.

Some lights on this topic?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!