WORKLOAD REPOSITORY PDB report (PDB snapshots)

DB NameDB IdUnique NameRoleEditionReleaseRACCDB
EBSCDB684292237EBSCDBPRIMARYEE19.0.0.0.0NOYES

InstanceInst NumStartup Time
EBSCDB109-Apr-20 23:51

Container DB IdContainer NameOpen Time
684292237VOL122909-Apr-20 23:51

Host NamePlatformCPUsCoresSocketsMemory (GB)
ebs1229dbLinux x86 64-bit 32 16 1 235.88

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:30723-Apr-20 18:30:49738 7.6
End Snap:31423-Apr-20 19:19:03739 7.4
Elapsed:  48.23 (mins)  
DB Time:  1,143.80 (mins)  

Report Summary

Top ADDM Findings by Average Active Sessions

Finding NameAvg active sessions of the taskPercent active sessions of findingTask NameBegin Snap TimeEnd Snap Time
Top SQL Statements87.7257.86ADDM:684292237_1_31123-Apr-20 18:5623-Apr-20 19:03
Buffer Busy - Hot Objects87.7236.34ADDM:684292237_1_31123-Apr-20 18:5623-Apr-20 19:03
PL/SQL Execution87.7220.72ADDM:684292237_1_31123-Apr-20 18:5623-Apr-20 19:03
Top SQL Statements21.5946.36ADDM:684292237_1_31223-Apr-20 19:0323-Apr-20 19:10
Top SQL Statements20.4237.46ADDM:684292237_1_31023-Apr-20 18:5123-Apr-20 18:56

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 23.7 0.0 0.00 0.15
DB CPU(s): 12.3 0.0 0.00 0.08
Background CPU(s): 0.0 0.0 0.00 0.00
Redo size (bytes): 15,245,406.6 23,717.9  
Logical read (blocks): 1,386,269.1 2,156.7  
Block changes: 101,351.0 157.7  
Physical read (blocks): 3,125.4 4.9  
Physical write (blocks): 13.7 0.0  
Read IO requests: 2,816.7 4.4  
Write IO requests: 0.6 0.0  
Read IO (MB): 24.4 0.0  
Write IO (MB): 0.1 0.0  
IM scan rows: 0.0 0.0  
Session Logical Read IM: 0.0 0.0  
User calls: 155.3 0.2  
Parses (SQL): 5,895.5 9.2  
Hard parses (SQL): 0.6 0.0  
SQL Work Area (MB): 91.3 0.1  
Logons: 1.7 0.0  
User logons: 0.3 0.0  
Executes (SQL): 41,992.0 65.3  
Rollbacks: 1.0 0.0  
Transactions: 642.8   

Top 10 Foreground Events by Total Wait Time

EventWaitsTotal Wait Time (sec)Avg Wait% DB timeWait Class
DB CPU 35.6K 51.9 
buffer busy waits3,036,71713.6K4.49ms19.9Concurrency
latch: cache buffers chains4,007,7843790.2945.71us5.5Concurrency
enq: TX - row lock contention121,2192960.724.42ms4.3Application
log file switch (checkpoint incomplete)3572109.85909.76ms3.1Configuration
enq: TX - index contention94,064830.28.83ms1.2Concurrency
enq: TX - allocate ITL entry13,680725.853.06ms1.1Configuration
library cache: mutex X158,779609.13.84ms.9Concurrency
free buffer waits11,510469.840.82ms.7Configuration
undo segment extension1,347366.1271.81ms.5Configuration

Wait Classes by Total Wait Time

Wait ClassWaitsTotal Wait Time (sec)Avg Wait Time% DB timeAvg Active Sessions
DB CPU 35,598 51.912.3
Concurrency7,700,65419,4322.52ms28.36.7
Configuration46,6674,34393.06ms6.31.5
Application123,5862,98124.12ms4.31.0
Other298,8211,5925.33ms2.30.6
User I/O8,694,96917019.53us.20.1
Commit8,98512914.32ms.20.0
Network415,05713.56us.00.0
System I/O30,394121.92us.00.0
Administrative24011.08us.00.0

IO Profile

Read+Write Per SecondRead per SecondWrite Per Second
Total Requests: 2,828.5 2,827.9 0.6
Database Requests: 2,817.3 2,816.7 0.6
Optimized Requests: 0.0 0.0 0.0
Redo Requests:   
Total (MB): 24.7 24.6 0.1
Database (MB): 24.5 24.4 0.1
Optimized Total (MB): 0.0 0.0 0.0
Redo (MB):   
Database (blocks): 3,139.1 3,125.4 13.7
Via Buffer Cache (blocks): 3,096.4 3,096.4 0.0
Direct (blocks): 42.6 29.0 13.7

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time% of Total CPU Time
sql execute elapsed time68,302.5299.53 
DB CPU35,597.6251.87100.00
PL/SQL execution elapsed time12,840.2518.71 
parse time elapsed301.180.44 
connection management call elapsed time54.510.08 
hard parse elapsed time29.100.04 
hard parse (sharing criteria) elapsed time20.130.03 
repeated bind elapsed time7.090.01 
failed parse elapsed time1.140.00 
PL/SQL compilation elapsed time0.770.00 
DB time68,627.80  
background elapsed time3.31  
background cpu time1.62 0.00
total CPU time35,599.25  


Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait%DB time
DB CPU  35,598 51.87
Concurrency7,699,479019,4302.52ms28.31
Configuration46,63734,28391.83ms6.24
Application123,58602,98124.12ms4.34
Other288,38239883.42ms1.44
User I/O8,687,367017019.51us0.25
Commit8,985012914.32ms0.19
Network413,131013.58us0.00
System I/O29,925002.97us0.00
Administrative240011.08us0.00


Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg waitWaits /txn% DB time
buffer busy waits3,036,717 13,6264.49ms1.6319.85
latch: cache buffers chains4,007,784 3,790945.71us2.155.52
enq: TX - row lock contention121,219 2,96124.42ms0.074.31
log file switch (checkpoint incomplete)357 2,1105909.76ms0.003.07
enq: TX - index contention94,064 8308.83ms0.051.21
enq: TX - allocate ITL entry13,680072653.06ms0.011.06
library cache: mutex X158,779 6093.84ms0.090.89
free buffer waits11,510 47040.82ms0.010.68
undo segment extension1,34794366271.81ms0.000.53
latch: redo allocation25,315 34713.70ms0.010.51
latch: In memory undo latch333,374 3361.01ms0.180.49
latch: cache buffers lru chain28,760 2488.61ms0.020.36
log file switch (private strand flush incomplete)736 237322.50ms0.000.35
write complete waits252 201795.65ms0.000.29
latch free8,551 18621.78ms0.000.27
db file sequential read7,858,190 13817.61us4.220.20
log file sync8,985 12914.32ms0.000.19
cursor: pin S11,682 12010.28ms0.010.18
latch: undo global data7,139 7510.47ms0.000.11
enq: SQ - contention7,660 597.72ms0.000.09
log buffer space333 52156.77ms0.000.08
latch: shared pool3,901 4611.79ms0.000.07
latch: call allocation1,893 4121.66ms0.000.06
enq: FB - contention22,402 381.68ms0.010.05
enq: HW - contention10,683 363.37ms0.010.05
latch: enqueue hash chains2,494 2710.82ms0.000.04
row cache mutex9,717 262.67ms0.010.04
log file switch completion72 26358.97ms0.000.04
enq: KO - fast object checkpoint1 1919.47 s0.000.03
cursor: mutex X39,890 18462.52us0.020.03
cursor: pin S wait on X212 1674.39ms0.000.02
read by other session144,029 1387.19us0.080.02
enq: TX - contention11,124 7592.12us0.010.01
Disk file operations I/O65,260 464.49us0.040.01
PGA memory operation158,041 426.06us0.080.01
library cache lock118 433.36ms0.000.01
utl_file I/O469,534 47.84us0.250.01
direct path write temp1,539 42.36ms0.000.01
cursor: mutex S347 39.48ms0.000.00
library cache load lock231 313.98ms0.000.00
local write wait384 36.91ms0.000.00
db file scattered read95,764 225.14us0.050.00
buffer deadlock7,1721002332.46us0.000.00
PX Deq: Join ACK3,845 2556.55us0.000.00
enq: DA - Slave Process Array78 227.33ms0.000.00
latch: object queue header operation192 29.85ms0.000.00
enq: PS - contention2,369 2752.90us0.000.00
db file parallel read50,524 233.74us0.030.00
library cache: bucket mutex X381 13.30ms0.000.00
PX Deq: Signal ACK EXT2,186 1571.50us0.000.00
wait list latch free227 15.28ms0.000.00
PX Deq: Slave Session Stats4,364 1268.68us0.000.00
row cache lock2,282 1389.57us0.000.00
SQL*Net break/reset to client2,358 1372.03us0.000.00
latch: checkpoint queue latch85 19.36ms0.000.00
SQL*Net more data to client24,907 129.07us0.010.00
SQL*Net message to client372,325 11.38us0.200.00
enq: RC - Result Cache: Contention8 031.33ms0.000.00
SQL*Net more data from client15,899 015.20us0.010.00
latch: messages41 05.04ms0.000.00
enq: US - contention15 013.40ms0.000.00
oracle thread bootstrap20 09.91ms0.000.00
latch: cache buffer handles29 05.36ms0.000.00
kksfbc child completion3100050.47ms0.000.00
direct path read temp1,651 059.64us0.000.00
control file sequential read29,925 02.97us0.020.00
direct path read388 0227.40us0.000.00
direct path sync43 02.04ms0.000.00
asynch descriptor resize755100053.01us0.000.00
PX qref latch1,062100013.12us0.000.00
L1 validation1100010.51ms0.000.00
enq: DV - contention13 0258.69us0.000.00
direct path write61 027.44us0.000.00
latch: redo writing7 0200.00us0.000.00
transaction55 019.55us0.000.00
SQL*Net message from client372,585 1,860,6824993.98ms0.20 
Streams AQ: waiting for messages in the queue5,3169846,6758780.16ms0.00 
PL/SQL lock timer1,70210014,7558669.33ms0.00 
pipe get3,2749914,4374409.64ms0.00 
PX Deq: Table Q Normal24,646 994.04ms0.01 
PX Deq: Execution Msg13,917 644.62ms0.01 
PX Deq: Execute Reply6,521 548.22ms0.00 
PX Deq: Parse Reply3,836 61.51ms0.00 
PX Deq: Msg Fragment3,776 020.01us0.00 
PX Deq Credit: send blkd147 0411.51us0.00 
PX Deq Credit: need buffer19 0736.00us0.00 
PX Deq: Table Q Sample32 0151.84us0.00 


Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
ebs_VOL122968,63035,6009,0424,011,779
VOL12290000
VOL1229_ebs_patch0000


Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
ebs_VOL1229 87380701707705108194992404136051
VOL1229 00000000


Back to Wait Events Statistics
Back to Top

