Basics of Partition Tables

Partitioning is a method of splitting an object (a table or index) into separate parts (called partitions) based on some criterion that is assigned to the partition. The criterion might be a date range, a number range, or any other possible value. Imagine, for example, that you have a huge table that is driving you crazy because queries on it are really slow. You get so mad at this table that you take a logical hatchet and begin to slice the table up into many smaller tables is a partition.

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

Miultiple Entities GDF 9651687
In SLA Not In GL GDF 9481239

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

Subledger Accounting 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.

Examples for dynamic pakcages:
XLA_00555_AAD_C_011117_PKG
XLA_00200_AAD_S_000012_PKG

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

4.

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.

[code]set serveroutput on
declare
cursor c1 is select version
from v$instance;
cursor c2 is
select
host_name
, instance_name
, to_char(sysdate, 'HH24:MI:SS DD-MON-YY') currtime
, to_char(startup_time, 'HH24:MI:SS DD-MON-YY') starttime
from v$instance;
cursor c4 is
select * from (SELECT count(*) cnt, substr(event,1,50)

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.

Subledger Level - It maintains data in SLA for ALC also, you can view the accounting in SLA OA pages and other reports.

Oracle 11.2.0.3, the second patch set for the 11gR2 database, is now certified with with E-Business Suite and is available for download in 32 and 64-bit.

You can download it from only your meta link account credential.

Patch No: 10404530

Oracle E-Business Suite Release 11i

Prerequisites

* 11.5.10.2 + ATG PF.H RUP 6 and higher

Certified Platforms

* Linux x86 (Oracle Linux 4, 5)
* Linux x86 (RHEL 4, 5)
* Linux x86 (SLES 10)
* Linux x86-64 (Oracle Linux 4, 5)

EPractize Labs Software, an emerging global provider for Java Certification Preparation released world’s first exam study guide (Training Lab) for Oracle Certified Associate, Java SE 7 Programmer certification. Download your FREE copy today and empower your preparation.

Oracle offers variety of Java Certifications for all Java Editions (Java SE, Java EE and Java ME).