Sairam Nimmagadda

R12 SLA (Sub ledger Accounting) 1) All accounting performed before transfer to the GL. Accounting data generated and stored in “Accounting Events” tables prior to transfer to GL 2) Run “Create Accounting” to populate accounting events (SLA) tables. User can “View Accounting” only after “Create Accounting” is run. Create Accounting process – Applies accounting rules – Loads SLA tables, GL tables – Creates detailed data per accounting rules, stores in SLA “distribution links” table 3) Below are the key tables for SLA in R12 XLA_AE_HEADERS xah XLA_AE_LINES xal XLA_TRANSACTION_ENTITIES xte XLA_DISTRIBUTION_LINKS xdl GL_IMPORT_REFERENCES gir Below are the possible joins between these XLA Tables xah.ae_header_id = xal.ae_header_id xah.application_id = xal.application_id xal.application_id = xte.application_id xte.application_id = xdl.application_id xah.entity_id = xte.entity_id xah.ae_header_id = xdl.ae_header_id xah.event_id = xdl.event_id xal.gl_sl_link_id = gir.gl_sl_link_id xal.gl

select distinct a.form_name, a.enabled, c.user_form_name, d.application_name from fnd_form_custom_rules a,           fnd_form b,           fnd_form_tl c,           fnd_application_tl d where             enabled = ‘Y’ and       a.form_name = b.form_name and                   b.form_id     = c.form_id and      b.application_id = d.application_id order by application_name 

Bulk Collect & For All vs Cursor & For-Loop After more and more reads about BULK COLLECT and FORALL and their performance improvements      I decided to have a closer look on it by myself to see how powerful they really are. So I built a little test-case which inserts all entries from the all_object view into another table. The inserts happens on three different ways: First way is a simple cursor over the view and a insert in a loop with FETCH into local variables. This way also shows how slow the opening of the cursor itself is. The second way is a simple FOR – IN LOOP with the insert of the cursor variables. And, of course, the third way is the way with bulking the rows and inserting them with FORALL so lets see. So the other table looks like this (three columns are enough for this tests) SQL> create table temp (owner varchar2(30), name varchar2(30), type varchar2(19)); Table created. And the three diffrent procedures looks like this CREATE OR REPLACE PROCEDURE CURSO