Top Process Types by Wait Class

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Top Process Types by CPU Used

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO SQL IdSQL ModulePDB NameSQL Text
21,716.70200108.5831.6416.460.100z318y6g3uagc e:ONT:cp:inv/INCTCW VOL1229 declare l_retstat varchar2 ( 3...
11,967.86299,9700.0417.441.630.02b5mv0n1ss384u e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 INSERT INTO MTL_MATERIAL_TRAN...
11,296.0432353.0016.4652.030.148zfgv4ck11dw9 e:ONT:cp:fnd/FNDWFBG VOL1229 BEGIN WF_ENGINE.BACKGROUNDCONC...
10,391.2364162.3615.1499.280.054y08a52989vfk e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 BEGIN WSH_PICK_LIST.RELEASE_BA...
6,253.0334183.919.1166.110.050074pdmwb7fmv e:ONT:cp:wsh/WSHINTERFACE VOL1229 BEGIN WSH_SHIP_CONFIRM_ACTIONS...
4,389.3632137.176.4087.850.596abn0zw8kkvtk e:AR:cp:ar/RAXTRX VOL1229 begin arp_etax_autoinv_util . ...
4,083.4132127.615.9568.560.295t6wystf9zvbb e:ONT:cp:ont/OEHVIMP VOL1229 BEGIN OE_BULK_ORDER_IMPORT_PVT...
2,387.663274.613.489.990.32byaf6gyh7qg9v e:AR:cp:ar/RAXTRX VOL1229 declare ok_flag BOOLEAN ; BEGI...
2,165.523267.673.165.180.01g31wtj4vanqku e:AR:wf:ARSBALSG VOL1229 DELETE FROM RA_INTERFACE_SALE...
1,932.5799,9860.022.8242.990.70assndb4wqnd6r e:ONT:cp:inv/INCTCW VOL1229 BEGIN INV_TXN_MANAGER_PUB.rel_...
1,717.711,479,7620.002.5020.540.06cd9mbmqyf4qhp e:ONT:wf:OEOH VOL1229 UPDATE WF_ITEM_ACTIVITY_STATUS...
1,389.3599,9870.012.0299.360.228gmgrb5mwa9f9 e:AR:cp:ar/RAXTRX VOL1229 SELECT TAX_REGIME_CODE, TAX, S...
1,159.69299,9810.001.6936.910.003b3psftuyks81 e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 BEGIN INV_TXNSTUB_PUB.postTran...
1,088.1799,9930.011.5999.390.014yak7x2zqz0dh e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 BEGIN inv_transfer_order_pvt.f...
1,074.711925.601.5762.402.3737f1qguwxw0sk e:AR:cp:ar/RAXTRX VOL1229 begin IF ( :v_msg_level:i_msg_...
869.46299,9750.001.2751.060.140mdnts20d60yr e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 declare v_ret number := 0; be...
845.482,906,5770.001.2399.340.007qh9zcbrq9ky7 e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT 'Y' FROM WSH_PR_WORKERS...
843.01299,9010.001.2347.530.004u81ft6vn8k4j e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT ACCT_PERIOD_ID FROM ORG...
781.1899,9990.011.144.650.000wabkkyua3y3v e:ONT:wf:OEOL VOL1229 SELECT ITEM_KEY FROM WF_ITEMS ...
728.8999,9770.011.0610.180.013hc5p1pfvaq7m e:ONT:cp:inv/INCTCW VOL1229 BEGIN INV_LOGICAL_TRANSACTIONS...
707.153222.101.0364.373.455dsv99085tx1k e:AR:cp:ar/RAXTRX VOL1229 SELECT /*+ leading(ct) index(c...


Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModulePDB NameSQL Text
10,316.3564161.1928.9810,391.2399.280.054y08a52989vfk e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 BEGIN WSH_PICK_LIST.RELEASE_BA...
5,877.5032183.6716.5111,296.0452.030.148zfgv4ck11dw9 e:ONT:cp:fnd/FNDWFBG VOL1229 BEGIN WF_ENGINE.BACKGROUNDCONC...
4,134.0034121.5911.616,253.0366.110.050074pdmwb7fmv e:ONT:cp:wsh/WSHINTERFACE VOL1229 BEGIN WSH_SHIP_CONFIRM_ACTIONS...
3,855.9632120.5010.834,389.3687.850.596abn0zw8kkvtk e:AR:cp:ar/RAXTRX VOL1229 begin arp_etax_autoinv_util . ...
3,574.9020017.8710.0421,716.7016.460.100z318y6g3uagc e:ONT:cp:inv/INCTCW VOL1229 declare l_retstat varchar2 ( 3...
2,799.733287.497.864,083.4168.560.295t6wystf9zvbb e:ONT:cp:ont/OEHVIMP VOL1229 BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,380.4599,9870.013.881,389.3599.360.228gmgrb5mwa9f9 e:AR:cp:ar/RAXTRX VOL1229 SELECT TAX_REGIME_CODE, TAX, S...
1,081.5199,9930.013.041,088.1799.390.014yak7x2zqz0dh e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 BEGIN inv_transfer_order_pvt.f...
839.882,906,5770.002.36845.4899.340.007qh9zcbrq9ky7 e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT 'Y' FROM WSH_PR_WORKERS...
830.7499,9860.012.331,932.5742.990.70assndb4wqnd6r e:ONT:cp:inv/INCTCW VOL1229 BEGIN INV_TXN_MANAGER_PUB.rel_...
670.661923.491.881,074.7162.402.3737f1qguwxw0sk e:AR:cp:ar/RAXTRX VOL1229 begin IF ( :v_msg_level:i_msg_...
548.433182.811.54550.8499.560.141wnq9qthbb54q e:ONT:cp:wsh/WSHPSRS VOL1229 BEGIN WSH_PICK_LIST.RELEASE_BA...
476.451239.701.34492.5496.730.137ptvbaycjtbg4 e:AR:cp:ar/ARTERRPW VOL1229 BEGIN arp_run.revenue_recognit...
455.183214.221.28707.1564.373.455dsv99085tx1k e:AR:cp:ar/RAXTRX VOL1229 SELECT /*+ leading(ct) index(c...
443.91299,9750.001.25869.4651.060.140mdnts20d60yr e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 declare v_ret number := 0; be...
428.03299,9810.001.201,159.6936.910.003b3psftuyks81 e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 BEGIN INV_TXNSTUB_PUB.postTran...
400.72299,9010.001.13843.0147.530.004u81ft6vn8k4j e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT ACCT_PERIOD_ID FROM ORG...
364.327,476,2410.001.02436.4283.480.003c32a4bk574vp   VOL1229 select d.sumobj# from sys.sumd...


Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModulePDB NameSQL Text
25.94320.8115.274,389.3687.850.596abn0zw8kkvtk e:AR:cp:ar/RAXTRX VOL1229 begin arp_etax_autoinv_util . ...
25.481920.1315.001,074.7162.402.3737f1qguwxw0sk e:AR:cp:ar/RAXTRX VOL1229 begin IF ( :v_msg_level:i_msg_...
24.37320.7614.35707.1564.373.455dsv99085tx1k e:AR:cp:ar/RAXTRX VOL1229 SELECT /*+ leading(ct) index(c...
20.822000.1012.2621,716.7016.460.100z318y6g3uagc e:ONT:cp:inv/INCTCW VOL1229 declare l_retstat varchar2 ( 3...
16.18299,8590.009.52380.1757.284.25drt9k4tpvph64 e:AR:cp:ar/RAXTRX VOL1229 SELECT AR_TAX.LOCATION_SEGMENT...
15.40320.489.0711,296.0452.030.148zfgv4ck11dw9 e:ONT:cp:fnd/FNDWFBG VOL1229 BEGIN WF_ENGINE.BACKGROUNDCONC...
13.5699,9860.007.981,932.5742.990.70assndb4wqnd6r e:ONT:cp:inv/INCTCW VOL1229 BEGIN INV_TXN_MANAGER_PUB.rel_...
12.01320.387.074,083.4168.560.295t6wystf9zvbb e:ONT:cp:ont/OEHVIMP VOL1229 BEGIN OE_BULK_ORDER_IMPORT_PVT...
10.6399,9990.006.26197.5011.945.3853j6qu1wu4673 e:ONT:cp:inv/INCTCW VOL1229 INSERT INTO MRP_RELIEF_INTERFA...
7.5841.894.46446.1677.181.705t39uchjqpyfm e:AR:cp:xla/XLAACCUP VOL1229 BEGIN xla_accounting_pkg.unit_...
7.56320.244.4577.8868.759.718an3ja4qk82vm e:AR:cp:ar/RAXTRX VOL1229 SELECT /*+ index (tl RA_CUSTOM...
7.53320.244.432,387.669.990.32byaf6gyh7qg9v e:AR:cp:ar/RAXTRX VOL1229 declare ok_flag BOOLEAN ; BEGI...
6.47320.203.81204.8151.063.16bkwbfrp993czv e:AR:cp:ar/RAXTRX VOL1229 UPDATE RA_CUSTOMER_TRX_LINES M...
6.27620.103.69244.9271.702.56a1wk2hsdfm7pu e:ONT:wf:OEOL VOL1229 select /*+ FIRST_ROWS(1) */ ta...
5.63640.093.3110,391.2399.280.054y08a52989vfk e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 BEGIN WSH_PICK_LIST.RELEASE_BA...
4.73320.152.78111.2176.154.25a72z5jmc038tt e:AR:cp:ar/RAXTRX VOL1229 SELECT /*+ index (line RA_CUST...
3.80320.122.23208.7169.011.82gccbpwamzp78q e:AR:cp:ar/RAXTRX VOL1229 declare l_header_rounding_flag...
3.74100.372.2014.3776.7026.00axhwy13vcu03g e:AR:bes:oracle.apps.xla.accounting.extract VOL1229 SELECT ROWID , DENSE_RANK() OV...
3.57320.112.1061.0578.965.85gxyzmvghm41nt e:AR:wf:ARSBALSG VOL1229 DELETE FROM RA_INTERFACE_SALE...
3.22320.101.90129.1550.232.490snr5d5m3uxh7 e:AR:cp:ar/RAXTRX VOL1229 DELETE FROM RA_INTERFACE_SALE...
3.17299,9020.001.8759.0553.305.372mfx52cpfr0yp e:AR:cp:ar/RAXTRX VOL1229 SELECT LOCATION_SEGMENT_ID FRO...
2.9999,9870.001.761,389.3599.360.228gmgrb5mwa9f9 e:AR:cp:ar/RAXTRX VOL1229 SELECT TAX_REGIME_CODE, TAX, S...
2.97340.091.756,253.0366.110.050074pdmwb7fmv e:ONT:cp:wsh/WSHINTERFACE VOL1229 BEGIN WSH_SHIP_CONFIRM_ACTIONS...
2.53299,9700.001.4911,967.861.630.02b5mv0n1ss384u e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 INSERT INTO MTL_MATERIAL_TRAN...
2.35320.071.39114.8061.052.05gc3yz4rdhyqt5 e:AR:cp:ar/RAXTRX VOL1229 begin arp_process_payinfo . co...
2.241280.021.3253.5355.784.18aptgswyxvu4ws e:AR:cp:ar/RAXTRX VOL1229 SELECT COUNT ( * ) FROM RA_INT...


Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s) %CPU %IO SQL IdSQL ModulePDB NameSQL Text
1,289,300,1416420,145,314.7032.1410,391.2399.3.14y08a52989vfk e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 BEGIN WSH_PICK_LIST.RELEASE_BA...
751,868,2963223,495,884.2518.744,389.3687.8.66abn0zw8kkvtk e:AR:cp:ar/RAXTRX VOL1229 begin arp_etax_autoinv_util . ...
584,147,5203218,254,610.0014.564,083.4168.6.35t6wystf9zvbb e:ONT:cp:ont/OEHVIMP VOL1229 BEGIN OE_BULK_ORDER_IMPORT_PVT...
554,805,89499,9875,548.7813.831,389.3599.4.28gmgrb5mwa9f9 e:AR:cp:ar/RAXTRX VOL1229 SELECT TAX_REGIME_CODE, TAX, S...
392,256,9912,906,577134.959.78845.4899.307qh9zcbrq9ky7 e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT 'Y' FROM WSH_PR_WORKERS...
317,231,094349,330,326.297.916,253.0366.100074pdmwb7fmv e:ONT:cp:wsh/WSHINTERFACE VOL1229 BEGIN WSH_SHIP_CONFIRM_ACTIONS...
314,815,253329,837,976.667.8511,296.0452.18zfgv4ck11dw9 e:ONT:cp:fnd/FNDWFBG VOL1229 BEGIN WF_ENGINE.BACKGROUNDCONC...
129,439,124192674,162.103.231,074.7162.42.437f1qguwxw0sk e:AR:cp:ar/RAXTRX VOL1229 begin IF ( :v_msg_level:i_msg_...
125,709,227200628,546.143.1321,716.7016.5.10z318y6g3uagc e:ONT:cp:inv/INCTCW VOL1229 declare l_retstat varchar2 ( 3...
121,743,214199,894609.043.03266.1699.7.2521y9hsruj6y2 e:ONT:cp:ont/OEHVIMP VOL1229 SELECT I.TAX_CODE FROM ZX_OUTP...
121,138,930199,892606.023.02264.1899.906dp3t6txwjvam e:ONT:cp:ont/OEHVIMP VOL1229 SELECT SU.TAX_CODE FROM HZ_CUS...
100,225,815323,132,056.722.50707.1564.43.45dsv99085tx1k e:AR:cp:ar/RAXTRX VOL1229 SELECT /*+ leading(ct) index(c...
85,104,111128664,875.872.12316.8468.503s3xp6fupjh7d e:ONT:cp:ont/OEHVIMP VOL1229 UPDATE MRP_ATP_SCHEDULE_TEMP S...
70,901,891199,944354.611.77189.0898.200wfry4rz1ygfk e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT /*+index (WDD WSH_DELIV...
68,991,973417,247,993.251.72446.1677.21.75t39uchjqpyfm e:AR:cp:xla/XLAACCUP VOL1229 BEGIN xla_accounting_pkg.unit_...
68,614,363125,717,863.581.71492.5496.7.17ptvbaycjtbg4 e:AR:cp:ar/ARTERRPW VOL1229 BEGIN arp_run.revenue_recognit...
66,412,676299,859221.481.66380.1757.34.3drt9k4tpvph64 e:AR:cp:ar/RAXTRX VOL1229 SELECT AR_TAX.LOCATION_SEGMENT...
64,481,45799,993644.861.611,088.1799.404yak7x2zqz0dh e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 BEGIN inv_transfer_order_pvt.f...
60,590,1701,479,76240.951.511,717.7120.5.1cd9mbmqyf4qhp e:ONT:wf:OEOH VOL1229 UPDATE WF_ITEM_ACTIVITY_STATUS...
60,392,041319,847188.821.51143.6798.106mu4cfrayu648 e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT 'x' FROM WSH_PR_WORKERS...
53,300,513199,919266.611.33312.3175.7.3279sut03s49jd e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT X.ORGANIZATION_ID ORGAN...
49,759,37219,9952,488.591.24138.0999.50f07y7y34utqz1 e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT SEQUENCE_NUMBER FROM WS...
48,587,640100,024485.761.21218.5698.5.5bmvr0154yzvmv e:ONT:cp:ont/OEHVIMP VOL1229 SELECT MIN(CALENDAR_DATE), MAX...
46,318,342254,586181.941.15261.8545.905fky033hvxn3s e:ONT:cp:wsh/WSHINTERFACES VOL1229 SELECT 'X' FROM WSH_TRIP_STOPS...


Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModulePDB NameSQL Text
2,117,9353266,185.4723.424,389.3687.850.596abn0zw8kkvtk e:AR:cp:ar/RAXTRX VOL1229 begin arp_etax_autoinv_util . ...
1,952,31019210,168.2821.591,074.7162.402.3737f1qguwxw0sk e:AR:cp:ar/RAXTRX VOL1229 begin IF ( :v_msg_level:i_msg_...
1,890,4903259,077.8120.90707.1564.373.455dsv99085tx1k e:AR:cp:ar/RAXTRX VOL1229 SELECT /*+ leading(ct) index(c...
1,265,513299,8594.2213.99380.1757.284.25drt9k4tpvph64 e:AR:cp:ar/RAXTRX VOL1229 SELECT AR_TAX.LOCATION_SEGMENT...
815,7483225,492.139.022,387.669.990.32byaf6gyh7qg9v e:AR:cp:ar/RAXTRX VOL1229 declare ok_flag BOOLEAN ; BEGI...
777,4323224,294.758.6077.8868.759.718an3ja4qk82vm e:AR:cp:ar/RAXTRX VOL1229 SELECT /*+ index (tl RA_CUSTOM...
564,7773217,649.286.24204.8151.063.16bkwbfrp993czv e:AR:cp:ar/RAXTRX VOL1229 UPDATE RA_CUSTOMER_TRX_LINES M...
559,5893217,487.166.19129.1550.232.490snr5d5m3uxh7 e:AR:cp:ar/RAXTRX VOL1229 DELETE FROM RA_INTERFACE_SALE...
470,0883214,690.255.2011,296.0452.030.148zfgv4ck11dw9 e:ONT:cp:fnd/FNDWFBG VOL1229 BEGIN WF_ENGINE.BACKGROUNDCONC...
402,9423212,591.944.46111.2176.154.25a72z5jmc038tt e:AR:cp:ar/RAXTRX VOL1229 SELECT /*+ index (line RA_CUST...
354,6513211,082.843.924,083.4168.560.295t6wystf9zvbb e:ONT:cp:ont/OEHVIMP VOL1229 BEGIN OE_BULK_ORDER_IMPORT_PVT...
282,829328,838.413.13208.7169.011.82gccbpwamzp78q e:AR:cp:ar/RAXTRX VOL1229 declare l_header_rounding_flag...
219,0032001,095.022.4221,716.7016.460.100z318y6g3uagc e:ONT:cp:inv/INCTCW VOL1229 declare l_retstat varchar2 ( 3...
205,584623,315.872.27244.9271.702.56a1wk2hsdfm7pu e:ONT:wf:OEOL VOL1229 select /*+ FIRST_ROWS(1) */ ta...
181,813299,9020.612.0159.0553.305.372mfx52cpfr0yp e:AR:cp:ar/RAXTRX VOL1229 SELECT LOCATION_SEGMENT_ID FRO...
178,885642,795.081.9810,391.2399.280.054y08a52989vfk e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 BEGIN WSH_PICK_LIST.RELEASE_BA...
170,389325,324.661.8861.0578.965.85gxyzmvghm41nt e:AR:wf:ARSBALSG VOL1229 DELETE FROM RA_INTERFACE_SALE...
168,3091281,314.911.8653.5355.784.18aptgswyxvu4ws e:AR:cp:ar/RAXTRX VOL1229 SELECT COUNT ( * ) FROM RA_INT...
157,487324,921.471.74114.8061.052.05gc3yz4rdhyqt5 e:AR:cp:ar/RAXTRX VOL1229 begin arp_process_payinfo . co...
129,386432,346.501.43446.1677.181.705t39uchjqpyfm e:AR:cp:xla/XLAACCUP VOL1229 BEGIN xla_accounting_pkg.unit_...
128,377343,775.791.426,253.0366.110.050074pdmwb7fmv e:ONT:cp:wsh/WSHINTERFACE VOL1229 BEGIN WSH_SHIP_CONFIRM_ACTIONS...
124,19499,9871.241.371,389.3599.360.228gmgrb5mwa9f9 e:AR:cp:ar/RAXTRX VOL1229 SELECT TAX_REGIME_CODE, TAX, S...


Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModulePDB NameSQL Text
2,084,4742,084,4743265,139.810.0025.576abn0zw8kkvtk e:AR:cp:ar/RAXTRX VOL1229 begin arp_etax_autoinv_util . ...
1,951,6641,951,66419210,164.920.0023.9437f1qguwxw0sk e:AR:cp:ar/RAXTRX VOL1229 begin IF ( :v_msg_level:i_msg_...
1,890,4871,890,4873259,077.720.0023.195dsv99085tx1k e:AR:cp:ar/RAXTRX VOL1229 SELECT /*+ leading(ct) index(c...
1,265,6201,265,620299,8594.220.0015.53drt9k4tpvph64 e:AR:cp:ar/RAXTRX VOL1229 SELECT AR_TAX.LOCATION_SEGMENT...
564,776564,7763217,649.250.006.93bkwbfrp993czv e:AR:cp:ar/RAXTRX VOL1229 UPDATE RA_CUSTOMER_TRX_LINES M...
485,871485,8713215,183.470.005.968an3ja4qk82vm e:AR:cp:ar/RAXTRX VOL1229 SELECT /*+ index (tl RA_CUSTOM...
469,805469,8053214,681.410.005.768zfgv4ck11dw9 e:ONT:cp:fnd/FNDWFBG VOL1229 BEGIN WF_ENGINE.BACKGROUNDCONC...
372,663372,6633211,645.720.004.57a72z5jmc038tt e:AR:cp:ar/RAXTRX VOL1229 SELECT /*+ index (line RA_CUST...
351,779351,7793210,993.090.004.325t6wystf9zvbb e:ONT:cp:ont/OEHVIMP VOL1229 BEGIN OE_BULK_ORDER_IMPORT_PVT...
282,786282,786328,837.060.003.47gccbpwamzp78q e:AR:cp:ar/RAXTRX VOL1229 declare l_header_rounding_flag...
274,816274,816328,588.000.003.37byaf6gyh7qg9v e:AR:cp:ar/RAXTRX VOL1229 declare ok_flag BOOLEAN ; BEGI...
218,886218,8862001,094.430.002.690z318y6g3uagc e:ONT:cp:inv/INCTCW VOL1229 declare l_retstat varchar2 ( 3...
205,607205,607623,316.240.002.52a1wk2hsdfm7pu e:ONT:wf:OEOL VOL1229 select /*+ FIRST_ROWS(1) */ ta...
181,776181,776299,9020.610.002.232mfx52cpfr0yp e:AR:cp:ar/RAXTRX VOL1229 SELECT LOCATION_SEGMENT_ID FRO...
166,203166,203325,193.840.002.040snr5d5m3uxh7 e:AR:cp:ar/RAXTRX VOL1229 DELETE FROM RA_INTERFACE_SALE...
157,437157,437324,919.910.001.93gc3yz4rdhyqt5 e:AR:cp:ar/RAXTRX VOL1229 begin arp_process_payinfo . co...
142,656142,656642,229.000.001.754y08a52989vfk e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 BEGIN WSH_PICK_LIST.RELEASE_BA...
128,353128,353343,775.090.001.570074pdmwb7fmv e:ONT:cp:wsh/WSHINTERFACE VOL1229 BEGIN WSH_SHIP_CONFIRM_ACTIONS...
98,48398,483128769.400.001.21aptgswyxvu4ws e:AR:cp:ar/RAXTRX VOL1229 SELECT COUNT ( * ) FROM RA_INT...
89,29589,29530,0002.980.001.1040tb15g61shu2 e:ONT:cp:ont/OEHVIMP VOL1229 INSERT INTO WF_ITEM_ATTRIBUTE_...


Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModulePDB NameSQL Text
7,476,24100.00436.4283.503c32a4bk574vp   VOL1229 select d.sumobj# from sys.sumd...
2,906,57799,8890.03845.4899.307qh9zcbrq9ky7 e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT 'Y' FROM WSH_PR_WORKERS...
2,391,88900.00105.22100.107t8v1mvj7vk71 e:AR:cp:ar/RAXTRX VOL1229 SELECT 'N' DUMMY_FLAG, REG.REG...
1,479,7621,479,7581.001,717.7120.5.1cd9mbmqyf4qhp e:ONT:wf:OEOH VOL1229 UPDATE WF_ITEM_ACTIVITY_STATUS...
1,001,62900.0048.1091.30bt475t962hbbr   VOL1229 select 1 from sys.sum$, sys.su...
999,670999,3041.00469.54580f4p5c1tvqfnfr e:ONT:cp:wsh/WSHINTERFACES VOL1229 SELECT ACCOUNTING_RULE_ID , AC...
989,706989,7021.00485.8434.5.1gnhmcahkmrnzs e:ONT:wf:OEOH VOL1229 INSERT INTO WF_ITEM_ACTIVITY_S...
898,713898,5611.0059.44100.506vubppkb5tps5 e:AR:cp:ar/ARTERRPW VOL1229 SELECT HEADER.PREVIOUS_CUSTOME...
839,065359,3020.4331.4999.5066tmsr3446uqn e:ONT:wf:OEOH VOL1229 SELECT WIAS.ACTIVITY_STATUS, W...
619,390618,8761.0022.4599.900423ayw04f496 e:AR:bes:oracle.apps.xla.accounting.extract VOL1229 SELECT FND_PROFILE.VALUE('XLA_...


Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModulePDB NameSQL Text
7,477,4117,476,24143.833c32a4bk574vp   VOL1229 select d.sumobj# from sys.sumd...
1,000,0131,001,6295.86bt475t962hbbr   VOL1229 select 1 from sys.sum$, sys.su...
507,727509,1142.980758ng3cbw07m e:ONT:cp:wsh/WSHINTERFACES VOL1229 SELECT STOP_ID FROM WSH_TRIP_S...
299,708299,9751.760mdnts20d60yr e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 declare v_ret number := 0; be...
299,037299,8701.750bj4c9wdx63t2 e:ONT:cp:ont/OEHVIMP VOL1229 SELECT HSECS FROM V$TIMER
264,542264,6201.5549suaruf5dtth   VOL1229 select distinct s.sowner, s.vn...
244,467244,5751.430x2a5zafnpz2y   VOL1229 select distinct s.sowner, s.vn...
200,209400,9671.171gpdqku7dc104 e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT MTL_MATERIAL_TRANSACTIO...
199,961200,1471.171v818hwxjxy58 e:ONT:wf:OECOGS VOL1229 select FND_FLEX_VALUES_VL.FLEX...
199,948199,9681.17c7f2ankv7htm4 e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT PRIMARY_RESERVATION_QUA...
199,917299,9511.175087kdcmjuqjs e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT ITEM_TYPE_CODE, ATO_LIN...
199,821299,9161.17d9ybtwvn89wct e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT HEADER_ID FROM OE_ORDER...
199,743199,9641.171c0b7sas42w2z e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT NVL(ITEM_COST, 0), COS...
199,722397,7331.170puu35brrk8z4 e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT * FROM MTL_SYSTEM_ITEMS...
199,591199,9471.179173mvrnzb898 e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT DEFAULT_COST_GROUP_ID, ...
199,411199,9621.170cnpxtkxfcv9j e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT DEFAULT_COST_GROUP_ID F...
199,324199,8801.171h2p0m6c0h40f e:ONT:cp:ont/OEHVIMP VOL1229 SELECT TYPE FROM RA_RULES WHER...
199,312199,9821.17b5ycnkqg2b0wk e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 SELECT MTL_DEMAND_S.NEXTVAL FR...
199,107199,9461.17gb694cbt9qks7 e:ONT:cp:wsh/WSHPSGL_SUB VOL1229 DELETE FROM WMS_TRANSACTIONS_T...
198,038599,1951.162amkqgr5gg7zs e:AR:cp:ar/RAXTRX VOL1229 SELECT 'Y' FROM ZX_JURISDICTIO...


Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModulePDB NameSQL Text
1,503,5484270.055f9spvysgkr1c SQL*Plus VOL1229 INSERT INTO FND_CONCURRENT_REQ...
1,320,251100.04bc9gpshz90yw0 e:AR:cp:xla/XLAACCUP VOL1229 INSERT INTO AR_XLA_LINES_EXTRA...
1,116,44440.0458aj2xxbjf844 e:AR:cp:xla/XLAACCUP VOL1229 SELECT STATUS FROM ALL_OBJECTS...


Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModulePDB NameSQL Text
39243xsxzzr557p9y e::cp:30 VOL1229 select S.QUEUE_APPLICATION_ID ...
392482y1b79wj51rx e::cp:30 VOL1229 SELECT P.CONCURRENT_PROCESS_ID...


Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0074pdmwb7fmvBEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
0423ayw04f496SELECT FND_PROFILE.VALUE('XLA_MERGE_MATCHING_LINES') FROM DUAL
0758ng3cbw07mSELECT STOP_ID FROM WSH_TRIP_STOPS WHERE BATCH_ID = :B1 FOR UPDATE NOWAIT
0bj4c9wdx63t2SELECT HSECS FROM V$TIMER
0cnpxtkxfcv9jSELECT DEFAULT_COST_GROUP_ID FROM MTL_SECONDARY_INVENTORIES WHERE SECONDARY_INVENTORY_NAME = :B2 AND ORGANIZATION_ID = :B1 AND DEFAULT_COST_GROUP_ID IS NOT NULL
0mdnts20d60yr declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7, :8)) then v_ret := 1; end if; :9 := v_ret; end;
0puu35brrk8z4SELECT * FROM MTL_SYSTEM_ITEMS WHERE ORGANIZATION_ID = :B2 AND INVENTORY_ITEM_ID = :B1
0snr5d5m3uxh7 DELETE FROM RA_INTERFACE_SALESCREDITS S WHERE EXISTS (SELECT 'X' FROM RA_INTERFACE_LINES_ALL L WHERE L.INTERFACE_LINE_CONTEXT ='Contra' AND L.INTERFACE_STATUS = 'P' AND S.INTERFACE_LINE_CONTEXT = L.INTERFACE_LINE_CONTEXT AND S.INTERFACE_LINE_ATTRIBUTE1= L.INTERFACE_LINE_ATTRIBUTE1 AND S.INTERFACE_LINE_ATTRIBUTE2= L.INTERFACE_LINE_ATTRIBUTE2 AND S.INTERFACE_LINE_ATTRIBUTE3= L.INTERFACE_LINE_ATTRIBUTE3)
0wabkkyua3y3vSELECT ITEM_KEY FROM WF_ITEMS WHERE ITEM_TYPE = :B2 AND ITEM_KEY = :B1 FOR UPDATE
0wfry4rz1ygfkSELECT /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ OH.ORDER_TYPE_ID FROM OE_ORDER_HEADERS_ALL OH, WSH_DELIVERY_DETAILS WDD WHERE OH.HEADER_ID = WDD.SOURCE_HEADER_ID AND WDD.RELEASED_STATUS = 'S' AND WDD.SOURCE_CODE = 'OE' AND WDD.MOVE_ORDER_LINE_ID = :B1
0x2a5zafnpz2yselect distinct s.sowner, s.vname from sys.snap$ s, sys.snap_reftime$ r where r.masobj# in (68511, 68722) and s.sowner = r.sowner and s.vname = r.vname and bitand(s.flag3, 67108864) = 67108864
0z318y6g3uagcdeclare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
1c0b7sas42w2z SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1gpdqku7dc104SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL FROM DUAL
1h2p0m6c0h40fSELECT TYPE FROM RA_RULES WHERE RULE_ID = :B1
1v818hwxjxy58select FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.DESCRIPTION, FND_FLEX_VALUES_VL.ENABLED_FLAG, to_char(FND_FLEX_VALUES_VL.START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(FND_FLEX_VALUES_VL.END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), FND_FLEX_VALUES_VL.SUMMARY_FLAG, FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES from FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL where (( FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :FND_BIND1) AND ( ((1=1) AND /* GL_COA_BS_TAG */ (GL_AFF_AWC_API_PKG.gl_valid_flex_values(:FND_BIND2, FND_FLEX_VALUES_VL.Flex_Value) = 'Y') ) )) and FND_FLEX_VALUES_VL.FLEX_VALUE = :FND_BIND3
1wnq9qthbb54qBEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5); END;
279sut03s49jdSELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , NULL LOT_NUMBER , NULL LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID , NULL IS_RESERVABLE_LOT FROM ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , DECODE(:B10 , 2, NULL, X.REVISION) REVISION , NULL LOT_NUMBER , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT MR.ORGANIZATION_ID ORGANIZATION_ID , MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MR.REVISION REVISION , MR.LOT_NUMBER LOT_NUMBER , MR.SUBINVENTORY_CODE SUBINVENTORY_CODE , MR.LOCATOR_ID LOCATOR_ID , MR.PRIMARY_RESERVATION_QUANTITY - NVL(MR.DETAILED_QUANTITY, 0) PRIMARY_QUANTITY , MR.SECONDARY_RESERVATION_QUANTITY - NVL(MR.SECONDARY_DETAILED_QUANTITY, 0) SECONDARY_QUANTITY , 3 QUANTITY_TYPE , TO_NUMBER(NULL) COST_GROUP_ID , LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_RESERVATIONS MR WHERE NVL(MR.SUPPLY_SOURCE_TYPE_ID, 13) = 13 AND MR.PRIMARY_RESERVATION_QUANTITY > NVL(MR.DETAILED_QUANTITY, 0) AND ((:B7 <>1) OR (:B7 = 1 AND MR.LPN_ID IS NULL)) AND (:B6 <> 3 OR (:B6 = 3 AND NOT ( :B5 = MR.DEMAND_SOURCE_TYPE_ID AND :B4 = MR.DEMAND_SOURCE_HEADER_ID AND NVL(:B3 , -9999) = NVL(MR.DEMAND_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') = NVL(MR.DEMAND_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) = NVL(MR.DEMAND_SOURCE_DELIVERY, -9999) ) ) ) UNION ALL SELECT MOQ.ORGANIZATION_ID ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MOQ.REVISION REVISION , MOQ.LOT_NUMBER LOT_NUMBER , MOQ.SUBINVENTORY_CODE SUBINVENTORY_CODE , MOQ.LOCATOR_ID LOCATOR_ID , MOQ.PRIMARY_TRANSACTION_QUANTITY , MOQ.SECONDARY_TRANSACTION_QUANTITY , 1 QUANTITY_TYPE , MOQ.COST_GROUP_ID COST_GROUP_ID , MOQ.LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ UNION ALL SELECT MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_ID LOCATOR_ID , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS) , 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) * ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS) , 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.SECONDARY_TRANSACTION_QUANTITY))) * ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 5), 1) QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID , DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID), NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID))) LPN_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , DECODE (MP.PROCESS_ENABLED_FLAG, 'Y', DECODE ((SELECT MOVE_ORDER_TYPE FROM MTL_TXN_REQUEST_HEADERS MTRH WHERE HEADER_ID = MMTT.MOVE_ORDER_HEADER_ID AND ROWNUM = 1), 5, 28, MMTT.TRANSACTION_ACTION_ID), MMTT.TRANSACTION_ACTION_ID), TO_NUMBER(NULL)) TRANSACTION_ACTION_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_SUBINVENTORY, TO_CHAR(NULL)) TRANSFER_SUBINVENTORY_CODE , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_TO_LOCATION, TO_NUMBER(NULL)) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT, MTL_PARAMETERS MP WHERE MMTT.POSTING_FLAG = 'Y' AND MMTT.SUBINVENTORY_CODE IS NOT NULL AND (NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 OR NVL(MMTT.TRANSACTION_STATUS, 0) = 2 AND MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34)) AND MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) AND MMTT.ORGANIZATION_ID = MP.ORGANIZATION_ID UNION ALL SELECT DECODE(MMTT.TRANSACTION_ACTION_ID, 3, MMTT.TRANSFER_ORGANIZATION, MMTT.ORGANIZATION_ID) ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE , MMTT.TRANSFER_TO_LOCATION LOCATOR_ID , ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , DECODE(NVL(MMTT.TRANSACTION_STATUS, 0), 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 6, 1 ), 1) QUANTITY_TYPE , MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.CONTENT_LPN_ID, MMTT.TRANSFER_LPN_ID) LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND DECODE( NVL(MMTT.TRANSACTION_STATUS, 0), 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 2), 1 ) <> 2 AND (MMTT.TRANSACTION_ACTION_ID IN (2, 3) OR (MMTT.TRANSACTION_ACTION_ID = 28 AND :B4 = MMTT.TRANSACTION_SOURCE_ID AND NVL(:B3 , -9999) = NVL(MMTT.TRX_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') = NVL(MMTT.TRANSACTION_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) = NVL(MMTT.TRX_SOURCE_DELIVERY_ID, -9999) ) ) AND MMTT.WIP_SUPPLY_TYPE IS NULL ) X WHERE X.ORGANIZATION_ID = :B9 AND X.INVENTORY_ITEM_ID = :B8 GROUP BY X.ORGANIZATION_ID, X.INVENTORY_ITEM_ID, X.REVISION , X.LOT_NUMBER, X.SUBINVENTORY_CODE, X.LOCATOR_ID , X.QUANTITY_TYPE, X.COST_GROUP_ID, X.LPN_ID , X.TRANSACTION_ACTION_ID, X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID ) X , MTL_SECONDARY_INVENTORIES SUB WHERE X.ORGANIZATION_ID = SUB.ORGANIZATION_ID (+) AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME (+) AND (:B12 = 2 OR NVL(SUB.ASSET_INVENTORY, 1) = 1) AND ( (:B11 = 1 AND NVL(SUB.INVENTORY_ATP_CODE, 1) = 1) OR (:B11 = 2 AND NVL(SUB.AVAILABILITY_TYPE, 1) = 1 ) OR :B11 =3 OR (:B11 = 4 AND (NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 AND NVL(SUB.AVAILABILITY_TYPE, 1)=1)) ) GROUP BY X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , NULL , NULL , SUB.RESERVABLE_TYPE , X.SUBINVENTORY_CODE , NULL , X.LOCATOR_ID , X.QUANTITY_TYPE , X.COST_GROUP_ID , X.LPN_ID , X.TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID
2amkqgr5gg7zsSELECT 'Y' FROM ZX_JURISDICTIONS_GT WHERE TAX_REGIME_CODE = :B2 AND TAX = :B1 AND ROWNUM = 1
2mfx52cpfr0ypSELECT LOCATION_SEGMENT_ID FROM RA_CUSTOMER_TRX_LINES_ALL INV, ZX_LINES CM, ZX_LINES ZXINV WHERE CM.TAX_LINE_ID = :B1 AND CM.ADJUSTED_DOC_TRX_ID = INV.CUSTOMER_TRX_ID AND CM.ADJUSTED_DOC_TAX_LINE_ID = INV.TAX_LINE_ID AND INV.LINE_TYPE = 'TAX' AND CM.ADJUSTED_DOC_TAX_LINE_ID = ZXINV.TAX_LINE_ID AND CM.TAX_PROVIDER_ID IS NOT NULL AND ZXINV.RECORD_TYPE_CODE = 'MIGRATED'
37f1qguwxw0skbegin IF ( :v_msg_level:i_msg_level > 0 ) THEN arp_util . enable_debug ( 1000000 ) ; arp_global . msg_level := :v_msg_level:i_msg_level ; END IF ; arp_auto_accounting . g_error_buffer := NULL ; :v_num_failed_dist_rows:i_num_failed_dist_rows := 0 ; :v_coa_id:i_coa_id := arp_standard . gl_chart_of_accounts_id ; :v_retval:i_retval := 1 ; arp_auto_accounting . do_autoaccounting ( :v_mode:i_vmode , :v_account_class , :v_trx_id:i_trx_id , :v_line_id:i_line_id , :v_line_salesrep_id:i_line_salesrep_id , :v_request_id:i_request_id , :v_gl_date , :v_orig_gl_date , :v_total_trx_amount:i_total_trx_amount , :v_passed_ccid:i_passed_ccid , :v_force_acct_set_no , :v_cust_trx_type_id:i_cust_trx_type_id , :v_primary_salesrep_id:i_primary_salesrep_id , :v_inv_item_id:i_inv_item_id , :v_memo_line_id:i_memo_line_id , :v_ccid:i_ccid , :v_concat_segments:i_concat_segments , :v_num_failed_dist_rows:i_num_failed_dist_rows ) ; IF ( :v_mode:i_vmode = 'G' AND :v_ccid:i_ccid = -1 ) THEN :v_retval:i_retval := 0 ; END IF ; EXCEPTION WHEN arp_auto_accounting . no_ccid THEN :v_retval:i_retval := 0 ; WHEN NO_DATA_FOUND THEN NULL ; WHEN OTHERS THEN arp_util . debug ( 'arcdaa()' ) ; arp_util . debug ( SQLERRM ) ; :v_errorbuf:i_errorbuf := arp_auto_accounting . g_error_buffer ; :v_sqlcode:i_sqlcode := SQLCODE ; END ;
3b3psftuyks81BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3c32a4bk574vpselect d.sumobj# from sys.sumdetail$ d, sys.sum$ s where d.sumobj# = s.obj# and bitand(d.flags, 2) = 2 and bitand(s.xpflags, 34359738368) = 34359738368 and d.detailobj# = :1
3hc5p1pfvaq7mBEGIN INV_LOGICAL_TRANSACTIONS_PUB.create_logical_trx_wrapper(:1, :2, :3, :4, :5, :6, :7); END;
3s3xp6fupjh7dUPDATE MRP_ATP_SCHEDULE_TEMP SET SCENARIO_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B45 , -1), SCENARIO_ID), INVENTORY_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B44 , INVENTORY_ITEM_ID), INVENTORY_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B43 , INVENTORY_ITEM_NAME), SOURCE_ORGANIZATION_ID =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B41 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B42 , NULL)), SOURCE_ORGANIZATION_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B39 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B40 , NULL)), ORDER_HEADER_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B38 , -1), NULL), DEMAND_SOURCE_TYPE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B37 , NULL), DELIVERY_LEAD_TIME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B35 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B36 , NULL)), SHIP_METHOD = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B33 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B34 , NULL)), DEMAND_CLASS = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B32 , NULL), SCHEDULED_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B30 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B31 , NULL)), AVAILABLE_QUANTITY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B29 , NULL), REQUESTED_DATE_QUANTITY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B28 , NULL), GROUP_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B26 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B27 , NULL)), GROUP_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B24 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B25 , NULL)), ERROR_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B22 , DECODE(ERROR_CODE, NULL, DECODE(:B23 , 150, 0, 61, 0, 0, 0, :B52 ))), ERROR_MESSAGE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B21 , NULL), STATUS_FLAG = 2, END_PEGGING_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B19 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B20 , NULL)), SCHEDULED_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B17 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B18 , NULL)), ORGANIZATION_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B16 , NULL), REQUEST_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B15 , NULL), REQUEST_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B14 , NULL), REQ_ITEM_REQ_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B13 , NULL), REQ_ITEM_AVAILABLE_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B12 , NULL), REQ_ITEM_AVAILABLE_DATE =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B11 , NULL), SALES_REP = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B10 , NULL), CUSTOMER_CONTACT = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B9 , NULL), COMPILE_DESIGNATOR = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), DECODE(:B51 , 4, :B8 , NULL), NULL), SUBST_FLAG = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B7 , NULL), MATCH_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B6 , NULL), MATCHED_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B5 , NULL), ATTRIBUTE_21 = NVL( :B4 , NULL ), PLAN_ID = :B3 , FIRST_VALID_SHIP_ARRIVAL_DATE = :B2 , ATP_LEAD_TIME = DECODE(ATO_MODEL_LINE_ID, NULL, NULL, ORDER_LINE_ID, 0, :B1 ) WHERE SESSION_ID = :B50 AND STATUS_FLAG = 99 AND NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID) = :B49 AND NVL(:B48 , 2) = 2 AND NVL(SOURCE_ORGANIZATION_ID, NVL(:B46 , -1)) = NVL(:B47 , -1)
3xsxzzr557p9yselect S.QUEUE_APPLICATION_ID , S.CONCURRENT_QUEUE_ID , DECODE(Q.TARGET_NODE, null , S.MIN_PROCESSES, NVL(Q.NODE_NAME, Q.TARGET_NODE), S.MIN_PROCESSES, NVL(S.FAILOVER_MIN, S.MIN_PROCESSES)) , DECODE(Q.TARGET_NODE, null , NVL(S.MAX_PROCESSES, S.MIN_PROCESSES), NVL(Q.NODE_NAME, Q.TARGET_NODE), NVL(S.MAX_PROCESSES, S.MIN_PROCESSES), NVL(NVL(S.FAILOVER_MAX, S.FAILOVER_MIN), NVL(S.MAX_PROCESSES, S.MIN_PROCESSES))) , Q.MAX_PROCESSES , NVL(S.MAX_PROCESSES, (-1)) , NVL(Q.TARGET_PROCESSES, (-1)) , NVL(Q.MIN_PROCESSES, (-1)) , NVL(Q.SLEEP_SECONDS, (-1)) , Q.CONTROL_CODE , ((DECODE(SPECIFIC_DATE, null , DECODE(FROM_WEEK_DAY, null , 6, 4), 2)-DECODE(START_TIME, null , 0, 1))+DECODE(P.APPLICATION_ID, 0, DECODE(P.CONCURRENT_TIME_PERIOD_ID, 0, 3, 0), 0)) , NVL(S.SLEEP_SECONDS, 0) , Q.Manager_type , P.APPLICATION_ID , P.CONCURRENT_TIME_PERIOD_ID , NVL(Q.CONCURRENT_TIME_PERIOD_ID, (-1)) , NVL(Q.PERIOD_APPLICATION_ID, (-1)) , S.SERVICE_PARAMETERS , Target_Node from FND_CONCURRENT_QUEUE_SIZE S , FND_CONCURRENT_TIME_PERIODS P , FND_CONCURRENT_QUEUES Q where ((((((P.APPLICATION_ID=S.PERIOD_APPLICATION_ID and Q.APPLICATION_ID=S.QUEUE_APPLICATION_ID) and Q.CONCURRENT_QUEUE_ID=S.CONCURRENT_QUEUE_ID) and P.CONCURRENT_TIME_PERIOD_ID=S.CONCURRENT_TIME_PERIOD_ID) and ((((SPECIFIC_DATE is not null and TRUNC(SYSDATE)=SPECIFIC_DATE) or (FROM_WEEK_DAY is not null and SYSDATE<=NEXT_DAY(((NEXT_DAY(SYSDATE, (mod(((FROM_WEEK_DAY+6)-:b0), 7)+1))-7)-1), (mod(((TO_WEEK_DAY+6)-:b0), 7)+1)))) and (START_TIME is null or TO_NUMBER(TO_CHAR(SYSDATE, 'HH24MI')) between START_TIME and END_TIME)) or (SPECIFIC_DATE is null and FROM_WEEK_DAY is null ))) and (Q.CONTROL_CODE is null or Q.CONTROL_CODE not in ('H'))) and Q.ENABLED_FLAG='Y') union select Application_ID , Concurrent_Queue_ID , 0 , 0 , 0 , 0 , NVL(TARGET_PROCESSES, (-1)) , NVL(MIN_PROCESSES, (-1)) , NVL(Sleep_Seconds, 0) , Control_Code , 10 , NVL(Sleep_Seconds, 0) , Manager_type , (-1) , (-1) , NVL(Concurrent_Time_Period_ID, 0) , NVL(Period_Application_ID, 0) , '' , Target_Node from Fnd_Concurrent_Queues where ((Manager_Type<>6 and (Control_Code is null or Control_Code not in ('H'))) and Enabled_Flag='Y') order by 1, 2, 11, 4 desc
40tb15g61shu2INSERT INTO WF_ITEM_ATTRIBUTE_VALUES ( ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE ) VALUES ( :B4 , :B1 , :B3 , :B2 )
49suaruf5dtthselect distinct s.sowner, s.vname from sys.snap$ s, sys.snap_reftime$ r where r.masobj# in (68722) and s.sowner = r.sowner and s.vname = r.vname and bitand(s.flag3, 67108864) = 67108864
4u81ft6vn8k4jSELECT ACCT_PERIOD_ID FROM ORG_ACCT_PERIODS WHERE PERIOD_CLOSE_DATE IS NULL AND ORGANIZATION_ID = :B1 AND TRUNC(SCHEDULE_CLOSE_DATE) >= INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(NVL(:B2 , SYSDATE), :B1 ) AND TRUNC(PERIOD_START_DATE) <= INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(NVL(:B2 , SYSDATE), :B1 )
4y08a52989vfkBEGIN WSH_PICK_LIST.RELEASE_BATCH_SUB(:errbuf, :rc, :A0, :A1, :A2, :A3); END;
4yak7x2zqz0dhBEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5087kdcmjuqjsSELECT ITEM_TYPE_CODE, ATO_LINE_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
521y9hsruj6y2SELECT I.TAX_CODE FROM ZX_OUTPUT_CLASSIFICATIONS_V L, MTL_SYSTEM_ITEMS I WHERE I.INVENTORY_ITEM_ID = :B4 AND I.ORGANIZATION_ID = :B3 AND L.LOOKUP_CODE = I.TAX_CODE AND L.ORG_ID IN (:B2 , -99) AND L.ENABLED_FLAG = 'Y' AND (L.START_DATE_ACTIVE <= :B1 OR L.START_DATE_ACTIVE IS NULL) AND (L.END_DATE_ACTIVE >= :B1 OR L.END_DATE_ACTIVE IS NULL) AND ROWNUM = 1 ORDER BY L.ORG_ID DESC
53j6qu1wu4673INSERT INTO MRP_RELIEF_INTERFACE (TRANSACTION_ID , INVENTORY_ITEM_ID , ORGANIZATION_ID , RELIEF_TYPE , DISPOSITION_TYPE , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , NEW_ORDER_QUANTITY , NEW_ORDER_DATE , OLD_ORDER_QUANTITY , OLD_ORDER_DATE , DISPOSITION_ID , DEMAND_CLASS , PROCESS_STATUS , LINE_NUM ) VALUES (MRP_RELIEF_INTERFACE_S.NEXTVAL , :B13 , :B12 , :B11 , :B10 , SYSDATE , :B9 , SYSDATE , :B9 , -1 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
58aj2xxbjf844SELECT STATUS FROM ALL_OBJECTS WHERE OBJECT_NAME = :B1 AND OWNER = USER ORDER BY STATUS ASC
5dsv99085tx1kSELECT /*+ leading(ct) index(ct, RA_CUSTOMER_TRX_N15) index(ctl, RA_CUSTOMER_TRX_LINES_N4) use_hash(ctl) */ ct.customer_trx_id, /* customer_trx_id */ ctl.customer_trx_line_id, /* customer_trx_line_id */ to_number(''), /* cust_trx_line_salesrep_id */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, nvl(ctl.revenue_amount, ctl.extended_amount), to_number('')), /* line_amount */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, decode(to_number(''), NULL, round((nvl(ctl.revenue_amount, ctl.extended_amount) * nvl(ct.exchange_rate, 1)), 2), round((nvl(ctl.revenue_amount, ctl.extended_amount) * nvl(ct.exchange_rate, 1)) / to_number('')) * to_number('') ), to_number('')), /* accounted_line_amount */ round( 100, 4), /* percent */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, nvl(ctl.revenue_amount, ctl.extended_amount), to_number('') ), /* amount */ decode( DECODE(1, 1, NULL) , NULL, decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, decode( to_number(''), NULL, round ((nvl(ctl.revenue_amount, ctl.extended_amount) * nvl(ct.exchange_rate, 1)), 2), round((nvl(ctl.revenue_amount, ctl.extended_amount) * nvl(ct.exchange_rate, 1)) / to_number('') ) * to_number('') ), to_number('')), DECODE(1, 1, NULL)), /* acctd_amt */ 'TAX', /* account class */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, 'N', 'Y' ), /* account_set_flag */ ct.cust_trx_type_id, /* cust_trx_type_id */ decode(ct.invoicing_rule_id, -3, 'Y', 'N'), /* allow_not_open_flag */ to_char(''), /* concatenated segments */ :code_combination_id , /* code_combination_id */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, to_char(rgd.gl_date, 'J'), '' ), /* gl_date */ decode( :original_gl_date, NULL, decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, to_char(rgd.original_gl_date, 'J'), '' ), decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, to_char(nvl(rgd.original_gl_date, :original_gl_date), 'J'), '' ) ), /* orig_gl_date */ nvl(ctl.default_ussgl_transaction_code, ct.default_ussgl_transaction_code), /* ussgl_trx_code */ nvl(ctl.default_ussgl_trx_code_context, ct.default_ussgl_trx_code_context), /* ussgl_trx_code_cntxt*/ ct.primary_salesrep_id, /* salesrep_id */ ctl_line.inventory_item_id, /* inventory_item_id */ ctl_line.memo_line_id, /* memo_line_id */ arp_etax_util.get_tax_account(ctl.customer_trx_line_id, rgd.gl_date, 'TAX'), arp_etax_util.get_tax_account(ctl.customer_trx_line_id, rgd.gl_date, 'INTERIM'), ct.bill_to_site_use_id, /* Billing site id */ ctl_line.warehouse_id /* Warehouse id */ , ctl.link_to_cust_trx_line_id /* 1651593 - tax errors */, ct.rev_rec_application /* Bug 16240687 changes for EBS-VRM Integration */, -999 FROM ra_customer_trx_lines ctl_line, fnd_currencies fc_foreign, ra_cust_trx_line_gl_dist rgd, ra_customer_trx_lines ctl, ra_customer_trx ct WHERE ct.customer_trx_id = ctl.customer_trx_id(+) AND ct.invoice_currency_code = fc_foreign.currency_code /* prevent duplicate records from being created */ AND not exists (SELECT /*+ INDEX (lgd RA_CUST_TRX_LINE_GL_DIST_N10)*/ 'distribution exists' FROM ra_cust_trx_line_gl_dist lgd WHERE ctl.customer_trx_id = lgd.customer_trx_id AND ctl.customer_trx_line_id = lgd.customer_trx_line_id and lgd.request_id = :request_id1 and 'TAX' = lgd.account_class and decode(ct.invoicing_rule_id, NULL, 'N', 'Y' ) = lgd.account_set_flag ) AND ct.customer_trx_id = rgd.customer_trx_id(+) AND 'REC' = rgd.account_class(+) AND 'N' = rgd.account_set_flag(+) AND ctl.line_type = 'TAX' AND ctl.link_to_cust_trx_line_id = ctl_line.customer_trx_line_id(+) and nvl(ct.invoicing_rule_id, -10) = nvl(ct.invoicing_rule_id, -10) AND ct.request_id = :request_id AND ctl.request_id (+) = :request_id AND ct.request_id is not null ORDER BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12
5f9spvysgkr1cINSERT INTO FND_CONCURRENT_REQUESTS ( REQUEST_ID, SECURITY_GROUP_ID, PHASE_CODE, STATUS_CODE, PRIORITY, PARENT_REQUEST_ID, PRIORITY_REQUEST_ID, DESCRIPTION, REQ_INFORMATION, IS_SUB_REQUEST, HAS_SUB_REQUEST, UPDATE_PROTECTED, HOLD_FLAG, ENFORCE_SERIALITY_FLAG, SINGLE_THREAD_FLAG, ARGUMENT_INPUT_METHOD_CODE, IMPLICIT_CODE, REQUEST_DATE, REQUESTED_START_DATE, REQUESTED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ORACLE_ID, CONC_LOGIN_ID, RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID, NLS_LANGUAGE, NLS_TERRITORY, NLS_NUMERIC_CHARACTERS, NLS_SORT, PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID, QUEUE_METHOD_CODE, REQUEST_CLASS_APPLICATION_ID, CONCURRENT_REQUEST_CLASS_ID, PRINT_GROUP, PRINTER, PRINT_STYLE, NUMBER_OF_COPIES, SAVE_OUTPUT_FLAG, CRM_THRSHLD, RESUBMIT_TIME, RESUBMIT_INTERVAL, RESUBMIT_INTERVAL_UNIT_CODE, RESUBMIT_INTERVAL_TYPE_CODE, RESUBMIT_END_DATE, RESUBMITTED, CRITICAL, REQUEST_TYPE, RELEASE_CLASS_APP_ID, RELEASE_CLASS_ID, STALE_DATE, CANCEL_OR_HOLD, OUTPUT_FILE_TYPE, NLS_COMPLIANT, CD_ID, REQUEST_LIMIT, INCREMENT_DATES, ENABLE_TRACE, OPS_INSTANCE, ORG_ID, NODE_NAME1, CONNSTR1, RECALC_PARAMETERS, EDITION_NAME, ARGUMENT_TEXT, NUMBER_OF_ARGUMENTS, ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4, ARGUMENT5, ARGUMENT6, ARGUMENT7, ARGUMENT8, ARGUMENT9, ARGUMENT10, ARGUMENT11, ARGUMENT12, ARGUMENT13, ARGUMENT14, ARGUMENT15, ARGUMENT16, ARGUMENT17, ARGUMENT18, ARGUMENT19, ARGUMENT20, ARGUMENT21, ARGUMENT22, ARGUMENT23, ARGUMENT24, ARGUMENT25) SELECT :B79 , :B78 , :B77 , DECODE (:B76 , 'A', 'A', 'Z', 'Z', DECODE(FCP.QUEUE_METHOD_CODE, 'B', 'Q', DECODE (:B57 , 'Y', 'Q', DECODE(:B38 , 'Y', 'Q', 'I')))), DECODE (FCP.QUEUE_CONTROL_FLAG, 'Y', NVL(FCP.REQUEST_PRIORITY, 0), DECODE (:B75 , NULL, 50, :B75 )), DECODE (:B67 , 0, NULL, :B67 ), :B74 , :B73 , NULL, :B72 , 'N', :B71 , :B70 , 'Y', :B57 , 'S', :B69 , SYSDATE, DECODE (:B68 , '', (SYSDATE - :B66 ), GREATEST (:B68 , DECODE (:B67 , 0, (SYSDATE - :B66 ), FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001')))), :B65 , SYSDATE, :B65 , :B64 , ORACLE_ID, :B64 , :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , FA.APPLICATION_ID, FCP.CONCURRENT_PROGRAM_ID, DECODE(:B38 , 'Y', 'B', DECODE(:B57 , 'N', FCP.QUEUE_METHOD_CODE, 'B')), FCP.CLASS_APPLICATION_ID, FCP.CONCURRENT_CLASS_ID, :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , DECODE (:B50 , '', NULL, TO_CHAR (FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001' || :B50 ), 'HH24:MI:SS')), DECODE (:B49 , '', NULL, :B49 ), :B48 , :B47 , :B46 , 'N', :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , FCP.OUTPUT_FILE_TYPE, FCP.NLS_COMPLIANT, :B39 , :B38 , :B37 , DECODE(:B36 , 'Y', 'Y', FCP.ENABLE_TRACE), :B35 , :B34 , :B33 , :B32 , :B31 , SYS_CONTEXT('userenv', 'current_edition_name'), :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 FROM FND_APPLICATION FA, FND_CONCURRENT_PROGRAMS FCP, FND_ORACLE_USERID WHERE ORACLE_USERNAME = :B3 AND FCP.ENABLED_FLAG = 'Y' AND (FCP.APPLICATION_ID = FA.APPLICATION_ID AND CONCURRENT_PROGRAM_NAME = UPPER (:B2 )) AND FA.APPLICATION_SHORT_NAME = UPPER (:B1 )
5fky033hvxn3sSELECT 'X' FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL, WSH_DELIVERY_ASSIGNMENTS WDA , WSH_DELIVERY_DETAILS WDD WHERE WTS.BATCH_ID = :B1 AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID AND WDA.DELIVERY_ID = WDL.DELIVERY_ID AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID AND WDD.CONTAINER_FLAG = 'N' AND WDD.SOURCE_CODE = 'OE' AND (EXISTS (SELECT 'any non-cancelled line outside batch' FROM WSH_DELIVERY_DETAILS WDD2 WHERE WDD2.SOURCE_LINE_ID = WDD.SOURCE_LINE_ID AND WDD2.SOURCE_CODE = 'OE' AND WDD2.CONTAINER_FLAG = 'N' AND WDD2.RELEASED_STATUS <> 'D' AND WDD2.DELIVERY_DETAIL_ID NOT IN (SELECT WDA3.DELIVERY_DETAIL_ID FROM WSH_DELIVERY_ASSIGNMENTS WDA3 , WSH_DELIVERY_LEGS WDL3, WSH_TRIP_STOPS WTS3, WSH_DELIVERY_DETAILS WDD3 WHERE WTS3.BATCH_ID = :B1 AND WDL3.PICK_UP_STOP_ID = WTS3.STOP_ID AND WDA3.DELIVERY_ID = WDL3.DELIVERY_ID AND WDD3.DELIVERY_DETAIL_ID = WDA3.DELIVERY_DETAIL_ID AND WDD3.SOURCE_LINE_ID = WDD.SOURCE_LINE_ID AND WDD3.SOURCE_CODE = 'OE' AND WDD3.CONTAINER_FLAG = 'N')) OR WDD.TOP_MODEL_LINE_ID IS NOT NULL OR WDD.SHIP_SET_ID IS NOT NULL OR NVL(WDD.SHIP_MODEL_COMPLETE_FLAG, 'N') = 'Y' OR WDD.REQUESTED_QUANTITY <> NVL(WDD.SHIPPED_QUANTITY, -99) OR NVL(REQUESTED_QUANTITY2, -99) <> NVL(SHIPPED_QUANTITY2, -99) OR WDD.SOURCE_LINE_SET_ID IS NOT NULL ) AND ROWNUM = 1
5t39uchjqpyfmBEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END;
5t6wystf9zvbbBEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14, :A15); END;
66tmsr3446uqnSELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6abn0zw8kkvtkbegin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :num_tax_failures , :return_status:i_return_status ) ; END ;
6dp3t6txwjvamSELECT SU.TAX_CODE FROM HZ_CUST_SITE_USES_ALL SU, ZX_OUTPUT_CLASSIFICATIONS_V L WHERE SU.SITE_USE_ID = :B3 AND SU.ORG_ID = :B2 AND L.LOOKUP_CODE = SU.TAX_CODE AND L.ORG_ID IN (:B2 , -99) AND L.ENABLED_FLAG = 'Y' AND (L.START_DATE_ACTIVE <= :B1 OR L.START_DATE_ACTIVE IS NULL) AND (L.END_DATE_ACTIVE >= :B1 OR L.END_DATE_ACTIVE IS NULL) AND ROWNUM = 1 ORDER BY L.ORG_ID DESC
6mu4cfrayu648SELECT 'x' FROM WSH_PR_WORKERS WHERE ROWID = :B1 AND PROCESSED = 'N' FOR UPDATE NOWAIT
6vubppkb5tps5SELECT HEADER.PREVIOUS_CUSTOMER_TRX_ID , NVL(ACC_RULE.DEFERRED_REVENUE_FLAG, 'N'), HEADER.INVOICING_RULE_ID FROM RA_CUSTOMER_TRX HEADER, RA_CUSTOMER_TRX_LINES LINES, RA_RULES ACC_RULE WHERE LINES.CUSTOMER_TRX_LINE_ID = :B1 AND LINES.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND ACC_RULE.RULE_ID = LINES.ACCOUNTING_RULE_ID
7ptvbaycjtbg4BEGIN arp_run.revenue_recognition(:errbuf, :rc, :A0, :A1, :A2); END;
7qh9zcbrq9ky7SELECT 'Y' FROM WSH_PR_WORKERS WHERE ROWID = :B1 AND PROCESSED = 'N' FOR UPDATE NOWAIT
7t8v1mvj7vk71SELECT 'N' DUMMY_FLAG, REG.REGISTRATION_ID, REG.REGISTRATION_TYPE_CODE, REG.REGISTRATION_NUMBER, REG.VALIDATION_RULE, REG.TAX_AUTHORITY_ID, REG.REP_TAX_AUTHORITY_ID, REG.COLL_TAX_AUTHORITY_ID, REG.ROUNDING_RULE_CODE, REG.TAX_JURISDICTION_CODE, REG.SELF_ASSESS_FLAG, REG.REGISTRATION_STATUS_CODE, REG.REGISTRATION_SOURCE_CODE, REG.REGISTRATION_REASON_CODE, REG.PARTY_TAX_PROFILE_ID, REG.TAX, REG.TAX_REGIME_CODE, REG.INCLUSIVE_TAX_FLAG, REG.EFFECTIVE_FROM, REG.EFFECTIVE_TO, REG.REP_PARTY_TAX_NAME, REG.LEGAL_REGISTRATION_ID, REG.DEFAULT_REGISTRATION_FLAG, REG.BANK_ID, REG.BANK_BRANCH_ID, REG.BANK_ACCOUNT_NUM, REG.LEGAL_LOCATION_ID, REG.RECORD_TYPE_CODE, REG.REQUEST_ID, REG.PROGRAM_APPLICATION_ID, REG.PROGRAM_ID, REG.PROGRAM_LOGIN_ID, REG.ACCOUNT_SITE_ID, NULL, REG.ACCOUNT_ID, REG.TAX_CLASSIFICATION_CODE, REG.ATTRIBUTE1, REG.ATTRIBUTE2, REG.ATTRIBUTE3, REG.ATTRIBUTE4, REG.ATTRIBUTE5, REG.ATTRIBUTE6, REG.ATTRIBUTE7, REG.ATTRIBUTE8, REG.ATTRIBUTE9, REG.ATTRIBUTE10, REG.ATTRIBUTE11, REG.ATTRIBUTE12, REG.ATTRIBUTE13, REG.ATTRIBUTE14, REG.ATTRIBUTE15, REG.ATTRIBUTE_CATEGORY, PTP.PARTY_TYPE_CODE, PTP.SUPPLIER_FLAG, PTP.CUSTOMER_FLAG, PTP.SITE_FLAG, PTP.PROCESS_FOR_APPLICABILITY_FLAG, PTP.ROUNDING_LEVEL_CODE, PTP.WITHHOLDING_START_DATE, PTP.ALLOW_AWT_FLAG, PTP.USE_LE_AS_SUBSCRIBER_FLAG, PTP.LEGAL_ESTABLISHMENT_FLAG, PTP.FIRST_PARTY_LE_FLAG, PTP.REPORTING_AUTHORITY_FLAG, PTP.COLLECTING_AUTHORITY_FLAG, PTP.PROVIDER_TYPE_CODE, PTP.CREATE_AWT_DISTS_TYPE_CODE, PTP.CREATE_AWT_INVOICES_TYPE_CODE, PTP.ALLOW_OFFSET_TAX_FLAG, PTP.EFFECTIVE_FROM_USE_LE, PTP.PARTY_ID, PTP.REP_REGISTRATION_NUMBER FROM ZX_REGISTRATIONS REG, ZX_PARTY_TAX_PROFILE PTP WHERE REG.PARTY_TAX_PROFILE_ID = :B5 AND REG.PARTY_TAX_PROFILE_ID = PTP.PARTY_TAX_PROFILE_ID AND NVL(REG.TAX_REGIME_CODE, 1) = NVL(:B4 , 1) AND NVL(REG.TAX, NVL(:B3 , 1)) = NVL(:B3 , 1) AND NVL(REG.TAX_JURISDICTION_CODE, NVL(:B2 , 1)) = NVL(:B2 , 1) AND :B1 >= REG.EFFECTIVE_FROM AND (:B1 <= REG.EFFECTIVE_TO OR REG.EFFECTIVE_TO IS NULL)
82y1b79wj51rxSELECT P.CONCURRENT_PROCESS_ID FROM FND_CONCURRENT_PROCESSES P, fnd_concurrent_queues q WHERE (P.QUEUE_APPLICATION_ID != :qapplid OR P.CONCURRENT_QUEUE_ID != :queueid) AND P.PROCESS_STATUS_CODE IN ('A', 'C', 'T', 'P') and (P.QUEUE_APPLICATION_ID = Q.APPLICATION_ID AND P.CONCURRENT_QUEUE_ID = Q.CONCURRENT_QUEUE_ID) AND Q.MANAGER_TYPE <> '6'
8an3ja4qk82vmSELECT /*+ index (tl RA_CUSTOMER_TRX_LINES_N4) */ TL.CUSTOMER_TRX_LINE_ID, NVL(TL.TAX_CLASSIFICATION_CODE, ZX.OUTPUT_TAX_CLASSIFICATION_CODE) FROM RA_CUSTOMER_TRX T, RA_CUSTOMER_TRX_LINES TL, ZX_LINES_DET_FACTORS ZX WHERE T.REQUEST_ID = :B2 AND T.CUSTOMER_TRX_ID = TL.CUSTOMER_TRX_ID AND TL.LINE_TYPE = 'LINE' AND TL.REQUEST_ID = :B2 AND NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -99) = DECODE(:B1 , 'INV', -99, 'DM', -99, NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -99)) AND ZX.APPLICATION_ID = 222 AND ZX.ENTITY_CODE = 'TRANSACTIONS' AND ZX.EVENT_CLASS_CODE IN ('INVOICE', 'DEBIT_MEMO', 'CREDIT_MEMO') AND ZX.TRX_ID = TL.CUSTOMER_TRX_ID AND ZX.TRX_LEVEL_TYPE = 'LINE' AND ZX.TRX_LINE_ID = TL.CUSTOMER_TRX_LINE_ID
8gmgrb5mwa9f9SELECT TAX_REGIME_CODE, TAX, STATUS_RESULT, RATE_RESULT, CONDITION_SET_ID, EXCEPTION_SET_ID, RESULT_ID, QUERY_NUM FROM (SELECT /*+ leading(PR) use_nl(RL) */ RL.TAX_REGIME_CODE, RL.TAX, PR.STATUS_RESULT, PR.RATE_RESULT, PR.CONDITION_SET_ID, PR.EXCEPTION_SET_ID, PR.RESULT_ID, 1 QUERY_NUM, TAX.COMPOUNDING_PRECEDENCE FROM ZX_PROCESS_RESULTS PR, ZX_SCO_RULES_B_V RL, ZX_SCO_TAXES_B_V TAX WHERE (PR.CONDITION_GROUP_CODE IN (:B2 , DECODE(:B4 , 'OUTPUT', SUBSTRB(:B3 , 1, 45)||'-'||'XOP' , 'INPUT' , SUBSTRB(:B3 , 1, 45)||'-'||'XIP' , :B2 ) ) OR PR.CONDITION_GROUP_CODE LIKE :B2 ||'~'||'%') AND RL.EFFECTIVE_FROM <= :B1 AND (RL.EFFECTIVE_TO >= :B1 OR RL.EFFECTIVE_TO IS NULL ) AND PR.ENABLED_FLAG = 'Y' AND RL.TAX_RULE_ID = PR.TAX_RULE_ID AND RL.SERVICE_TYPE_CODE = 'DET_DIRECT_RATE' AND TAX.TAX_REGIME_CODE=RL.TAX_REGIME_CODE AND TAX.TAX=RL.TAX AND TAX.EFFECTIVE_FROM <= :B1 AND (TAX.EFFECTIVE_TO >= :B1 OR TAX.EFFECTIVE_TO IS NULL ) AND TAX.LIVE_FOR_PROCESSING_FLAG = 'Y' AND TAX.LIVE_FOR_APPLICABILITY_FLAG = 'Y' AND EXISTS (SELECT /*+ no_unnest */ 1 FROM ZX_SCO_RATES_B_V RT WHERE RT.TAX_REGIME_CODE = RL.TAX_REGIME_CODE AND RT.TAX = RL.TAX AND RT.TAX_STATUS_CODE = PR.STATUS_RESULT AND RT.TAX_RATE_CODE = PR.RATE_RESULT AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFECTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B4 OR RT.TAX_CLASS IS NULL)) UNION ALL SELECT /*+ leading(RT.a) use_nl(RT.sd) */ DISTINCT RT.TAX_REGIME_CODE, RT.TAX, RT.TAX_STATUS_CODE, RT.TAX_RATE_CODE, NULL CONDITION_SET_ID, NULL EXCEPTION_SET_ID, NULL RESULT_ID, 2 QUERY_NUM, TAX.COMPOUNDING_PRECEDENCE FROM ZX_SCO_RATES_B_V RT, ZX_SCO_TAXES_B_V TAX WHERE RT.TAX_RATE_CODE = :B3 AND RT.RATE_TYPE_CODE <> 'RECOVERY' AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFECTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B4 OR RT.TAX_CLASS IS NULL) AND TAX.TAX_REGIME_CODE = RT.TAX_REGIME_CODE AND TAX.TAX = RT.TAX AND TAX.LIVE_FOR_PROCESSING_FLAG = 'Y' AND TAX.LIVE_FOR_APPLICABILITY_FLAG = 'Y' AND TAX.EFFECTIVE_FROM <= :B1 AND (TAX.EFFECTIVE_TO >= :B1 OR TAX.EFFECTIVE_TO IS NULL ) ) ORDER BY COMPOUNDING_PRECEDENCE NULLS FIRST
8zfgv4ck11dw9BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END;
9173mvrnzb898SELECT DEFAULT_COST_GROUP_ID, PRIMARY_COST_METHOD FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = :B1
a1wk2hsdfm7puselect /*+ FIRST_ROWS(1) */ tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration , tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "APPLSYS"."WF_DEFERRED_TABLE_M" tab, "APPLSYS"."AQ$_WF_DEFERRED_TABLE_M_I" iot where (iot.subscriber# = :1 and iot.name = :2 and iot.queue# = :3) and iot.msg_priority = tab.priority and iot.msg_enq_time = tab.enq_time and iot.msg_step_no = tab.step_no and iot.msg_chain_no = tab.chain_no and iot.msg_local_order_no = tab.local_order_no and tab.corrid = :4 and tab.msgid = iot.msgid
a72z5jmc038ttSELECT /*+ index (line RA_CUSTOMER_TRX_LINES_N4) */ LINE.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, SUM(DECODE(LINE.EXTENDED_AMOUNT, 0, 0, TAX.EXTENDED_AMOUNT)) INCLUSIVE_AMOUNT, HEADER.INVOICE_CURRENCY_CODE CURRENCY_CODE, HEADER.EXCHANGE_RATE EXCHANGE_RATE, CURRENCY.PRECISION PRECISION, CURRENCY.MINIMUM_ACCOUNTABLE_UNIT MAU FROM RA_CUSTOMER_TRX HEADER, FND_CURRENCIES CURRENCY, RA_CUSTOMER_TRX_LINES LINE, RA_CUSTOMER_TRX_LINES TAX WHERE HEADER.REQUEST_ID = :B1 AND NVL(HEADER.PREVIOUS_CUSTOMER_TRX_ID, -99) = DECODE(:B2 , 'CM', NVL(HEADER.PREVIOUS_CUSTOMER_TRX_ID, -99), -99) AND LINE.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND LINE.LINE_TYPE = 'LINE' AND LINE.REQUEST_ID = :B1 AND TAX.LINK_TO_CUST_TRX_LINE_ID = LINE.CUSTOMER_TRX_LINE_ID AND TAX.LINE_TYPE = 'TAX' AND TAX.AMOUNT_INCLUDES_TAX_FLAG = 'Y' AND TAX.CUSTOMER_TRX_ID = LINE.CUSTOMER_TRX_ID AND HEADER.INVOICE_CURRENCY_CODE = CURRENCY.CURRENCY_CODE GROUP BY LINE.CUSTOMER_TRX_LINE_ID, HEADER.INVOICE_CURRENCY_CODE, HEADER.EXCHANGE_RATE, CURRENCY.PRECISION, CURRENCY.MINIMUM_ACCOUNTABLE_UNIT
aptgswyxvu4wsSELECT COUNT ( * ) FROM RA_INTERFACE_ERRORS ERR , RA_INTERFACE_LINES LINES WHERE LINES . REQUEST_ID = :B1 AND LINES . INTERFACE_LINE_ID = ERR . INTERFACE_LINE_ID
assndb4wqnd6rBEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END;
axhwy13vcu03gSELECT ROWID , DENSE_RANK() OVER (PARTITION BY AE_HEADER_ID ORDER BY AE_HEADER_ID , GL_TRANSFER_MODE_CODE , ACCOUNTING_CLASS_CODE , EVENT_TYPE_CODE , ROUNDING_CLASS_CODE , DOCUMENT_ROUNDING_LEVEL , CURRENCY_CODE , CURRENCY_CONVERSION_TYPE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , CODE_COMBINATION_ID , CODE_COMBINATION_STATUS_CODE , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CODE_COMBINATION_ID , ALT_CCID_STATUS_CODE , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , JGZZ_RECON_REF , USSGL_TRANSACTION_CODE , MERGE_DUPLICATE_CODE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , BUSINESS_CLASS_CODE , MPA_ACCRUAL_ENTRY_FLAG , ENCUMBRANCE_TYPE_ID , DECODE(MERGE_DUPLICATE_CODE, 'N', ROWNUM, 'D', ROWNUM, MERGE_INDEX) , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , ENTERED_CURRENCY_MAU) AE_LINE_NUM , ROWNUM FROM XLA_AE_LINES_GT WHERE TEMP_LINE_NUM <> 0
b5mv0n1ss384u INSERT INTO MTL_MATERIAL_TRANSACTIONS ( TRANSACTION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID, REVISION, TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_NAME, TRANSACTION_QUANTITY, TRANSACTION_UOM, PRIMARY_QUANTITY, TRANSACTION_DATE, TRANSACTION_COST, ACTUAL_COST, PRIOR_COST, NEW_COST, QUANTITY_ADJUSTED, VARIANCE_AMOUNT, TRANSFER_COST, TRANSPORTATION_COST, TRANSFER_TRANSACTION_ID, TRANSFER_ORGANIZATION_ID, TRANSFER_SUBINVENTORY, TRANSFER_LOCATOR_ID , ACCT_PERIOD_ID, TRANSACTION_REFERENCE, REASON_ID, REPETITIVE_LINE_ID, DEPARTMENT_ID, OPERATION_SEQ_NUM, SHIPMENT_NUMBER, FREIGHT_CODE, WAYBILL_AIRBILL, TRX_SOURCE_LINE_ID, MOVE_ORDER_LINE_ID , DISTRIBUTION_ACCOUNT_ID , ENCUMBRANCE_ACCOUNT , ENCUMBRANCE_AMOUNT , COST_UPDATE_ID , PROJECT_ID , TASK_ID , TO_PROJECT_ID , TO_TASK_ID , LPN_ID , TRANSFER_LPN_ID, CONTENT_LPN_ID , PUT_AWAY_STRATEGY_ID , PUT_AWAY_RULE_ID , PICK_STRATEGY_ID , PICK_RULE_ID , CREATED_BY , COST_GROUP_ID , TRANSFER_COST_GROUP_ID , TRANSACTION_SET_ID , PM_COST_COLLECTED , COST_CATEGORY_ID , ORGANIZATION_TYPE , TRANSFER_ORGANIZATION_TYPE , OWNING_ORGANIZATION_ID , OWNING_TP_TYPE , PLANNING_ORGANIZATION_ID , PLANNING_TP_TYPE , XFR_OWNING_ORGANIZATION_ID , TRANSFER_OWNING_TP_TYPE , XFR_PLANNING_ORGANIZATION_ID , TRANSFER_PLANNING_TP_TYPE , SECONDARY_TRANSACTION_QUANTITY , SECONDARY_UOM_CODE, PICK_SLIP_NUMBER, PICKING_LINE_ID, VENDOR_LOT_NUMBER, SOURCE_CODE, SOURCE_LINE_ID, MOVE_TRANSACTION_ID, RCV_TRANSACTION_ID, COMPLETION_TRANSACTION_ID, CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, OVERHEAD_ACCOUNT, MOVEMENT_ID, SOURCE_PROJECT_ID, SOURCE_TASK_ID, PA_EXPENDITURE_ORG_ID, EXPENDITURE_TYPE, TRANSFER_PERCENTAGE, ORG_COST_GROUP_ID, COST_TYPE_ID, VALUE_CHANGE, PERCENTAGE_CHANGE, EMPLOYEE_CODE, MASTER_SCHEDULE_UPDATE_CODE, TRX_SOURCE_DELIVERY_ID, RECEIVING_DOCUMENT, TRANSPORTATION_DIST_ACCOUNT, NUMBER_OF_CONTAINERS, RMA_LINE_ID, CYCLE_COUNT_ID, PHYSICAL_ADJUSTMENT_ID, FLOW_SCHEDULE, FINAL_COMPLETION_FLAG, QA_COLLECTION_ID, OVERCOMPLETION_TRANSACTION_QTY, OVERCOMPLETION_PRIMARY_QTY, OVERCOMPLETION_TRANSACTION_ID, COMMON_BOM_SEQ_ID, COMMON_ROUTING_SEQ_ID, MVT_STAT_STATUS, PICK_SLIP_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SHIP_TO_LOCATION_ID, TRANSACTION_MODE, TRANSACTION_BATCH_ID, TRANSACTION_BATCH_SEQ, FOB_POINT, INTRANSIT_ACCOUNT, TRX_FLOW_HEADER_ID, LOGICAL_TRX_TYPE_CODE, ORIGINAL_TRANSACTION_TEMP_ID, SHORTAGE_PROCESS_CODE, TRANSFER_PRICE, COSTED_FLAG, OPM_COSTED_FLAG, MCC_CODE, INVOICED_FLAG) VALUES(:1, SYSDATE, :2, SYSDATE, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, ROUND(:17, 5), :18, ROUND(:19, 5), nvl(:20, sysdate), :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, ROUND(:75, 5), :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, 'NEW', :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, Decode(:149, 'D', 'N', NULL), DECODE(:150, 'O', 'N', NULL), :151, :152)
b5ycnkqg2b0wkSELECT MTL_DEMAND_S.NEXTVAL FROM DUAL
bc9gpshz90yw0INSERT INTO AR_XLA_LINES_EXTRACT ( EVENT_ID , LINE_NUMBER , LANGUAGE , LEDGER_ID , SOURCE_ID , SOURCE_TABLE , LINE_ID , TAX_CODE_ID , LOCATION_SEGMENT_ID , BASE_CURRENCY_CODE , EXCHANGE_RATE_TYPE , EXCHANGE_RATE , EXCHANGE_DATE , ACCTD_AMOUNT , TAXABLE_ACCTD_AMOUNT , ORG_ID , HEADER_TABLE_ID , POSTING_ENTITY , CASH_RECEIPT_ID , CUSTOMER_TRX_ID , CUSTOMER_TRX_LINE_ID , CUST_TRX_LINE_GL_DIST_ID , CUST_TRX_LINE_SALESREP_ID , INVENTORY_ITEM_ID , SALES_TAX_ID , SO_ORGANIZATION_ID , TAX_EXEMPTION_ID , UOM_CODE , WAREHOUSE_ID , AGREEMENT_ID , CUSTOMER_BANK_ACCT_ID , DRAWEE_BANK_ACCOUNT_ID , REMITTANCE_BANK_ACCT_ID , DISTRIBUTION_SET_ID , PAYMENT_SCHEDULE_ID , RECEIPT_METHOD_ID , RECEIVABLES_TRX_ID , ED_ADJ_RECEIVABLES_TRX_ID , UNED_RECEIVABLES_TRX_ID , SET_OF_BOOKS_ID , SALESREP_ID , BILL_SITE_USE_ID , DRAWEE_SITE_USE_ID , PAYING_SITE_USE_ID , SOLD_SITE_USE_ID , SHIP_SITE_USE_ID , RECEIPT_CUSTOMER_SITE_USE_ID , BILL_CUST_ROLE_ID , DRAWEE_CUST_ROLE_ID , SHIP_CUST_ROLE_ID , SOLD_CUST_ROLE_ID , BILL_CUSTOMER_ID , DRAWEE_CUSTOMER_ID , PAYING_CUSTOMER_ID , SOLD_CUSTOMER_ID , SHIP_CUSTOMER_ID , REMIT_ADDRESS_ID , RECEIPT_BATCH_ID , RECEIVABLE_APPLICATION_ID , CUSTOMER_BANK_BRANCH_ID , ISSUER_BANK_BRANCH_ID , BATCH_SOURCE_ID , BATCH_ID , TERM_ID , SELECT_FLAG , LEVEL_FLAG , FROM_TO_FLAG , FROM_AMOUNT , AMOUNT , FROM_ACCTD_AMOUNT , EVENT_TYPE_CODE , EVENT_CLASS_CODE , ENTITY_CODE , TAX_LINE_ID , ADDITIONAL_CHAR1 , MFAR_ADDITIONAL_ENTRY , SOURCE_TYPE , CM_APP_TO_TRX_LINE_ID , BAL_SEG_VALUE , ADDITIONAL_CHAR2 ) SELECT /*+LEADING(gt) cardinality(gt, 1) USE_NL(gt, app)*/ GT.EVENT_ID, DIST.LINE_ID, '', SOB.SET_OF_BOOKS_ID, DIST.SOURCE_ID, DIST.SOURCE_TABLE, DIST.LINE_ID, DIST.TAX_CODE_ID, DIST.LOCATION_SEGMENT_ID, SOB.CURRENCY_CODE, TRXT.EXCHANGE_RATE_TYPE, TRXT.EXCHANGE_RATE, DECODE(TRXT.INVOICE_CURRENCY_CODE, SOB.CURRENCY_CODE, TRXT.TRX_DATE, TRXT.EXCHANGE_DATE), NVL(DIST.ACCTD_AMOUNT_CR, 0) - NVL(DIST.ACCTD_AMOUNT_DR, 0), NVL(DIST.TAXABLE_ACCOUNTED_CR, 0) - NVL(DIST.TAXABLE_ACCOUNTED_DR, 0), APP.ORG_ID, APP.RECEIVABLE_APPLICATION_ID, 'APP', NULL, TRXT.CUSTOMER_TRX_ID, TLT.CUSTOMER_TRX_LINE_ID, GLDT.CUST_TRX_LINE_GL_DIST_ID, GLDT.CUST_TRX_LINE_SALESREP_ID, TLT.INVENTORY_ITEM_ID, TLT.SALES_TAX_ID, OSP.MASTER_ORGANIZATION_ID, TLT.TAX_EXEMPTION_ID, TLT.UOM_CODE, TLT.WAREHOUSE_ID, TRXT.AGREEMENT_ID, TRXT.CUSTOMER_BANK_ACCOUNT_ID, TRXT.DRAWEE_BANK_ACCOUNT_ID, TRXT.REMIT_BANK_ACCT_USE_ID, NULL, PSCH.PAYMENT_SCHEDULE_ID, TRXT.RECEIPT_METHOD_ID, NULL, ARP_XLA_EXTRACT_MAIN_PKG.ED_UNED_TRX('EDISC', APP.ORG_ID), ARP_XLA_EXTRACT_MAIN_PKG.ED_UNED_TRX('UNEDISC', APP.ORG_ID), TRXT.SET_OF_BOOKS_ID, TRXT.PRIMARY_SALESREP_ID, TRXT.BILL_TO_SITE_USE_ID, TRXT.DRAWEE_SITE_USE_ID, TRXT.PAYING_SITE_USE_ID, TRXT.SOLD_TO_SITE_USE_ID, TRXT.SHIP_TO_SITE_USE_ID, NULL, TRXT.BILL_TO_CONTACT_ID, TRXT.DRAWEE_CONTACT_ID, TRXT.SHIP_TO_CONTACT_ID, TRXT.SOLD_TO_CONTACT_ID, TRXT.BILL_TO_CUSTOMER_ID, TRXT.DRAWEE_ID, TRXT.PAYING_CUSTOMER_ID, TRXT.SOLD_TO_CUSTOMER_ID, TRXT.SHIP_TO_CUSTOMER_ID, TRXT.REMIT_TO_ADDRESS_ID, NULL, NULL, NULL, NULL, TRXT.BATCH_SOURCE_ID, TRXT.BATCH_ID, TRXT.TERM_ID, 'Y', 'L', 'T', CASE WHEN (APP.UPGRADE_METHOD IS NULL AND APP.STATUS ='APP') THEN CASE WHEN (DIST.FROM_AMOUNT_DR IS NOT NULL OR DIST.FROM_AMOUNT_CR IS NOT NULL) THEN NVL(DIST.FROM_AMOUNT_CR, 0)-NVL(DIST.FROM_AMOUNT_DR, 0) ELSE CASE WHEN (DIST.SOURCE_TYPE NOT IN ('REC', 'EDISC', 'UNEDISC')) THEN NULL ELSE CASE WHEN (APP.EARNED_DISCOUNT_TAKEN IS NOT NULL AND APP.EARNED_DISCOUNT_TAKEN = NVL(DIST.AMOUNT_DR, 0)-NVL(DIST.AMOUNT_CR, 0) AND APP.ACCTD_EARNED_DISCOUNT_TAKEN = NVL(DIST.ACCTD_AMOUNT_DR, 0)-NVL(DIST.ACCTD_AMOUNT_CR, 0) AND DIST.SOURCE_TYPE = 'REC') THEN NULL ELSE CASE WHEN (TRXT.INVOICE_CURRENCY_CODE = CR.CURRENCY_CODE) THEN NVL(DIST.AMOUNT_CR, 0)-NVL(DIST.AMOUNT_DR, 0) ELSE CASE WHEN (APP.AMOUNT_APPLIED <> 0 AND APP.AMOUNT_APPLIED_FROM <> 0) THEN NVL(APP.AMOUNT_APPLIED_FROM / APP.AMOUNT_APPLIED * DIST.AMOUNT_CR, 0)- NVL(APP.AMOUNT_APPLIED_FROM / APP.AMOUNT_APPLIED * DIST.AMOUNT_DR, 0) ELSE NULL END END END END END ELSE NVL(DIST.FROM_AMOUNT_CR, 0) -NVL(DIST.FROM_AMOUNT_DR, 0) END, NVL(DIST.AMOUNT_CR, 0) - NVL(DIST.AMOUNT_DR, 0), CASE WHEN (APP.UPGRADE_METHOD IS NULL AND APP.STATUS ='APP') THEN CASE WHEN (DIST.FROM_ACCTD_AMOUNT_DR IS NOT NULL OR DIST.FROM_ACCTD_AMOUNT_CR IS NOT NULL) THEN NVL(DIST.FROM_ACCTD_AMOUNT_CR, 0)-NVL(DIST.FROM_ACCTD_AMOUNT_DR, 0) ELSE CASE WHEN (DIST.SOURCE_TYPE NOT IN ('REC', 'EDISC', 'UNEDISC')) THEN NULL ELSE CASE WHEN (APP.EARNED_DISCOUNT_TAKEN IS NOT NULL AND APP.EARNED_DISCOUNT_TAKEN = NVL(DIST.AMOUNT_DR, 0)-NVL(DIST.AMOUNT_CR, 0) AND APP.ACCTD_EARNED_DISCOUNT_TAKEN = NVL(DIST.ACCTD_AMOUNT_DR, 0)-NVL(DIST.ACCTD_AMOUNT_CR, 0) AND DIST.SOURCE_TYPE = 'REC') THEN NULL ELSE CASE WHEN (TRXT.INVOICE_CURRENCY_CODE = SOB.CURRENCY_CODE AND CR.CURRENCY_CODE = SOB.CURRENCY_CODE ) THEN NVL(DIST.ACCTD_AMOUNT_CR, 0)-NVL(DIST.ACCTD_AMOUNT_DR, 0) ELSE CASE WHEN (APP.ACCTD_AMOUNT_APPLIED_TO <> 0 AND APP.ACCTD_AMOUNT_APPLIED_FROM <> 0) THEN NVL(APP.ACCTD_AMOUNT_APPLIED_FROM / APP.ACCTD_AMOUNT_APPLIED_TO * DIST.ACCTD_AMOUNT_CR, 0)- NVL(APP.ACCTD_AMOUNT_APPLIED_FROM / APP.ACCTD_AMOUNT_APPLIED_TO * DIST.ACCTD_AMOUNT_DR, 0) ELSE NULL END END END END END ELSE NVL(DIST.FROM_ACCTD_AMOUNT_CR, 0) -NVL(DIST.FROM_ACCTD_AMOUNT_DR, 0) END, GT.EVENT_TYPE_CODE , GT.EVENT_CLASS_CODE , GT.ENTITY_CODE , TLT.TAX_LINE_ID , APP.UPGRADE_METHOD , 'N' , NULL , TO_NUMBER(NULL) , NULL , DECODE(TRXT.UPGRADE_METHOD, 'R12_11ICASH', 'N', '') FROM XLA_EVENTS_GT GT, AR_RECEIVABLE_APPLICATIONS_ALL APP, AR_DISTRIBUTIONS_ALL DIST, GL_SETS_OF_BOOKS SOB, OE_SYSTEM_PARAMETERS_ALL OSP, RA_CUSTOMER_TRX_ALL TRXT, RA_CUSTOMER_TRX_LINES_ALL TLT, RA_CUST_TRX_LINE_GL_DIST_ALL GLDT, AR_PAYMENT_SCHEDULES_ALL PSCH, AR_CASH_RECEIPTS_ALL CR WHERE GT.EVENT_TYPE_CODE IN ( 'RECP_CREATE' , 'RECP_UPDATE' , 'RECP_RATE_ADJUST' ) AND GT.APPLICATION_ID = :B1 AND GT.EVENT_ID = APP.EVENT_ID AND (APP.UPGRADE_METHOD IN ('R12_NLB', 'R12', 'R12_11IMFAR', 'R12_11ICASH', '11I_R12_POST', 'R12_MERGE') OR (APP.UPGRADE_METHOD IS NULL AND APP.STATUS = 'APP') OR (DECODE(APP.UPGRADE_METHOD, '11I_MFAR_UPG' , DECODE(DIST.SOURCE_TABLE_SECONDARY, 'UPMFRAMIAR', 'Y', 'N'), 'N') = 'Y')) AND APP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID AND APP.ORG_ID = OSP.ORG_ID(+) AND APP.APPLIED_CUSTOMER_TRX_ID = TRXT.CUSTOMER_TRX_ID AND APP.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID AND DIST.SOURCE_ID = APP.RECEIVABLE_APPLICATION_ID AND DIST.SOURCE_TABLE = 'RA' AND DIST.REF_CUSTOMER_TRX_LINE_ID = TLT.CUSTOMER_TRX_LINE_ID(+) AND DIST.REF_CUST_TRX_LINE_GL_DIST_ID = GLDT.CUST_TRX_LINE_GL_DIST_ID(+) AND TRXT.CUSTOMER_TRX_ID = PSCH.CUSTOMER_TRX_ID AND NVL(PSCH.TERMS_SEQUENCE_NUMBER, 1) = 1 UNION ALL SELECT /*+LEADING(gt) cardinality(gt, 1) USE_NL(gt, app)*/ GT.EVENT_ID, DIST.LINE_ID, '', SOB.SET_OF_BOOKS_ID, DIST.SOURCE_ID, DIST.SOURCE_TABLE, DIST.LINE_ID, DIST.TAX_CODE_ID, DIST.LOCATION_SEGMENT_ID, SOB.CURRENCY_CODE, TRXT.EXCHANGE_RATE_TYPE, TRXT.EXCHANGE_RATE, DECODE(TRXT.INVOICE_CURRENCY_CODE, SOB.CURRENCY_CODE, TRXT.TRX_DATE, TRXT.EXCHANGE_DATE), NVL(DIST.ACCTD_AMOUNT_CR, 0) - NVL(DIST.ACCTD_AMOUNT_DR, 0), NVL(DIST.TAXABLE_ACCOUNTED_CR, 0) - NVL(DIST.TAXABLE_ACCOUNTED_DR, 0), APP.ORG_ID, APP.RECEIVABLE_APPLICATION_ID, 'APP', NULL, TRXT.CUSTOMER_TRX_ID, TLT.CUSTOMER_TRX_LINE_ID, GLDT.CUST_TRX_LINE_GL_DIST_ID, GLDT.CUST_TRX_LINE_SALESREP_ID, TLT.INVENTORY_ITEM_ID, TLT.SALES_TAX_ID, OSP.MASTER_ORGANIZATION_ID, TLT.TAX_EXEMPTION_ID, TLT.UOM_CODE, TLT.WAREHOUSE_ID, TRXT.AGREEMENT_ID, TRXT.CUSTOMER_BANK_ACCOUNT_ID, TRXT.DRAWEE_BANK_ACCOUNT_ID, TRXT.REMIT_BANK_ACCT_USE_ID, NULL, PSCH.PAYMENT_SCHEDULE_ID, TRXT.RECEIPT_METHOD_ID, NULL, NULL, NULL, TRXT.SET_OF_BOOKS_ID, TRXT.PRIMARY_SALESREP_ID, TRXT.BILL_TO_SITE_USE_ID, TRXT.DRA WEE_SITE_USE_ID, TRXT.PAYING_SITE_USE_ID, TRXT.SOLD_TO_SITE_USE_ID, TRXT.SHIP_TO_SITE_USE_ID, NULL, TRXT.BILL_TO_CONTACT_ID, TRXT.DRAWEE_CONTACT_ID, TRXT.SHIP_TO_CONTACT_ID, TRXT.SOLD_TO_CONTACT_ID, TRXT.BILL_TO_CUSTOMER_ID, TRXT.DRAWEE_ID, TRXT.PAYING_CUSTOMER_ID, TRXT.SOLD_TO_CUSTOMER_ID, TRXT.SHIP_TO_CUSTOMER_ID, TRXT.REMIT_TO_ADDRESS_ID, NULL, NULL, NULL, NULL, TRXT.BATCH_SOURCE_ID, TRXT.BATCH_ID, TRXT.TERM_ID, 'Y', 'L', 'T', CASE WHEN (DIST.FROM_AMOUNT_CR IS NULL AND DIST.FROM_AMOUNT_DR IS NULL) THEN NVL(DIST.AMOUNT_CR, 0) - NVL(DIST.AMOUNT_DR, 0) ELSE NVL(DIST.FROM_AMOUNT_CR, 0) - NVL(DIST.FROM_AMOUNT_DR, 0) END, NVL(DIST.AMOUNT_CR, 0) -NVL(DIST.AMOUNT_DR, 0), CASE WHEN (DIST.FROM_ACCTD_AMOUNT_CR IS NULL AND DIST.FROM_ACCTD_AMOUNT_DR IS NULL) THEN NVL(DIST.ACCTD_AMOUNT_CR, 0) - NVL(DIST.ACCTD_AMOUNT_DR, 0) ELSE NVL(DIST.FROM_ACCTD_AMOUNT_CR, 0) - NVL(DIST.FROM_ACCTD_AMOUNT_DR, 0) END, GT.EVENT_TYPE_CODE , GT.EVENT_CLASS_CODE , GT.ENTITY_CODE , TLT.TAX_LINE_ID , APP.UPGRADE_METHOD , 'N' , DIST.SOURCE_TYPE , DECODE(DIST.REF_PREV_CUST_TRX_LINE_ID, NULL, TO_NUMBER(NULL), DIST.REF_CUSTOMER_TRX_LINE_ID) , ARP_XLA_EXTRACT_MAIN_PKG.THE_SEGMENT_VALUE(SOB.CHART_OF_ACCOUNTS_ID, 'GL_BALANCING', DIST.REF_DIST_CCID) , DECODE(TRXT.UPGRADE_METHOD, 'R12_11ICASH', 'N', '') FROM XLA_EVENTS_GT GT, AR_RECEIVABLE_APPLICATIONS_ALL APP, AR_DISTRIBUTIONS_ALL DIST, GL_SETS_OF_BOOKS SOB, OE_SYSTEM_PARAMETERS_ALL OSP, RA_CUSTOMER_TRX_ALL TRXT, RA_CUSTOMER_TRX_LINES_ALL TLT, RA_CUST_TRX_LINE_GL_DIST_ALL GLDT, AR_PAYMENT_SCHEDULES_ALL PSCH WHERE GT.EVENT_TYPE_CODE IN ( 'CM_CREATE', 'CM_UPDATE' ) AND GT.APPLICATION_ID = :B1 AND GT.EVENT_ID = APP.EVENT_ID AND (APP.UPGRADE_METHOD IN ('R12_NLB', 'R12', 'R12_11IMFAR', 'R12_11ICASH', '11I_R12_POST', 'R12_MERGE') OR (APP.UPGRADE_METHOD IS NULL AND APP.STATUS = 'APP') OR (DECODE(APP.UPGRADE_METHOD, '11I_MFAR_UPG' , DECODE(DIST.SOURCE_TABLE_SECONDARY, 'UPMFRAMIAR', 'Y', 'N'), 'N') = 'Y')) AND DIST.SOURCE_TABLE = 'RA' AND DIST.SOURCE_ID = APP.RECEIVABLE_APPLICATION_ID AND APP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID AND APP.ORG_ID = OSP.ORG_ID(+) AND APP.APPLIED_CUSTOMER_TRX_ID = TRXT.CUSTOMER_TRX_ID AND DIST.REF_CUSTOMER_TRX_LINE_ID = TLT.CUSTOMER_TRX_LINE_ID(+) AND DIST.REF_CUST_TRX_LINE_GL_DIST_ID = GLDT.CUST_TRX_LINE_GL_DIST_ID(+) AND TRXT.CUSTOMER_TRX_ID = PSCH.CUSTOMER_TRX_ID AND NVL(PSCH.TERMS_SEQUENCE_NUMBER, 1) = 1 AND ((( DIST.REF_CUST_TRX_LINE_GL_DIST_ID IS NOT NULL AND SIGN(DIST.REF_CUST_TRX_LINE_GL_DIST_ID) = 1) AND DIST.REF_CUST_TRX_LINE_GL_DIST_ID IN (SELECT CUST_TRX_LINE_GL_DIST_ID FROM RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD WHERE CTLGD.CUSTOMER_TRX_ID = APP.APPLIED_CUSTOMER_TRX_ID)) OR (((DIST.REF_CUST_TRX_LINE_GL_DIST_ID IS NULL OR SIGN(DIST.REF_CUST_TRX_LINE_GL_DIST_ID) = -1) AND ((SIGN((APP.AMOUNT_APPLIED+NVL(APP.EARNED_DISCOUNT_TAKEN, 0)+NVL(APP.UNEARNED_DISCOUNT_TAKEN, 0))) = SIGN(NVL(DIST.AMOUNT_CR, 0) * -1+NVL(DIST.AMOUNT_DR, 0)) AND DIST.SOURCE_TYPE = 'DEFERRED_TAX' ) OR (SIGN((APP.ACCTD_AMOUNT_APPLIED_TO+NVL(APP.ACCTD_EARNED_DISCOUNT_TAKEN, 0)+NVL(APP.ACCTD_UNEARNED_DISCOUNT_TAKEN, 0))) = SIGN(NVL(DIST.ACCTD_AMOUNT_DR, 0) * -1+NVL(DIST.ACCTD_AMOUNT_CR, 0)) AND DIST.SOURCE_TYPE = 'CURR_ROUND') OR ( (SIGN((APP.AMOUNT_APPLIED+NVL(APP.EARNED_DISCOUNT_TAKEN, 0)+NVL(APP.UNEARNED_DISCOUNT_TAKEN, 0))) = SIGN(NVL(DIST.AMOUNT_DR, 0) * -1+NVL(DIST.AMOUNT_CR, 0)) AND DIST.SOURCE_TYPE NOT IN ('DEFERRED_TAX', 'CURR_ROUND')) AND (((SIGN((APP.AMOUNT_APPLIED+NVL(APP.EARNED_DISCOUNT_TAKEN, 0)+NVL(APP.UNEARNED_DISCOUNT_TAKEN, 0)))*-1) <> 0) OR ((SIGN((APP.AMOUNT_APPLIED+NVL(APP.EARNED_DISCOUNT_TAKEN, 0)+NVL(APP.UNEARNED_DISCOUNT_TAKEN, 0)))*-1 = 0) AND DIST.AMOUNT_DR IS NOT NULL))))))) UNION SELECT /*+LEADING(gt) cardinality(gt, 1) USE_NL(gt, app)*/ GT.EVENT_ID, DIST.LINE_ID, '', SOB.SET_OF_BOOKS_ID, DIST.SOURCE_ID, DIST.SOURCE_TABLE, DIST.LINE_ID, DIST.TAX_CODE_ID, DIST.LOCATION_SEGMENT_ID, SOB.CURRENCY_CODE, TRX.EXCHANGE_RATE_TYPE, TRX.EXCHANGE_RATE, TRX.EXCHANGE_DATE, NVL(DIST.ACCTD_AMOUNT_CR, 0) - NVL(DIST.ACCTD_AMOUNT_DR, 0), NVL(DIST.TAXABLE_ACCOUNTED_CR, 0) - NVL(DIST.TAXABLE_ACCOUNTED_DR, 0), APP.ORG_ID, APP.RECEIVABLE_APPLICATION_ID, 'APP', NULL, APP.CUSTOMER_TRX_ID, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, APP.RECEIVABLES_TRX_ID, NULL, NULL, APP.SET_OF_BOOKS_ID, NULL, TRX.BILL_TO_SITE_USE_ID, NULL, NULL, TRX.SOLD_TO_SITE_USE_ID, TRX.SHIP_TO_SITE_USE_ID, NULL, NULL, NULL, NULL, NULL, TRX.BILL_TO_CUSTOMER_ID, NULL, NULL, TRX.SOLD_TO_CUSTOMER_ID, TRX.SHIP_TO_CUSTOMER_ID, NULL, NULL, APP.RECEIVABLE_APPLICATION_ID, NULL, NULL, NULL, NULL, NULL, 'Y', 'L', 'T', NVL(DIST.AMOUNT_CR, 0) - NVL(DIST.AMOUNT_DR, 0), NVL(DIST.AMOUNT_CR, 0) -NVL(DIST.AMOUNT_DR, 0), NVL(DIST.ACCTD_AMOUNT_CR, 0) - NVL(DIST.ACCTD_AMOUNT_DR, 0), GT.EVENT_TYPE_CODE , GT.EVENT_CLASS_CODE , GT.ENTITY_CODE , NULL , APP.UPGRADE_METHOD , 'N' , DIST.SOURCE_TYPE , TO_NUMBER(NULL) , NULL , NULL FROM XLA_EVENTS_GT GT, AR_RECEIVABLE_APPLICATIONS_ALL APP, AR_DISTRIBUTIONS_ALL DIST, GL_SETS_OF_BOOKS SOB, RA_CUSTOMER_TRX_ALL TRX WHERE GT.EVENT_TYPE_CODE IN ( 'CM_CREATE', 'CM_UPDATE' ) AND GT.APPLICATION_ID = :B1 AND GT.EVENT_ID = APP.EVENT_ID AND DIST.SOURCE_TABLE = 'RA' AND DIST.SOURCE_ID = APP.RECEIVABLE_APPLICATION_ID AND APP.STATUS = 'ACTIVITY' AND APP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID AND TRX.CUSTOMER_TRX_ID = APP.CUSTOMER_TRX_ID AND DIST.SOURCE_TYPE = 'ACTIVITY'
bkwbfrp993czvUPDATE RA_CUSTOMER_TRX_LINES MTL SET LINE_RECOVERABLE = EXTENDED_AMOUNT, TAX_RECOVERABLE = (SELECT SUM(EXTENDED_AMOUNT) FROM RA_CUSTOMER_TRX_LINES SQTL WHERE SQTL.LINK_TO_CUST_TRX_LINE_ID = MTL.CUSTOMER_TRX_LINE_ID AND SQTL.CUSTOMER_TRX_ID = MTL.CUSTOMER_TRX_ID AND SQTL.LINE_TYPE = 'TAX') WHERE MTL.REQUEST_ID = :B2 AND NVL(MTL.PREVIOUS_CUSTOMER_TRX_ID, -99) = DECODE(:B1 , 'CM', MTL.PREVIOUS_CUSTOMER_TRX_ID, -99) AND MTL.LINE_TYPE = 'LINE'
bmvr0154yzvmvSELECT MIN(CALENDAR_DATE), MAX(CALENDAR_DATE) FROM BOM_CALENDAR_DATES WHERE CALENDAR_CODE = :B1 AND SEQ_NUM IS NOT NULL
bt475t962hbbrselect 1 from sys.sum$, sys.sumdep$ where obj# = sumobj# and bitand(xpflags, 1099511627776) = 1099511627776 and p_obj# = :1 and rownum < 2
byaf6gyh7qg9vdeclare ok_flag BOOLEAN ; BEGIN ok_flag := AR_InterfaceSalesCredits_GRP . delete_salescredit ( ) ; END ;
c7f2ankv7htm4SELECT PRIMARY_RESERVATION_QUANTITY FROM MTL_RESERVATIONS WHERE RESERVATION_ID = :B1
cd9mbmqyf4qhpUPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
d9ybtwvn89wctSELECT HEADER_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
drt9k4tpvph64SELECT AR_TAX.LOCATION_SEGMENT_ID, AR_TAX.ORG_ID, AR_TAX.TAX_LINE_ID, AR_TAX.VAT_TAX_ID, AR_TAX.SET_OF_BOOKS_ID, NVL(AR_REC.GL_DATE, TRUNC(SYSDATE)) FROM RA_CUSTOMER_TRX_LINES AR_TAX, RA_CUST_TRX_LINE_GL_DIST AR_REC WHERE AR_TAX.CUSTOMER_TRX_LINE_ID = :B1 AND AR_TAX.CUSTOMER_TRX_ID = AR_REC.CUSTOMER_TRX_ID AND AR_REC.ACCOUNT_CLASS = 'REC' AND AR_REC.LATEST_REC_FLAG = 'Y'
f07y7y34utqz1SELECT SEQUENCE_NUMBER FROM WSH_DOCUMENT_INSTANCES WHERE ENTITY_NAME = :B3 AND ENTITY_ID = :B2 AND STATUS <> 'CANCELLED' AND DOCUMENT_TYPE = :B1
f4p5c1tvqfnfrSELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOBAL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LATEST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHEDULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIPPING_QUANTITY_UOM2 , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRIBUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE , CHARGE_PERIODICITY_CODE , CANCELLED_QUANTITY2 , FULFILLED_QUANTITY2 , CONTINGENCY_ID , REVREC_EVENT_CODE , REVREC_EXPIRATION_DAYS , ACCEPTED_QUANTITY , REVREC_COMMENTS , REVREC_SIGNATURE , REVREC_SIGNATURE_DATE , ACCEPTED_BY , REVREC_REFERENCE_DOCUMENT , REVREC_IMPLICIT_FLAG , BYPASS_SCH_FLAG , PRE_EXPLODED_FLAG , SERVICE_BILL_PROFILE_ID , SERVICE_COV_TEMPLATE_ID , SERVICE_SUBS_TEMPLATE_ID , SERVICE_BILL_OPTION_CODE , SUBSCRIPTION_ENABLE_FLAG , SERVICE_FIRST_PERIOD_AMOUNT , SERVICE_FIRST_PERIOD_ENDDATE , FULFILLMENT_BASE , CONTAINER_NUMBER , EQUIPMENT_ID , REQUIRE_BILLING_VALIDATION , BILLING_PLAN_HEADER_ID , SOURCE_ORDER_LINE_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
g31wtj4vanqku DELETE FROM RA_INTERFACE_SALESCREDITS S WHERE EXISTS (SELECT 'X' FROM RA_INTERFACE_LINES_ALL L WHERE L.INTERFACE_LINE_CONTEXT ='ORDER ENTRY' AND L.INTERFACE_STATUS = 'P' AND S.INTERFACE_LINE_CONTEXT = L.INTERFACE_LINE_CONTEXT AND S.INTERFACE_LINE_ATTRIBUTE1= L.INTERFACE_LINE_ATTRIBUTE1 AND S.INTERFACE_LINE_ATTRIBUTE2= L.INTERFACE_LINE_ATTRIBUTE2 AND S.INTERFACE_LINE_ATTRIBUTE3= L.INTERFACE_LINE_ATTRIBUTE3 AND S.INTERFACE_LINE_ATTRIBUTE4= L.INTERFACE_LINE_ATTRIBUTE4 AND S.INTERFACE_LINE_ATTRIBUTE5= L.INTERFACE_LINE_ATTRIBUTE5 AND S.INTERFACE_LINE_ATTRIBUTE6= L.INTERFACE_LINE_ATTRIBUTE6 AND S.INTERFACE_LINE_ATTRIBUTE7= L.INTERFACE_LINE_ATTRIBUTE7 AND S.INTERFACE_LINE_ATTRIBUTE8= L.INTERFACE_LINE_ATTRIBUTE8 AND S.INTERFACE_LINE_ATTRIBUTE9= L.INTERFACE_LINE_ATTRIBUTE9 AND S.INTERFACE_LINE_ATTRIBUTE10= L.INTERFACE_LINE_ATTRIBUTE10 AND S.INTERFACE_LINE_ATTRIBUTE11= L.INTERFACE_LINE_ATTRIBUTE11 AND S.INTERFACE_LINE_ATTRIBUTE12= L.INTERFACE_LINE_ATTRIBUTE12 AND S.INTERFACE_LINE_ATTRIBUTE13= L.INTERFACE_LINE_ATTRIBUTE13 AND S.INTERFACE_LINE_ATTRIBUTE14= L.INTERFACE_LINE_ATTRIBUTE14)
gb694cbt9qks7DELETE FROM WMS_TRANSACTIONS_TEMP WHERE PP_TRANSACTION_TEMP_ID = :B1
gc3yz4rdhyqt5begin arp_process_payinfo . copy_payment_ext_id ( :num_copy_ext_failures ) ; EXCEPTION WHEN OTHERS THEN arp_standard . debug ( 'Error in arp_process_payinfo.' || 'copy_payment_ext_id()' ) ; arp_standard . debug ( '[' || SQLERRM ( SQLCODE ) || ']' ) ; RAISE ; END ;
gccbpwamzp78qdeclare l_header_rounding_flag VARCHAR2 ( 1 ) ; BEGIN select trx_header_level_rounding into l_header_rounding_flag from ar_system_parameters ; :return_value:i_return_value := arp_rounding . correct_dist_rounding_errors ( :request_id , NULL , NULL , :rows_processed:i_rows_processed , :error_msg:i_error_msg , NULL , NULL , :trx_class , 'N' , :debug_mode , l_header_rounding_flag , 'N' ) ; END ;
gnhmcahkmrnzsINSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 )
gxyzmvghm41nt DELETE FROM RA_INTERFACE_SALESCREDITS S WHERE EXISTS (SELECT 'X' FROM RA_INTERFACE_LINES_ALL L WHERE L.INTERFACE_LINE_CONTEXT ='OKL_CONTRACTS' AND L.INTERFACE_STATUS = 'P' AND S.INTERFACE_LINE_CONTEXT = L.INTERFACE_LINE_CONTEXT AND S.INTERFACE_LINE_ATTRIBUTE10= L.INTERFACE_LINE_ATTRIBUTE10 AND S.INTERFACE_LINE_ATTRIBUTE14= L.INTERFACE_LINE_ATTRIBUTE14 AND S.INTERFACE_LINE_ATTRIBUTE11= L.INTERFACE_LINE_ATTRIBUTE11)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

