Oracle Fusion ERP – AR Cash Report Sample Query
Oracle Cloud ERP – Buyer Query
Which THREE predefined database service names are available in an Autonomous Data Warehouse?
Workload Type Database Services Names Data Warehouse dbname_high dbname_medium dbname_low Transaction Processing dbname_tpurgent dbname_tp dbname_high dbname_medium dbname_low JSON Database dbname_tpurgent dbname_tp dbname_high dbname_medium dbname_low →Read more
eText Template in Oracle BI/XML Publisher
An eText template is an RTF-based template that is used to generate text output for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI). At runtime, BI Publisher applies this template to an input XML data file to create an output text file that can be transmitted to a bank or other customer. Because the […] →Read more
XML Publisher – Data Template Approach – Samples
XML Publisher Data Template Sample →Read more
Oracle APEX – Display Icon in the Navigation Bar
I have come across a requirement to show icon in the Navigation Bar – below screenshot is the solution for the same 🙂 →Read more
Oracle E-Business – Invoke Concurrent Programing Using PLSQL
Oracle Fusion BI Publisher Desktop
Verify BIP Version with the Fusion ERP – BIP Click the below link and download the appropriate BIP Version https://www.oracle.com/middleware/technologies/analytics-publisher/downloads.html →Read more
DEPT and EMP Table Scripts Oracle Database
create table dept(deptno number(2,0),dname varchar2(14),loc varchar2(13),constraint pk_dept primary key (deptno)) ; create table emp(empno number(4,0),ename varchar2(10),job varchar2(9),mgr number(4,0),hiredate date,sal number(7,2),comm number(7,2),deptno number(2,0),constraint pk_emp primary key (empno),constraint fk_deptno foreign key (deptno) references dept (deptno)); INSERT INTO DEPT VALUES (10, ‘ACCOUNTING’, ‘NEW YORK’);INSERT INTO DEPT VALUES (20, ‘RESEARCH’, ‘DALLAS’);INSERT INTO DEPT VALUES (30, ‘SALES’, ‘CHICAGO’);INSERT INTO DEPT […] →Read more