Monday, March 23, 2020

cards using badge in oracle apex

--card copy in template 1
--

<div class="db2_container #CONTAINER_CLASS#">
  <div class="db2_main">
    <div class="db2_number">
#DATA#</div>
<div class="db2_title">
                                #TITLE#</div>
<div class="db2_text">
                                #TEXT#</div>
</div>
<div class="db2_icon_container">
    <i class="fa #ICON_CLASS#"></i>
  </div>
</div>


---calsical report

select 'Population'  title
     , population    data
     , 'Number of inhabitants'  text
     , 'fa-users'   as  icon_class
     , 'db2_red'     as  container_class
from   cnt



--page css inline


.db2_container {
    background-color: rgb(237, 102, 71);
    color: white;
    float: left;
    height: 120px;
    margin-right:1%;
    padding: 5px;
    position: relative;
    width: 24%;
}

.db2_icon_container {
    height: 100%;
    left: 0;
    padding-top: 30px;
    position: absolute;
    text-align: center;
    top: 0;
    width: 80px;
}

.db2_red {
    background-color: rgb(237, 102, 71);
}
.db2_blue {
    background-color: rgb(38,125,179);
}
.db2_green {
    background-color: rgb(104,193,130);
}
.db2_orange {
    background-color: rgb(250,213,92);
}
.db2_main {
    border-left: 1px solid white;
    left: 80px;
    padding: 0 10px;
    position: absolute;
    top: 5px;
    height:110px;
}

.db2_number {
    font-size: 1.8em;
    padding: 10px 0 5px;
}

.db2_container i {
    font-size: 50px;
}
.db2_text {
    font-size: 0.8em;
    line-height: 1.1em;
}

Wednesday, March 18, 2020

REP-52262 Diagnostic output is disabled in oracle



















D:\Oracle\Middleware\Config\domains\base_domain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration

D:\Oracle\Middleware\Config\domains\base_domain\servers\WLS_REPORTS\tmp\_WL_user\reports_12.2.1\4ltj0p\configuration

     <!–webcommandaccess>L1</webcommandaccess–>
        Then change the value from L1 to L2
     <webcommandaccess>L2</webcommandaccess>
    Save and close the file
    Restart WLS_REPORTS

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...