StatisticTotalper Secondper Trans
db block changes293,304,862101,351.01157.68
execute count121,522,75541,991.9965.33
logons cumulative4,8371.670.00
opened cursors cumulative125,640,44143,414.8567.54
parse count (total)17,061,1605,895.469.17
parse time elapsed25,2648.730.01
physical reads9,044,6773,125.374.86
physical writes39,61213.690.02
redo size44,119,459,58415,245,406.5723,717.93
session cursor cache hits125,460,77543,352.7667.45
session logical reads4,011,794,7271,386,269.062,156.68
user calls449,551155.340.24
user commits1,857,233641.761.00
user rollbacks2,9401.020.00
workarea executions - onepass200.010.00
workarea executions - optimal6,973,8192,409.793.75


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
ASSM cbk:blocks examined2,534,224875.701.36
ASSM cbk:blocks marked full349,915120.910.19
ASSM gsp:L1 bitmaps examined2,226,516769.371.20
ASSM gsp:L2 bitmap full9,8043.390.01
ASSM gsp:L2 bitmaps examined1,128,377389.910.61
ASSM gsp:L3 bitmaps examined00.000.00
ASSM gsp:Optimized reject DB199,62068.980.11
ASSM gsp:Optimized reject l117,1845.940.01
ASSM gsp:Search all46,68116.130.03
ASSM gsp:Search hint171,62859.310.09
ASSM gsp:Search steal46,67916.130.03
ASSM gsp:bump HWM46,67916.130.03
ASSM gsp:get free block1,881,038649.991.01
ASSM gsp:get free data block30.000.00
ASSM gsp:good hint772,988267.100.42
ASSM gsp:reject L114,3664.960.01
ASSM gsp:reject db303,523104.880.16
ASSM rsv:fill reserve430.010.00
ASSM wasted db state change1,707,833590.140.92
Batched IO (bound) vector count1,109,665383.440.60
Batched IO (full) vector count460.020.00
Batched IO block miss count2,960,9561,023.151.59
Batched IO buffer defrag count5990.210.00
Batched IO double miss count15,6645.410.01
Batched IO same unit count1,927,336665.991.04
Batched IO single block count1,062,850367.270.57
Batched IO slow jump count8210.280.00
Batched IO vector block count163,38856.460.09
Batched IO vector read count56,17719.410.03
Block Cleanout Optim referenced122,70042.400.07
CCursor + sql area evicted1,8540.640.00
CPU used by this session3,550,8441,226.991.91
CPU used when call started3,545,9681,225.301.91
CR blocks created30,721,10810,615.6316.52
Cached Commit SCN referenced25,9048.950.01
Commit SCN cached160.010.00
DFO trees parallelized1,8820.650.00
DML statements retried40.000.00
Effective IO time00.000.00
HSC Heap Segment Block Changes42,782,80214,783.5323.00
Heap Segment Array Deletes211,09272.940.11
Heap Segment Array Inserts328,038113.350.18
Heap Segment Array Updates206,16971.240.11
Heatmap BlkLevel Flushed40.000.00
Heatmap BlkLevel Flushed to BF40.000.00
Heatmap BlkLevel Ranges Flushed40.000.00
IMU CR rollbacks1,017,596351.630.55
IMU Flushes1,283,593443.540.69
IMU Redo allocation size2,740,742,488947,059.051,473.38
IMU commits529,147182.850.28
IMU contention512,675177.150.28
IMU ktichg flush9,4943.280.01
IMU pool not allocated146,77150.720.08
IMU recursive-transaction flush129,35944.700.07
IMU undo allocation size3,257,572,3761,125,648.771,751.22
IMU- failed to get a private strand146,77150.720.08
KTFB alloc req46,29116.000.02
KTFB alloc space (block)17,814,913,0246,155,913.849,577.02
KTFB alloc time (ms)4,688,3721,620.062.52
KTFB apply req9,5923.310.01
KTFB apply time (ms)79,39427.430.04
KTFB commit req00.000.00
KTFB commit time (ms)00.000.00
KTFB free req00.000.00
KTFB free space (block)00.000.00
KTFB free time (ms)00.000.00
LOB table id lookup cache misses00.000.00
Number of read IOs issued3880.130.00
PX local messages recv'd50,01217.280.03
PX local messages sent50,23817.360.03
Parallel operations downgraded 25 to 50 pct60.000.00
Parallel operations downgraded 75 to 99 pct00.000.00
Parallel operations downgraded to serial2300.080.00
Parallel operations not downgraded1,8760.650.00
Requests to/from client372,736128.800.20
RowCR - row contention268,75092.870.14
RowCR attempts28,047,7779,691.8615.08
RowCR hits24,851,7228,587.4713.36
SQL*Net roundtrips to/from client372,762128.810.20
active txn count during cleanout194,103,93167,072.29104.35
blocks cleaned out using minact186,79164.550.10
branch node splits1,2690.440.00
buffer is not pinned count1,491,239,399515,295.32801.67
buffer is pinned count2,446,502,967845,385.071,315.20
bytes received via SQL*Net from client103,464,18935,751.8855.62
bytes sent via SQL*Net to client115,036,53039,750.6861.84
calls to get snapshot scn: kcmgss141,238,16048,804.6175.93
calls to kcmgas18,285,3046,318.469.83
calls to kcmgcs14,970,7455,173.128.05
cell physical IO interconnect bytes74,928,570,36825,891,444.0440,280.43
change write time122,55142.350.07
cleanout - number of ktugct calls35,392,10212,229.6819.03
cleanouts and rollbacks - consistent read gets25,928,6118,959.5913.94
cleanouts only - consistent read gets922,233318.680.50
cluster key scan block gets278,54996.250.15
cluster key scans111,89738.670.06
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed92,21931.870.05
commit batch/immediate requested92,21931.870.05
commit cleanout failures: block lost582,178201.170.31
commit cleanout failures: buffer being written166,23257.440.09
commit cleanout failures: callback failure338,889117.100.18
commit cleanout failures: cannot pin673,525232.740.36
commit cleanouts15,421,9065,329.018.29
commit cleanouts successfully completed13,661,0824,720.567.34
commit immediate performed92,21931.870.05
commit immediate requested92,21931.870.05
commit txn count during cleanout7,685,8782,655.844.13
consistent changes1,745,974,527603,318.62938.61
consistent gets3,658,913,5011,264,331.531,966.97
consistent gets direct44,08515.230.02
consistent gets examination2,325,463,274803,560.001,250.13
consistent gets examination (fastpath)2,102,170,714726,401.631,130.09
consistent gets from cache3,658,869,4161,264,316.301,966.95
consistent gets pin1,333,406,142460,756.30716.82
consistent gets pin (fastpath)1,305,542,579451,128.09701.84
cursor authentications2,0890.720.00
cursor reload failures250.010.00
data blocks consistent reads - undo records applied1,713,121,283591,966.24920.95
db block changes293,304,862101,351.01157.68
db block gets352,881,254121,937.54189.70
db block gets direct630.020.00
db block gets from cache352,881,191121,937.51189.70
db block gets from cache (fastpath)261,906,27790,501.28140.80
deferred (CURRENT) block cleanout applications2,319,684801.561.25
dirty buffers inspected2,011,380695.031.08
doubling up with imu segment00.000.00
enqueue conversions8,9133.080.00
enqueue deadlocks300.010.00
enqueue releases9,138,6013,157.834.91
enqueue requests11,219,5353,876.896.03
enqueue timeouts2,080,875719.041.12
enqueue waits283,51597.970.15
exchange deadlocks207,65671.760.11
execute count121,522,75541,991.9965.33
failed probes on index block reclamation14,7125.080.01
fastpath consistent get quota limit452,642156.410.24
file io service time243,17684.030.13
frame signature mismatch00.000.00
free buffer inspected205,351,75870,958.96110.39
free buffer requested49,159,24616,986.9026.43
heap block compress56,629,07619,568.0830.44
hot buffers moved to head of LRU169,540,59558,584.4791.14
immediate (CR) block cleanout applications26,851,1919,278.3814.43
immediate (CURRENT) block cleanout applications1,756,999607.130.94
index crx state invalidation6840.240.00
index crx upgrade (positioned)110,11638.050.06
index fast full scans (direct read)00.000.00
index fast full scans (full)00.000.00
index fast full scans (rowid ranges)2920.100.00
index fetch by key169,428,54758,545.7691.08
index range scans243,152,94284,021.10130.72
index reclamation/extension switch100.000.00
index split cancel op set6580.230.00
index split cancel wait clean5760.200.00
index split cancel wait noclean85,82729.660.05
java call heap collected bytes3,810,843,4001,316,830.662,048.65
java call heap collected count51,826,15017,908.4427.86
java call heap gc count2,8350.980.00
java call heap live object count5,915,0282,043.933.18
java call heap live object count max6,250,7752,159.953.36
java call heap live size485,310,072167,698.10260.90
java call heap live size max507,937,232175,516.87273.06
java call heap object count12,286,3494,245.536.60
java call heap object count max12,780,9784,416.456.87
java call heap total size3,303,792,6401,141,620.101,776.07
java call heap total size max3,303,925,7601,141,666.101,776.14
java call heap used size950,944,064328,597.15511.21
java call heap used size max957,180,448330,752.13514.57
java session heap live size281,210,88097,171.96151.17
java session heap live size max281,210,88097,171.96151.17
java session heap used size281,210,88097,171.96151.17
java session heap used size max281,210,88097,171.96151.17
leaf node 90-10 splits19,0176.570.01
leaf node splits333,800115.340.18
lob reads603,341208.480.32
lob writes602,901208.330.32
lob writes unaligned602,901208.330.32
logical read bytes from cache32,864,260,972,54411,356,191,232.1717,667,314.26
logons cumulative4,8371.670.00
messages sent551,418190.540.30
min active SCN optimization applied on CR7,186,6232,483.333.86
no buffer to keep pinned count1,8680.650.00
no work - consistent read gets1,241,764,144429,089.55667.55
non-idle wait count21,416,5917,400.4711.51
opened cursors cumulative125,640,44143,414.8567.54
parse count (describe)260.010.00
parse count (failures)4690.160.00
parse count (hard)1,6080.560.00
parse count (total)17,061,1605,895.469.17
parse time cpu17,7646.140.01
parse time elapsed25,2648.730.01
physical read IO requests8,151,5052,816.744.38
physical read bytes74,093,993,98425,603,057.5439,831.78
physical read total IO requests8,183,8452,827.914.40
physical read total bytes74,604,068,86425,779,313.0840,105.98
physical read total multi block requests20,5927.120.01
physical reads9,044,6773,125.374.86
physical reads cache8,960,9093,096.434.82
physical reads cache prefetch909,867314.400.49
physical reads direct83,76828.950.05
physical reads direct (lob)600.020.00
physical reads direct temporary tablespace40,19413.890.02
physical reads prefetch warmup00.000.00
physical write IO requests1,6000.550.00
physical write bytes324,501,504112,130.96174.45
physical write total IO requests1,6000.550.00
physical write total bytes324,501,504112,130.96174.45
physical write total multi block requests1,2410.430.00
physical writes39,61213.690.02
physical writes direct39,61213.690.02
physical writes direct (lob)630.020.00
physical writes direct temporary tablespace39,54913.670.02
physical writes non checkpoint39,61213.690.02
pinned buffers inspected55,55519.200.03
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use7980.280.00
process last non-idle time2,8951.000.00
queries parallelized4220.150.00
recursive aborts on index block reclamation1430.050.00
recursive calls213,813,52773,882.91114.94
recursive cpu usage2,626,478907.581.41
redo buffer allocation retries1,4660.510.00
redo entries151,288,21752,277.3981.33
redo log space requests27,6479.550.01
redo ordering marks9,6663.340.01
redo size44,119,459,58415,245,406.5723,717.93
redo size for direct writes3,6601.260.00
redo subscn max counts255,84188.410.14
redo synch long waits80.000.00
redo synch time12,8854.450.01
redo synch time (usec)128,850,96644,524.2469.27
redo synch time overhead (usec)2,807,965970.291.51
redo synch time overhead count ( 2ms)8,6913.000.00
redo synch time overhead count ( 8ms)2320.080.00
redo synch time overhead count ( 32ms)620.020.00
redo synch time overhead count (128ms)30.000.00
redo synch writes9,6113.320.01
redo write info find8,9883.110.00
rollback changes - undo records applied97,65233.740.05
rollbacks only - consistent read gets4,160,1291,437.532.24
root node splits720.020.00
rows fetched via callback103,467,03235,752.8655.62
securefile direct read bytes00.000.00
securefile direct read ops00.000.00
session connect time00.000.00
session cursor cache hits125,460,77543,352.7667.45
session logical reads4,011,794,7271,386,269.062,156.68
shared hash latch upgrades - no wait45,575,32415,748.4824.50
shared hash latch upgrades - wait693,208239.540.37
shared io pool buffer get success00.000.00
sorts (disk)100.000.00
sorts (memory)14,962,6725,170.338.04
sorts (rows)46,617,68516,108.6625.06
sql area evicted1,8040.620.00
sql area purged4160.140.00
switch current caused by our pin3,710,4851,282.151.99
switch current to new buffer4,470,6541,544.832.40
table fetch by rowid1,810,959,096625,773.93973.54
table fetch continued row20,887,5537,217.6611.23
table scan blocks gotten104,603,89636,145.7056.23
table scan disk non-IMC rows gotten9,498,459,8593,282,177.155,106.22
table scan rows gotten9,499,480,5703,282,529.865,106.77
table scans (direct read)10.000.00
table scans (long tables)990.030.00
table scans (rowid ranges)970.030.00
table scans (short tables)3,776,2861,304.892.03
temp space allocated (bytes)1,048,576362.330.56
transaction rollbacks92,21931.870.05
transaction tables consistent read rollbacks2,3190.800.00
transaction tables consistent reads - undo records applied3,537,0301,222.211.90
undo change vector size16,164,291,5325,585,544.318,689.67
user calls449,551155.340.24
user commits1,857,233641.761.00
user logons cumulative9630.330.00
user logouts cumulative9620.330.00
user rollbacks2,9401.020.00
workarea executions - onepass200.010.00
workarea executions - optimal6,973,8192,409.793.75
write clones created in foreground578,384199.860.31


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current738739
opened cursors current5,6225,453
session cursor cache count1,541,3501,711,702
session pga memory2,436,638,3042,475,769,776
session pga memory max2,781,638,6242,851,729,136
session uga memory29,887,135,51231,071,753,000
session uga memory max346,622,787,216372,250,206,440
workarea memory allocated5,8926,049


Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Data File68.6G2811.8224.281M39.8G1186.7214.08M3.13us1.00us
TOTAL:68.6G2811.8224.281M39.8G1186.7214.08M3.13us1.00us


