Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
BMQL Error — Cloud Customer Connect
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

BMQL Error

Accepted answer
13
Views
3
Comments
edited May 25, 2021 6:13PM in Configure Price Quote 3 comments

Content

BML Code:

 

ApprovedDisount=0.0;

if(status_t=="Approved")
{
    ApprovedDisount=totalDiscount_Header;
}
modifySet1="SPA_ID='"+transactionID_t+"'";
modifySet2="Distributor='"+distributorName_Header_Distributor+"'";
modifySet3="Requester='"+owner_t+"'";
modifySet4="RequestedDiscount='"+string(totalDiscount_Header)+"'";
modifySet5="ApprovedDisount='"+string(ApprovedDisount) +"'";


results= bmql("modify MasterMetrics set $modifySet1, $modifySet2, $modifySet3, $modifySet4, modifySet5 where $modifySet1");

return "";

 

 

Error:

  • Compilation error: Error in line 14, column 122: bmql: Encountered " "," ", "" at line 1, column 37.
  • Was expecting one of:
  • <EOF>
  • "WHERE" ...

 

Any suggestion is appreciated.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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