Visual Builder

Get Involved. Join the Conversation.

Posts

  • Cesar Tepetla Corte
    Security when embedding a Visual Builder application in...15
    Topic posted November 27, 2018 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged Groovy, SaaS Integration, Security, Services, Stage / Publish / DevOps, UI, Validation, Web 
    Title:
    Security when embedding a Visual Builder application in Oracle Fusion page integrator
    Summary:
    Security when embedding a Visual Builder application in Oracle Fusion page integrator
    Content:

    Hi

    I have embedded an application of Autonomous Visual Builder with page integrator in Oracle Fusion the problem is that I have to log in to Visual Builder to view the page in Fusion otherwise nothing will be shown.

    In what way can I avoid this? What I'm looking for is for the user to log in only on Fusion and see the application.

    Any comments and guidance is grateful.

    Thanks

  • Stephen Bryant
    regExp in Visual BuilderAnswered12
    Topic posted June 7, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Business Objects, Groovy, UI, Validation 
    Title:
    regExp in Visual Builder
    Summary:
    Attempting to Implement Pattern Match
    Content:

    Hello,

    I need some guidance on how to best go about validating a field for a particular pattern.

    I've tried implementing the Jet Cookbook approach but cannot import the RegExpValidatorFactory.  I wanted to use the validator property on the field and I figured this was the way to go about it.  

    I also checked out creating a regExp validator on the business object but the compile method is not allowed on the server.

    The pattern I am implementing is simple but how to get it into Visual Builder is the problem.  If someone can point me in the right direction (e.g., how to import the regExp validation factory) that would be great.

    Thanks,

    Steve

    **Update**

    I imported the validators this way and it worked --- "define(['ojs/Validator','ojs/RegExpValidator'], function(oj) { ...}

    I created a blur event on the field calling this function:

     PageModule.prototype.plCodeValidator = function(plCode) {

        var rvf = oj.Validation.validatorFactory(oj.ValidatorFactory.VALIDATOR_TYPE_REGEXP);
        var plCodeValid = rvf.createValidator({
          'pattern': '\d{3}\-\d{3}',
          'messageDetail': 'You must enter two sets of three numbers separated by a dash'     
          
        });
        
        if(plCodeValid.validate(plCode)) {
          
          return true;
          
        } else {
          
          return false;
        }

      };

    I am now getting the following errors in Chrome Dev Tools:

    CallModuleAction (callModuleFunction1_cakqkh3et) The module does not exist or the function 'plCodeValidator' does not exist in the module.

    Action CallModuleAction failed. CallModuleAction (callModuleFunction1_cakqkh3et) The module does not exist or the function 'plCodeValidator' does not exist in the module.

     

    Can anyone help?  It appears the validators will not import.  I can verify that in devtools.  Am I barking up the wrong tree?

    Thanks,

    Steve

     

     

     

     

     

    Version:
    19.1.3
  • Ziv Rubin
    Browser Crashed While Trying to Load 20K Rows From External...11
    Topic posted August 4, 2019 by Ziv RubinBronze Medal: 1,250+ Points, tagged Business Objects, Database, Groovy, REST, Web 
    Title:
    Browser Crashed While Trying to Load 20K Rows From External REST API
    Content:

    Hi All,

    While trying to load data from a rest API to a Business Object, it suddenly crashes - probably because I was trying to load 20K rows.

    Does anyone know a better way to load data from external REST API to my VBCS BO?

    Thanks,

    Ziv

  • Nathan Zentner
    Variable Access from Trigger8
    Topic posted January 9, 2019 by Nathan ZentnerRed Ribbon: 250+ Points, tagged Business Objects, Groovy 
    Title:
    Variable Access from Trigger
    Summary:
    Variable Access from Trigger
    Content:

    How can I use application variables within a trigger of a Business Object.

    I could not figure out how to pass or use an Application variable within a groovy trigger.

    $application.variables.<myvarname>

  • Stephen Bryant
    Field Level Update Trigger updates field only onceAnswered6
    Topic posted November 15, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Business Objects, Custom Code, Groovy 
    Title:
    Field Level Update Trigger updates field only once
    Summary:
    Field Level Update Trigger on BO only updates field when record is created
    Content:

    Hello,

    I have a very simple trigger in one BO that executes always.  When a field is updated (treasurySymbol), I grab another field from a related BO (attributeOne).

    This works fine when the record is created but updates do not work.

    It is an update trigger so I am a little confused here.  When I change the treasurySymbol field, the attribute1 field does not change.

    Here is the simple code generated:

    // Field Trigger Beginning 
    println 'Field Trigger started: testUpdateTrigger, business object: fvBeTrxHdrs, field: treasurySymbol';

    try {

      // Always Execute Criterion (Always Execute)
      alwaysExecuteCriterion_1: {
        // Action Group (Action Group)
        test = {
        treasurySymbolObject.attributeOne
        }.call();

      }

    } finally {

      // Field Trigger End 
      println 'Field Trigger ended: testUpdateTrigger';

    }

    Am I missing anything?  I've tried setAttribute, isAttributeChanged without success.

     

    Thank you,

    Steve

    Version:
    19.3.1.2
  • Deep Mandal
    Oracle VBCS Role Based Mail SendAnswered65.0
    Topic posted November 14, 2019 by Deep MandalGreen Ribbon: 100+ Points, tagged Action Flows, Business Objects, Custom Code, Groovy 
    Title:
    Oracle VBCS Role Based Mail Send
    Summary:
    Oracle VBCS Role Based Mail Send
    Content:

    In Oracle VBCS how can we send mail to the Users attached to particular VBCS Role.

    For Example:

    Suppose I have two Roles Creator and Approver. So, when users having "Creator" Role creates some record in VBCS BO then I want to send mail to the users having "Approver" role. How this business scenario can be achieved.

    Version:
    19.3.1.2
  • Stephen Bryant
    Object Trigger - create record in another BOAnswered6
    Topic posted July 9, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Business Objects, Custom Code, Groovy, Validation 
    Title:
    Object Trigger - create record in another BO
    Summary:
    Object Trigger - only create if the record does not exist in the target BO
    Content:

    Hello,

    I have two BOs.  One BO stores balances by various attributes.  I have an Object trigger on this BO that will create the record in another BO as long as certain fields are not present in the BO.  For example, the source BO has fields for Fund, Period and Balance.  If the combination of those fields does not exist in the target BO, then create the record.

    I cannot seem to programmatically access the fields in the target BO using object trigger.

    How can I check using an Object Trigger if fields exists in the target BO? There is no relationship between the two.

    However, if I were to relate the two, could I accomplish this?

    Any other suggestions?

    Thanks,

    Steve

    Version:
    19.1.3
  • Abhilasha Singh
    How to assign repeating element of a variable with values...5
    Topic posted October 23, 2019 by Abhilasha SinghRed Ribbon: 250+ Points, tagged Custom Code, Groovy, JET, REST, UI 
    Title:
    How to assign repeating element of a variable with values from an array in the action chain
    Summary:
    How to assign repeating element of a variable with values from an array in the action chain
    Content:

    I have a variable based on REST endpoint that has repeating element in it that needs to be assigned from the rows of an ADP variable. How do I do that in action chain. I don't see for available in assign. if I use for each in the action chain how do I iterate the target variable to assign to next row in the loop. 

    Document:
    assign.PNG (33KB)
  • Nisheeth Ranjan
    When the Field Level Validation Triggers5
    Topic posted June 17, 2019 by Nisheeth RanjanSilver Medal: 2,000+ Points, tagged Business Objects, Groovy, Validation 
    Title:
    When the Field Level Validation Triggers
    Content:

    Hi Experts, 

    I am adding a field level validation trigger on one of my BO fields. This field is being populated using a Dropdown(Select One ) Component.

    So the use case is if the user doesn't select any value in the dropdown and click on a submit button on the page(means the value is null for the field), it should throw the error I have defined in the validation trigger.

    I have defined the trigger and added the condition however it's not triggering the validation.

    Is the approach I am following is correct? When does the field level validation trigger on a page?

    Thanks,

    Nisheeth

     

  • Stephen Bryant
    Compare Amount in UI Field to Business Object dataAnswered5
    Topic posted May 24, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Business Objects, Custom Code, Groovy, UI, Validation 
    Title:
    Compare Amount in UI Field to Business Object data
    Summary:
    Verify funds are available for a transaction
    Content:

    Hello,

    I have a transaction screen where I want to verify that funds are available for a given transaction before saving.

    The amount of the current transaction is compared to the amount of a predecessor transaction.  If the predecessor transaction has other transactions booked against it, those transactions must also be included in the amount available calculation.

    For example, the data in the Business Object may look like this:

    docNumber          fromDocNumber      Amount

    transA                   ----                           $1000

    transB                  transA                       200

    transC                  transA                       100

    Amount available is $700

    The next Transaction comes in for 500.  Checking for funds would iterate through the Business Object and summarize the remaining amount and make the compare of $700 and $500.

    I can do this in JavaScript in Sublime but I fail to get it to work in VBCS.

    I tried a Field Validation rule on the BO but I cannot access the existing data in the BO, only the current transaction data.  I would like to create an array/list in the Field Validation Rule but cannot get to the existing data.

    If I create a JavaScript function on the page, I cannot iterate over the Business Object to summarize the data.

    Can anyone provide guidance?

    Thanks,

    Steve

    Version:
    19.1.3