TKPROF: Release 10.2.0.5.0 - Production on Thu Apr 21 08:46:08 2011 Copyright (c) 1982, 2007, Oracle. All rights reserved. Trace file: test_ora_7660_APPS.trc Sort options: prsela exeela fchela ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** SELECT DECODE(SUBSTR (VALUE,1,INSTR(VALUE,',') -1) , NULL , VALUE , SUBSTR (VALUE,1,INSTR(VALUE,',') -1)) FROM V$PARAMETER WHERE NAME = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 821988 290.28 284.81 0 0 0 0 Fetch 821988 6761.45 6607.34 0 0 0 821988 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1643977 7051.73 6892.15 0 0 0 821988 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 821988 HASH JOIN (cr=0 pr=0 pw=0 time=6596874798 us) 821988 FIXED TABLE FULL X$KSPPI (cr=0 pr=0 pw=0 time=1959986827 us) 1331620560 FIXED TABLE FULL X$KSPPCV (cr=0 pr=0 pw=0 time=3782027642 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 821988 HASH JOIN 821988 FIXED TABLE (FULL) OF 'X$KSPPI' (TABLE (FIXED)) 1331620560 FIXED TABLE (FULL) OF 'X$KSPPCV' (TABLE (FIXED)) ******************************************************************************** SELECT SUM (NVL(XAL.ACCOUNTED_CR , 0 ) ) , SUM (NVL(XAL.ACCOUNTED_DR , 0 ) ) FROM AP_INVOICES_ALL A , AP_INVOICE_DISTRIBUTIONS_ALL B , PO_VENDORS POV , PO_VENDOR_SITES_ALL POVS , XLA_AE_LINES XAL , XLA_AE_HEADERS XAH , XLA_TRANSACTION_ENTITIES XTE WHERE A.INVOICE_ID = B.INVOICE_ID AND POV.VENDOR_ID = A.VENDOR_ID AND POVS.VENDOR_ID = POV.VENDOR_ID AND A.VENDOR_ID = NVL(:b1 , A.VENDOR_ID ) AND A.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID AND B.ACCOUNTING_EVENT_ID = XAH.EVENT_ID AND XAH.APPLICATION_ID = 200 AND XAH.ENTITY_ID = XTE.ENTITY_ID AND XTE.ENTITY_CODE = :b2 AND XTE.APPLICATION_ID = 200 AND XTE.SOURCE_ID_INT_1 = A.INVOICE_ID AND XAL.APPLICATION_ID = 200 AND XAL.AE_HEADER_ID = XAH.AE_HEADER_ID AND XAH.LEDGER_ID = B.SET_OF_BOOKS_ID AND A.ACCTS_PAY_CODE_COMBINATION_ID = NVL(:b3 , A.ACCTS_PAY_CODE_COMBINATION_ID ) AND ( A.ORG_ID = :b4 OR A.ORG_ID IS NULL ) AND A.VENDOR_ID = :b5 AND A.INVOICE_CURRENCY_CODE = :b6 AND XAL.ACCOUNTING_CLASS_CODE IN ( :b7 , :b8 ) AND B.ACCOUNTING_DATE <= :b9 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 912 1.77 1.84 0 0 0 0 Fetch 912 450.62 1032.07 161874 12067108 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1825 452.40 1033.92 161874 12067108 0 912 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 912 SORT AGGREGATE (cr=12067108 pr=161874 pw=0 time=1032088430 us) 64 TABLE ACCESS BY LOCAL INDEX ROWID XLA_AE_LINES PARTITION: 1 1 (cr=12067108 pr=161874 pw=0 time=1031828513 us) 18937536 NESTED LOOPS (cr=9702234 pr=89387 pw=0 time=991599776 us) 1071933 NESTED LOOPS (cr=7465055 pr=68724 pw=0 time=414889288 us) 1071933 NESTED LOOPS (cr=4247513 pr=47915 pw=0 time=277447286 us) 1071946 NESTED LOOPS (cr=1026270 pr=26259 pw=0 time=109195788 us) 104877 NESTED LOOPS (cr=462136 pr=0 pw=0 time=18590177 us) 104878 NESTED LOOPS (cr=250699 pr=0 pw=0 time=14833655 us) 912 NESTED LOOPS (cr=4560 pr=0 pw=0 time=70480 us) 912 TABLE ACCESS BY INDEX ROWID AP_SUPPLIERS (cr=2736 pr=0 pw=0 time=46610 us) 912 INDEX UNIQUE SCAN AP_SUPPLIERS_U1 (cr=1824 pr=0 pw=0 time=24652 us)(object id 280445) 912 INDEX UNIQUE SCAN HZ_PARTIES_U1 (cr=1824 pr=0 pw=0 time=18645 us)(object id 51195) 104878 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=246139 pr=0 pw=0 time=14617737 us) 305002 INDEX RANGE SCAN AP_INVOICES_N18 (cr=7967 pr=0 pw=0 time=1607700 us)(object id 280573) 104877 TABLE ACCESS BY INDEX ROWID AP_SUPPLIER_SITES_ALL (cr=211437 pr=0 pw=0 time=3340688 us) 104877 INDEX UNIQUE SCAN AP_SUPPLIER_SITES_U1 (cr=106560 pr=0 pw=0 time=1750758 us)(object id 280471) 1071946 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=564134 pr=26259 pw=0 time=111358451 us) 1071946 INDEX RANGE SCAN AP_INVOICE_DISTRIBUTIONS_N27 (cr=214201 pr=1847 pw=0 time=12962873 us)(object id 322241) 1071933 PARTITION LIST SINGLE PARTITION: KEY KEY (cr=3221243 pr=21656 pw=0 time=158766018 us) 1071933 TABLE ACCESS BY LOCAL INDEX ROWID XLA_AE_HEADERS PARTITION: 1 1 (cr=3221243 pr=21656 pw=0 time=150775442 us) 1071933 INDEX RANGE SCAN XLA_AE_HEADERS_N2 PARTITION: 1 1 (cr=2149310 pr=6613 pw=0 time=60491797 us)(object id 298917) 1071933 PARTITION LIST SINGLE PARTITION: KEY KEY (cr=3217542 pr=20809 pw=0 time=142323619 us) 1071933 TABLE ACCESS BY LOCAL INDEX ROWID XLA_TRANSACTION_ENTITIES PARTITION: 1 1 (cr=3217542 pr=20809 pw=0 time=134389382 us) 1071933 INDEX UNIQUE SCAN XLA_TRANSACTION_ENTITIES_U1 PARTITION: 1 1 (cr=2145609 pr=4478 pw=0 time=40958976 us)(object id 299093) 17864691 PARTITION LIST SINGLE PARTITION: KEY KEY (cr=2237179 pr=20663 pw=0 time=165234792 us) 17864691 INDEX RANGE SCAN XLA_AE_LINES_U1 PARTITION: 1 1 (cr=2237179 pr=20663 pw=0 time=126267293 us)(object id 298983) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 912 SORT (AGGREGATE) 64 TABLE ACCESS MODE: ANALYZED (BY LOCAL INDEX ROWID) OF 'XLA_AE_LINES' (TABLE) PARTITION: START=1 STOP=1 18937536 NESTED LOOPS 1071933 NESTED LOOPS 1071933 NESTED LOOPS 1071946 NESTED LOOPS 104877 NESTED LOOPS 104878 NESTED LOOPS 912 NESTED LOOPS 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIERS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIERS_U1' (INDEX (UNIQUE)) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HZ_PARTIES_U1' (INDEX (UNIQUE)) 104878 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 305002 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICES_N18' (INDEX) 104877 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIER_SITES_ALL' (TABLE) 104877 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIER_SITES_U1' (INDEX (UNIQUE)) 1071946 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 1071946 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_DISTRIBUTIONS_N27' (INDEX) 1071933 PARTITION LIST (SINGLE) PARTITION:KEYKEY 1071933 TABLE ACCESS MODE: ANALYZED (BY LOCAL INDEX ROWID) OF 'XLA_AE_HEADERS' (TABLE) PARTITION: START=1 STOP=1 1071933 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XLA_AE_HEADERS_N2' (INDEX) PARTITION: START=1 STOP=1 1071933 PARTITION LIST (SINGLE) PARTITION:KEYKEY 1071933 TABLE ACCESS MODE: ANALYZED (BY LOCAL INDEX ROWID) OF 'XLA_TRANSACTION_ENTITIES' (TABLE) PARTITION: START=1 STOP=1 1071933 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'XLA_TRANSACTION_ENTITIES_U1' (INDEX (UNIQUE)) PARTITION: START=1 STOP=1 17864691 PARTITION LIST (SINGLE) PARTITION:KEYKEY 17864691 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XLA_AE_LINES_U1' (INDEX (UNIQUE)) PARTITION: START=1 STOP=1 ******************************************************************************** SELECT NVL(SUM (B.AMOUNT) , 0 ) AMOUNT , MIN (A.EXCHANGE_DATE) EXCHANGE_DATE , MIN (A.EXCHANGE_RATE_TYPE) EXCHANGE_RATE_TYPE , MIN (A.EXCHANGE_RATE) EXCHANGE_RATE FROM AP_INVOICES_ALL A , AP_INVOICE_DISTRIBUTIONS_ALL B , PO_VENDORS POV , PO_VENDOR_SITES_ALL POVS WHERE A.INVOICE_ID = B.INVOICE_ID AND POV.VENDOR_ID = A.VENDOR_ID AND POVS.VENDOR_ID = POV.VENDOR_ID AND A.VENDOR_ID = NVL(:b1 , A.VENDOR_ID ) AND A.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID AND A.ACCTS_PAY_CODE_COMBINATION_ID = NVL(:b2 , A.ACCTS_PAY_CODE_COMBINATION_ID ) AND ( A.ORG_ID = :b3 OR A.ORG_ID IS NULL ) AND A.VENDOR_ID = :b4 AND A.INVOICE_CURRENCY_CODE = :b5 AND A.INVOICE_TYPE_LOOKUP_CODE NOT IN ( :b6 , :b7 , :b8 ) AND B.LINE_TYPE_LOOKUP_CODE != :b9 AND B.MATCH_STATUS_FLAG = 'A' AND TRUNC (B.ACCOUNTING_DATE ) <= TRUNC (:b10 ) AND B.POSTED_FLAG = 'Y' GROUP BY A.INVOICE_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 2.20 2.19 0 0 0 0 Fetch 88879 102.29 845.64 178043 930062 0 87967 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 89792 104.49 847.84 178043 930062 0 87967 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 87967 HASH GROUP BY (cr=930062 pr=178043 pw=0 time=818805432 us) 1018049 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=930062 pr=178043 pw=0 time=776443277 us) 1109489 NESTED LOOPS (cr=609780 pr=32613 pw=0 time=892375295 us) 88338 NESTED LOOPS (cr=428937 pr=24519 pw=0 time=172749966 us) 88339 NESTED LOOPS (cr=250699 pr=24179 pw=0 time=167064959 us) 912 NESTED LOOPS (cr=4560 pr=217 pw=0 time=1288036 us) 912 TABLE ACCESS BY INDEX ROWID AP_SUPPLIERS (cr=2736 pr=203 pw=0 time=1198507 us) 912 INDEX UNIQUE SCAN AP_SUPPLIERS_U1 (cr=1824 pr=10 pw=0 time=95447 us)(object id 280445) 912 INDEX UNIQUE SCAN HZ_PARTIES_U1 (cr=1824 pr=14 pw=0 time=84146 us)(object id 51195) 88339 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=246139 pr=23962 pw=0 time=165649646 us) 305002 INDEX RANGE SCAN AP_INVOICES_N18 (cr=7967 pr=2031 pw=0 time=4051393 us)(object id 280573) 88338 TABLE ACCESS BY INDEX ROWID AP_SUPPLIER_SITES_ALL (cr=178238 pr=340 pw=0 time=5075032 us) 88338 INDEX UNIQUE SCAN AP_SUPPLIER_SITES_U1 (cr=89900 pr=32 pw=0 time=1843959 us)(object id 280471) 1020239 INDEX RANGE SCAN AP_INVOICE_DISTRIBUTIONS_N27 (cr=180843 pr=8094 pw=0 time=49970375 us)(object id 322241) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 87967 HASH (GROUP BY) 1018049 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 1109489 NESTED LOOPS 88338 NESTED LOOPS 88339 NESTED LOOPS 912 NESTED LOOPS 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIERS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIERS_U1' (INDEX (UNIQUE)) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HZ_PARTIES_U1' (INDEX (UNIQUE)) 88339 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 305002 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICES_N18' (INDEX) 88338 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIER_SITES_ALL' (TABLE) 88338 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIER_SITES_U1' (INDEX (UNIQUE)) 1020239 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_DISTRIBUTIONS_N27' (INDEX) ******************************************************************************** SELECT SUM ( abs ( apd . amount ) ) amount , api . vendor_id , api . invoice_currency_code , api . org_id , api . accts_pay_code_combination_id accts FROM ap_invoices_all api , ap_invoice_distributions_all apd , po_vendors pov , ap_supplier_sites_all povs WHERE api.invoice_id = apd.invoice_id AND api.vendor_id = pov.vendor_id AND pov.vendor_id = povs.vendor_id AND api.vendor_site_id = povs.vendor_site_id AND api.vendor_id = api.vendor_id AND pov.segment1 = pov.segment1 AND ( ( : p_vendor_type_lookup_code is null ) OR ( ( : p_vendor_type_lookup_code is not null ) and ( pov.vendor_type_lookup_code = : p_vendor_type_lookup_code ) ) ) AND TRUNC ( apd.accounting_date ) <= TRUNC ( : p_as_of_date ) AND ( api.org_id = : p_org_id ) AND apd.match_status_flag = 'A' AND DECODE ( povs.accts_pay_code_combination_id , NULL , povs.accts_pay_code_combination_id , povs.accts_pay_code_combination_id ) = NVL ( : p_accts_id , DECODE ( povs.accts_pay_code_combination_id , NULL , povs.accts_pay_code_combination_id , povs.accts_pay_code_combination_id ) ) GROUP BY api.org_id , api.accts_pay_code_combination_id , api.vendor_id , api.invoice_currency_code ORDER BY 4 ASC,5 ASC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 304 138.86 801.43 192843 2706338 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 305 138.86 801.43 192843 2706338 0 912 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 SORT (GROUP BY) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 0 NESTED LOOPS 0 NESTED LOOPS 0 NESTED LOOPS 0 HASH JOIN 0 TABLE ACCESS MODE: ANALYZED (FULL) OF 'AP_SUPPLIER_SITES_ALL' (TABLE) 0 TABLE ACCESS MODE: ANALYZED (FULL) OF 'AP_SUPPLIERS' (TABLE) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICES_N18' (INDEX) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HZ_PARTIES_U1' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_DISTRIBUTIONS_N27' (INDEX) ******************************************************************************** SELECT B.AMOUNT , A.PAYMENT_CURRENCY_CODE , B.EXCHANGE_RATE , B.EXCHANGE_DATE , B.EXCHANGE_RATE_TYPE FROM AP_INVOICES_ALL A , AP_INVOICE_PAYMENTS_ALL B , AP_CHECKS_ALL C , PO_VENDORS POV , PO_VENDOR_SITES_ALL POVS WHERE A.INVOICE_ID = B.INVOICE_ID AND POV.VENDOR_ID = A.VENDOR_ID AND B.CHECK_ID = C.CHECK_ID AND POVS.VENDOR_ID = POV.VENDOR_ID AND A.VENDOR_ID = NVL(:b1 , A.VENDOR_ID ) AND A.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID AND A.ACCTS_PAY_CODE_COMBINATION_ID = NVL(:b2 , A.ACCTS_PAY_CODE_COMBINATION_ID ) AND ( A.ORG_ID = :b3 OR A.ORG_ID IS NULL ) AND A.VENDOR_ID = :b4 AND A.PAYMENT_CURRENCY_CODE = :b5 AND C.STATUS_LOOKUP_CODE IN ( :b6 , :b7 , :b8 , :b9 , :b10 , :b11 , :b12 , :b13 ) AND TRUNC (B.ACCOUNTING_DATE ) <= TRUNC (:b14 ) AND B.POSTED_FLAG = 'Y' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 2.61 2.87 0 0 0 0 Fetch 102916 40.89 141.10 15555 1263367 0 102004 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 103829 43.50 143.98 15555 1263367 0 102004 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 102004 NESTED LOOPS (cr=1467375 pr=15555 pw=0 time=96625264 us) 102004 NESTED LOOPS (cr=1161363 pr=11616 pw=0 time=118649047 us) 104877 NESTED LOOPS (cr=658148 pr=1944 pw=0 time=27220451 us) 104878 NESTED LOOPS (cr=358980 pr=1935 pw=0 time=21864177 us) 912 NESTED LOOPS (cr=4560 pr=0 pw=0 time=72974 us) 912 TABLE ACCESS BY INDEX ROWID AP_SUPPLIERS (cr=2736 pr=0 pw=0 time=47931 us) 912 INDEX UNIQUE SCAN AP_SUPPLIERS_U1 (cr=1824 pr=0 pw=0 time=24343 us)(object id 280445) 912 INDEX UNIQUE SCAN HZ_PARTIES_U1 (cr=1824 pr=0 pw=0 time=19124 us)(object id 51195) 104878 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=354420 pr=1935 pw=0 time=21612274 us) 305002 INDEX RANGE SCAN AP_INVOICES_N18 (cr=96548 pr=66 pw=0 time=2868184 us)(object id 280573) 104877 TABLE ACCESS BY INDEX ROWID AP_SUPPLIER_SITES_ALL (cr=299168 pr=9 pw=0 time=5036014 us) 104877 INDEX UNIQUE SCAN AP_SUPPLIER_SITES_U1 (cr=194291 pr=1 pw=0 time=3006115 us)(object id 280471) 102004 TABLE ACCESS BY INDEX ROWID AP_INVOICE_PAYMENTS_ALL (cr=503215 pr=9672 pw=0 time=87915796 us) 102005 INDEX RANGE SCAN AP_INVOICE_PAYMENTS_N1 (cr=401210 pr=2382 pw=0 time=23986313 us)(object id 32528) 102004 TABLE ACCESS BY INDEX ROWID AP_CHECKS_ALL (cr=306012 pr=3939 pw=0 time=36371456 us) 102004 INDEX UNIQUE SCAN AP_CHECKS_U1 (cr=204008 pr=287 pw=0 time=5651495 us)(object id 31104) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 102004 NESTED LOOPS 102004 NESTED LOOPS 104877 NESTED LOOPS 104878 NESTED LOOPS 912 NESTED LOOPS 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIERS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIERS_U1' (INDEX (UNIQUE)) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HZ_PARTIES_U1' (INDEX (UNIQUE)) 104878 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 305002 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICES_N18' (INDEX) 104877 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIER_SITES_ALL' (TABLE) 104877 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIER_SITES_U1' (INDEX (UNIQUE)) 102004 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_PAYMENTS_ALL' (TABLE) 102005 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_PAYMENTS_N1' (INDEX) 102004 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_CHECKS_ALL' (TABLE) 102004 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_CHECKS_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT CURRENCY_CODE FROM GL_SETS_OF_BOOKS WHERE SET_OF_BOOKS_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 205497 73.43 72.48 0 0 0 0 Fetch 205497 9.55 9.78 0 410994 0 205497 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 410995 82.98 82.27 0 410994 0 205497 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 205497 TABLE ACCESS BY INDEX ROWID GL_LEDGERS (cr=410994 pr=0 pw=0 time=9083413 us) 205497 INDEX UNIQUE SCAN GL_LEDGERS_U2 (cr=205497 pr=0 pw=0 time=3823933 us)(object id 287002) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 205497 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_LEDGERS' (TABLE) 205497 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_LEDGERS_U2' (INDEX (UNIQUE)) ******************************************************************************** SELECT NVL(SUM (A.AMOUNT) , 0 ) AMOUNT , MIN (B.EXCHANGE_RATE_TYPE) EXCHANGE_RATE_TYPE , MIN (B.EXCHANGE_RATE) EXCHANGE_RATE , MIN (B.EXCHANGE_DATE) EXCHANGE_DATE FROM AP_INVOICES_ALL B , AP_INVOICE_DISTRIBUTIONS_ALL A , PO_VENDORS POV , PO_VENDOR_SITES_ALL POVS WHERE A.INVOICE_ID = B.INVOICE_ID AND POV.VENDOR_ID = B.VENDOR_ID AND B.VENDOR_ID = NVL(:b1 , B.VENDOR_ID ) AND POVS.VENDOR_ID = POV.VENDOR_ID AND B.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID AND B.ACCTS_PAY_CODE_COMBINATION_ID = NVL(:b2 , B.ACCTS_PAY_CODE_COMBINATION_ID ) AND ( B.ORG_ID = :b3 OR B.ORG_ID IS NULL ) AND B.VENDOR_ID = :b4 AND A.MATCH_STATUS_FLAG = 'A' AND B.INVOICE_CURRENCY_CODE = :b5 AND TRUNC (A.ACCOUNTING_DATE ) <= TRUNC (:b6 ) AND B.INVOICE_TYPE_LOOKUP_CODE = :b7 AND A.LINE_TYPE_LOOKUP_CODE != :b8 AND A.POSTED_FLAG = 'Y' GROUP BY B.INVOICE_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 1.78 1.77 0 0 0 0 Fetch 10019 7.48 74.94 13722 97255 0 9107 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10932 9.26 76.72 13722 97255 0 9107 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 9107 HASH GROUP BY (cr=97255 pr=13722 pw=0 time=74759273 us) 44151 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=97255 pr=13722 pw=0 time=103320405 us) 54193 NESTED LOOPS (cr=78018 pr=5781 pw=0 time=167065102 us) 9130 NESTED LOOPS (cr=59196 pr=4663 pw=0 time=71697341 us) 9130 NESTED LOOPS (cr=40507 pr=4663 pw=0 time=71332356 us) 912 NESTED LOOPS (cr=4560 pr=0 pw=0 time=78405 us) 912 TABLE ACCESS BY INDEX ROWID AP_SUPPLIERS (cr=2736 pr=0 pw=0 time=51716 us) 912 INDEX UNIQUE SCAN AP_SUPPLIERS_U1 (cr=1824 pr=0 pw=0 time=27874 us)(object id 280445) 912 INDEX UNIQUE SCAN HZ_PARTIES_U1 (cr=1824 pr=0 pw=0 time=21458 us)(object id 51195) 9130 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=35947 pr=4663 pw=0 time=71236858 us) 52022 INDEX RANGE SCAN AP_INVOICES_N2 (cr=2964 pr=119 pw=0 time=184812 us)(object id 331128) 9130 TABLE ACCESS BY INDEX ROWID AP_SUPPLIER_SITES_ALL (cr=18689 pr=0 pw=0 time=302587 us) 9130 INDEX UNIQUE SCAN AP_SUPPLIER_SITES_U1 (cr=9559 pr=0 pw=0 time=161028 us)(object id 280471) 44151 INDEX RANGE SCAN AP_INVOICE_DISTRIBUTIONS_N27 (cr=18822 pr=1118 pw=0 time=6723788 us)(object id 322241) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 9107 HASH (GROUP BY) 44151 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 54193 NESTED LOOPS 9130 NESTED LOOPS 9130 NESTED LOOPS 912 NESTED LOOPS 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIERS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIERS_U1' (INDEX (UNIQUE)) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HZ_PARTIES_U1' (INDEX (UNIQUE)) 9130 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 52022 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICES_N2' (INDEX) 9130 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIER_SITES_ALL' (TABLE) 9130 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIER_SITES_U1' (INDEX (UNIQUE)) 44151 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_DISTRIBUTIONS_N27' (INDEX) ******************************************************************************** SELECT B.AMOUNT , A.EXCHANGE_DATE , A.EXCHANGE_RATE_TYPE , A.EXCHANGE_RATE , A.INVOICE_CURRENCY_CODE FROM AP_INVOICES_ALL A , AP_INVOICE_DISTRIBUTIONS_ALL B , PO_VENDORS POV , PO_VENDOR_SITES_ALL POVS WHERE A.INVOICE_ID = B.INVOICE_ID AND POV.VENDOR_ID = A.VENDOR_ID AND POVS.VENDOR_ID = POV.VENDOR_ID AND A.VENDOR_ID = NVL(:b1 , A.VENDOR_ID ) AND A.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID AND A.ACCTS_PAY_CODE_COMBINATION_ID = NVL(:b2 , A.ACCTS_PAY_CODE_COMBINATION_ID ) AND A.VENDOR_ID = :b3 AND ( A.ORG_ID = :b4 OR A.ORG_ID IS NULL ) AND A.INVOICE_CURRENCY_CODE = :b5 AND A.INVOICE_TYPE_LOOKUP_CODE IN ( :b6 ) AND B.MATCH_STATUS_FLAG = 'A' AND TRUNC (B.ACCOUNTING_DATE ) <= TRUNC (:b7 ) AND B.POSTED_FLAG = 'Y' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 1.63 1.48 0 0 0 0 Fetch 7331 5.23 59.19 11613 81103 0 6419 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8244 6.86 60.68 11613 81103 0 6419 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 6419 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=93941 pr=11613 pw=0 time=43043298 us) 13648 NESTED LOOPS (cr=87522 pr=8283 pw=0 time=228599484 us) 6317 NESTED LOOPS (cr=62155 pr=7746 pw=0 time=33733277 us) 6317 NESTED LOOPS (cr=43207 pr=7746 pw=0 time=33375583 us) 912 NESTED LOOPS (cr=4560 pr=0 pw=0 time=82986 us) 912 TABLE ACCESS BY INDEX ROWID AP_SUPPLIERS (cr=2736 pr=0 pw=0 time=55420 us) 912 INDEX UNIQUE SCAN AP_SUPPLIERS_U1 (cr=1824 pr=0 pw=0 time=30724 us)(object id 280445) 912 INDEX UNIQUE SCAN HZ_PARTIES_U1 (cr=1824 pr=0 pw=0 time=22051 us)(object id 51195) 6317 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=38647 pr=7746 pw=0 time=33276702 us) 41939 INDEX RANGE SCAN AP_INVOICES_N2 (cr=9194 pr=560 pw=0 time=2891358 us)(object id 331128) 6317 TABLE ACCESS BY INDEX ROWID AP_SUPPLIER_SITES_ALL (cr=18948 pr=0 pw=0 time=323717 us) 6317 INDEX UNIQUE SCAN AP_SUPPLIER_SITES_U1 (cr=12631 pr=0 pw=0 time=199458 us)(object id 280471) 6419 INDEX RANGE SCAN AP_INVOICE_DISTRIBUTIONS_N27 (cr=25367 pr=537 pw=0 time=4129610 us)(object id 322241) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 6419 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 13648 NESTED LOOPS 6317 NESTED LOOPS 6317 NESTED LOOPS 912 NESTED LOOPS 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIERS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIERS_U1' (INDEX (UNIQUE)) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HZ_PARTIES_U1' (INDEX (UNIQUE)) 6317 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 41939 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICES_N2' (INDEX) 6317 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIER_SITES_ALL' (TABLE) 6317 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIER_SITES_U1' (INDEX (UNIQUE)) 6419 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_DISTRIBUTIONS_N27' (INDEX) ******************************************************************************** SELECT SUM (B.AMOUNT) FROM AP_INVOICES_ALL A , AP_INVOICE_DISTRIBUTIONS_ALL B , PO_VENDORS POV , PO_VENDOR_SITES_ALL POVS WHERE A.INVOICE_ID = B.INVOICE_ID AND POV.VENDOR_ID = A.VENDOR_ID AND POV.VENDOR_ID = POVS.VENDOR_ID AND A.VENDOR_ID = NVL(:b1 , A.VENDOR_ID ) AND A.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID AND A.ACCTS_PAY_CODE_COMBINATION_ID = NVL(:b2 , A.ACCTS_PAY_CODE_COMBINATION_ID ) AND A.VENDOR_ID = :b3 AND ( A.ORG_ID = :b4 OR A.ORG_ID IS NULL ) AND A.INVOICE_CURRENCY_CODE = :b5 AND B.MATCH_STATUS_FLAG = 'A' AND A.INVOICE_TYPE_LOOKUP_CODE NOT IN ( :b6 , :b7 , :b8 ) AND B.LINE_TYPE_LOOKUP_CODE != :b9 AND TRUNC (B.ACCOUNTING_DATE ) <= TRUNC (:b10 ) AND B.POSTED_FLAG = 'Y' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 2.06 2.00 0 0 0 0 Fetch 912 39.66 38.70 0 930062 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1825 41.72 40.70 0 930062 0 912 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 912 SORT AGGREGATE (cr=930062 pr=0 pw=0 time=38718100 us) 1018049 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=930062 pr=0 pw=0 time=40502841 us) 1109489 NESTED LOOPS (cr=609780 pr=0 pw=0 time=88919391 us) 88338 NESTED LOOPS (cr=428937 pr=0 pw=0 time=16393642 us) 88339 NESTED LOOPS (cr=250699 pr=0 pw=0 time=13238918 us) 912 NESTED LOOPS (cr=4560 pr=0 pw=0 time=70328 us) 912 TABLE ACCESS BY INDEX ROWID AP_SUPPLIERS (cr=2736 pr=0 pw=0 time=46100 us) 912 INDEX UNIQUE SCAN AP_SUPPLIERS_U1 (cr=1824 pr=0 pw=0 time=24307 us)(object id 280445) 912 INDEX UNIQUE SCAN HZ_PARTIES_U1 (cr=1824 pr=0 pw=0 time=19546 us)(object id 51195) 88339 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=246139 pr=0 pw=0 time=13051254 us) 305002 INDEX RANGE SCAN AP_INVOICES_N18 (cr=7967 pr=0 pw=0 time=1520955 us)(object id 280573) 88338 TABLE ACCESS BY INDEX ROWID AP_SUPPLIER_SITES_ALL (cr=178238 pr=0 pw=0 time=2790770 us) 88338 INDEX UNIQUE SCAN AP_SUPPLIER_SITES_U1 (cr=89900 pr=0 pw=0 time=1469319 us)(object id 280471) 1020239 INDEX RANGE SCAN AP_INVOICE_DISTRIBUTIONS_N27 (cr=180843 pr=0 pw=0 time=4606336 us)(object id 322241) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 912 SORT (AGGREGATE) 1018049 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 1109489 NESTED LOOPS 88338 NESTED LOOPS 88339 NESTED LOOPS 912 NESTED LOOPS 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIERS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIERS_U1' (INDEX (UNIQUE)) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HZ_PARTIES_U1' (INDEX (UNIQUE)) 88339 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 305002 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICES_N18' (INDEX) 88338 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIER_SITES_ALL' (TABLE) 88338 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIER_SITES_U1' (INDEX (UNIQUE)) 1020239 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_DISTRIBUTIONS_N27' (INDEX) ******************************************************************************** SELECT SUM (NVL(B.AMOUNT , 0 ) ) FROM AP_INVOICES_ALL A , AP_INVOICE_PAYMENTS_ALL B , AP_CHECKS_ALL C , PO_VENDORS POV , PO_VENDOR_SITES_ALL POVS WHERE A.INVOICE_ID = B.INVOICE_ID AND POV.VENDOR_ID = A.VENDOR_ID AND B.CHECK_ID = C.CHECK_ID AND POV.VENDOR_ID = POVS.VENDOR_ID AND A.VENDOR_ID = NVL(:b1 , A.VENDOR_ID ) AND A.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID AND A.ACCTS_PAY_CODE_COMBINATION_ID = NVL(:b2 , A.ACCTS_PAY_CODE_COMBINATION_ID ) AND A.VENDOR_ID = :b3 AND ( A.ORG_ID = :b4 OR A.ORG_ID IS NULL ) AND A.PAYMENT_CURRENCY_CODE = :b5 AND C.STATUS_LOOKUP_CODE IN ( :b6 , :b7 , :b8 , :b9 , :b10 , :b11 , :b12 , :b13 ) AND TRUNC (B.ACCOUNTING_DATE ) <= TRUNC (:b14 ) AND B.POSTED_FLAG = 'Y' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 2.63 2.68 0 0 0 0 Fetch 912 25.27 25.04 120 980135 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1825 27.90 27.73 120 980135 0 912 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 912 SORT AGGREGATE (cr=980135 pr=120 pw=0 time=25049118 us) 102004 NESTED LOOPS (cr=980135 pr=120 pw=0 time=25970712 us) 102004 NESTED LOOPS (cr=774612 pr=119 pw=0 time=21393832 us) 104877 NESTED LOOPS (cr=462136 pr=0 pw=0 time=17924182 us) 104878 NESTED LOOPS (cr=250699 pr=0 pw=0 time=14158763 us) 912 NESTED LOOPS (cr=4560 pr=0 pw=0 time=63918 us) 912 TABLE ACCESS BY INDEX ROWID AP_SUPPLIERS (cr=2736 pr=0 pw=0 time=41872 us) 912 INDEX UNIQUE SCAN AP_SUPPLIERS_U1 (cr=1824 pr=0 pw=0 time=20998 us)(object id 280445) 912 INDEX UNIQUE SCAN HZ_PARTIES_U1 (cr=1824 pr=0 pw=0 time=16894 us)(object id 51195) 104878 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=246139 pr=0 pw=0 time=13967859 us) 305002 INDEX RANGE SCAN AP_INVOICES_N18 (cr=7967 pr=0 pw=0 time=1530983 us)(object id 280573) 104877 TABLE ACCESS BY INDEX ROWID AP_SUPPLIER_SITES_ALL (cr=211437 pr=0 pw=0 time=3358889 us) 104877 INDEX UNIQUE SCAN AP_SUPPLIER_SITES_U1 (cr=106560 pr=0 pw=0 time=1794810 us)(object id 280471) 102004 TABLE ACCESS BY INDEX ROWID AP_INVOICE_PAYMENTS_ALL (cr=312476 pr=119 pw=0 time=7961241 us) 102005 INDEX RANGE SCAN AP_INVOICE_PAYMENTS_N1 (cr=211777 pr=110 pw=0 time=3703179 us)(object id 32528) 102004 TABLE ACCESS BY INDEX ROWID AP_CHECKS_ALL (cr=205523 pr=1 pw=0 time=4156466 us) 102004 INDEX UNIQUE SCAN AP_CHECKS_U1 (cr=103519 pr=0 pw=0 time=1839501 us)(object id 31104) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 912 SORT (AGGREGATE) 102004 NESTED LOOPS 102004 NESTED LOOPS 104877 NESTED LOOPS 104878 NESTED LOOPS 912 NESTED LOOPS 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIERS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIERS_U1' (INDEX (UNIQUE)) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HZ_PARTIES_U1' (INDEX (UNIQUE)) 104878 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 305002 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICES_N18' (INDEX) 104877 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIER_SITES_ALL' (TABLE) 104877 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIER_SITES_U1' (INDEX (UNIQUE)) 102004 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_PAYMENTS_ALL' (TABLE) 102005 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_PAYMENTS_N1' (INDEX) 102004 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_CHECKS_ALL' (TABLE) 102004 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_CHECKS_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT SET_OF_BOOKS_ID FROM ORG_ORGANIZATION_DEFINITIONS WHERE NVL(OPERATING_UNIT , 0 ) = NVL(:b1 , 0 ) AND ROWNUM = 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 0.27 0.36 0 0 0 0 Fetch 912 5.93 5.80 0 37392 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1825 6.20 6.16 0 37392 0 912 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 912 COUNT STOPKEY (cr=37392 pr=0 pw=0 time=5802490 us) 912 NESTED LOOPS (cr=37392 pr=0 pw=0 time=5774396 us) 912 NESTED LOOPS (cr=36480 pr=0 pw=0 time=5754155 us) 912 NESTED LOOPS (cr=34656 pr=0 pw=0 time=5701232 us) 912 NESTED LOOPS (cr=31920 pr=0 pw=0 time=5647713 us) 11856 NESTED LOOPS (cr=14592 pr=0 pw=0 time=5179369 us) 11856 INDEX FULL SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK (cr=912 pr=0 pw=0 time=466787 us)(object id 43965) 11856 TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS (cr=13680 pr=0 pw=0 time=4601319 us) 11856 INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK (cr=1824 pr=0 pw=0 time=137617 us)(object id 43923) 912 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=17328 pr=0 pw=0 time=529773 us) 3648 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (cr=13680 pr=0 pw=0 time=394261 us)(object id 215869) 912 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=2736 pr=0 pw=0 time=49534 us) 912 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (cr=1824 pr=0 pw=0 time=29783 us)(object id 215869) 912 TABLE ACCESS BY INDEX ROWID GL_LEDGERS (cr=1824 pr=0 pw=0 time=49038 us) 912 INDEX UNIQUE SCAN GL_LEDGERS_U2 (cr=912 pr=0 pw=0 time=26197 us)(object id 287002) 912 INDEX UNIQUE SCAN MTL_PARAMETERS_U1 (cr=912 pr=0 pw=0 time=14636 us)(object id 117900) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 912 COUNT (STOPKEY) 912 NESTED LOOPS 912 NESTED LOOPS 912 NESTED LOOPS 912 NESTED LOOPS 11856 NESTED LOOPS 11856 INDEX MODE: ANALYZED (FULL SCAN) OF 'HR_ALL_ORGANIZATION_UNTS_TL_PK' (INDEX (UNIQUE)) 11856 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ALL_ORGANIZATION_UNITS' (TABLE) 11856 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HR_ORGANIZATION_UNITS_PK' (INDEX (UNIQUE)) 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ORGANIZATION_INFORMATION' (TABLE) 3648 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO_FK2' (INDEX) 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ORGANIZATION_INFORMATION' (TABLE) 912 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO_FK2' (INDEX) 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_LEDGERS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_LEDGERS_U2' (INDEX (UNIQUE)) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'MTL_PARAMETERS_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT SUM (B.AMOUNT) FROM AP_INVOICES_ALL A , AP_INVOICE_DISTRIBUTIONS_ALL B , PO_VENDORS POV , PO_VENDOR_SITES_ALL POVS WHERE A.INVOICE_ID = B.INVOICE_ID AND POV.VENDOR_ID = A.VENDOR_ID AND POV.VENDOR_ID = POVS.VENDOR_ID AND A.VENDOR_ID = NVL(:b1 , A.VENDOR_ID ) AND A.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID AND A.ACCTS_PAY_CODE_COMBINATION_ID = NVL(:b2 , A.ACCTS_PAY_CODE_COMBINATION_ID ) AND A.VENDOR_ID = :b3 AND ( A.ORG_ID = :b4 OR A.ORG_ID IS NULL ) AND A.INVOICE_CURRENCY_CODE = :b5 AND A.INVOICE_TYPE_LOOKUP_CODE IN ( :b6 ) AND B.LINE_TYPE_LOOKUP_CODE != :b7 AND B.MATCH_STATUS_FLAG = 'A' AND TRUNC (B.ACCOUNTING_DATE ) <= TRUNC (:b8 ) AND B.POSTED_FLAG = 'Y' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 1.53 1.61 0 0 0 0 Fetch 912 3.29 3.28 7 97255 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1825 4.82 4.89 7 97255 0 912 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 912 SORT AGGREGATE (cr=97255 pr=7 pw=0 time=3305715 us) 44151 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=97255 pr=7 pw=0 time=2897663 us) 54193 NESTED LOOPS (cr=78018 pr=6 pw=0 time=5335260 us) 9130 NESTED LOOPS (cr=59196 pr=5 pw=0 time=2631390 us) 9130 NESTED LOOPS (cr=40507 pr=5 pw=0 time=2298100 us) 912 NESTED LOOPS (cr=4560 pr=0 pw=0 time=64153 us) 912 TABLE ACCESS BY INDEX ROWID AP_SUPPLIERS (cr=2736 pr=0 pw=0 time=42000 us) 912 INDEX UNIQUE SCAN AP_SUPPLIERS_U1 (cr=1824 pr=0 pw=0 time=21423 us)(object id 280445) 912 INDEX UNIQUE SCAN HZ_PARTIES_U1 (cr=1824 pr=0 pw=0 time=17538 us)(object id 51195) 9130 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=35947 pr=5 pw=0 time=2219011 us) 52022 INDEX RANGE SCAN AP_INVOICES_N2 (cr=2964 pr=0 pw=0 time=163546 us)(object id 331128) 9130 TABLE ACCESS BY INDEX ROWID AP_SUPPLIER_SITES_ALL (cr=18689 pr=0 pw=0 time=280701 us) 9130 INDEX UNIQUE SCAN AP_SUPPLIER_SITES_U1 (cr=9559 pr=0 pw=0 time=149083 us)(object id 280471) 44151 INDEX RANGE SCAN AP_INVOICE_DISTRIBUTIONS_N27 (cr=18822 pr=1 pw=0 time=353078 us)(object id 322241) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 912 SORT (AGGREGATE) 44151 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 54193 NESTED LOOPS 9130 NESTED LOOPS 9130 NESTED LOOPS 912 NESTED LOOPS 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIERS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIERS_U1' (INDEX (UNIQUE)) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HZ_PARTIES_U1' (INDEX (UNIQUE)) 9130 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 52022 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICES_N2' (INDEX) 9130 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIER_SITES_ALL' (TABLE) 9130 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIER_SITES_U1' (INDEX (UNIQUE)) 44151 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_DISTRIBUTIONS_N27' (INDEX) ******************************************************************************** SELECT SUM (B.AMOUNT) FROM AP_INVOICES_ALL A , AP_INVOICE_DISTRIBUTIONS_ALL B , PO_VENDORS POV , PO_VENDOR_SITES_ALL POVS WHERE A.INVOICE_ID = B.INVOICE_ID AND POV.VENDOR_ID = A.VENDOR_ID AND POV.VENDOR_ID = POVS.VENDOR_ID AND A.VENDOR_ID = NVL(:b1 , A.VENDOR_ID ) AND A.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID AND A.ACCTS_PAY_CODE_COMBINATION_ID = NVL(:b2 , A.ACCTS_PAY_CODE_COMBINATION_ID ) AND A.VENDOR_ID = :b3 AND ( A.ORG_ID = :b4 OR A.ORG_ID IS NULL ) AND A.INVOICE_CURRENCY_CODE = :b5 AND A.INVOICE_TYPE_LOOKUP_CODE IN ( :b6 ) AND B.MATCH_STATUS_FLAG = 'A' AND TRUNC (B.ACCOUNTING_DATE ) <= TRUNC (:b7 ) AND B.POSTED_FLAG = 'Y' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 1.56 1.43 0 0 0 0 Fetch 912 1.97 2.08 195 67476 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1825 3.53 3.51 195 67476 0 912 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 912 SORT AGGREGATE (cr=67476 pr=195 pw=0 time=2099841 us) 6419 TABLE ACCESS BY INDEX ROWID AP_INVOICE_DISTRIBUTIONS_ALL (cr=67476 pr=195 pw=0 time=1701047 us) 13648 NESTED LOOPS (cr=61591 pr=195 pw=0 time=10049135 us) 6317 NESTED LOOPS (cr=48600 pr=195 pw=0 time=1303770 us) 6317 NESTED LOOPS (cr=35628 pr=195 pw=0 time=1065863 us) 912 NESTED LOOPS (cr=4560 pr=0 pw=0 time=64510 us) 912 TABLE ACCESS BY INDEX ROWID AP_SUPPLIERS (cr=2736 pr=0 pw=0 time=42004 us) 912 INDEX UNIQUE SCAN AP_SUPPLIERS_U1 (cr=1824 pr=0 pw=0 time=21469 us)(object id 280445) 912 INDEX UNIQUE SCAN HZ_PARTIES_U1 (cr=1824 pr=0 pw=0 time=17646 us)(object id 51195) 6317 TABLE ACCESS BY INDEX ROWID AP_INVOICES_ALL (cr=31068 pr=195 pw=0 time=991678 us) 41939 INDEX RANGE SCAN AP_INVOICES_N2 (cr=2915 pr=2 pw=0 time=140211 us)(object id 331128) 6317 TABLE ACCESS BY INDEX ROWID AP_SUPPLIER_SITES_ALL (cr=12972 pr=0 pw=0 time=206047 us) 6317 INDEX UNIQUE SCAN AP_SUPPLIER_SITES_U1 (cr=6655 pr=0 pw=0 time=111003 us)(object id 280471) 6419 INDEX RANGE SCAN AP_INVOICE_DISTRIBUTIONS_N27 (cr=12991 pr=0 pw=0 time=198811 us)(object id 322241) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 912 SORT (AGGREGATE) 6419 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICE_DISTRIBUTIONS_ALL' (TABLE) 13648 NESTED LOOPS 6317 NESTED LOOPS 6317 NESTED LOOPS 912 NESTED LOOPS 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIERS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIERS_U1' (INDEX (UNIQUE)) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HZ_PARTIES_U1' (INDEX (UNIQUE)) 6317 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_INVOICES_ALL' (TABLE) 41939 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICES_N2' (INDEX) 6317 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIER_SITES_ALL' (TABLE) 6317 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIER_SITES_U1' (INDEX (UNIQUE)) 6419 INDEX MODE: ANALYZED (RANGE SCAN) OF 'AP_INVOICE_DISTRIBUTIONS_N27' (INDEX) ******************************************************************************** SELECT NAME FROM HR_ORGANIZATION_UNITS WHERE NVL(ORGANIZATION_ID , 0 ) = NVL(:b1 , 0 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 0.38 0.33 0 0 0 0 Fetch 912 1.14 1.17 4 15504 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1825 1.52 1.51 4 15504 0 912 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 912 NESTED LOOPS (cr=16566 pr=45 pw=0 time=1545903 us) 912 TABLE ACCESS FULL HR_ALL_ORGANIZATION_UNITS (cr=14434 pr=24 pw=0 time=1239377 us) 912 TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS_TL (cr=2132 pr=21 pw=0 time=300738 us) 912 INDEX UNIQUE SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK (cr=1220 pr=21 pw=0 time=282128 us)(object id 43965) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 912 NESTED LOOPS 912 TABLE ACCESS MODE: ANALYZED (FULL) OF 'HR_ALL_ORGANIZATION_UNITS' (TABLE) 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ALL_ORGANIZATION_UNITS_TL' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HR_ALL_ORGANIZATION_UNTS_TL_PK' (INDEX (UNIQUE)) ******************************************************************************** SELECT SEGMENT_NUM, APPLICATION_COLUMN_NAME FROM FND_ID_FLEX_SEGMENTS WHERE ID_FLEX_NUM = :B2 AND ID_FLEX_CODE = :B1 ORDER BY SEGMENT_NUM call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 913 0.47 0.52 0 0 0 0 Fetch 913 0.46 0.52 26 13695 0 6391 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1827 0.93 1.04 26 13695 0 6391 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 6391 SORT ORDER BY (cr=13695 pr=26 pw=0 time=432301 us) 6391 TABLE ACCESS FULL FND_ID_FLEX_SEGMENTS (cr=13695 pr=26 pw=0 time=231507 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 6391 SORT (ORDER BY) 6391 TABLE ACCESS MODE: ANALYZED (FULL) OF 'FND_ID_FLEX_SEGMENTS' (TABLE) ******************************************************************************** SELECT LOCATION_ID FROM HR_ORGANIZATION_UNITS WHERE ORGANIZATION_ID = NVL(:b1 , 0 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 0.38 0.36 0 0 0 0 Fetch 912 0.60 0.57 0 2736 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1825 0.98 0.94 0 2736 0 912 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 912 NESTED LOOPS (cr=3601 pr=47 pw=0 time=1095392 us) 912 INDEX UNIQUE SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK (cr=1666 pr=39 pw=0 time=520587 us)(object id 43965) 912 TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS (cr=1935 pr=8 pw=0 time=569114 us) 912 INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK (cr=912 pr=0 pw=0 time=16845 us)(object id 43923) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 912 NESTED LOOPS 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HR_ALL_ORGANIZATION_UNTS_TL_PK' (INDEX (UNIQUE)) 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ALL_ORGANIZATION_UNITS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HR_ORGANIZATION_UNITS_PK' (INDEX (UNIQUE)) ******************************************************************************** SELECT ADDRESS_LINE_1 || ',' || ADDRESS_LINE_2 || ',' || ADDRESS_LINE_3 || ',' || TOWN_OR_CITY || ',' || COUNTRY || ',' || POSTAL_CODE || ',' || TELEPHONE_NUMBER_1 || ',' || TELEPHONE_NUMBER_2 || ',' || TELEPHONE_NUMBER_3 FROM HR_LOCATIONS WHERE LOCATION_ID = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 0.35 0.36 0 6 0 0 Fetch 912 0.40 0.50 0 2736 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1825 0.75 0.86 0 2742 0 912 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 912 NESTED LOOPS (cr=2736 pr=0 pw=0 time=475397 us) 912 INDEX UNIQUE SCAN HR_LOCATIONS_ALL_TL_PK (cr=912 pr=0 pw=0 time=21700 us)(object id 48886) 912 TABLE ACCESS BY INDEX ROWID HR_LOCATIONS_ALL (cr=1824 pr=0 pw=0 time=447895 us) 912 INDEX UNIQUE SCAN HR_LOCATIONS_PK (cr=912 pr=0 pw=0 time=14133 us)(object id 48815) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 912 NESTED LOOPS 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HR_LOCATIONS_ALL_TL_PK' (INDEX (UNIQUE)) 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_LOCATIONS_ALL' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HR_LOCATIONS_PK' (INDEX (UNIQUE)) ******************************************************************************** SELECT SEGMENT1 FROM gl_code_combinations WHERE code_combination_id = :p_ccid call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 913 0.06 0.09 0 0 0 0 Execute 913 0.36 0.37 0 0 0 0 Fetch 913 0.08 0.26 38 2736 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2739 0.50 0.73 38 2736 0 912 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=0 pr=0 pw=0 time=9 us) 0 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=0 pr=0 pw=0 time=3 us)(object id 51100) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_CODE_COMBINATIONS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_CODE_COMBINATIONS_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT SEGMENT2 FROM gl_code_combinations WHERE code_combination_id = :p_ccid call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 913 0.04 0.03 0 0 0 0 Execute 913 0.28 0.36 0 0 0 0 Fetch 913 0.03 0.03 0 2736 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2739 0.35 0.43 0 2736 0 912 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=0 pr=0 pw=0 time=8 us) 0 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=0 pr=0 pw=0 time=2 us)(object id 51100) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_CODE_COMBINATIONS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_CODE_COMBINATIONS_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT SEGMENT5 FROM gl_code_combinations WHERE code_combination_id = :p_ccid call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 913 0.01 0.03 0 0 0 0 Execute 913 0.41 0.35 0 0 0 0 Fetch 913 0.03 0.03 0 2736 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2739 0.45 0.43 0 2736 0 912 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=0 pr=0 pw=0 time=8 us) 0 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=0 pr=0 pw=0 time=3 us)(object id 51100) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_CODE_COMBINATIONS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_CODE_COMBINATIONS_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT SEGMENT4 FROM gl_code_combinations WHERE code_combination_id = :p_ccid call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 913 0.02 0.03 0 0 0 0 Execute 913 0.34 0.36 0 0 0 0 Fetch 913 0.08 0.03 0 2736 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2739 0.44 0.43 0 2736 0 912 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=0 pr=0 pw=0 time=7 us) 0 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=0 pr=0 pw=0 time=4 us)(object id 51100) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_CODE_COMBINATIONS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_CODE_COMBINATIONS_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT SEGMENT7 FROM gl_code_combinations WHERE code_combination_id = :p_ccid call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 913 0.05 0.03 0 0 0 0 Execute 913 0.36 0.35 0 0 0 0 Fetch 913 0.01 0.03 0 2736 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2739 0.42 0.43 0 2736 0 912 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=0 pr=0 pw=0 time=8 us) 0 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=0 pr=0 pw=0 time=3 us)(object id 51100) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_CODE_COMBINATIONS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_CODE_COMBINATIONS_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT SEGMENT6 FROM gl_code_combinations WHERE code_combination_id = :p_ccid call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 913 0.03 0.03 0 0 0 0 Execute 913 0.38 0.35 0 0 0 0 Fetch 913 0.05 0.03 0 2736 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2739 0.46 0.43 0 2736 0 912 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=0 pr=0 pw=0 time=8 us) 0 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=0 pr=0 pw=0 time=2 us)(object id 51100) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_CODE_COMBINATIONS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_CODE_COMBINATIONS_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT SEGMENT3 FROM gl_code_combinations WHERE code_combination_id = :p_ccid call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 913 0.01 0.03 0 0 0 0 Execute 913 0.39 0.35 0 0 0 0 Fetch 913 0.00 0.03 0 2736 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2739 0.40 0.43 0 2736 0 912 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=0 pr=0 pw=0 time=6 us) 0 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=0 pr=0 pw=0 time=3 us)(object id 51100) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_CODE_COMBINATIONS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_CODE_COMBINATIONS_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT VENDOR_NAME FROM PO_VENDORS WHERE VENDOR_ID = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 913 0.33 0.33 0 0 0 0 Fetch 913 0.09 0.07 0 4560 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1828 0.42 0.40 0 4560 0 912 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=12 us) 0 TABLE ACCESS BY INDEX ROWID AP_SUPPLIERS (cr=0 pr=0 pw=0 time=6 us) 0 INDEX UNIQUE SCAN AP_SUPPLIERS_U1 (cr=0 pr=0 pw=0 time=4 us)(object id 280445) 0 INDEX UNIQUE SCAN HZ_PARTIES_U1 (cr=0 pr=0 pw=0 time=0 us)(object id 51195) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIERS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIERS_U1' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HZ_PARTIES_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT SEGMENT1 FROM PO_VENDORS WHERE VENDOR_ID = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 0.38 0.32 0 0 0 0 Fetch 912 0.08 0.07 0 4560 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1825 0.46 0.40 0 4560 0 912 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 912 NESTED LOOPS (cr=4560 pr=0 pw=0 time=66246 us) 912 TABLE ACCESS BY INDEX ROWID AP_SUPPLIERS (cr=2736 pr=0 pw=0 time=42846 us) 912 INDEX UNIQUE SCAN AP_SUPPLIERS_U1 (cr=1824 pr=0 pw=0 time=20810 us)(object id 280445) 912 INDEX UNIQUE SCAN HZ_PARTIES_U1 (cr=1824 pr=0 pw=0 time=17911 us)(object id 51195) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 912 NESTED LOOPS 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIERS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIERS_U1' (INDEX (UNIQUE)) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HZ_PARTIES_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT VENDOR_TYPE_LOOKUP_CODE FROM PO_VENDORS WHERE VENDOR_ID = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 0.31 0.32 0 0 0 0 Fetch 912 0.09 0.07 0 4560 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1825 0.40 0.39 0 4560 0 912 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 912 NESTED LOOPS (cr=4560 pr=0 pw=0 time=64513 us) 912 TABLE ACCESS BY INDEX ROWID AP_SUPPLIERS (cr=2736 pr=0 pw=0 time=42021 us) 912 INDEX UNIQUE SCAN AP_SUPPLIERS_U1 (cr=1824 pr=0 pw=0 time=20557 us)(object id 280445) 912 INDEX UNIQUE SCAN HZ_PARTIES_U1 (cr=1824 pr=0 pw=0 time=17251 us)(object id 51195) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 912 NESTED LOOPS 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'AP_SUPPLIERS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'AP_SUPPLIERS_U1' (INDEX (UNIQUE)) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HZ_PARTIES_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT CURRENCY_CODE FROM GL_SETS_OF_BOOKS WHERE SET_OF_BOOKS_ID = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 912 0.35 0.32 0 0 0 0 Fetch 912 0.03 0.04 0 1824 0 912 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1825 0.38 0.37 0 1824 0 912 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 912 TABLE ACCESS BY INDEX ROWID GL_LEDGERS (cr=1824 pr=0 pw=0 time=39408 us) 912 INDEX UNIQUE SCAN GL_LEDGERS_U2 (cr=912 pr=0 pw=0 time=15539 us)(object id 287002) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 912 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_LEDGERS' (TABLE) 912 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_LEDGERS_U2' (INDEX (UNIQUE)) ******************************************************************************** begin Fnd_Concurrent.Init_Request; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.38 0.36 0 887 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.38 0.36 0 887 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :org_id); fnd_profile.put('MFG_ORGANIZATION_ID', :mfg_org_id); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :coa); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.07 0.08 0 170 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.07 0.08 0 170 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** begin :con := XLA_SECURITY_POLICY_PKG.MO_POLICY(:sn, :on); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.04 0.07 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.04 0.07 0 0 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) ******************************************************************************** SELECT PER.ORGANIZATION_ID ORGANIZATION_ID , HR.NAME NAME FROM PER_ORGANIZATION_LIST PER , HR_OPERATING_UNITS HR WHERE PER.SECURITY_PROFILE_ID = TO_NUMBER(:B1 ) AND HR.ORGANIZATION_ID = PER.ORGANIZATION_ID AND HR.USABLE_FLAG IS NULL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.08 0.06 0 0 0 0 Fetch 1 0.00 0.00 0 16 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.08 0.06 0 16 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=16 pr=0 pw=0 time=1100 us) 3 NESTED LOOPS (cr=15 pr=0 pw=0 time=1018 us) 1 NESTED LOOPS (cr=13 pr=0 pw=0 time=1008 us) 1 NESTED LOOPS (cr=11 pr=0 pw=0 time=961 us) 21 NESTED LOOPS (cr=9 pr=0 pw=0 time=773 us) 21 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=7 pr=0 pw=0 time=334 us) 21 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_IX1 (cr=1 pr=0 pw=0 time=40 us)(object id 49347) 21 INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK (cr=2 pr=0 pw=0 time=194 us)(object id 43923) 1 INDEX RANGE SCAN PER_ORGANIZATION_LIST_UK1 (cr=2 pr=0 pw=0 time=307 us)(object id 215874) 1 TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS_TL (cr=2 pr=0 pw=0 time=40 us) 1 INDEX UNIQUE SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK (cr=1 pr=0 pw=0 time=26 us)(object id 43965) 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (cr=2 pr=0 pw=0 time=31 us)(object id 215869) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ORGANIZATION_INFORMATION' (TABLE) 3 NESTED LOOPS 1 NESTED LOOPS 1 NESTED LOOPS 21 NESTED LOOPS 21 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ORGANIZATION_INFORMATION' (TABLE) 21 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO_IX1' (INDEX) 21 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HR_ORGANIZATION_UNITS_PK' (INDEX (UNIQUE)) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'PER_ORGANIZATION_LIST_UK1' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ALL_ORGANIZATION_UNITS_TL' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HR_ALL_ORGANIZATION_UNTS_TL_PK' (INDEX (UNIQUE)) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO_FK2' (INDEX) ******************************************************************************** SELECT * FROM PER_SECURITY_PROFILES WHERE SECURITY_PROFILE_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 3 0.04 0.05 0 0 0 0 Fetch 3 0.00 0.00 0 6 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.04 0.06 0 6 0 3 Misses in library cache during parse: 2 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID PER_SECURITY_PROFILES (cr=2 pr=0 pw=0 time=48 us) 1 INDEX UNIQUE SCAN PER_SECURITY_PROFILES_PK (cr=1 pr=0 pw=0 time=20 us)(object id 72556) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'PER_SECURITY_PROFILES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'PER_SECURITY_PROFILES_PK' (INDEX (UNIQUE)) ******************************************************************************** SELECT /*+ USE_NL (A B I) */ DISTINCT A.APPLICATION_ID, A.APPLICATION_NAME, B.APPLICATION_SHORT_NAME, B.BASEPATH, I.PRODUCT_VERSION FROM FND_APPLICATION_TL A, FND_APPLICATION B, FND_PRODUCT_INSTALLATIONS I WHERE A.APPLICATION_ID = I.APPLICATION_ID (+) AND A.APPLICATION_ID = B.APPLICATION_ID AND A.LANGUAGE = USERENV ('LANG') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.03 0.02 0 95 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.03 0.02 0 490 0 275 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.06 0.05 0 585 0 275 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 275 HASH UNIQUE (cr=490 pr=0 pw=0 time=24683 us) 275 NESTED LOOPS OUTER (cr=490 pr=0 pw=0 time=25421 us) 275 NESTED LOOPS (cr=292 pr=0 pw=0 time=13031 us) 275 TABLE ACCESS FULL FND_APPLICATION (cr=15 pr=0 pw=0 time=3943 us) 275 TABLE ACCESS BY INDEX ROWID FND_APPLICATION_TL (cr=277 pr=0 pw=0 time=7188 us) 275 INDEX UNIQUE SCAN FND_APPLICATION_TL_U1 (cr=2 pr=0 pw=0 time=2934 us)(object id 30304) 196 TABLE ACCESS BY INDEX ROWID FND_PRODUCT_INSTALLATIONS (cr=198 pr=0 pw=0 time=10001 us) 196 INDEX RANGE SCAN FND_PRODUCT_INSTALLATIONS_PK (cr=2 pr=0 pw=0 time=3438 us)(object id 136262) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 275 HASH (UNIQUE) 275 NESTED LOOPS (OUTER) 275 NESTED LOOPS 275 TABLE ACCESS MODE: ANALYZED (FULL) OF 'FND_APPLICATION' (TABLE) 275 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_APPLICATION_TL' (TABLE) 275 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_APPLICATION_TL_U1' (INDEX (UNIQUE)) 196 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_PRODUCT_INSTALLATIONS' (TABLE) 196 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_PRODUCT_INSTALLATIONS_PK' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net more data to client 6 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = :B2 AND LOOKUP_CODE = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.04 0.04 0 0 0 0 Fetch 2 0.00 0.00 0 8 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.04 0.04 0 8 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=8 pr=0 pw=0 time=157 us) 2 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (cr=6 pr=0 pw=0 time=114 us)(object id 135789) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 2 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_LOOKUP_VALUES' (TABLE) 2 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_LOOKUP_VALUES_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT SECURITY_PROFILE_NAME , BUSINESS_GROUP_ID , VIEW_ALL_ORGANIZATIONS_FLAG FROM PER_SECURITY_PROFILES WHERE SECURITY_PROFILE_ID = TO_NUMBER(:B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.04 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.04 0 2 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID PER_SECURITY_PROFILES (cr=2 pr=0 pw=0 time=46 us) 1 INDEX UNIQUE SCAN PER_SECURITY_PROFILES_PK (cr=1 pr=0 pw=0 time=18 us)(object id 72556) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'PER_SECURITY_PROFILES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'PER_SECURITY_PROFILES_PK' (INDEX (UNIQUE)) ******************************************************************************** SELECT PR.SPID ,SE.SID ,SE.PROGRAM ,SE.MODULE FROM V$SESSION SE ,V$PROCESS PR WHERE SE.SID = (SELECT SID FROM V$MYSTAT WHERE ROWNUM = 1) AND SE.PADDR = PR.ADDR call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.03 0.03 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.03 0.04 0 0 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=6554 us) 1 HASH JOIN (cr=0 pr=0 pw=0 time=6531 us) 1 FIXED TABLE FULL X$KSUSE (cr=0 pr=0 pw=0 time=4192 us) 1 COUNT STOPKEY (cr=0 pr=0 pw=0 time=40 us) 1 FIXED TABLE FULL X$KSUMYSTA (cr=0 pr=0 pw=0 time=31 us) 1 FIXED TABLE FULL X$KSUSGIF (cr=0 pr=0 pw=0 time=10 us) 202 FIXED TABLE FULL X$KSUPR (cr=0 pr=0 pw=0 time=1033 us) 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=12 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 NESTED LOOPS 1 HASH JOIN 1 FIXED TABLE (FULL) OF 'X$KSUSE' (TABLE (FIXED)) 1 COUNT (STOPKEY) 1 FIXED TABLE (FULL) OF 'X$KSUMYSTA' (TABLE (FIXED)) 1 FIXED TABLE (FULL) OF 'X$KSUSGIF' (TABLE (FIXED)) 202 FIXED TABLE (FULL) OF 'X$KSUPR' (TABLE (FIXED)) 1 FIXED TABLE (FIXED INDEX) OF 'X$KSLED (ind:2)' (TABLE (FIXED)) ******************************************************************************** SELECT ORGANIZATION_ID FROM FND_MO_SP_PREFERENCES WHERE USER_ID = FND_GLOBAL.USER_ID AND RESP_ID = FND_GLOBAL.RESP_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.05 0.03 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.05 0.03 0 3 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS FULL FND_MO_SP_PREFERENCES (cr=3 pr=0 pw=0 time=64 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (FULL) OF 'FND_MO_SP_PREFERENCES' (TABLE) ******************************************************************************** SELECT COUNT(*) FROM FND_DATA_GROUPS WHERE DATA_GROUP_NAME NOT LIKE 'Multiple Reporting Currencies%' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.04 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 1 1 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.04 0.03 1 1 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=3679 us) 1 INDEX FULL SCAN FND_DATA_GROUPS_U2 (cr=1 pr=1 pw=0 time=3653 us)(object id 42978) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 SORT (AGGREGATE) 1 INDEX MODE: ANALYZED (FULL SCAN) OF 'FND_DATA_GROUPS_U2' (INDEX (UNIQUE)) ******************************************************************************** begin FND_TRACE.START_TRACE; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.02 0.02 0 34 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.02 0.02 0 34 0 1 Misses in library cache during parse: 0 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SELECT LEGISLATION_CODE FROM PER_BUSINESS_GROUPS_PERF WHERE BUSINESS_GROUP_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.01 0.02 0 0 0 0 Fetch 1 0.00 0.00 0 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.02 0 6 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 MERGE JOIN CARTESIAN (cr=6 pr=0 pw=0 time=183 us) 1 NESTED LOOPS (cr=3 pr=0 pw=0 time=65 us) 1 INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK (cr=1 pr=0 pw=0 time=16 us)(object id 43923) 1 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=2 pr=0 pw=0 time=44 us) 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK1 (cr=1 pr=0 pw=0 time=24 us)(object id 49335) 1 BUFFER SORT (cr=3 pr=0 pw=0 time=106 us) 1 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=3 pr=0 pw=0 time=65 us) 2 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (cr=2 pr=0 pw=0 time=35 us)(object id 215869) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 MERGE JOIN (CARTESIAN) 1 NESTED LOOPS 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HR_ORGANIZATION_UNITS_PK' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ORGANIZATION_INFORMATION' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO_FK1' (INDEX) 1 BUFFER (SORT) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ORGANIZATION_INFORMATION' (TABLE) 2 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO_FK2' (INDEX) ******************************************************************************** SELECT MESSAGE_TEXT, MESSAGE_NUMBER, TYPE, FND_LOG_SEVERITY, CATEGORY, SEVERITY FROM FND_NEW_MESSAGES M, FND_APPLICATION A WHERE :B3 = M.MESSAGE_NAME AND :B2 = M.LANGUAGE_CODE AND :B1 = A.APPLICATION_SHORT_NAME AND M.APPLICATION_ID = A.APPLICATION_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.02 0 0 0 0 Fetch 1 0.00 0.00 0 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.02 0 6 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=89 us) 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION (cr=2 pr=0 pw=0 time=33 us) 1 INDEX UNIQUE SCAN FND_APPLICATION_U3 (cr=1 pr=0 pw=0 time=18 us)(object id 30258) 1 TABLE ACCESS BY INDEX ROWID FND_NEW_MESSAGES (cr=4 pr=0 pw=0 time=47 us) 1 INDEX UNIQUE SCAN FND_NEW_MESSAGES_PK (cr=3 pr=0 pw=0 time=31 us)(object id 135983) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_APPLICATION' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_APPLICATION_U3' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_NEW_MESSAGES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_NEW_MESSAGES_PK' (INDEX (UNIQUE)) ******************************************************************************** declare dummy boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, dummy, :org_id, :server_id);end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 14 0.02 0.02 0 93 0 14 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.02 0.02 0 93 0 14 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 14 0.00 0.00 SQL*Net message from client 14 0.00 0.00 ******************************************************************************** SELECT NVL(MPI.STATUS, 'N') FROM FND_MO_PRODUCT_INIT MPI WHERE MPI.APPLICATION_SHORT_NAME = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.01 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.02 0 2 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_MO_PRODUCT_INIT (cr=2 pr=0 pw=0 time=37 us) 1 INDEX UNIQUE SCAN FND_MO_PRODUCT_INIT_U1 (cr=1 pr=0 pw=0 time=18 us)(object id 135931) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_MO_PRODUCT_INIT' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_MO_PRODUCT_INIT_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT P.PID, P.SPID, AUDSID, PROCESS, SUBSTR(USERENV('LANGUAGE'), INSTR( USERENV('LANGUAGE'), '.') + 1) FROM V$SESSION S, V$PROCESS P WHERE P.ADDR = S.PADDR AND S.AUDSID = USERENV('SESSIONID') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.01 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.01 0 0 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=4261 us) 1 HASH JOIN (cr=0 pr=0 pw=0 time=4241 us) 1 FIXED TABLE FULL X$KSUSE (cr=0 pr=0 pw=0 time=2475 us) 203 FIXED TABLE FULL X$KSUPR (cr=0 pr=0 pw=0 time=830 us) 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=12 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 NESTED LOOPS 1 HASH JOIN 1 FIXED TABLE (FULL) OF 'X$KSUSE' (TABLE (FIXED)) 203 FIXED TABLE (FULL) OF 'X$KSUPR' (TABLE (FIXED)) 1 FIXED TABLE (FIXED INDEX) OF 'X$KSLED (ind:2)' (TABLE (FIXED)) ******************************************************************************** SELECT P.OPTIMIZER_MODE, P.CONCURRENT_PROGRAM_NAME, UPPER(P.ENABLE_TRACE), UPPER(R.ENABLE_TRACE), DECODE(UPPER(P.ENABLE_TIME_STATISTICS),'Y','TRUE', NULL), EXECUTION_METHOD_CODE, MULTI_ORG_CATEGORY, ORG_ID FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURRENT_REQUESTS R WHERE P.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID AND P.APPLICATION_ID = R.PROGRAM_APPLICATION_ID AND R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 0 6 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=331 us) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=279 us) 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=256 us)(object id 41365) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=40 us) 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=21 us)(object id 40924) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_CONCURRENT_REQUESTS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_CONCURRENT_PROGRAMS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CONCURRENT_PROGRAMS_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT SUBSTR(REPLACE(USER_CONCURRENT_PROGRAM_NAME,'''',' '),1,240), SUBSTR(CONCURRENT_PROGRAM_NAME,1,30) FROM FND_CONCURRENT_PROGRAMS_VL WHERE CONCURRENT_PROGRAM_ID = :B1 AND APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.01 0 0 0 0 Fetch 1 0.00 0.00 0 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 0 6 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_CONCURRENT_PROGRAMS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CONCURRENT_PROGRAMS_U1' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_CONCURRENT_PROGRAMS_TL' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CONCURRENT_PROGRAMS_TL_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT PLSQL_LOG, PLSQL_OUT, PLSQL_DIR FROM FND_CONCURRENT_PROCESSES P, FND_CONCURRENT_REQUESTS R WHERE P.CONCURRENT_PROCESS_ID = R.CONTROLLING_MANAGER AND R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.01 0 6 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=307 us) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=258 us) 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=238 us)(object id 41365) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROCESSES (cr=3 pr=0 pw=0 time=41 us) 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROCESSES_U1 (cr=2 pr=0 pw=0 time=23 us)(object id 40791) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_CONCURRENT_REQUESTS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_CONCURRENT_PROCESSES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CONCURRENT_PROCESSES_U1' (INDEX (UNIQUE)) ******************************************************************************** UPDATE FND_CONCURRENT_REQUESTS SET ORACLE_SESSION_ID = :B4 , ORACLE_PROCESS_ID = :B3 , OS_PROCESS_ID = :B2 , NLS_CODESET = :B1 WHERE REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.01 0 2 3 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.02 0.01 0 2 3 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE FND_CONCURRENT_REQUESTS (cr=2 pr=0 pw=0 time=590 us) 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=315 us)(object id 41365) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: ALL_ROWS 1 UPDATE OF 'FND_CONCURRENT_REQUESTS' 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT SET_OF_BOOKS_ID FROM HR_OPERATING_UNITS WHERE ORGANIZATION_ID = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.01 0 0 0 0 Fetch 1 0.00 0.00 0 9 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.01 0 9 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 MERGE JOIN (CARTESIAN) 0 NESTED LOOPS 0 NESTED LOOPS 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HR_ALL_ORGANIZATION_UNTS_TL_PK' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HR_ORGANIZATION_UNITS_PK' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ORGANIZATION_INFORMATION' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO_FK2' (INDEX) 0 BUFFER (SORT) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HR_ORGANIZATION_INFORMATION' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HR_ORGANIZATION_INFORMATIO_FK2' (INDEX) ******************************************************************************** SELECT P.ROLLBACK_SEGMENT FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURRENT_REQUESTS R WHERE R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID AND R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.03 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.03 0.01 0 6 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=321 us) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=274 us) 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=253 us)(object id 41365) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=40 us) 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=26 us)(object id 40924) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_CONCURRENT_REQUESTS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_CONCURRENT_PROGRAMS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CONCURRENT_PROGRAMS_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 52 0.01 0.01 0 0 0 0 Fetch 52 0.01 0.00 0 115 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 104 0.02 0.01 0 115 0 10 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_PROFILE_OPTION_VALUES' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_PROFILE_OPTION_VALUES_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT NLS_DATE_LANGUAGE FROM (SELECT UTF8_DATE_LANGUAGE NLS_DATE_LANGUAGE FROM FND_LANGUAGES WHERE NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')) IN ('UTF8', 'AL32UTF8') AND INSTALLED_FLAG <>'D' AND NLS_LANGUAGE = :B1 UNION SELECT LOCAL_DATE_LANGUAGE NLS_DATE_LANGUAGE FROM FND_LANGUAGES WHERE NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')) NOT IN ('UTF8', 'AL32UTF8') AND INSTALLED_FLAG <>'D' AND NLS_LANGUAGE = :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 0 2 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 VIEW (cr=2 pr=0 pw=0 time=149 us) 1 SORT UNIQUE (cr=2 pr=0 pw=0 time=141 us) 1 UNION-ALL (cr=2 pr=0 pw=0 time=51 us) 0 FILTER (cr=0 pr=0 pw=0 time=4 us) 0 TABLE ACCESS BY INDEX ROWID FND_LANGUAGES (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN FND_LANGUAGES_U5 (cr=0 pr=0 pw=0 time=0 us)(object id 57413) 1 TABLE ACCESS BY INDEX ROWID FND_LANGUAGES (cr=2 pr=0 pw=0 time=37 us) 1 INDEX UNIQUE SCAN FND_LANGUAGES_U5 (cr=1 pr=0 pw=0 time=20 us)(object id 57413) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 VIEW 1 SORT (UNIQUE) 1 UNION-ALL 0 FILTER 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_LANGUAGES' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_LANGUAGES_U5' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_LANGUAGES' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_LANGUAGES_U5' (INDEX (UNIQUE)) ******************************************************************************** SELECT NAME FROM GL_SETS_OF_BOOKS WHERE SET_OF_BOOKS_ID = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 2 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'GL_LEDGERS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'GL_LEDGERS_U2' (INDEX (UNIQUE)) ******************************************************************************** SELECT R.RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL R WHERE R.RESPONSIBILITY_ID = :B2 AND R.APPLICATION_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.01 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 10 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.01 0.00 0 10 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 NESTED LOOPS (cr=10 pr=0 pw=0 time=171 us) 2 INDEX UNIQUE SCAN FND_RESPONSIBILITY_U1 (cr=4 pr=0 pw=0 time=52 us)(object id 136401) 2 TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY_TL (cr=6 pr=0 pw=0 time=105 us) 2 INDEX UNIQUE SCAN FND_RESPONSIBILITY_TL_U1 (cr=4 pr=0 pw=0 time=68 us)(object id 136408) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 2 NESTED LOOPS 2 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_RESPONSIBILITY_U1' (INDEX (UNIQUE)) 2 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_RESPONSIBILITY_TL' (TABLE) 2 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_RESPONSIBILITY_TL_U1' (INDEX (UNIQUE)) ******************************************************************************** begin :con := XLA_SECURITY_POLICY_PKG.XLA_STANDARD_POLICY(:sn, :on); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 0 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) ******************************************************************************** SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 18 0.00 0.00 0 0 0 0 Fetch 18 0.00 0.00 0 39 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 37 0.00 0.00 0 39 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_PROFILE_OPTION_VALUES' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_PROFILE_OPTION_VALUES_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT U.USER_NAME, NVL(U.EMPLOYEE_ID, :B2 ) EMPLOYEE_ID, NVL(U.CUSTOMER_ID, :B2 ) CUSTOMER_ID, NVL(U.SUPPLIER_ID, :B2 ) SUPPLIER_ID, NVL(U.PERSON_PARTY_ID, :B2 ) PERSON_PARTY_ID FROM FND_USER U WHERE U.USER_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_USER (cr=2 pr=0 pw=0 time=37 us) 1 INDEX UNIQUE SCAN FND_USER_U1 (cr=1 pr=0 pw=0 time=16 us)(object id 136999) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_USER' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_USER_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 34 0.00 0.00 0 0 0 0 Fetch 34 0.00 0.00 0 95 0 27 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 68 0.00 0.00 0 95 0 27 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_PROFILE_OPTIONS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_PROFILE_OPTIONS_U2' (INDEX (UNIQUE)) ******************************************************************************** SELECT SUBSTR(RELEASE_NAME,1,4) FROM FND_PRODUCT_GROUPS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 15 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 15 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL FND_PRODUCT_GROUPS (cr=15 pr=0 pw=0 time=273 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (FULL) OF 'FND_PRODUCT_GROUPS' (TABLE) ******************************************************************************** SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER IN ( 'NLS_LANGUAGE', 'NLS_DATE_LANGUAGE', 'NLS_SORT', 'NLS_TERRITORY', 'NLS_DATE_FORMAT', 'NLS_NUMERIC_CHARACTERS', 'NLS_CHARACTERSET' ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 7 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 7 FIXED TABLE FULL X$NLS_PARAMETERS (cr=0 pr=0 pw=0 time=79 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 7 FIXED TABLE (FULL) OF 'X$NLS_PARAMETERS' (TABLE (FIXED)) ******************************************************************************** begin FND_CONCURRENT.SET_PREFERRED_RBS; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** DELETE FROM MO_GLOB_ORG_ACCESS_TMP call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE MO_GLOB_ORG_ACCESS_TMP (cr=0 pr=0 pw=0 time=18 us) 0 TABLE ACCESS FULL MO_GLOB_ORG_ACCESS_TMP (cr=0 pr=0 pw=0 time=9 us) Rows Execution Plan ------- --------------------------------------------------- 0 DELETE STATEMENT MODE: ALL_ROWS 0 DELETE OF 'MO_GLOB_ORG_ACCESS_TMP' 0 TABLE ACCESS (FULL) OF 'MO_GLOB_ORG_ACCESS_TMP' (TABLE (TEMP)) ******************************************************************************** SELECT DECODE(READ_ONLY_FLAG,'U', 'Y' ,'M', 'Y' ,'K', 'Y' ,'N') SCHEMA_MODE, DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1),' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1, 10)) FROM FND_ORACLE_USERID WHERE ORACLE_USERNAME = USER call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 2 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_ORACLE_USERID (cr=2 pr=0 pw=0 time=42 us) 1 INDEX UNIQUE SCAN FND_ORACLE_USERID_U2 (cr=1 pr=0 pw=0 time=17 us)(object id 136124) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_ORACLE_USERID' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_ORACLE_USERID_U2' (INDEX (UNIQUE)) ******************************************************************************** begin fnd_conc_stat.collect; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) ******************************************************************************** SELECT CONCURRENT_PROGRAM_ID , NVL(ENABLE_TRACE , 'N' ) FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=3 pr=0 pw=0 time=49 us) 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=2 pr=0 pw=0 time=23 us)(object id 41365) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_CONCURRENT_REQUESTS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** INSERT INTO MO_GLOB_ORG_ACCESS_TMP (ORGANIZATION_ID , ORGANIZATION_NAME) VALUES (:B1 , :B2 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 1 20 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 20 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 INSERT STATEMENT MODE: ALL_ROWS ******************************************************************************** SELECT NVL(MULTI_ORG_FLAG, 'N') FROM FND_PRODUCT_GROUPS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 15 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 15 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL FND_PRODUCT_GROUPS (cr=15 pr=0 pw=0 time=200 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (FULL) OF 'FND_PRODUCT_GROUPS' (TABLE) ******************************************************************************** SELECT A.APPLICATION_SHORT_NAME FROM FND_APPLICATION A WHERE A.APPLICATION_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION (cr=2 pr=0 pw=0 time=33 us) 1 INDEX UNIQUE SCAN FND_APPLICATION_U1 (cr=1 pr=0 pw=0 time=18 us)(object id 30256) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_APPLICATION' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_APPLICATION_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT FNDU.EMPLOYEE_ID FROM FND_USER FNDU WHERE :B1 IS NOT NULL AND FNDU.USER_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 2 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 FILTER (cr=2 pr=0 pw=0 time=41 us) 1 TABLE ACCESS BY INDEX ROWID FND_USER (cr=2 pr=0 pw=0 time=35 us) 1 INDEX UNIQUE SCAN FND_USER_U1 (cr=1 pr=0 pw=0 time=17 us)(object id 136999) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 FILTER 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_USER' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_USER_U1' (INDEX (UNIQUE)) ******************************************************************************** SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID FND_NODES (cr=1 pr=0 pw=0 time=31 us) 0 INDEX RANGE SCAN FND_NODES_N1 (cr=1 pr=0 pw=0 time=26 us)(object id 331466) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_NODES' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_NODES_N1' (INDEX) ******************************************************************************** SELECT TO_CHAR(SYSDATE,'DD-MON-YY:HH24:MI:SS') FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 0 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 FAST DUAL ******************************************************************************** SELECT 'TRACE_USER_DETAILS: TIMESTAMP=20-APR-11:18:00:00: USER_NAME= HELPDESKRN: CONC_REQUEST_ID=23734784: OLTP_OPT_MODE= : CONC_OPT_MODE= : CONC_PROG_EXE=JAINCTRB: CONC_PROG_NAME=India - Creditors Trial Balance Report: RESPONSIBILITY=Payables Super User (SAG): APPL_NAME=SQLAP' FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 FAST DUAL ******************************************************************************** SELECT NAME, VERSION FROM FND_CACHE_VERSIONS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 17 0.00 0.00 0 0 0 0 Fetch 17 0.01 0.00 0 17 0 136 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 34 0.01 0.00 0 17 0 136 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 INDEX MODE: ANALYZED (FULL SCAN) OF 'FND_CACHE_VERSIONS_PK1' (INDEX (UNIQUE)) ******************************************************************************** ALTER SESSION SET SQL_TRACE = TRUE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (APPS) (recursive depth: 1) ******************************************************************************** COMMIT call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 2 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 2 0 Misses in library cache during parse: 0 Parsing user id: 44 (APPS) (recursive depth: 1) ******************************************************************************** ALTER SESSION SET EVENTS '10046 trace name context forever, level 4' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 44 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 27 0.04 0.05 0 95 0 0 Execute 15530 21.04 21.17 0 1190 0 19 Fetch 221311 823.95 3031.87 573976 19294537 0 218543 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 236868 845.03 3053.10 573976 19295822 0 218562 Misses in library cache during parse: 22 Misses in library cache during execute: 11 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 24 0.00 0.00 SQL*Net message from client 24 0.00 0.01 SQL*Net more data to client 6 0.00 0.00 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 7292 0.68 0.73 0 0 0 0 Execute 1036711 368.46 362.13 0 3 25 4 Fetch 1039061 6772.50 6620.67 364 452754 0 1046280 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2083064 7141.64 6983.54 364 452757 25 1046284 Misses in library cache during parse: 84 Misses in library cache during execute: 63 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 6467 user SQL statements in session. 1692 internal SQL statements in session. 8159 SQL statements in session. 66 statements EXPLAINed in this session. ******************************************************************************** Trace file: test_ora_7660_APPS.trc Trace file compatibility: 10.01.00 Sort options: prsela exeela fchela 1 session in tracefile. 6467 user SQL statements in trace file. 1692 internal SQL statements in trace file. 8159 SQL statements in trace file. 132 unique SQL statements in trace file. 66 SQL statements EXPLAINed using schema: APPS.prof$plan_table Default table was used. Table was created. Table was dropped. 11948367 lines in trace file. 11181 elapsed seconds in trace file.