Back to IO Stats
Back to Top

Tablespace IO Stats

No data exists for this section of the report.

Back to IO Stats
Back to Top

File IO Stats

No data exists for this section of the report.

Back to IO Stats
Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block2,263,76613,1296
undo block826,4783660
undo header338,9081530
segment header18,308432
1st level bmb32,485191
2nd level bmb49000
3rd level bmb25300
extent map1501
file header block6100



Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
181,949.312,324,601017115/150/00/0/0/0/0/0


Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
23-Apr 19:11548,638117,639038150/00/0/0/0/0/0
23-Apr 19:01452,5191,013,2480171150/00/0/0/0/0/0
23-Apr 18:5186,535190,717034150/00/0/0/0/0/0
23-Apr 18:41684,560948,453051150/00/0/0/0/0/0
23-Apr 18:31177,06054,544053150/00/0/0/0/0/0


Back to Undo Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Logical Reads%TotalPDB Name
ZXAPPS_TS_TX_DATA ZX_RATES_B TABLE19456751945675518,356,75212.92 VOL1229
APPLSYSAPPS_TS_SEED FND_LOOKUP_VALUES TABLE34779461059232,198,2085.79 VOL1229
WSHAPPS_TS_TX_IDX WSH_DELIVERY_DETAILS_U1 INDEX68520520691467,159,2961.67 VOL1229
BOMAPPS_TS_TX_DATA BOM_CALENDAR_DATES TABLE47150177962648,445,0721.21 VOL1229
WSHAPPS_TS_TX_DATA WSH_DELIVERY_DETAILS TABLE68511520691747,274,0641.18 VOL1229


Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Physical Reads%TotalPDB Name
ARAPPS_TS_INTERFACE RA_INTERFACE_LINES_ALL TABLE436961778810693,3467.67 VOL1229
ZXAPPS_TS_TX_DATA ZX_LINES_DET_FACTORS TABLE19456061945606682,5247.55 VOL1229
INVAPPS_TS_TX_DATA MTL_SYSTEM_ITEMS_B TABLE411551778882314,7663.48 VOL1229
ARAPPS_TS_TX_DATA RA_CUSTOMER_TRX_LINES_ALL TABLE436431778171196,8962.18 VOL1229
ARAPPS_TS_INTERFACE RA_INTERFACE_SALESCREDITS_ALL TABLE437041779471138,9681.54 VOL1229


Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Phys Read Requests%TotalPDB Name
ZXAPPS_TS_TX_DATA ZX_LINES_DET_FACTORS TABLE19456061945606678,7968.33 VOL1229
INVAPPS_TS_TX_DATA MTL_SYSTEM_ITEMS_B TABLE411551778882314,7043.86 VOL1229
ARAPPS_TS_TX_DATA RA_CUSTOMER_TRX_LINES_ALL TABLE436431778171196,5962.41 VOL1229
ARAPPS_TS_INTERFACE RA_INTERFACE_LINES_ALL TABLE436961778810155,6131.91 VOL1229
ZXAPPS_TS_TX_DATA ZX_LINES TABLE19455791945579112,4661.38 VOL1229


Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#UnOptimized Reads%TotalPDB Name
ZXAPPS_TS_TX_DATA ZX_LINES_DET_FACTORS TABLE19456061945606678,7968.33 VOL1229
INVAPPS_TS_TX_DATA MTL_SYSTEM_ITEMS_B TABLE411551778882314,7043.86 VOL1229
ARAPPS_TS_TX_DATA RA_CUSTOMER_TRX_LINES_ALL TABLE436431778171196,5962.41 VOL1229
ARAPPS_TS_INTERFACE RA_INTERFACE_LINES_ALL TABLE436961778810155,6131.91 VOL1229
ZXAPPS_TS_TX_DATA ZX_LINES TABLE19455791945579112,4661.38 VOL1229


Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Direct Reads%TotalPDB Name
ARAPPS_TS_INTERFACE RA_INTERFACE_LINES_ALL TABLE43696177881043,15751.52 VOL1229


Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Physical Writes%TotalPDB Name
ARAPPS_TS_INTERFACE RA_INTERFACE_LINES_ALL TABLE436961778810168,169424.54 VOL1229
APPLSYSAPPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_N1 INDEX25688272568827163,776413.45 VOL1229
WSHAPPS_TS_SUMMARY MLOG$_WSH_DELIVERY_DETAILS TABLE1297429419092281,627206.07 VOL1229
ZXAPPS_TS_TX_DATA ZX_LINES TABLE1945579194557980,189202.44 VOL1229
APPLSYSAPPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK INDEX35429179720272,491183.00 VOL1229


Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Phys Write Requests%TotalPDB Name
APPLSYSAPPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_N1 INDEX25688272568827149,4829342.63 VOL1229
ARAPPS_TS_INTERFACE RA_INTERFACE_LINES_ALL TABLE436961778810143,6338977.06 VOL1229
ZXAPPS_TS_TX_DATA ZX_LINES TABLE1945579194557967,6634228.94 VOL1229
APPLSYSAPPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK INDEX35429179720262,9163932.25 VOL1229
APPLSYSAPPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N5 INDEX7668528766852856,9563559.75 VOL1229


Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Table Scans%TotalPDB Name
INVAPPS_TS_INTERFACE MTL_TRANSACTIONS_INTERFACE TABLE4118317897779797.98 VOL1229


Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#DB Block Changes% of CapturePDB Name
WSHAPPS_TS_INTERFACE WSH_PR_WORKERS TABLE19456655206958403,289,39224.47 VOL1229
INVAPPS_TS_TX_IDX MTL_MATERIAL_TRANS_TEMP_N14 INDEX409301832497145,684,9448.84 VOL1229
WSHAPPS_TS_TX_IDX WSH_DELIVERY_DETAILS_N7 INDEX21000885206904128,302,8647.79 VOL1229
ARAPPS_TS_INTERFACE RA_INTERFACE_LINES_ALL TABLE43696177881078,330,5124.75 VOL1229
MRPAPPS_TS_TX_IDX MRP_ATP_SCHEDULE_TEMP_N1 INDEX4604083460408374,248,5924.51 VOL1229


Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Row Lock Waits% of CapturePDB Name
WSHAPPS_TS_INTERFACE WSH_PR_WORKERS TABLE194566552069582,073,72094.02 VOL1229
APPLSYSAPPS_TS_TX_DATA WF_ITEMS TABLE351711779752120,5895.47 VOL1229
WSHAPPS_TS_TX_IDX WSH_TRIP_STOPS_N6 INDEX88943252069405,1270.23 VOL1229
APPLSYSAPPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N5 INDEX766852876685281,7890.08 VOL1229
APPLSYSAPPS_TS_TX_DATA FND_CONCURRENT_REQUESTS TABLE3437617840801,4490.07 VOL1229


Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#ITL Waits% of CapturePDB Name
APPLSYSAPPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSESWF_ITEM49TABLE PARTITION35229181041913,53499.20 VOL1229
SYSSYSTEM COL$ TABLE74628937462886430.32 VOL1229
ARAPPS_TS_INTERFACE RA_INTERFACE_LINES_U1 INDEX436981828904100.07 VOL1229
XLAAPPS_TS_TX_IDX XLA_DISTRIBUTION_LINKS_U1ARINDEX PARTITION1946605194660580.06 VOL1229
INVAPPS_TS_TX_IDX MTL_MATERIAL_TRANSACTIONS_N29 INDEX7668543766854350.04 VOL1229


Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeObj#Dataobj#Buffer Busy Waits% of CapturePDB Name
APPLSYSAPPS_TS_QUEUES SYS_IOT_TOP_35554 INDEX355551782356355,19916.06 VOL1229
APPLSYSAPPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES TABLE354241778320215,9529.77 VOL1229
ONTAPPS_TS_TX_DATA OE_ORDER_LINES_ALL TABLE680695206900210,7119.53 VOL1229
WSHAPPS_TS_TX_IDX WSH_TRIP_STOPS_N6 INDEX8894325206940187,4188.48 VOL1229
INVAPPS_TS_TX_IDX MTL_MATERIAL_TRANSACTIONS_U1 INDEX409071796290152,2976.89 VOL1229


