Posts

Showing posts from June, 2020

Balance sheet

Image
Oracle Apex - Balance Sheet I have developed nice report to show the Balance Sheet using PL/SQL Dynamic Content. Steps : 1. create a table to store the Main Account Details 2. Create table to store the sub account details sample data as follows for Main Account Details sample data as follows for Sub Account Details 3. create a PL/SQL Dynamic Content Region and write the below code Balance Sheet main Report Drill Down Note : define the "GetInfo" javascript for drill down report, you must define it in Page Designer > HTML Header as follows

Customize Apex Login

Image
How to customize Oracle Apex - Application Login Page Sometime i feel little dryness in Oracle Application login page, just like similar to below  While searching in internet i found below steps to change your login page appearances like below Application Express 18.1.0.00.45 Steps : 1. upload the files into your workspace Application Builder -- Shared Components - Static Application files  2. Write Below HTML - CSS code  in     a. Goto Page # 9999 (Default Login Page)     b. Goto Page Designer Property > CSS > Inline span.t-Login-logo { background-image: url(#APP_IMAGES#logo.jpg); background-size: cover; width: 400px; height: 204px; } .t-Body {   background: url(&APP_IMAGES.backround.jpg); } That's All, You can see nice login page during login.