Posts by Doyensys

Report Generation from BI through APEX

Oracle APEX is user friendly for designing part as well as client side data entry and validation related things. Oracle BI Publisher is good for report output; it will give…

Read More

Create Customize POPUP LOV for APEX

Javascript Used to Get the Tabular Form Id           Example :           var eleTables = document.getElementsByTagName(“table”);           for…

Read More

Dynamically Generate the Checksum id to solve the apex vulnerability problem

Ajax(Application Process) used call the Oracle Query of APEX_ITEM.MD5_CHECKSUM Java method of Math.random used to get Random no Random no used to get the Attribute value from Select list  …

Read More

To put the Company logo in each APEX page

Go to Shared Components then click the images link and upload the image to application. Click the Definition write the image name to logo text field as #WORKSPACE_IMAGES#company_logo.gif Go to…

Read More

BI Bursting

One of the very good features of Oracle BI Publisher is its ability to burst and send the reports to multiple users simultaneously. Using BI Publisher’s bursting feature we can…

Read More

Table Partitioning

Every data’s should be stored in database, because world can’t run without storing the data’s in the database.  Machinery world should store data’s in database for future reference and process,…

Read More

Untitled

EXCLUDE=STATISTICS Or EXCLUDE=INDEX_STATISTICS During Datapump Import Still Analyzes The Indexes APPLIES TO: Oracle Database – Enterprise Edition – Version 10.2.0.1 and later SYMPTOMS: You are using Data Pump import (impdp)…

Read More

Untitled

While Accessing Public Synonym Getting Error ORA-1775: looping chain of synonyms APPLIES TO: Oracle Database – Enterprise Edition – Version 11.2.0.3 and later SYMPTOMS: User created a public synonym with…

Read More

Untitled

DataPump Import Results In ORA-39001 Invalid Argument Value ORA-1775 Looping Chain Of Synonyms APPLIES TO: Oracle Database – Enterprise Edition – Version 10.2.0.2 and later SYMPTOMS: When running DataPump import…

Read More

Untitled

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL Worked But Nothing In Dba_network_acls APPLIES TO: Oracle Database – Enterprise Edition – Version 11.2.0.2 and later SYMPTOMS: Nothing in the dba_network_acl_privileges view after creating ACL. Created ACL list as below.…

Read More