Back to Segment Statistics
Back to Top

Initialization Parameters

Back to Top

Parameters modified by this container

Parameter NameBegin valueEnd value (if different)PDB Name
aq_tm_processes1   VOL1229
cursor_sharingEXACT   VOL1229
db_block_checkingFALSE   VOL1229
db_files512   VOL1229
job_queue_processes2   VOL1229
max_dump_file_size20480   VOL1229
nls_compbinary   VOL1229
nls_date_formatDD-MON-RR   VOL1229
nls_length_semanticsBYTE   VOL1229
nls_numeric_characters.,   VOL1229
nls_sortbinary   VOL1229
nls_territoryamerica   VOL1229
open_cursors600   VOL1229
optimizer_secure_view_mergingFALSE   VOL1229
parallel_force_localTRUE   VOL1229
parallel_max_servers8   VOL1229
pga_aggregate_limit0   VOL1229
pga_aggregate_target10737418240   VOL1229
plsql_code_typeINTERPRETED   VOL1229
recyclebinoff   VOL1229
session_cached_cursors500   VOL1229
sessions5024   VOL1229
sga_target5368709120   VOL1229
shared_pool_size1895825408   VOL1229
sql92_securityTRUE   VOL1229
undo_managementAUTO   VOL1229
undo_tablespaceAPPS_UNDOTS1   VOL1229
workarea_size_policyAUTO   VOL1229


