Creating Dependent Parameter in Fusion BI Report
If you want to make any parameter dependent on other parameter in oracle fusion BI reports then below is the sample sql example provided while creating LOV for the dependent…
Read MoreDynamically Displaying XSL Element
<?xml version=”1.0″ encoding=”utf-8″?> <!– +======================================================================+ –> <!– | Copyright (c) 2005, 2014 Oracle and/or its affiliates. | –> <!– | All rights reserved. | –> <!– | Version 12.0.0 |…
Read MoreTo Create Business Purpose as Statements for Customer Site
To Create Business Purpose as Statements for Customer Site / SET SERVEROUTPUT ON; DECLARE p_cust_site_use_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE; p_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE; x_site_use_id NUMBER; x_return_status VARCHAR2(2000); x_msg_count NUMBER; x_msg_data VARCHAR2(2000); ln_cust_acct_id NUMBER; lv_location VARCHAR2(240);…
Read More