Blogs

FIne Grained Dependencies in Oracle 11g

Dependency Oracle schema is the place where all the Database objects get stored. This make a room for the entire set of objects under the Category of Data Storage ( Tables, Views) and Data Access (Stored Procedure ,Functions ,Packages and Triggers) .These Objects make a reference across all these objects to form the application.This is known as dependency.

Impact on Packages - Assign permissions directly vs Assign permission via Roles

articles: 

Document depicts how Roles and Privileges behave for Packages

DB Version: 10.2.0.4

Users: TESTUSR (Table Owner)
TESTUSR_PKG (Package Onwer)
TESTUSR_APP (Application Owner)

Roles: TESTUSR_APP_ROLE
TESTUSR_PKG_ROLE

Table: TEST_TBL
Package: TEST_PKG

Table Text:
create table test_tbl(a number);

Announcing my upcoming Book on Advanced Oracle PL/SQL Concepts (1Z0-146 Preparation handbook)

articles: 

Hello,

It gives me great pleasure and honour to announce my upcoming book Oracle Advanced PL/SQL Developer Professional Guide with Pact Publishers. The book 'Oracle Advanced PL/SQL Developer Professional Guide' is focussed on the preparation of OCP (1Z0-146) examination. The book doesn't restricts its scope to the examination but aims to strengthen the advanced concepts in Oracle 11g PL/SQL.

Basics of Partition Tables in Oracle

Basics of Partition Tables

Please use ANSI join syntax

articles: 

The old Oracle join syntax really should be consigned to history.

vamsi kasina's picture

R12 - XLA / FAH - Useful Notes / GDFs / Patches

articles: 

Miultiple Entities GDF 9651687
In SLA Not In GL GDF 9481239

FAQ for SLA Upgrade 604893.1
SLA Obsolete Profiles 553229.1
FAQ - FSAH / FAH 729545.1
XLA Setup Diagnostics Test 942252.1

vamsi kasina's picture

R12 - XLA / FAH - After running Validate AAD program, why the XLA dynamic package becomes invalid?

articles: 

Subledger Accounting / Financials Accounting Hub uses dynamic package to generate the journal entries.
Depending on the rules (AMB Setup and Event Model) the dynamic package will be created, when the Validate Application Accounting Definition program has been run.
The package will be generated with the naming convension XLA_{5DIGIT_APPL_ID}_AAD_{SEED_CUSTOM}_{6DIGIT_AAD_HASH}_PKG.
AAD_HASH value will be found in xla_product_rules_b.product_rule_hash_id.

   SELECT 'XLA_' || lpad(application_id,5,'0') || '_AAD_' || 
          product_rule_type_code || '_' || lpad(product_rule_hash_id,6,'0') || '_PKG'
   FROM xla_product_rules_b
   WHERE application_id = &p_appl_id
   AND amb_context_code = NVL('&amb_context_code','DEFAULT')
   AND product_rule_code = '&aad_code';
Examples for dynamic pakcages:
XLA_00555_AAD_C_011117_PKG
XLA_00200_AAD_S_000012_PKG

Common ORA errors

Below are some ORA-ERROR which every DBA face:

1. ORA-00600/ORA-07445
Clause: Most likely it is related to bug
Solution: go to metalink and apply patch set.

2. ORA-03113
Clause: It is generic error means lots of reason behind this.
Solution: Depends on condition but best way to search on google/forms.

3. ORA-04031
Clause: Mis-configuration of SGA, insufficient memory
Solution: Sametime need to add memory on system, or sametime need to reduce SGA memory

Script to find Oracle database performance

articles: 

This single script provides the overall picture of the database in terms of Waits events, Active/Inactive killed sessions, Top Processes (physical I/O, logical I/O, memory and CPU processes), Top CPU usage by users, etc.

vamsi kasina's picture

R12 - GL / XLA / FAH - Reporting Currencies

articles: 

There are three levels of reporting currencies.
Subledger, Journal and Balance.

The data will be create for those ledgers, when the following processes have been run.
Create Accounting - Journals will be created in SLA.
Transfer to GL & Journal Import - Journals will be created in GL.
Post to GL - Balances will be created / updated in GL.

Pages

Subscribe to RSS - blogs