Back to Initialization Parameters
Back to Top

Parameters modified by other containers

Parameter NameBegin valueEnd value (if different)PDB Name
_b_tree_bitmap_plansFALSE    
_fast_full_scan_enabledFALSE    
_like_with_bind_as_equalityTRUE    
_optimizer_autostats_jobFALSE    
_pdb_name_case_sensitiveTRUE    
_sort_elimination_cost_ratio5    
_system_trig_enabledTRUE    
_trace_files_publicFALSE    
audit_file_dest/u01/admin/EBSCDB/adump    
audit_sys_operationsTRUE    
audit_trailDB    
compatible19.0.0    
control_files/u01/oradata/EBSCDB/control01.ctl, /u01/oradata/EBSCDB/control02.ctl    
db_block_checksumTRUE    
db_block_size8192    
db_domain      
db_nameEBSCDB    
diagnostic_dest/u01    
dispatchers(PROTOCOL=TCP) (SERVICE=EBSCDBXDB)    
dml_locks10000    
enable_pluggable_databaseTRUE    
event10995 trace name context forever, level 16, 10946 trace name context forever, level 8454144    
local_listenerebs1229db:1521    
log_archive_format%t_%s_%r.dbf    
log_buffer104857600    
log_checkpoint_interval100000    
log_checkpoint_timeout1200    
log_checkpoints_to_alertTRUE    
nls_languageAMERICAN    
parallel_min_servers0    
processes2500    
remote_login_passwordfileEXCLUSIVE    
sec_case_sensitive_logonFALSE    
shared_pool_reserved_size105696460    


Back to Initialization Parameters
Back to Top

Multi-Valued Parameters modified by this container

No data exists for this section of the report.

Back to Initialization Parameters
Back to Top

Multi-Valued Parameters modified by other containers

Parameter NameBegin valueEnd value (if different)PDB Name
control_files/u01/oradata/EBSCDB/control01.ctl    
/u01/oradata/EBSCDB/control02.ctl    
event10946 trace name context forever, level 8454144    
10995 trace name context forever, level 16    


Back to Initialization Parameters
Back to Top

Active Session History (ASH) Report

Back to Top

Top SQL with Top Events

SQL IDPlan HashExecutions% ActivityEvent% EventTop Row Source% Row SourceSQL TextContainer Name
0z318y6g3uagc 20021.69 buffer busy waits15.00** Row Source Not Available **15.00 declare l_retstat varchar2 ( 3...VOL1229
 20021.69 CPU + Wait for CPU4.30** Row Source Not Available **4.30 declare l_retstat varchar2 ( 3...VOL1229
 20021.69 enq: TX - index contention1.07** Row Source Not Available **1.07 declare l_retstat varchar2 ( 3...VOL1229
8zfgv4ck11dw9 305.40 CPU + Wait for CPU4.56** Row Source Not Available **4.56 BEGIN WF_ENGINE.BACKGROUNDCONC...VOL1229
4y08a52989vfk 434.55 CPU + Wait for CPU4.55** Row Source Not Available **4.55 BEGIN WSH_PICK_LIST.RELEASE_BA...VOL1229
g31wtj4vanqku3271231823313.18 enq: TX - row lock contention3.17DELETE3.17 DELETE FROM RA_INTERFACE_SALE...VOL1229
cd9mbmqyf4qhp15975065851512.46 enq: TX - allocate ITL entry1.16UPDATE1.16 UPDATE WF_ITEM_ACTIVITY_STATUS...VOL1229


Back to Active Session History (ASH) Report
Back to Top

Top SQL with Top Row Sources

SQL IDPlan HashExecutions% ActivityRow Source% Row SourceTop Event% EventSQL TextContainer Name
0z318y6g3uagc 20021.69 ** Row Source Not Available **21.69buffer busy waits15.00 declare l_retstat varchar2 ( 3...VOL1229
8zfgv4ck11dw9 305.40 ** Row Source Not Available **5.40CPU + Wait for CPU4.56 BEGIN WF_ENGINE.BACKGROUNDCONC...VOL1229
4y08a52989vfk 434.55 ** Row Source Not Available **4.55CPU + Wait for CPU4.55 BEGIN WSH_PICK_LIST.RELEASE_BA...VOL1229
g31wtj4vanqku3271231823313.18 DELETE3.17enq: TX - row lock contention3.17 DELETE FROM RA_INTERFACE_SALE...VOL1229
cd9mbmqyf4qhp15975065851512.46 UPDATE1.96enq: TX - allocate ITL entry1.16 UPDATE WF_ITEM_ACTIVITY_STATUS...VOL1229


Back to Active Session History (ASH) Report
Back to Top

Top Sessions

No data exists for this section of the report.

Back to Active Session History (ASH) Report
Back to Top

Top Blocking Sessions

Blocking Sid (Inst)% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
3612,35729( 1)4.74log file switch (checkpoint incomplete)3.58 ** NOT FOUND **BLOCKING SESSION NOT FOUND0/289 [ 0%] 
159,61341( 1)2.97enq: TX - row lock contention2.97 APPSRAXTRX@ebs1229mt (TNS V1-V3)39/289 [ 13%]3
479,59280( 1)1.24buffer busy waits1.24 APPSINVMGR@ebs1229mt (TNS V1-V3)13/289 [ 4%]11


Back to Active Session History (ASH) Report
Back to Top

Top PL/SQL Procedures

PL/SQL Entry Subprogram% ActivityPL/SQL Current Subprogram% CurrentContainer Name
APPS.INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS33.94 SQL28.96 VOL1229
UNKNOWN_PLSQL_ID <7534518, 50>1.28 VOL1229
APPS.WF_ENGINE.BACKGROUNDCONCURRENT16.09 SQL10.92 VOL1229
SYS.DBMS_AQ.DEQUEUE#21.33 VOL1229
APPS.WSH_PICK_LIST.RELEASE_BATCH_SUB14.87 SQL10.97 VOL1229
UNKNOWN_PLSQL_ID <7115664, 39>1.03 VOL1229
APPS.WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_ALL_WRP9.01 SQL7.88 VOL1229
APPS.ARP_ETAX_AUTOINV_UTIL.CALCULATE_TAX6.40 SQL5.65 VOL1229


Back to Active Session History (ASH) Report
Back to Top

Top Events

EventEvent ClassSession Type% ActivityAvg Active Sessions
CPU + Wait for CPUCPUFOREGROUND 56.5413.27
buffer busy waitsConcurrencyFOREGROUND 18.954.45
latch: cache buffers chainsConcurrencyFOREGROUND 7.491.76
enq: TX - row lock contentionApplicationFOREGROUND 4.511.06
log file switch (checkpoint incomplete)ConfigurationFOREGROUND 3.470.82


Back to Active Session History (ASH) Report
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1, P2, P3 Values% ActivityParameter 1Parameter 2Parameter 3
buffer busy waits18.95"136","132723","1"2.99 file#block#class#
"139","132892","1"1.25
"138","130881","1"1.24
latch: cache buffers chains7.49"3332077888","327","188915068"1.12 addressnumberwhy
enq: TX - row lock contention4.51"1415053318","8847379","1807"3.15 name|modeusn<<16 | slotsequence
enq: TX - index contention1.31"1415053316","4784160","7523"0.69 name|modeusn<<16 | slotsequence
enq: TX - allocate ITL entry1.16"1415053316","2359321","31269"0.04 name|modeusn<<16 | slotsequence


Back to Active Session History (ASH) Report
Back to Top

Top DB Objects

Object ID% ActivityEvent% EventObject Name (Type)TablespaceContainer Name
4090715.14buffer busy waits15.14 INV.MTL_MATERIAL_TRANSACTIONS_U1 (INDEX)APPS_TS_TX_IDX VOL1229
437043.39enq: TX - row lock contention3.37 AR.RA_INTERFACE_SALESCREDITS_ALL (TABLE)APPS_TS_INTERFACE VOL1229
351711.15enq: TX - row lock contention1.13 APPLSYS.WF_ITEMS (TABLE)APPS_TS_TX_DATA VOL1229


Back to Active Session History (ASH) Report
Back to Top

Activity Over Time

Slot Time (Duration)Slot CountEventEvent Count% Event
18:30:49 (4.2 min)428CPU + Wait for CPU2693.96
log file switch (checkpoint incomplete)1051.55
buffer busy waits180.27
18:35:00 (5.0 min)742CPU + Wait for CPU73510.82
buffer busy waits10.01
enq: FB - contention10.01
18:40:00 (5.0 min)175CPU + Wait for CPU1752.58
18:45:00 (5.0 min)146CPU + Wait for CPU1392.05
row cache mutex30.04
enq: CR - block range reuse ckpt20.03
18:50:00 (5.0 min)561CPU + Wait for CPU3144.62
latch: cache buffers chains1952.87
buffer busy waits270.40
18:55:00 (5.0 min)2,586CPU + Wait for CPU1,11216.37
buffer busy waits85712.62
latch: cache buffers chains2603.83
19:00:00 (5.0 min)1,196CPU + Wait for CPU6219.14
buffer busy waits3795.58
latch: cache buffers chains510.75
19:05:00 (5.0 min)820CPU + Wait for CPU3985.86
enq: TX - row lock contention1942.86
log file switch (checkpoint incomplete)841.24
19:10:00 (5.0 min)87CPU + Wait for CPU510.75
enq: TX - row lock contention350.52
db file sequential read10.01
19:15:00 (4.1 min)51CPU + Wait for CPU350.52
write complete waits80.12
enq: CR - block range reuse ckpt60.09


Back to Active Session History (ASH) Report
Back to Top

ADDM Task ADDM:684292237_1_311

          ADDM Report for Task 'ADDM:684292237_1_311'
          -------------------------------------------

Analysis Period
---------------
AWR snapshot range from 310 to 311.
Time period starts at 23-APR-20 06.56.20 PM
Time period ends at 23-APR-20 07.03.11 PM

Analysis Target
---------------
Database 'EBSCDB' with DB ID 684292237.
Database version 19.0.0.0.0.
ADDM performed an analysis of instance EBSCDB, numbered 1 and hosted at
ebs1229db.
ADDM detected that the system is a PDB.

Activity During the Analysis Period
-----------------------------------
Total database time was 36052 seconds.
The average number of active sessions was 87.72.

Summary of Findings
-------------------
   Description                Active Sessions      Recommendations
                              Percent of Activity
   -------------------------  -------------------  ---------------
1  Top SQL Statements         50.75 | 57.86        4
2  Buffer Busy - Hot Objects  31.88 | 36.34        5
3  PL/SQL Execution           18.17 | 20.72        3
4  Buffer Cache Latches       4.76 | 5.43          0
5  Shared Pool Latches        1.94 | 2.22          1
6  Index Block Split          1.9 | 2.17           1
7  Row Lock Waits             1.83 | 2.09          1
8  Log File Switches          1.77 | 2.02          0


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


          Findings and Recommendations
          ----------------------------

Finding 1: Top SQL Statements
Impact is 50.75 active sessions, 57.86% of total activity.
----------------------------------------------------------
SQL statements consuming significant database time were found. These
statements offer a good opportunity for performance improvement.

   Recommendation 1: SQL Tuning
   Estimated benefit is 36.52 active sessions, 41.63% of total activity.
   ---------------------------------------------------------------------
   Action
      Investigate the PL/SQL statement with SQL_ID "0z318y6g3uagc" for
      possible performance improvements. You can supplement the information
      given here with an ASH report for this SQL_ID.
      Related Object
         SQL statement with SQL_ID 0z318y6g3uagc.
         declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ;
         l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval :=
         INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 ,
         p_commit => fnd_api . g_true , x_return_status => l_retstat ,
         x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count
         => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
   Rationale
      The SQL Tuning Advisor cannot operate on PL/SQL statements.
   Rationale
      Database time for this SQL was divided as follows: 82% for SQL
      execution, 0% for parsing, 13% for PL/SQL execution and 5% for Java
      execution.
   Rationale
      SQL statement with SQL_ID "0z318y6g3uagc" was executed 200 times and had
      an average elapsed time of 108 seconds.
   Rationale
      Waiting for event "buffer busy waits" in wait class "Concurrency"
      accounted for 69% of the database time spent in processing the SQL
      statement with SQL_ID "0z318y6g3uagc".
   Rationale
      Waiting for event "enq: TX - index contention" in wait class
      "Concurrency" accounted for 4% of the database time spent in processing
      the SQL statement with SQL_ID "0z318y6g3uagc".

   Recommendation 2: SQL Tuning
   Estimated benefit is 9.1 active sessions, 10.37% of total activity.
   -------------------------------------------------------------------
   Action
      Investigate the PL/SQL statement with SQL_ID "8zfgv4ck11dw9" for
      possible performance improvements. You can supplement the information
      given here with an ASH report for this SQL_ID.
      Related Object
         SQL statement with SQL_ID 8zfgv4ck11dw9.
         BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf,:rc,:A0,:A1,:A2,:A3,:A4)
         ; END;
   Rationale
      The SQL Tuning Advisor cannot operate on PL/SQL statements.
   Rationale
      Database time for this SQL was divided as follows: 8% for SQL execution,
      0% for parsing, 92% for PL/SQL execution and 0% for Java execution.
   Rationale
      SQL statement with SQL_ID "8zfgv4ck11dw9" was executed 32 times and had
      an average elapsed time of 353 seconds.

   Recommendation 3: SQL Tuning
   Estimated benefit is 3.12 active sessions, 3.56% of total activity.
   -------------------------------------------------------------------
   Action
      Investigate the UPDATE statement with SQL_ID "cd9mbmqyf4qhp" for
      possible performance improvements. You can supplement the information
      given here with an ASH report for this SQL_ID.
      Related Object
         SQL statement with SQL_ID cd9mbmqyf4qhp.
         UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 ,
         ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE =
         NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE =
         DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID =
         :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 ,
         NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ),
         EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND
         PROCESS_ACTIVITY = :B1
   Rationale
      The SQL spent only 23% of its database time on CPU, I/O and Cluster
      waits. Therefore, the SQL Tuning Advisor is not applicable in this case.
      Look at performance data for the SQL to find potential improvements.
   Rationale
      Database time for this SQL was divided as follows: 100% for SQL
      execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java
      execution.
   Rationale
      SQL statement with SQL_ID "cd9mbmqyf4qhp" was executed 799881 times and
      had an average elapsed time of 0.0016 seconds.
   Rationale
      Waiting for event "enq: TX - allocate ITL entry" in wait class
      "Configuration" accounted for 62% of the database time spent in
      processing the SQL statement with SQL_ID "cd9mbmqyf4qhp".
   Rationale
      Top level calls to execute the PL/SQL statement with SQL_ID
      "8zfgv4ck11dw9" are responsible for 100% of the database time spent on
      the UPDATE statement with SQL_ID "cd9mbmqyf4qhp".
      Related Object
         SQL statement with SQL_ID 8zfgv4ck11dw9.
         BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf,:rc,:A0,:A1,:A2,:A3,:A4)
         ; END;

   Recommendation 4: SQL Tuning
   Estimated benefit is 2.01 active sessions, 2.29% of total activity.
   -------------------------------------------------------------------
   Action
      Investigate the SELECT statement with SQL_ID "0wabkkyua3y3v" for
      possible performance improvements. You can supplement the information
      given here with an ASH report for this SQL_ID.
      Related Object
         SQL statement with SQL_ID 0wabkkyua3y3v.
         SELECT ITEM_KEY FROM WF_ITEMS WHERE ITEM_TYPE = :B2 AND ITEM_KEY =
         :B1 FOR UPDATE
   Rationale
      The SQL spent only 4% of its database time on CPU, I/O and Cluster
      waits. Therefore, the SQL Tuning Advisor is not applicable in this case.
      Look at performance data for the SQL to find potential improvements.
   Rationale
      Database time for this SQL was divided as follows: 100% for SQL
      execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java
      execution.
   Rationale
      SQL statement with SQL_ID "0wabkkyua3y3v" was executed 99999 times and
      had an average elapsed time of 0.0078 seconds.
   Rationale
      Waiting for event "enq: TX - row lock contention" in wait class
      "Application" accounted for 95% of the database time spent in processing
      the SQL statement with SQL_ID "0wabkkyua3y3v".
   Rationale
      Top level calls to execute the PL/SQL statement with SQL_ID
      "8zfgv4ck11dw9" are responsible for 100% of the database time spent on
      the SELECT statement with SQL_ID "0wabkkyua3y3v".
      Related Object
         SQL statement with SQL_ID 8zfgv4ck11dw9.
         BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf,:rc,:A0,:A1,:A2,:A3,:A4)
         ; END;


