Oracle Applications E-Learning Lab

Friends, Recently while exploring the latest oracle cloud features, VBCS caught my attention I was curious to learn more about this technology. I quickly hopped into  Oracle Groundbreakers Forum  and posted a query to understand and learn about this nascent technology VBCS. Based on my learning and understanding about VBCS, I'm putting all together in this article which will help you to understand the concept of VBCS and its architecture What is VBCS?  VBCS stands for Visual Builder Cloud services, it is a part of PaaS cloud services, similar to Java Cloud services. Using VBCS we can create and host both web and mobile applications in a secure cloud environment. Aimed at users who aren’t professional software developers, VBCS delivers an intuitive and visual development experience with no-coding required for application development.   Oracle Visual Builder leverages the open-source Oracle JavaScript Extension Toolkit (Oracle JET) to create engaging web and mobile interfaces. The re

Query to find out Profile Option values at Various levels SELECT fpo.profile_option_name SHORT_NAME,          fpot.user_profile_option_name NAME,          DECODE (fpov.level_id,                  10001, 'Site',                  10002, 'Application',                  10003, 'Responsibility',                  10004, 'User',                  10005, 'Server',                  'UnDef')             LEVEL_SET,          DECODE (TO_CHAR (fpov.level_id),                  '10001', '',                  '10002', fap.application_short_name,                  '10003', frsp.responsibility_key,                  '10005', fnod.node_name,                  '10006', hou.name,                  '10004', fu.user_name,                  'UnDef')             "CONTEXT",          fpov.profile_option_value VALUE     FROM fnd_profile_options fpo,          fnd_profile_option_v