Yearly Archives: 2020

Supplier Import Using FBDI – Fusion Applications

This blog describes the step by step process of Supplier migration in Fusion Application using File Based Data Import. FBDI Template: SupplierImportTemplate.xlsm Interface Tables: POZ_SUPPLIERS_INT Base Table: POZ_SUPPLIERS Import Process:…

Read More

iExpense audit SLA report

Introduction This report is about to find the expense details and time taken to complete the audit. SELECT A.Report_Number, A.Employee_Name, A.Emp_Number, A.Operating_Unit, A.Amount, A.Currency, A.Last_Audited_By, A.Report_submit_date, TO_CHAR(A.Claim_Approved_Date,’DD-MON-YYYY HH24:MI:SS’) Claim_Approved_Date, TO_CHAR(A.Pending_Your_Resolution_Date,’DD-MON-YYYY…

Read More

Protecting Data using Oracle Maximum Availability Architecture

When considering the security, it is important to ensure the availability. Data High availability ensured by achieving below key architecture to preventing downtime. Data Availability: Ensure that we are not…

Read More

Oracle Data Safe

Data Safe is a control center for your Oracle Databases which helps understand the sensitivity of data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess…

Read More

Guidelines for Securing the Network

Network security was improved by using client, listener, and network guidelines to ensure protection. Using SSL is an essential element in these lists, enabling top security for authentication and communications.…

Read More

Oracle Secure Backup

Oracle Secure Backup is a centralized tape backup management solution providing heterogeneous data protection in distributed UNIX, Linux, Windows, and Network Attached Storage (NAS) Environments. By protecting the file system and…

Read More

Oracle Sharding

A scalability and availability feature for custom-designed OLTP applications that enables distribution and replication of data across a pool of discrete Oracle Databases. This pool of databases is presented to…

Read More

LEAST PRIVILEGE AND SEPARATION OF DUTY

To support the principles of least privilege and separation of duty, the SYSOPER administrative privilege allows an administrator to perform limited tasks such as starting and stopping the database without having…

Read More

Oracle Data Redaction

Oracle Data Redaction provides the ability to masking data, typically sensitive data in real-time like credit card, Aadhar card details etc. before displaying with application. For example, in a call…

Read More

How Oracle Database Vault Addresses Database Consolidation Concerns

Consolidation and cloud environments reduce cost but can expose sensitive application data to those without a true need-to-know. Data from one country may be hosted in an entirely different country,…

Read More