Finding 2: Buffer Busy - Hot Objects
Impact is 31.88 active sessions, 36.34% of total activity.
----------------------------------------------------------
Read and write contention on database blocks was consuming significant
database time.

   Recommendation 1: Application Analysis
   Estimated benefit is 26.86 active sessions, 30.62% of total activity.
   ---------------------------------------------------------------------
   Action
      Trace the cause of contention on INDEX
      "INV.MTL_MATERIAL_TRANSACTIONS_U1" with object ID 40907 in the
      application.
      Related Object
         Database object with ID 40907.

   Recommendation 2: Application Analysis
   Estimated benefit is 1.25 active sessions, 1.43% of total activity.
   -------------------------------------------------------------------
   Action
      Trace the cause of contention on IOT "APPLSYS.AQ$_WF_DEFERRED_TABLE_M_I"
      with object ID 35554 in the application.
      Related Object
         Database object with ID 35554.

   Recommendation 3: Schema Changes
   Estimated benefit is 1.05 active sessions, 1.19% of total activity.
   -------------------------------------------------------------------
   Action
      Consider rebuilding the TABLE "ONT.OE_ORDER_LINES_ALL" with object ID
      68069 using a higher value for PCTFREE.
      Related Object
         Database object with ID 68069.

   Recommendation 4: Schema Changes
   Estimated benefit is .81 active sessions, .92% of total activity.
   -----------------------------------------------------------------
   Action
      Consider rebuilding the TABLE "INV.MTL_TRANSACTIONS_INTERFACE" with
      object ID 41183 using a higher value for PCTFREE.
      Related Object
         Database object with ID 41183.

   Recommendation 5: Application Analysis
   Estimated benefit is .34 active sessions, .39% of total activity.
   -----------------------------------------------------------------
   Action
      Trace the cause of contention on TABLE "ONT.ONT_DBI_CHANGE_LOG" with
      object ID 68232 in the application.
      Related Object
         Database object with ID 68232.

   Symptoms That Led to the Finding:
   ---------------------------------
      Read and write contention on database blocks was consuming significant
      database time.
      Impact is 31.88 active sessions, 36.34% of total activity.
         Wait class "Concurrency" was consuming significant database time.
         Impact is 41 active sessions, 46.74% of total activity.


Finding 3: PL/SQL Execution
Impact is 18.17 active sessions, 20.72% of total activity.
----------------------------------------------------------
PL/SQL execution consumed significant database time.

   Recommendation 1: SQL Tuning
   Estimated benefit is 8.73 active sessions, 9.95% of total activity.
   -------------------------------------------------------------------
   Action
      Tune the entry point PL/SQL "APPS.WF_ENGINE.BACKGROUNDCONCURRENT" of
      type "PACKAGE" and ID 7421721. Refer to the PL/SQL documentation for
      addition information.
   Rationale
      917 seconds spent in executing PL/SQL "SYS.DBMS_AQ.DEQUEUE#2" of type
      "PACKAGE" and ID 2452.
   Rationale
      387 seconds spent in executing PL/SQL
      "APPS.ASO_ORDER_FEEDBACK_UPDATE_PVT.ASO_LINE_TBL_TO_VAR" of type
      "PACKAGE" and ID 7484517.
   Rationale
      Subprogam ID 39 of PL/SQL ID 7115664 spent 183 seconds in execution.
   Rationale
      132 seconds spent in executing PL/SQL
      "APPS.ASO_ORDER_FEEDBACK_UPDATE_PVT.UPDATE_NOTICE" of type "PACKAGE" and
      ID 7484517.
   Rationale
      101 seconds spent in executing PL/SQL "APPS.OE_LINE_UTIL.QUERY_ROW#2" of
      type "PACKAGE" and ID 7584904.

   Recommendation 2: SQL Tuning
   Estimated benefit is 8.63 active sessions, 9.84% of total activity.
   -------------------------------------------------------------------
   Action
      Tune the entry point PL/SQL
      "APPS.INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS" of type "PACKAGE" and ID
      7147758. Refer to the PL/SQL documentation for addition information.
   Rationale
      Subprogam ID 50 of PL/SQL ID 7534518 spent 886 seconds in execution.
   Rationale
      Subprogam ID 39 of PL/SQL ID 7115664 spent 407 seconds in execution.
   Rationale
      Subprogam ID 15 of PL/SQL ID 2318 spent 112 seconds in execution.
   Rationale
      Subprogam ID 1 of PL/SQL ID 0 spent 101 seconds in execution.
   Rationale
      91 seconds spent in executing PL/SQL
      "APPS.INV_TXN_MANAGER_GRP.GET_OPEN_PERIOD" of type "PACKAGE" and ID
      7567246.

   Recommendation 3: SQL Tuning
   Estimated benefit is .82 active sessions, .93% of total activity.
   -----------------------------------------------------------------
   Action
      Tune the entry point PL/SQL "APPS.HR_GENERAL.GET_XBG_PROFILE" of type
      "PACKAGE" and ID 7131989. Refer to the PL/SQL documentation for addition
      information.
   Rationale
      Subprogam ID 39 of PL/SQL ID 7115664 spent 203 seconds in execution.


Finding 4: Buffer Cache Latches
Impact is 4.76 active sessions, 5.43% of total activity.
--------------------------------------------------------
Contention on buffer cache latches was consuming significant database time.

   No recommendations are available.

   Symptoms That Led to the Finding:
   ---------------------------------
      Wait class "Concurrency" was consuming significant database time.
      Impact is 41 active sessions, 46.74% of total activity.


Finding 5: Shared Pool Latches
Impact is 1.94 active sessions, 2.22% of total activity.
--------------------------------------------------------
Contention for latches related to the shared pool was consuming significant
database time.
Waits for "library cache: mutex X" amounted to 1% of database time.

   Recommendation 1: Application Analysis
   Estimated benefit is 1.94 active sessions, 2.22% of total activity.
   -------------------------------------------------------------------
   Action
      Investigate the cause for latch contention using the given blocking
      sessions or modules.
   Rationale
      The session with ID 1443 and serial number 45850 in instance number 1
      was the blocking session responsible for 22% of this recommendation's
      benefit.

   Symptoms That Led to the Finding:
   ---------------------------------
      Wait class "Concurrency" was consuming significant database time.
      Impact is 41 active sessions, 46.74% of total activity.


Finding 6: Index Block Split
Impact is 1.9 active sessions, 2.17% of total activity.
-------------------------------------------------------
Contention on index block splits was consuming significant database time.

   Recommendation 1: Schema Changes
   Estimated benefit is 1.85 active sessions, 2.11% of total activity.
   -------------------------------------------------------------------
   Action
      Consider hash partitioning the INDEX "INV.MTL_MATERIAL_TRANSACTIONS_U1"
      with object ID 40907 in a manner that will evenly distribute concurrent
      DML across multiple partitions.
      Related Object
         Database object with ID 40907.

   Symptoms That Led to the Finding:
   ---------------------------------
      Wait class "Concurrency" was consuming significant database time.
      Impact is 41 active sessions, 46.74% of total activity.


Finding 7: Row Lock Waits
Impact is 1.83 active sessions, 2.09% of total activity.
--------------------------------------------------------
SQL statements were found waiting for row lock waits.

   Recommendation 1: Application Analysis
   Estimated benefit is 1.83 active sessions, 2.09% of total activity.
   -------------------------------------------------------------------
   Action
      Significant row contention was detected in the TABLE "APPLSYS.WF_ITEMS"
      with object ID 35171. Trace the cause of row contention in the
      application logic using the given blocked SQL.
      Related Object
         Database object with ID 35171.
   Rationale
      The SQL statement with SQL_ID "0wabkkyua3y3v" was blocked on row locks.
      Related Object
         SQL statement with SQL_ID 0wabkkyua3y3v.
         SELECT ITEM_KEY FROM WF_ITEMS WHERE ITEM_TYPE = :B2 AND ITEM_KEY =
         :B1 FOR UPDATE
   Rationale
      The session with ID 4115 and serial number 17637 in instance number 1
      was the blocking session responsible for 10% of this recommendation's
      benefit.

   Symptoms That Led to the Finding:
   ---------------------------------
      Wait class "Application" was consuming significant database time.
      Impact is 1.84 active sessions, 2.09% of total activity.


Finding 8: Log File Switches
Impact is 1.77 active sessions, 2.02% of total activity.
--------------------------------------------------------
Log file switch operations were consuming significant database time while
waiting for checkpoint completion.

   No recommendations are available.

   Symptoms That Led to the Finding:
   ---------------------------------
      Wait class "Configuration" was consuming significant database time.
      Impact is 4.12 active sessions, 4.69% of total activity.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

          Additional Information
          ----------------------

Miscellaneous Information
-------------------------
Wait class "Commit" was not consuming significant database time.
CPU was not a bottleneck for the DB on this instance.
Wait class "Network" was not consuming significant database time.
Wait class "User I/O" was not consuming significant database time.
Session connect and disconnect calls were not consuming significant database
time.
Hard parsing of SQL statements was not consuming significant database time.

ADDM Task ADDM:684292237_1_312

          ADDM Report for Task 'ADDM:684292237_1_312'
          -------------------------------------------

Analysis Period
---------------
AWR snapshot range from 311 to 312.
Time period starts at 23-APR-20 07.03.11 PM
Time period ends at 23-APR-20 07.11.00 PM

Analysis Target
---------------
Database 'EBSCDB' with DB ID 684292237.
Database version 19.0.0.0.0.
ADDM performed an analysis of instance EBSCDB, numbered 1 and hosted at
ebs1229db.
ADDM detected that the system is a PDB.

Activity During the Analysis Period
-----------------------------------
Total database time was 10105 seconds.
The average number of active sessions was 21.55.

Summary of Findings
-------------------
   Description         Active Sessions      Recommendations
                       Percent of Activity
   ------------------  -------------------  ---------------
1  Top SQL Statements  9.99 | 46.36         5
2  Row Lock Waits      4.7 | 21.79          1
3  PL/SQL Execution    1.28 | 5.96          2
4  Log File Switches   1.14 | 5.27          0
5  Free Buffer Waits   1.13 | 5.25          1


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


          Findings and Recommendations
          ----------------------------

Finding 1: Top SQL Statements
Impact is 10.01 active sessions, 46.36% of total activity.
----------------------------------------------------------
SQL statements consuming significant database time were found. These
statements offer a good opportunity for performance improvement.

   Recommendation 1: SQL Tuning
   Estimated benefit is 4.66 active sessions, 21.62% of total activity.
   --------------------------------------------------------------------
   Action
      Investigate the DELETE statement with SQL_ID "g31wtj4vanqku" for
      possible performance improvements. You can supplement the information
      given here with an ASH report for this SQL_ID.
      Related Object
         SQL statement with SQL_ID g31wtj4vanqku.
         DELETE FROM RA_INTERFACE_SALESCREDITS S
         WHERE  EXISTS
         (SELECT 'X'
         FROM   RA_INTERFACE_LINES_ALL L
         WHERE  L.INTERFACE_LINE_CONTEXT ='ORDER ENTRY' AND L.INTERFACE_STATUS
         = 'P' AND S.INTERFACE_LINE_CONTEXT = L.INTERFACE_LINE_CONTEXT AND
         S.INTERFACE_LINE_ATTRIBUTE1= L.INTERFACE_LINE_ATTRIBUTE1 AND
         S.INTERFACE_LINE_ATTRIBUTE2= L.INTERFACE_LINE_ATTRIBUTE2 AND
         S.INTERFACE_LINE_ATTRIBUTE3= L.INTERFACE_LINE_ATTRIBUTE3 AND
         S.INTERFACE_LINE_ATTRIBUTE4= L.INTERFACE_LINE_ATTRIBUTE4 AND
         S.INTERFACE_LINE_ATTRIBUTE5= L.INTERFACE_LINE_ATTRIBUTE5 AND
         S.INTERFACE_LINE_ATTRIBUTE6= L.INTERFACE_LINE_ATTRIBUTE6 AND
         S.INTERFACE_LINE_ATTRIBUTE7= L.INTERFACE_LINE_ATTRIBUTE7 AND
         S.INTERFACE_LINE_ATTRIBUTE8= L.INTERFACE_LINE_ATTRIBUTE8 AND
         S.INTERFACE_LINE_ATTRIBUTE9= L.INTERFACE_LINE_ATTRIBUTE9 AND
         S.INTERFACE_LINE_ATTRIBUTE10= L.INTERFACE_LINE_ATTRIBUTE10 AND
         S.INTERFACE_LINE_ATTRIBUTE11= L.INTERFACE_LINE_ATTRIBUTE11 AND
         S.INTERFACE_LINE_ATTRIBUTE12= L.INTERFACE_LINE_ATTRIBUTE12 AND
         S.INTERFACE_LINE_ATTRIBUTE13= L.INTERFACE_LINE_ATTRIBUTE13 AND
         S.INTERFACE_LINE_ATTRIBUTE14= L.INTERFACE_LINE_ATTRIBUTE14)
   Rationale
      The SQL spent only 0% of its database time on CPU, I/O and Cluster
      waits. Therefore, the SQL Tuning Advisor is not applicable in this case.
      Look at performance data for the SQL to find potential improvements.
   Rationale
      Database time for this SQL was divided as follows: 100% for SQL
      execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java
      execution.
   Rationale
      SQL statement with SQL_ID "g31wtj4vanqku" was executed 32 times and had
      an average elapsed time of 67 seconds.
   Rationale
      Waiting for event "enq: TX - row lock contention" in wait class
      "Application" accounted for 99% of the database time spent in processing
      the SQL statement with SQL_ID "g31wtj4vanqku".
   Rationale
      Top level calls to execute the PL/SQL statement with SQL_ID
      "byaf6gyh7qg9v" are responsible for 100% of the database time spent on
      the DELETE statement with SQL_ID "g31wtj4vanqku".
      Related Object
         SQL statement with SQL_ID byaf6gyh7qg9v.
         declare ok_flag BOOLEAN ; BEGIN ok_flag :=
         AR_InterfaceSalesCredits_GRP . delete_salescredit ( ) ; END ;

   Recommendation 2: SQL Tuning
   Estimated benefit is 2.57 active sessions, 11.92% of total activity.
   --------------------------------------------------------------------
   Action
      Run SQL Tuning Advisor on the SELECT statement with SQL_ID
      "8gmgrb5mwa9f9".
      Related Object
         SQL statement with SQL_ID 8gmgrb5mwa9f9.
         SELECT TAX_REGIME_CODE, TAX, STATUS_RESULT, RATE_RESULT,
         CONDITION_SET_ID, EXCEPTION_SET_ID, RESULT_ID, QUERY_NUM FROM (SELECT
         /*+ leading(PR) use_nl(RL) */ RL.TAX_REGIME_CODE, RL.TAX,
         PR.STATUS_RESULT, PR.RATE_RESULT, PR.CONDITION_SET_ID,
         PR.EXCEPTION_SET_ID, PR.RESULT_ID, 1 QUERY_NUM,
         TAX.COMPOUNDING_PRECEDENCE FROM ZX_PROCESS_RESULTS PR,
         ZX_SCO_RULES_B_V RL, ZX_SCO_TAXES_B_V TAX WHERE
         (PR.CONDITION_GROUP_CODE IN (:B2 , DECODE(:B4 ,'OUTPUT',SUBSTRB(:B3
         ,1,45)||'-'||'XOP' ,'INPUT' ,SUBSTRB(:B3 ,1,45)||'-'||'XIP' ,:B2 ) )
         OR PR.CONDITION_GROUP_CODE LIKE :B2 ||'~'||'%') AND RL.EFFECTIVE_FROM
         <= :B1 AND (RL.EFFECTIVE_TO >= :B1 OR RL.EFFECTIVE_TO IS NULL ) AND
         PR.ENABLED_FLAG = 'Y' AND RL.TAX_RULE_ID = PR.TAX_RULE_ID AND
         RL.SERVICE_TYPE_CODE = 'DET_DIRECT_RATE' AND
         TAX.TAX_REGIME_CODE=RL.TAX_REGIME_CODE AND TAX.TAX=RL.TAX AND
         TAX.EFFECTIVE_FROM <= :B1 AND (TAX.EFFECTIVE_TO >= :B1 OR
         TAX.EFFECTIVE_TO IS NULL ) AND TAX.LIVE_FOR_PROCESSING_FLAG = 'Y' AND
         TAX.LIVE_FOR_APPLICABILITY_FLAG = 'Y' AND EXISTS (SELECT /*+
         no_unnest */ 1 FROM ZX_SCO_RATES_B_V RT WHERE RT.TAX_REGIME_CODE =
         RL.TAX_REGIME_CODE AND RT.TAX = RL.TAX AND RT.TAX_STATUS_CODE =
         PR.STATUS_RESULT AND RT.TAX_RATE_CODE = PR.RATE_RESULT AND
         RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFECTIVE_TO >= :B1 OR
         RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS
         = :B4 OR RT.TAX_CLASS IS NULL)) UNION ALL SELECT /*+ leading(RT.a)
         use_nl(RT.sd) */ DISTINCT RT.TAX_REGIME_CODE, RT.TAX,
         RT.TAX_STATUS_CODE, RT.TAX_RATE_CODE, NULL CONDITION_SET_ID, NULL
         EXCEPTION_SET_ID, NULL RESULT_ID, 2 QUERY_NUM,
         TAX.COMPOUNDING_PRECEDENCE FROM ZX_SCO_RATES_B_V RT, ZX_SCO_TAXES_B_V
         TAX WHERE RT.TAX_RATE_CODE = :B3 AND RT.RATE_TYPE_CODE <> 'RECOVERY'
         AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFECTIVE_TO >= :B1 OR
         RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS
         = :B4 OR RT.TAX_CLASS IS NULL) AND TAX.TAX_REGIME_CODE =
         RT.TAX_REGIME_CODE AND TAX.TAX = RT.TAX AND
         TAX.LIVE_FOR_PROCESSING_FLAG = 'Y' AND
         TAX.LIVE_FOR_APPLICABILITY_FLAG = 'Y' AND TAX.EFFECTIVE_FROM <= :B1
         AND (TAX.EFFECTIVE_TO >= :B1 OR TAX.EFFECTIVE_TO IS NULL ) ) ORDER BY
         COMPOUNDING_PRECEDENCE NULLS FIRST
   Rationale
      The SQL spent 99% of its database time on CPU, I/O and Cluster waits.
      This part of database time may be improved by the SQL Tuning Advisor.
   Rationale
      Database time for this SQL was divided as follows: 100% for SQL
      execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java
      execution.
   Rationale
      SQL statement with SQL_ID "8gmgrb5mwa9f9" was executed 99987 times and
      had an average elapsed time of 0.013 seconds.
   Rationale
      At least 3 distinct execution plans were utilized for this SQL statement
      during the analysis period.
   Rationale
      Top level calls to execute the PL/SQL statement with SQL_ID
      "6abn0zw8kkvtk" are responsible for 100% of the database time spent on
      the SELECT statement with SQL_ID "8gmgrb5mwa9f9".
      Related Object
         SQL statement with SQL_ID 6abn0zw8kkvtk.
         begin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase ,
         :num_tax_failures , :return_status:i_return_status ) ; END ;

   Recommendation 3: SQL Tuning
   Estimated benefit is 1.41 active sessions, 6.57% of total activity.
   -------------------------------------------------------------------
   Action
      Investigate the PL/SQL statement with SQL_ID "6abn0zw8kkvtk" for
      possible performance improvements. You can supplement the information
      given here with an ASH report for this SQL_ID.
      Related Object
         SQL statement with SQL_ID 6abn0zw8kkvtk.
         begin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase ,
         :num_tax_failures , :return_status:i_return_status ) ; END ;
   Rationale
      The SQL Tuning Advisor cannot operate on PL/SQL statements.
   Rationale
      Database time for this SQL was divided as follows: 24% for SQL
      execution, 0% for parsing, 76% for PL/SQL execution and 0% for Java
      execution.
   Rationale
      SQL statement with SQL_ID "6abn0zw8kkvtk" was executed 32 times and had
      an average elapsed time of 137 seconds.

   Recommendation 4: SQL Tuning
   Estimated benefit is .83 active sessions, 3.84% of total activity.
   ------------------------------------------------------------------
   Action
      Run SQL Tuning Advisor on the SELECT statement with SQL_ID
      "drt9k4tpvph64". Additionally, investigate this statement for possible
      performance improvements. You can supplement the information given here
      with an ASH report for this SQL_ID.
      Related Object
         SQL statement with SQL_ID drt9k4tpvph64.
         SELECT AR_TAX.LOCATION_SEGMENT_ID, AR_TAX.ORG_ID, AR_TAX.TAX_LINE_ID,
         AR_TAX.VAT_TAX_ID, AR_TAX.SET_OF_BOOKS_ID, NVL(AR_REC.GL_DATE,
         TRUNC(SYSDATE)) FROM RA_CUSTOMER_TRX_LINES AR_TAX,
         RA_CUST_TRX_LINE_GL_DIST AR_REC WHERE AR_TAX.CUSTOMER_TRX_LINE_ID =
         :B1 AND AR_TAX.CUSTOMER_TRX_ID = AR_REC.CUSTOMER_TRX_ID AND
         AR_REC.ACCOUNT_CLASS = 'REC' AND AR_REC.LATEST_REC_FLAG = 'Y'
   Rationale
      The SQL spent 42% of its database time on CPU, I/O and Cluster waits.
      This part of database time may be improved by the SQL Tuning Advisor.
      Look at data given below and an ASH report for further performance
      improvements.
   Rationale
      Database time for this SQL was divided as follows: 100% for SQL
      execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java
      execution.
   Rationale
      SQL statement with SQL_ID "drt9k4tpvph64" was executed 299859 times and
      had an average elapsed time of 0.0012 seconds.
   Rationale
      Top level calls to execute the PL/SQL statement with SQL_ID
      "37f1qguwxw0sk" are responsible for 100% of the database time spent on
      the SELECT statement with SQL_ID "drt9k4tpvph64".
      Related Object
         SQL statement with SQL_ID 37f1qguwxw0sk.
         begin IF ( :v_msg_level:i_msg_level > 0 ) THEN arp_util .
         enable_debug ( 1000000 ) ; arp_global . msg_level :=
         :v_msg_level:i_msg_level ; END IF ; arp_auto_accounting .
         g_error_buffer := NULL ;
         :v_num_failed_dist_rows:i_num_failed_dist_rows := 0 ;
         :v_coa_id:i_coa_id := arp_standard . gl_chart_of_accounts_id ;
         :v_retval:i_retval := 1 ; arp_auto_accounting . do_autoaccounting (
         :v_mode:i_vmode , :v_account_class , :v_trx_id:i_trx_id ,
         :v_line_id:i_line_id , :v_line_salesrep_id:i_line_salesrep_id ,
         :v_request_id:i_request_id , :v_gl_date , :v_orig_gl_date ,
         :v_total_trx_amount:i_total_trx_amount , :v_passed_ccid:i_passed_ccid
         , :v_force_acct_set_no , :v_cust_trx_type_id:i_cust_trx_type_id ,
         :v_primary_salesrep_id:i_primary_salesrep_id ,
         :v_inv_item_id:i_inv_item_id , :v_memo_line_id:i_memo_line_id ,
         :v_ccid:i_ccid , :v_concat_segments:i_concat_segments ,
         :v_num_failed_dist_rows:i_num_failed_dist_rows ) ; IF (
         :v_mode:i_vmode = 'G' AND :v_ccid:i_ccid = -1 ) THEN
         :v_retval:i_retval := 0 ; END IF ; EXCEPTION WHEN arp_auto_accounting
         . no_ccid THEN :v_retval:i_retval := 0 ; WHEN NO_DATA_FOUND THEN NULL
         ; WHEN OTHERS THEN arp_util . debug ( 'arcdaa()' ) ; arp_util . debug
         ( SQLERRM ) ; :v_errorbuf:i_errorbuf := arp_auto_accounting .
         g_error_buffer ; :v_sqlcode:i_sqlcode := SQLCODE ; END ;

   Recommendation 5: SQL Tuning
   Estimated benefit is .5 active sessions, 2.32% of total activity.
   -----------------------------------------------------------------
   Action
      Investigate the UPDATE statement with SQL_ID "cmbsq0wfywbnq" for
      possible performance improvements. You can supplement the information
      given here with an ASH report for this SQL_ID.
      Related Object
         SQL statement with SQL_ID cmbsq0wfywbnq.
         update RA_INTERFACE_SALESCREDITS  set
         INTERFACE_SALESCREDIT_ID=NVL(INTERFACE_SALESCREDIT_ID,RA_CUST_TRX_LIN
         E_SALESREPS_S.nextval
         ),INTERFACE_LINE_ID=:b1,LAST_UPDATE_DATE=sysdate,LAST_UPDATED_BY=:b2,
         LAST_UPDATE_LOGIN=:b3,REQUEST_ID=:b4 where ROWID=:b5
   Rationale
      The SQL spent only 8% of its database time on CPU, I/O and Cluster
      waits. Therefore, the SQL Tuning Advisor is not applicable in this case.
      Look at performance data for the SQL to find potential improvements.
   Rationale
      Database time for this SQL was divided as follows: 100% for SQL
      execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java
      execution.
   Rationale
      SQL statement with SQL_ID "cmbsq0wfywbnq" was executed 351 times and had
      an average elapsed time of 0.15 seconds.


Finding 2: Row Lock Waits
Impact is 4.71 active sessions, 21.79% of total activity.
---------------------------------------------------------
SQL statements were found waiting for row lock waits.

   Recommendation 1: Application Analysis
   Estimated benefit is 4.7 active sessions, 21.79% of total activity.
   -------------------------------------------------------------------
   Action
      Significant row contention was detected in the TABLE
      "AR.RA_INTERFACE_SALESCREDITS_ALL" with object ID 43704. Trace the cause
      of row contention in the application logic using the given blocked SQL.
      Related Object
         Database object with ID 43704.
   Rationale
      The SQL statement with SQL_ID "g31wtj4vanqku" was blocked on row locks.
      Related Object
         SQL statement with SQL_ID g31wtj4vanqku.
         DELETE FROM RA_INTERFACE_SALESCREDITS S
         WHERE  EXISTS
         (SELECT 'X'
         FROM   RA_INTERFACE_LINES_ALL L
         WHERE  L.INTERFACE_LINE_CONTEXT ='ORDER ENTRY' AND L.INTERFACE_STATUS
         = 'P' AND S.INTERFACE_LINE_CONTEXT = L.INTERFACE_LINE_CONTEXT AND
         S.INTERFACE_LINE_ATTRIBUTE1= L.INTERFACE_LINE_ATTRIBUTE1 AND
         S.INTERFACE_LINE_ATTRIBUTE2= L.INTERFACE_LINE_ATTRIBUTE2 AND
         S.INTERFACE_LINE_ATTRIBUTE3= L.INTERFACE_LINE_ATTRIBUTE3 AND
         S.INTERFACE_LINE_ATTRIBUTE4= L.INTERFACE_LINE_ATTRIBUTE4 AND
         S.INTERFACE_LINE_ATTRIBUTE5= L.INTERFACE_LINE_ATTRIBUTE5 AND
         S.INTERFACE_LINE_ATTRIBUTE6= L.INTERFACE_LINE_ATTRIBUTE6 AND
         S.INTERFACE_LINE_ATTRIBUTE7= L.INTERFACE_LINE_ATTRIBUTE7 AND
         S.INTERFACE_LINE_ATTRIBUTE8= L.INTERFACE_LINE_ATTRIBUTE8 AND
         S.INTERFACE_LINE_ATTRIBUTE9= L.INTERFACE_LINE_ATTRIBUTE9 AND
         S.INTERFACE_LINE_ATTRIBUTE10= L.INTERFACE_LINE_ATTRIBUTE10 AND
         S.INTERFACE_LINE_ATTRIBUTE11= L.INTERFACE_LINE_ATTRIBUTE11 AND
         S.INTERFACE_LINE_ATTRIBUTE12= L.INTERFACE_LINE_ATTRIBUTE12 AND
         S.INTERFACE_LINE_ATTRIBUTE13= L.INTERFACE_LINE_ATTRIBUTE13 AND
         S.INTERFACE_LINE_ATTRIBUTE14= L.INTERFACE_LINE_ATTRIBUTE14)
   Rationale
      The session with ID 159 and serial number 61341 in instance number 1 was
      the blocking session responsible for 88% of this recommendation's
      benefit.

   Symptoms That Led to the Finding:
   ---------------------------------
      Wait class "Application" was consuming significant database time.
      Impact is 4.74 active sessions, 21.98% of total activity.


Finding 3: PL/SQL Execution
Impact is 1.29 active sessions, 5.96% of total activity.
--------------------------------------------------------
PL/SQL execution consumed significant database time.

   Recommendation 1: SQL Tuning
   Estimated benefit is 1.11 active sessions, 5.15% of total activity.
   -------------------------------------------------------------------
   Action
      Tune the entry point PL/SQL "APPS.ARP_ETAX_AUTOINV_UTIL.CALCULATE_TAX"
      of type "PACKAGE" and ID 7060780. Refer to the PL/SQL documentation for
      addition information.
   Rationale
      Subprogam ID 25 of PL/SQL ID 7645952 spent 51 seconds in execution.
   Rationale
      51 seconds spent in executing PL/SQL
      "APPS.ZX_TDS_APPLICABILITY_DETM_PKG.GET_PROCESS_RESULTS" of type
      "PACKAGE" and ID 7645970.

   Recommendation 2: SQL Tuning
   Estimated benefit is .17 active sessions, .81% of total activity.
   -----------------------------------------------------------------
   Action
      Tune the entry point PL/SQL
      "APPS.ARP_AUTO_ACCOUNTING.DO_AUTOACCOUNTING#1" of type "PACKAGE" and ID
      7481364. Refer to the PL/SQL documentation for addition information.


Finding 4: Log File Switches
Impact is 1.14 active sessions, 5.27% of total activity.
--------------------------------------------------------
Log file switch operations were consuming significant database time while
waiting for checkpoint completion.

   No recommendations are available.

   Symptoms That Led to the Finding:
   ---------------------------------
      Wait class "Configuration" was consuming significant database time.
      Impact is 2.97 active sessions, 13.76% of total activity.


Finding 5: Free Buffer Waits
Impact is 1.13 active sessions, 5.25% of total activity.
--------------------------------------------------------
Database writers (DBWR) were unable to keep up with the demand for free
buffers.

   Recommendation 1: Application Analysis
   Estimated benefit is 1.13 active sessions, 5.25% of total activity.
   -------------------------------------------------------------------
   Action
      Investigate application logic for possible use of direct path inserts as
      an alternative for multiple INSERT operations.

   Symptoms That Led to the Finding:
   ---------------------------------
      Wait class "Configuration" was consuming significant database time.
      Impact is 2.97 active sessions, 13.76% of total activity.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

          Additional Information
          ----------------------

Miscellaneous Information
-------------------------
Wait class "Commit" was not consuming significant database time.
Wait class "Concurrency" was not consuming significant database time.
CPU was not a bottleneck for the DB on this instance.
Wait class "Network" was not consuming significant database time.
Wait class "User I/O" was not consuming significant database time.
Session connect and disconnect calls were not consuming significant database
time.
Hard parsing of SQL statements was not consuming significant database time.

ADDM Task ADDM:684292237_1_310

          ADDM Report for Task 'ADDM:684292237_1_310'
          -------------------------------------------

Analysis Period
---------------
AWR snapshot range from 309 to 310.
Time period starts at 23-APR-20 06.51.11 PM
Time period ends at 23-APR-20 06.56.20 PM

Analysis Target
---------------
Database 'EBSCDB' with DB ID 684292237.
Database version 19.0.0.0.0.
ADDM performed an analysis of instance EBSCDB, numbered 1 and hosted at
ebs1229db.
ADDM detected that the system is a PDB.

Activity During the Analysis Period
-----------------------------------
Total database time was 6309 seconds.
The average number of active sessions was 20.42.

Summary of Findings
-------------------
   Description                       Active Sessions      Recommendations
                                     Percent of Activity
   --------------------------------  -------------------  ---------------
1  Top SQL Statements                7.65 | 37.46         5
2  Buffer Cache Latches              5.86 | 28.7          1
3  PL/SQL Execution                  2.59 | 12.7          1
4  Buffer Busy - Hot Objects         .8 | 3.92            1
5  Unusual "Concurrency" Wait Event  .45 | 2.21           4
6  Buffer Busy - Hot Block           .24 | 1.16           1


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


          Findings and Recommendations
          ----------------------------

Finding 1: Top SQL Statements
Impact is 7.65 active sessions, 37.46% of total activity.
---------------------------------------------------------
SQL statements consuming significant database time were found. These
statements offer a good opportunity for performance improvement.

   Recommendation 1: SQL Tuning
   Estimated benefit is 3.39 active sessions, 16.61% of total activity.
   --------------------------------------------------------------------
   Action
      Investigate the PL/SQL statement with SQL_ID "0074pdmwb7fmv" for
      possible performance improvements. You can supplement the information
      given here with an ASH report for this SQL_ID.
      Related Object
         SQL statement with SQL_ID 0074pdmwb7fmv.
         BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf,:rc,:A0,:A1,
         :A2,:A3,:A4,:A5,:A6,:A7,:A8); END;
   Rationale
      The SQL Tuning Advisor cannot operate on PL/SQL statements.
   Rationale
      Database time for this SQL was divided as follows: 36% for SQL
      execution, 1% for parsing, 63% for PL/SQL execution and 0% for Java
      execution.
   Rationale
      SQL statement with SQL_ID "0074pdmwb7fmv" was executed 34 times and had
      an average elapsed time of 183 seconds.

   Recommendation 2: SQL Tuning
   Estimated benefit is 1.4 active sessions, 6.84% of total activity.
   ------------------------------------------------------------------
   Action
      Investigate the UPDATE statement with SQL_ID "00b9c91r6ysp9" for
      possible performance improvements. You can supplement the information
      given here with an ASH report for this SQL_ID.
      Related Object
         SQL statement with SQL_ID 00b9c91r6ysp9.
         UPDATE WSH_TRIP_STOPS SET PENDING_INTERFACE_FLAG = 'P', REQUEST_ID =
         FND_GLOBAL.CONC_REQUEST_ID, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
         LAST_UPDATE_DATE = SYSDATE, BATCH_ID = :B2 WHERE STOP_ID = :B1
   Rationale
      The SQL spent only 23% of its database time on CPU, I/O and Cluster
      waits. Therefore, the SQL Tuning Advisor is not applicable in this case.
      Look at performance data for the SQL to find potential improvements.
   Rationale
      Database time for this SQL was divided as follows: 96% for SQL
      execution, 0% for parsing, 4% for PL/SQL execution and 0% for Java
      execution.
   Rationale
      SQL statement with SQL_ID "00b9c91r6ysp9" was executed 254623 times and
      had an average elapsed time of 0.0013 seconds.
   Rationale
      Waiting for event "buffer busy waits" in wait class "Concurrency"
      accounted for 40% of the database time spent in processing the SQL
      statement with SQL_ID "00b9c91r6ysp9".
   Rationale
      Top level calls to execute the PL/SQL statement with SQL_ID
      "0074pdmwb7fmv" are responsible for 100% of the database time spent on
      the UPDATE statement with SQL_ID "00b9c91r6ysp9".
      Related Object
         SQL statement with SQL_ID 0074pdmwb7fmv.
         BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf,:rc,:A0,:A1,
         :A2,:A3,:A4,:A5,:A6,:A7,:A8); END;

   Recommendation 3: SQL Tuning
   Estimated benefit is 1.03 active sessions, 5.05% of total activity.
   -------------------------------------------------------------------
   Action
      Run SQL Tuning Advisor on the SELECT statement with SQL_ID
      "0758ng3cbw07m". Additionally, investigate this statement for possible
      performance improvements. You can supplement the information given here
      with an ASH report for this SQL_ID.
      Related Object
         SQL statement with SQL_ID 0758ng3cbw07m.
         SELECT STOP_ID FROM WSH_TRIP_STOPS WHERE BATCH_ID = :B1 FOR UPDATE
         NOWAIT
   Rationale
      The SQL spent 35% of its database time on CPU, I/O and Cluster waits.
      This part of database time may be improved by the SQL Tuning Advisor.
      Look at data given below and an ASH report for further performance
      improvements.
   Rationale
      Database time for this SQL was divided as follows: 100% for SQL
      execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java
      execution.
   Rationale
      SQL statement with SQL_ID "0758ng3cbw07m" was executed 509114 times and
      had an average elapsed time of 0.00063 seconds.
   Rationale
      Waiting for event "latch: cache buffers chains" in wait class
      "Concurrency" accounted for 58% of the database time spent in processing
      the SQL statement with SQL_ID "0758ng3cbw07m".
   Rationale
      Top level calls to execute the PL/SQL statement with SQL_ID
      "0074pdmwb7fmv" are responsible for 100% of the database time spent on
      the SELECT statement with SQL_ID "0758ng3cbw07m".
      Related Object
         SQL statement with SQL_ID 0074pdmwb7fmv.
         BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf,:rc,:A0,:A1,
         :A2,:A3,:A4,:A5,:A6,:A7,:A8); END;

   Recommendation 4: SQL Tuning
   Estimated benefit is 1.03 active sessions, 5.05% of total activity.
   -------------------------------------------------------------------
   Action
      Run SQL Tuning Advisor on the SELECT statement with SQL_ID
      "fja4t7huk8v7m". Additionally, investigate this statement for possible
      performance improvements. You can supplement the information given here
      with an ASH report for this SQL_ID.
      Related Object
         SQL statement with SQL_ID fja4t7huk8v7m.
         SELECT WDD.DELIVERY_DETAIL_ID FROM WSH_TRIP_STOPS WTS,
         WSH_DELIVERY_LEGS WDL, WSH_DELIVERY_ASSIGNMENTS_V WDA,
         WSH_DELIVERY_DETAILS WDD WHERE WDD.INV_INTERFACED_FLAG IN ('N', 'P')
         AND WTS.BATCH_ID = :B1 AND WTS.STOP_LOCATION_ID =
         WDD.SHIP_FROM_LOCATION_ID AND WTS.STOP_ID = WDL.PICK_UP_STOP_ID AND
         WDL.DELIVERY_ID = WDA.DELIVERY_ID AND WDA.DELIVERY_ID IS NOT NULL AND
         WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND WDD.SOURCE_CODE
         IN ('OE','OKE', 'WSH','RTV') AND WDD.RELEASED_STATUS <> 'D' AND
         NVL(WDD.LINE_DIRECTION , 'O') IN ('O', 'IO') AND ROWNUM = 1
   Rationale
      The SQL spent 35% of its database time on CPU, I/O and Cluster waits.
      This part of database time may be improved by the SQL Tuning Advisor.
      Look at data given below and an ASH report for further performance
      improvements.
   Rationale
      Database time for this SQL was divided as follows: 100% for SQL
      execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java
      execution.
   Rationale
      SQL statement with SQL_ID "fja4t7huk8v7m" was executed 509158 times and
      had an average elapsed time of 0.0005 seconds.
   Rationale
      Waiting for event "latch: cache buffers chains" in wait class
      "Concurrency" accounted for 58% of the database time spent in processing
      the SQL statement with SQL_ID "fja4t7huk8v7m".
   Rationale
      Top level calls to execute the PL/SQL statement with SQL_ID
      "0074pdmwb7fmv" are responsible for 100% of the database time spent on
      the SELECT statement with SQL_ID "fja4t7huk8v7m".
      Related Object
         SQL statement with SQL_ID 0074pdmwb7fmv.
         BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf,:rc,:A0,:A1,
         :A2,:A3,:A4,:A5,:A6,:A7,:A8); END;

   Recommendation 5: SQL Tuning
   Estimated benefit is .8 active sessions, 3.91% of total activity.
   -----------------------------------------------------------------
   Action
      Investigate the SELECT statement with SQL_ID "416vjrw5cxwu5" for
      possible performance improvements. You can supplement the information
      given here with an ASH report for this SQL_ID.
      Related Object
         SQL statement with SQL_ID 416vjrw5cxwu5.
         SELECT DISTINCT WND.DELIVERY_ID FROM WSH_DELIVERY_DETAILS WDD,
         WSH_DELIVERY_ASSIGNMENTS_V WDA, WSH_NEW_DELIVERIES WND,
         WSH_DELIVERY_LEGS WDL, WSH_TRIP_STOPS WTS WHERE WDD.SOURCE_CODE =
         'RTV' AND NVL(WDD.INV_INTERFACED_FLAG, 'N') = 'N' AND
         WDD.CONTAINER_FLAG = 'N' AND WDD.RELEASED_STATUS <> 'D' AND
         NVL(WDD.LINE_DIRECTION,'O') IN ('O','IO') AND WDD.DELIVERY_DETAIL_ID
         = WDA.DELIVERY_DETAIL_ID AND WDA.DELIVERY_ID = WND.DELIVERY_ID AND
         WDA.DELIVERY_ID IS NOT NULL AND WND.DELIVERY_ID = WDL.DELIVERY_ID AND
         WDL.PICK_UP_STOP_ID = WTS.STOP_ID AND WDD.SHIP_FROM_LOCATION_ID =
         WTS.STOP_LOCATION_ID AND WTS.BATCH_ID = :B1
   Rationale
      The SQL spent only 29% of its database time on CPU, I/O and Cluster
      waits. Therefore, the SQL Tuning Advisor is not applicable in this case.
      Look at performance data for the SQL to find potential improvements.
   Rationale
      Database time for this SQL was divided as follows: 100% for SQL
      execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java
      execution.
   Rationale
      SQL statement with SQL_ID "416vjrw5cxwu5" was executed 254595 times and
      had an average elapsed time of 0.00066 seconds.
   Rationale
      Waiting for event "latch: cache buffers chains" in wait class
      "Concurrency" accounted for 58% of the database time spent in processing
      the SQL statement with SQL_ID "416vjrw5cxwu5".
   Rationale
      Top level calls to execute the PL/SQL statement with SQL_ID
      "0074pdmwb7fmv" are responsible for 100% of the database time spent on
      the SELECT statement with SQL_ID "416vjrw5cxwu5".
      Related Object
         SQL statement with SQL_ID 0074pdmwb7fmv.
         BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf,:rc,:A0,:A1,
         :A2,:A3,:A4,:A5,:A6,:A7,:A8); END;


Finding 2: Buffer Cache Latches
Impact is 5.86 active sessions, 28.7% of total activity.
--------------------------------------------------------
Contention on buffer cache latches was consuming significant database time.

   Recommendation 1: Application Analysis
   Estimated benefit is 5.86 active sessions, 28.7% of total activity.
   -------------------------------------------------------------------
   Action
      Look at the "Top SQL Statements" finding for SQL statements consuming
      significant time on the "latch: cache buffers chains" wait event. For
      example, the SELECT statement with SQL_ID "0758ng3cbw07m" is responsible
      for 10% of these waits.

   Symptoms That Led to the Finding:
   ---------------------------------
      Wait class "Concurrency" was consuming significant database time.
      Impact is 7.2 active sessions, 35.26% of total activity.


Finding 3: PL/SQL Execution
Impact is 2.59 active sessions, 12.7% of total activity.
--------------------------------------------------------
PL/SQL execution consumed significant database time.

   Recommendation 1: SQL Tuning
   Estimated benefit is 2.59 active sessions, 12.7% of total activity.
   -------------------------------------------------------------------
   Action
      Tune the entry point PL/SQL
      "APPS.WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_ALL_WRP" of type "PACKAGE" and
      ID 7639477. Refer to the PL/SQL documentation for addition information.
   Rationale
      61 seconds spent in executing PL/SQL "SYS.DBMS_AQ.ENQUEUE#2" of type
      "PACKAGE" and ID 2452.
   Rationale
      51 seconds spent in executing PL/SQL
      "APPS.WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_ALL" of type "PACKAGE" and ID
      7639477.
   Rationale
      Subprogam ID 22 of PL/SQL ID 7639477 spent 51 seconds in execution.


Finding 4: Buffer Busy - Hot Objects
Impact is .8 active sessions, 3.92% of total activity.
------------------------------------------------------
Read and write contention on database blocks was consuming significant
database time.

   Recommendation 1: Schema Changes
   Estimated benefit is .56 active sessions, 2.76% of total activity.
   ------------------------------------------------------------------
   Action
      Consider hash partitioning the INDEX "WSH.WSH_TRIP_STOPS_N6" with object
      ID 889432 in a manner that will evenly distribute concurrent DML across
      multiple partitions.
      Related Object
         Database object with ID 889432.
   Rationale
      The UPDATE statement with SQL_ID "00b9c91r6ysp9" was significantly
      affected by "buffer busy" waits.
      Related Object
         SQL statement with SQL_ID 00b9c91r6ysp9.
         UPDATE WSH_TRIP_STOPS SET PENDING_INTERFACE_FLAG = 'P', REQUEST_ID =
         FND_GLOBAL.CONC_REQUEST_ID, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
         LAST_UPDATE_DATE = SYSDATE, BATCH_ID = :B2 WHERE STOP_ID = :B1

   Symptoms That Led to the Finding:
   ---------------------------------
      Read and write contention on database blocks was consuming significant
      database time.
      Impact is .8 active sessions, 3.92% of total activity.
         Wait class "Concurrency" was consuming significant database time.
         Impact is 7.2 active sessions, 35.26% of total activity.


Finding 5: Unusual "Concurrency" Wait Event
Impact is .45 active sessions, 2.21% of total activity.
-------------------------------------------------------
Wait event "latch: In memory undo latch" in wait class "Concurrency" was
consuming significant database time.

   Recommendation 1: Application Analysis
   Estimated benefit is .45 active sessions, 2.21% of total activity.
   ------------------------------------------------------------------
   Action
      Investigate the cause for high "latch: In memory undo latch" waits.
      Refer to Oracle's "Database Reference" for the description of this wait
      event.

   Recommendation 2: Application Analysis
   Estimated benefit is .45 active sessions, 2.21% of total activity.
   ------------------------------------------------------------------
   Action
      Investigate the cause for high "latch: In memory undo latch" waits in
      Service "ebs_VOL1229".

   Recommendation 3: Application Analysis
   Estimated benefit is .26 active sessions, 1.26% of total activity.
   ------------------------------------------------------------------
   Action
      Investigate the cause for high "latch: In memory undo latch" waits in
      Module "e:ONT:cp:wsh/WSHINTERFACES".

   Recommendation 4: Application Analysis
   Estimated benefit is .19 active sessions, .95% of total activity.
   -----------------------------------------------------------------
   Action
      Investigate the cause for high "latch: In memory undo latch" waits in
      Module "e:ONT:wf:OECOGS".

   Symptoms That Led to the Finding:
   ---------------------------------
      Wait class "Concurrency" was consuming significant database time.
      Impact is 7.2 active sessions, 35.26% of total activity.


Finding 6: Buffer Busy - Hot Block
Impact is .24 active sessions, 1.16% of total activity.
-------------------------------------------------------
A hot data block with concurrent read and write activity was found. The block
belongs to segment "WSH.WSH_TRIP_STOPS_N6" and is block 132213 in file 135.

   Recommendation 1: Application Analysis
   Estimated benefit is .24 active sessions, 1.16% of total activity.
   ------------------------------------------------------------------
   Action
      Investigate application logic to find the cause of high concurrent read
      and write activity to the data present in this block.
      Related Object
         Database block with object number 889432, file number 135 and block
         number 132213.

   Symptoms That Led to the Finding:
   ---------------------------------
      Read and write contention on database blocks was consuming significant
      database time.
      Impact is .8 active sessions, 3.92% of total activity.
         Wait class "Concurrency" was consuming significant database time.
         Impact is 7.2 active sessions, 35.26% of total activity.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

          Additional Information
          ----------------------

Miscellaneous Information
-------------------------
Wait class "Application" was not consuming significant database time.
Wait class "Commit" was not consuming significant database time.
Wait class "Configuration" was not consuming significant database time.
CPU was not a bottleneck for the DB on this instance.
Wait class "Network" was not consuming significant database time.
Wait class "User I/O" was not consuming significant database time.
Session connect and disconnect calls were not consuming significant database
time.
Hard parsing of SQL statements was not consuming significant database time.


Back to Top

End of Report