Auto Pricing Is Not Working In Opportunity (Doc ID 2073107.1)

Last updated on NOVEMBER 05, 2015

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Goal

We have created a custom object called price list line item under sales.we are maintaining the price for each product in the price list line item.From there we are fetching the price based on the product selected in the opportunity.It was working fine earlier now its stopped working.
Same code its working fine in stagging environment.

def strobjRevenueView = nvl(ChildRevenue,0);
  //strobjRevenueView.UnitPrice=0.00;
def Price1=0.00;
int i=0;
while(strobjRevenueView.hasNext())
  {
  println("inside while")
def revItem=strobjRevenueView.next()
def strItemNumber=revItem.ItemNumber;
  setAttribute('Description',strItemNumber);
//revItem.UnitPrice=0.00;

def view2= newView('PriceListLineItem_c')
  def vc1 = view2.createViewCriteria();
  def vcr1 = vc1.createRow();
  vc1.insertRow(vcr1);
  def vci1 = vcr1.ensureCriteriaItem('RecordName');
  vci1.setOperator('=');
  vci1.setValue(strItemNumber);
  view2.executeQuery();

while(view2.hasNext())
{ def row = view2.next();

if(row.getAttribute('Product_c')==nvl(strItemNumber,null))
{
// println("Inside");
Price1 = row.getAttribute('ListPrice_c');

setAttribute('Description',Price1);

row.setAttribute("UnitPrice",Price1);

}
}

}
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms