WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
VIS300141512VIS123-Sep-11 09:0911.2.0.1.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
app0AIX-Based Systems (64-bit) 24 12  47.25

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:6323-Sep-11 11:35:5990 5.7
End Snap:6423-Sep-11 12:23:1090 5.7
Elapsed:  47.17 (mins)  
DB Time:  738.24 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 28,416M 28,416MStd Block Size: 8K
Shared Pool Size: 2,304M 2,304MLog Buffer: 115,724K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 15.7 0.0 0.00 0.09
DB CPU(s): 7.0 0.0 0.00 0.04
Redo size: 14,385,001.8 28,588.6  
Logical reads: 3,207,890.5 6,375.3  
Block changes: 88,095.6 175.1  
Physical reads: 46.8 0.1  
Physical writes: 1,100.5 2.2  
User calls: 175.6 0.4  
Parses: 1,615.4 3.2  
Hard parses: 0.3 0.0  
W/A MB processed: 43.8 0.1  
Logons: 0.6 0.0  
Executes: 32,204.4 64.0  
Rollbacks: 0.5 0.0  
Transactions: 503.2   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.91Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 101.20Soft Parse %: 99.98
Execute to Parse %: 94.98Latch Hit %: 91.82
Parse CPU to Parse Elapsd %: 30.27% Non-Parse CPU: 99.88

Shared Pool Statistics

BeginEnd
Memory Usage %: 43.28 43.66
% SQL with executions>1: 91.21 91.61
% Memory for SQL w/exec>1: 91.54 92.74

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 19,731 44.54 
latch: cache buffers chains19,918,7812,66106.01Concurrency
buffer busy waits8,062,6412,05904.65Concurrency
enq: TX - row lock contention122,0421,271102.87Application
db file sequential read60,45318830.42User I/O

Host CPU (CPUs: 24 Cores: 12 Sockets: )

Load Average BeginLoad Average End%User%System%WIO%Idle
0.21 1.23 53.7 1.7 0.1 44.6
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
29.1 52.6 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 48,384.0 48,384.0
SGA use (MB): 31,552.0 31,552.0
PGA use (MB): 261.4 260.8
% Host Mem used for SGA+PGA: 65.75 65.75

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time44,148.4899.67
DB CPU19,730.9044.54
PL/SQL execution elapsed time5,452.2912.31
Java execution elapsed time2,335.985.27
parse time elapsed87.170.20
sequence load elapsed time45.140.10
connection management call elapsed time6.360.01
repeated bind elapsed time5.450.01
hard parse elapsed time2.390.01
failed parse elapsed time0.190.00
hard parse (sharing criteria) elapsed time0.160.00
inbound PL/SQL rpc elapsed time0.160.00
PL/SQL compilation elapsed time0.140.00
hard parse (bind mismatch) elapsed time0.030.00
DB time44,294.61 
background elapsed time639.46 
background cpu time67.09 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
NUM_LCPUS0 
NUM_VCPUS0 
AVG_BUSY_TIME156,745 
AVG_IDLE_TIME126,395 
AVG_IOWAIT_TIME179 
AVG_SYS_TIME4,639 
AVG_USER_TIME152,039 
BUSY_TIME3,764,220 
IDLE_TIME3,035,629 
IOWAIT_TIME5,468 
SYS_TIME113,201 
USER_TIME3,651,019 
LOAD01
OS_CPU_WAIT_TIME3,988,800 
PHYSICAL_MEMORY_BYTES50,734,301,184 
NUM_CPUS24 
NUM_CPU_CORES12 
GLOBAL_RECEIVE_SIZE_MAX1,048,576 
GLOBAL_SEND_SIZE_MAX1,048,576 
TCP_RECEIVE_SIZE_DEFAULT16,384 
TCP_RECEIVE_SIZE_MAX9,223,372,036,854,775,807 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX9,223,372,036,854,775,807 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
23-Sep 11:35:590.21     
23-Sep 12:23:101.2355.3653.691.6644.640.08

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  19,731 44.54
Concurrency28,349,50104,935011.14
Application124,25101,272102.87
User I/O1,833,435031800.72
Configuration135,798015510.35
Other541,094918500.19
Commit7,39503140.07
Network434,1320100.00
System I/O1,5270000.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
latch: cache buffers chains19,918,78102,661013.996.01
buffer busy waits8,062,64102,05905.664.65
enq: TX - row lock contention122,04201,271100.092.87
db file sequential read60,453018830.040.42
enq: HW - contention39,157013030.030.29
read by other session18,201011460.010.26
enq: TX - index contention78,438011210.060.25
latch: In memory undo latch211,16806800.150.15
log file sync7,39503140.010.07
buffer deadlock222,1871002500.160.06
enq: TX - contention20,25302410.010.05
enq: SQ - contention96,37702100.070.05
library cache: mutex X69,55501400.050.03
latch: redo allocation2,33801040.000.02
utl_file I/O1,713,9790901.200.02
latch: undo global data26,6920900.020.02
latch free3,4050820.000.02
cursor: pin S1,6200640.000.01
latch: shared pool40405130.000.01
enq: FB - contention3,0550520.000.01
undo segment extension118974370.000.01
cursor: pin S wait on X34104120.000.01
db file scattered read2,0950310.000.01
Disk file operations I/O33,4440300.020.01
latch: row cache objects3,1890310.000.01
latch: cache buffers lru chain3530240.000.00
direct path read temp5,2220100.000.00
latch: enqueue hash chains2170150.000.00
SQL*Net break/reset to client2,2040100.000.00
row cache lock3,2690100.000.00
os thread startup2401360.000.00
kksfbc child completion21761390.000.00
latch: call allocation1270040.000.00
wait list latch free3400110.000.00
asynch descriptor resize261,208102000.180.00
SQL*Net message to client423,5250000.300.00
control file sequential read1,5270000.000.00
SQL*Net more data to client7,9380000.010.00
cursor: mutex S54100030.000.00
latch: cache buffer handles1,0680000.000.00
enq: TX - allocate ITL entry1460000.000.00
L1 validation61000100.000.00
SQL*Net more data from client2,6690000.000.00
latch: object queue header operation300020.000.00
enq: RO - fast object reuse50060.000.00
direct path read120020.000.00
direct path write temp220010.000.00
PX Deq: Slave Session Stats480000.000.00
enq: CR - block range reuse ckpt50010.000.00
library cache lock170000.000.00
latch: checkpoint queue latch20020.000.00
direct path write70000.000.00
SQL*Net message from client423,5250127,3693010.30 
Streams AQ: waiting for messages in the queue1,8999612,49065770.00 
PL/SQL lock timer600982,91348550.00 
pipe get1,1321002,82824980.00 
PX Deq: Execution Msg7280220.00 
PX Deq: Execute Reply3550000.00 
PX Deq: Parse Reply360010.00 
PX Deq: Table Q Normal620010.00 
PX Deq: Msg Fragment700000.00 
PX Deq: Join ACK300000.00 
PX Deq Credit: send blkd310000.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
log file parallel write715,282032400.5050.74
db file parallel write211,616014910.1523.33
LGWR wait for redo copy139,55501400.102.12
control file sequential read3,5800410.000.56
reliable message5330360.000.46
rdbms ipc reply5310350.000.39
control file parallel write1,4630210.000.28
latch: redo allocation1,9720110.000.18
buffer busy waits2860140.000.16
os thread startup1001590.000.09
latch: cache buffers chains2370020.000.06
db file sequential read500040.000.03
db file scattered read240030.000.01
latch free800010.000.01
latch: In memory undo latch120040.000.01
latch: redo writing500100.000.01
Disk file operations I/O1,3240000.000.01
latch: cache buffers lru chain640010.000.01
library cache: mutex X300130.000.01
direct path read100250.000.00
direct path write200010.000.00
buffer deadlock33100000.000.00
latch: call allocation80010.000.00
SQL*Net message to client4,4590000.000.00
asynch descriptor resize1,645100000.000.00
rdbms ipc message472,534335,160740.33 
PX Idle Wait3,649997,23219820.00 
Streams AQ: qmn slave idle wait1,06405,66253220.00 
DIAG idle wait5,6481005,65310010.00 
Streams AQ: waiting for time management or cleanup tasks530473,15859590.00 
smon timer7652,864376810.00 
Space Manager: slave idle wait5671002,83249940.00 
Streams AQ: qmn coordinator idle wait1,081382,83126190.00 
pmon timer1,193792,83023720.00 
JOX Jit Process Sleep44100450102330.00 
SQL*Net message from client5,94503460.00 
class slave wait100060.00 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
Disk file operations I/O34.8K100.0.0.0 .0 .0 
L1 validation6    100.0   
LGWR wait for redo copy139.6K99.1.3.2.1.1.1.0 
PX Deq: Signal ACK EXT7100.0       
PX Deq: Slave Session Stats48100.0       
PX qref latch1100.0       
SQL*Net break/reset to client219194.9.81.01.11.2.8.1 
SQL*Net message to client427.8K100.0       
SQL*Net more data from client2677100.0.0      
SQL*Net more data to client7943100.0       
asynch descriptor resize272.8K100.0       
buffer busy waits8060.2K98.1.4.4.4.3.3.2 
buffer deadlock222.1K98.6.3.3.4.3.1.0 
control file parallel write146485.25.33.92.71.6.6.5 
control file sequential read510891.72.72.01.81.1.4.4 
cursor: mutex S5461.13.713.01.916.73.7  
cursor: pin S162068.52.55.78.87.74.82.1 
cursor: pin S wait on X341    92.15.62.3 
db file parallel write212.7K91.65.12.01.0.3.0.0 
db file scattered read211978.2.75.014.51.6   
db file sequential read60.5K56.65.310.417.97.02.3.5 
direct path read1338.5 15.438.5 7.7  
direct path read temp5222100.0  .0.0   
direct path write2785.2 7.43.73.7   
direct path write temp2277.34.513.64.5    
enq: CR - block range reuse ckpt560.0 40.0     
enq: DV - contention8100.0       
enq: FB - contention305586.92.52.43.02.51.9.8 
enq: HW - contention39.2K73.715.81.01.31.92.73.6 
enq: PS - contention12100.0       
enq: RO - fast object reuse520.0 20.020.040.0   
enq: SQ - contention96.4K99.5.2.1.1.0.0.0 
enq: TX - allocate ITL entry14694.51.41.4.72.1   
enq: TX - contention20.4K72.820.52.32.31.5.5.1 
enq: TX - index contention78.4K81.35.93.34.13.61.4.3 
enq: TX - row lock contention122K9.120.443.96.35.44.910.0 
kksfbc child completion2123.8     76.2 
latch free348584.61.82.63.03.32.71.9 
latch: In memory undo latch211.2K97.2.6.6.6.5.3.2 
latch: cache buffer handles106499.5.1.1 .3   
latch: cache buffers chains19.9M99.5.1.1.1.1.1.0 
latch: cache buffers lru chain41764.71.93.812.99.45.51.7 
latch: call allocation13553.310.416.35.98.15.2.7 
latch: checkpoint queue latch2  100.0     
latch: enqueue hash chains21765.41.84.18.811.54.14.1 
latch: messages9100.0       
latch: object queue header operation3971.85.115.45.12.6   
latch: redo allocation431072.44.76.26.95.72.91.1 
latch: redo writing560.0    40.0  
latch: row cache objects318893.21.21.31.01.41.4.6 
latch: shared pool40441.82.55.911.614.911.112.1 
latch: undo global data26.7K98.2.2.3.3.5.3.2 
library cache lock17100.0       
library cache: mutex X69.6K98.2.3.3.4.5.2.1 
log file parallel write715.3K94.41.32.21.9.1.0.0 
log file sync739046.911.212.913.99.44.41.4 
os thread startup35     28.671.4 
rdbms ipc reply53668.83.23.75.68.86.53.4 
read by other session18.2K32.98.215.119.913.18.62.2 
reliable message54354.714.45.25.96.89.93.1 
row cache lock326999.9    .1  
undo segment extension11823.71.7 3.419.517.833.9 
utl_file I/O1692.9K100.0.0.0.0.0   
wait list latch free32    96.93.1  
DIAG idle wait5649      99.9.1
JOX Jit Process Sleep44      4.595.5
PL/SQL lock timer6001.8     8.290.0
PX Deq Credit: send blkd31100.0       
PX Deq: Execute Reply35596.63.1  .3   
PX Deq: Execution Msg72875.513.53.72.71.21.61.6 
PX Deq: Join ACK3096.73.3      
PX Deq: Msg Fragment7092.9 7.1     
PX Deq: Parse Reply3683.35.65.6 2.82.8  
PX Deq: Table Q Normal6180.3 19.7     
PX Idle Wait3648.0.0    1.398.7
SQL*Net message from client429.4K79.61.91.82.32.61.77.03.1
Space Manager: slave idle wait567       100.0
Streams AQ: qmn coordinator idle wait107855.61.91.31.9.9.3.237.8
Streams AQ: qmn slave idle wait105923.1      76.9
Streams AQ: waiting for messages in the queue1900.1  .1  1.997.9
Streams AQ: waiting for time management or cleanup tasks53051.9     46.61.5
class slave wait1172.7   18.2 9.1 
pipe get1133       100.0
pmon timer11947.2.4.91.01.3.77.980.6
rdbms ipc message472.5K69.213.47.64.1.9.72.02.1
smon timer76   1.3  26.372.4

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
Disk file operations I/O1100.0.0      
LGWR wait for redo copy13100.0.0      
SQL*Net break/reset to client299.9.1      
buffer busy waits14.1K99.8.1.0.0 .0  
buffer deadlock75100.0.0      
control file parallel write899.5.5      
control file sequential read1899.6.4      
cursor: pin S3497.92.0.1     
cursor: pin S wait on X897.72.3      
db file parallel write27100.0.0.0.0    
db file sequential read27399.5.4.0     
enq: FB - contention2599.2.8      
enq: HW - contention139896.42.8.7.1    
enq: SQ - contention2100.0.0      
enq: TX - contention2199.9.1      
enq: TX - index contention25599.7.3.0     
enq: TX - row lock contention12.3K90.05.74.1.2.0.0  
kksfbc child completion1623.876.2      
latch free6798.11.7.1.1    
latch: In memory undo latch41199.8.2.0     
latch: cache buffers chains7518100.0.0.0.0    
latch: cache buffers lru chain798.31.7      
latch: call allocation199.3.7      
latch: enqueue hash chains995.94.1      
latch: redo allocation4698.91.0.1     
latch: row cache objects1899.4.5.1     
latch: shared pool4987.97.94.2     
latch: undo global data4999.8.2.0     
library cache: mutex X5999.9.1.0     
log file parallel write43100.0.0.0     
log file sync10498.61.4.0     
os thread startup2528.665.72.92.9    
rdbms ipc reply1896.63.2.2     
read by other session40897.82.2.0     
reliable message1796.92.9.2     
undo segment extension4066.116.111.05.11.7   

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
VIS44,26019,7151299,069,556
SYS$USERS341617,060
SYS$BACKGROUND0022,897

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
VIS 1831916317283494014933004340741
SYS$USERS 15221100100520
SYS$BACKGROUND 1419054820000

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 ModuleSQL Text
9,222.5448192.1420.8243.310.204y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
6,711.8624279.6615.1522.353.778zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
5,479.7124228.3212.3750.660.000fks7wk7hfq2n RAXTRX begin arp_process_payinfo . de...
5,475.6924228.1512.3650.670.00ccpt6a6djarcv RAXTRX UPDATE RA_INTERFACE_LINES IL S...
5,206.7724216.9511.7548.830.0003r0vwczazc4d RAXTRX declare l_return_status VARCHA...
5,073.929,9990.5111.4548.850.003wtnuzdm579hg RAXTRX UPDATE RA_INTERFACE_LINES_GT S...
3,455.5324143.987.8055.180.016abn0zw8kkvtk RAXTRX begin arp_etax_autoinv_util . ...
3,391.285006.787.6639.450.190z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
2,305.404576.355.2071.760.305t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
1,885.2510188.524.2672.250.0066wrj78kps6jm XLAACCUP UPDATE XLA_AE_LINES_GT AEL SET...
1,765.6595,0400.023.9954.540.0034bx0h6k0q8a1 RAXTRX SELECT TAX_REGIME_CODE, TAX, S...
1,680.642470.033.7949.870.485t6wystf9zvbb OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,471.305192.833.3221.530.011p2p9fdwaujpv INCTCM update MTL_TRANSACTIONS_INTERF...
1,346.932651.803.0448.590.870074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
753.42297,4990.001.7041.890.103b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
629.822,397,4010.001.4257.910.007qh9zcbrq9ky7 WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
622.8399,7230.011.4149.600.014yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
606.0999,9790.011.3710.340.000wabkkyua3y3v FNDWFBG SELECT ITEM_KEY FROM WF_ITEMS ...
541.96278,3130.001.2254.590.009d8w3myb2h8bs RAXTRX SELECT TAX_REGIME_CODE, TAX, T...
513.0099,8450.011.1643.020.13assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
453.6019,9750.021.0231.020.00f07y7y34utqz1 WSHPSGL_SUB SELECT SEQUENCE_NUMBER FROM WS...

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 ModuleSQL Text
3,994.474883.2220.249,222.5443.310.204y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
2,776.0824115.6714.075,479.7150.660.000fks7wk7hfq2n RAXTRX begin arp_process_payinfo . de...
2,774.3024115.6014.065,475.6950.670.00ccpt6a6djarcv RAXTRX UPDATE RA_INTERFACE_LINES IL S...
2,542.4224105.9312.895,206.7748.830.0003r0vwczazc4d RAXTRX declare l_return_status VARCHA...
2,478.749,9990.2512.565,073.9248.850.003wtnuzdm579hg RAXTRX UPDATE RA_INTERFACE_LINES_GT S...
1,906.652479.449.663,455.5355.180.016abn0zw8kkvtk RAXTRX begin arp_etax_autoinv_util . ...
1,654.314413.588.382,305.4071.760.305t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
1,500.032462.507.606,711.8622.353.778zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
1,362.1010136.216.901,885.2572.250.0066wrj78kps6jm XLAACCUP UPDATE XLA_AE_LINES_GT AEL SET...
1,337.695002.686.783,391.2839.450.190z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
962.9095,0400.014.881,765.6554.540.0034bx0h6k0q8a1 RAXTRX SELECT TAX_REGIME_CODE, TAX, S...
838.192434.924.251,680.6449.870.485t6wystf9zvbb OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
654.432625.173.321,346.9348.590.870074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
364.722,397,4010.001.85629.8257.910.007qh9zcbrq9ky7 WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
316.765190.611.611,471.3021.530.011p2p9fdwaujpv INCTCM update MTL_TRANSACTIONS_INTERF...
315.57297,4990.001.60753.4241.890.103b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
308.9199,7230.001.57622.8349.600.014yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
295.86278,3130.001.50541.9654.590.009d8w3myb2h8bs RAXTRX SELECT TAX_REGIME_CODE, TAX, T...
239.02298.241.21417.7857.210.187ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit...
220.6999,8450.001.12513.0043.020.13assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
202.03367.341.02297.3867.940.221wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
201.44299,3790.001.02324.5062.080.2333838u0xy9fk9 WSHPSGL_SUB INSERT INTO MTL_MATERIAL_TRAN...

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 ModuleSQL Text
252.772410.5379.376,711.8622.353.778zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
18.41480.385.789,222.5443.310.204y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
11.67260.453.671,346.9348.590.870074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
8.07240.342.541,680.6449.870.485t6wystf9zvbb OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
6.9541.742.182,305.4071.760.305t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
6.365000.012.003,391.2839.450.190z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1.671,478,6950.000.52430.9227.710.39cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
0.77297,4990.000.24753.4241.890.103b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
0.771440.010.24326.7657.500.2337f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
0.76290.030.24417.7857.210.187ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
2,486,028,99724103,584,541.5427.385,206.7748.830.0003r0vwczazc4d RAXTRX declare l_return_status VARCHA...
2,477,417,1999,999247,766.5027.295,073.9248.850.003wtnuzdm579hg RAXTRX UPDATE RA_INTERFACE_LINES_GT S...
1,071,748,9084822,328,102.2511.809,222.5443.310.204y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
758,658,2744189,664,568.508.362,305.4071.760.305t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
672,969,1011067,296,910.107.411,885.2572.250.0066wrj78kps6jm XLAACCUP UPDATE XLA_AE_LINES_GT AEL SET...
671,426,5512427,976,106.297.393,455.5355.180.016abn0zw8kkvtk RAXTRX begin arp_etax_autoinv_util . ...
487,738,88895,0405,131.935.371,765.6554.540.0034bx0h6k0q8a1 RAXTRX SELECT TAX_REGIME_CODE, TAX, S...
345,242,8112,397,401144.013.80629.8257.910.007qh9zcbrq9ky7 WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
307,676,4502412,819,852.083.391,680.6449.870.485t6wystf9zvbb OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
241,845,2502410,076,885.422.666,711.8622.353.778zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
132,745,749265,105,605.731.461,346.9348.590.870074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
116,170,813500232,341.631.283,391.2839.450.190z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
53,168413,292.0040.182,305.4071.760.305t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
36,618241,525.7527.676,711.8622.353.778zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
12,09848252.049.149,222.5443.310.204y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
3,66626141.002.771,346.9348.590.870074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
2,0722486.331.571,680.6449.870.485t6wystf9zvbb OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
9365001.870.713,391.2839.450.190z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
8183272.670.62297.3867.940.221wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
3651,478,6950.000.28430.9227.710.39cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
2961442.060.22326.7657.500.2337f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
2802411.670.213,455.5355.180.016abn0zw8kkvtk RAXTRX begin arp_etax_autoinv_util . ...

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 ModuleSQL Text
36,65436,654241,527.250.0052.878zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
12,07912,07948251.650.0017.424y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
6,2686,26841,567.000.009.045t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
3,6603,66026140.770.005.280074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
2,1112,1112487.960.003.045t6wystf9zvbb OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
9369365001.870.001.350z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
8188183272.670.001.181wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
2962961442.060.000.4337f1qguwxw0sk RAXTRX begin IF ( :v_msg_level:i_msg_...
2802802411.670.000.406abn0zw8kkvtk RAXTRX begin arp_etax_autoinv_util . ...
2452455190.470.000.351p2p9fdwaujpv INCTCM update MTL_TRANSACTIONS_INTERF...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
2,397,40199,9330.04629.8257.910.007qh9zcbrq9ky7 WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
1,478,6951,478,2851.00430.9227.710.39cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
1,088,4331,087,8891.00289.5733.720.18gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
797,787796,2661.00406.9828.780.007bdg2fscmus2h WSHINTERFACES SELECT ACCOUNTING_RULE_ID , AC...
299,697299,5581.00264.3853.760.010mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0; be...
299,379298,9791.00324.5062.080.2333838u0xy9fk9 WSHPSGL_SUB INSERT INTO MTL_MATERIAL_TRAN...
297,499296,6711.00753.4241.890.103b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
278,313266,4880.96541.9654.590.009d8w3myb2h8bs RAXTRX SELECT TAX_REGIME_CODE, TAX, T...
239,99710,0000.04290.7339.220.006mu4cfrayu648 WSHPSGL_SUB SELECT 'x' FROM WSH_PR_WORKERS...
222,663221,8431.0030.05104.580.010758ng3cbw07m WSHINTERFACES SELECT STOP_ID FROM WSH_TRIP_S...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
294,638299,6976.440mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0; be...
220,854222,6634.830758ng3cbw07m WSHINTERFACES SELECT STOP_ID FROM WSH_TRIP_S...
196,719198,1844.301c0b7sas42w2z WSHPSGL_SUB SELECT NVL(ITEM_COST, 0), COS...
195,737196,6914.281v818hwxjxy58 WSHINTERFACES select FND_FLEX_VALUES_VL.FLEX...
119,444118,9742.61bf7uwg5pa3pj6 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.V...
119,421119,0922.6176sw2a4vnc89j WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.S...
119,345119,6672.61dcvv68fju01g4 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.E...
119,304118,7062.61608c0n36kaw62 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.C...
100,820100,8222.214m7m0t6fjcs5x   update seq$ set increment$=:2,...
99,28799,5062.17cw171rvngr1w9 WSHINTERFACES begin OE_FLEX_COGS_PUB.GET_COS...
98,98599,5582.16bsuw7pmwrufpy INCTCW SELECT reservation_id , prima...
98,68298,9762.16g2qs4xk48vcwy WSHINTERFACES select to_char(CODE_COMBINATIO...
95,63997,2122.09a40f9h91scg23 WSHINTERFACES select to_char(CODE_COMBINATIO...
95,61297,3612.096ujg2sv6yp0w9 WSHPSGL_SUB SELECT BASE.REVISION , BASE.LO...
89,18689,2851.952skwhauh2cwky   select o.name, u.name from obj...
88,94889,0821.957gtztzv329wg0   select c.name, u.name from con...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,571,040240.07akz2hmcq2mppg RAXTRX INSERT ALL WHEN (ZX_LOCATION_M...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

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;
03r0vwczazc4d declare l_return_status VARCHAR2 ( 2000 ) ; l_msg_count NUMBER ; l_msg_data VARCHAR2 ( 2000 ) ; l_instrument_assignment_id NUMBER ; l_response_rec IBY_FNDCPT_COMMON_PUB . RESULT_REC_TYPE ; l_payment_trxn_extension_id NUMBER ; l_payer_rec IBY_FNDCPT_COMMON_PUB . PAYERCONTEXT_REC_TYPE ; l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB . TRXNEXTENSION_REC_TYPE ; l_cust_account_id NUMBER ; l_cust_site_use_id NUMBER ; l_party_id NUMBER ; l_org_id NUMBER ; l_org_type VARCHAR2 ( 30 ) ; l_payment_function VARCHAR2 ( 30 ) ; l_payment_channel VARCHAR2 ( 30 ) ; l_instrument_type VARCHAR2 ( 30 ) ; cursor lines_rec_cur is select distinct l . customer_trx_id , l . trx_number , l . paying_customer_id , l . paying_site_use_id , l . orig_system_bill_customer_id , l . orig_system_bill_address_id , l . org_id , l . receipt_method_id , l . currency_code , l . trx_date , rm . payment_channel_code , pc . instrument_type , su . site_use_id bill_to_site_use_id from ra_interface_lines_gt l , ar_receipt_methods rm , ar_receipt_classes rc , iby_fndcpt_pmt_chnnls_b pc , hz_cust_site_uses su where l . request_id = fnd_global . conc_request_id and l . receipt_method_id is not null and l . customer_trx_id is not null and l . payment_trxn_extension_id is null and nvl ( l . interface_status , '~' ) != 'P' and rm . receipt_method_id = l . receipt_method_id and rm . receipt_class_id = rc . receipt_class_id and rc . creation_method_code in ( 'AUTOMATIC' , 'BR' ) and rm . payment_channel_code = pc . paym ent_channel_code and su . site_use_code = 'BILL_TO' and su . cust_acct_site_id = l . orig_system_bill_address_id ; BEGIN arp_standard . debug ( 'Default Payment Transaction Extension ID()+' ) ; FOR line_rec IN lines_rec_cur LOOP l_payment_channel := line_rec . payment_channel_code ; l_instrument_type := line_rec . instrument_type ; l_instrument_assignment_id := NULL ; l_payment_trxn_extension_id := NULL ; IF l_instrument_type = 'CREDITCARD' THEN Select substrb ( max ( decode ( acct_site_use_id , NULL , '1' || to_char ( instr_assignment_id ) , '2' || to_char ( instr_assignment_id ) ) ) , 2 ) into l_instrument_assignment_id from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'CREDITCARD' and order_of_preference = 1 and cust_account_id = line_rec . paying_customer_id and line_rec . paying_site_use_id = nvl ( acct_site_use_id , line_rec . paying_site_use_id ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ; IF l_instrument_assignment_id IS NULL THEN Select substrb ( max ( decode ( acct_site_use_id , NULL , '1' || to_char ( instr_assignment_id ) , '2' || to_char ( instr_assignment_id ) ) ) , 2 ) into l_instrument_assignment_id from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'CREDITCARD' and order_of_preference = 1 and cust_account_id = line_rec . orig_system_bill_customer_id and line_rec . bill_to_site_use_id = nvl ( acct_site_use_id , line_rec . bill_to_site_ use_id ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ; END IF ; ELSIF l_instrument_type = 'BANKACCOUNT' THEN Select substrb ( min ( decode ( acct_site_use_id , NULL , decode ( currency_code , NULL , '4' || to_char ( instr_assignment_id ) , '3' || to_char ( instr_assignment_id ) ) , decode ( currency_code , NULL , '2' || to_char ( instr_assignment_id ) , '1' || to_char ( instr_assignment_id ) ) ) ) , 2 ) into l_instrument_assignment_id from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'BANKACCOUNT' and cust_account_id = line_rec . paying_customer_id and line_rec . paying_site_use_id = nvl ( acct_site_use_id , line_rec . paying_site_use_id ) and line_rec . currency_code = nvl ( currency_code , line_rec . currency_code ) and order_of_preference = ( select substrb ( min ( decode ( acct_site_use_id , NULL , decode ( currency_code , NULL , '4' || to_char ( order_of_preference ) , '3' || to_char ( order_of_preference ) ) , decode ( currency_code , NULL , '2' || to_char ( order_of_preference ) , '1' || to_char ( order_of_preference ) ) ) ) , 2 ) from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'BANKACCOUNT' and cust_account_id = line_rec . paying_customer_id and line_rec . paying_site_use_id = nvl ( acct_site_use_id , line_rec . paying_site_use_id ) and line_rec . currency_code = nvl ( currency_code , line_rec . currency_code ) and line_rec . tr x_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ; IF l_instrument_assignment_id IS NULL THEN Select substrb ( min ( decode ( acct_site_use_id , NULL , decode ( currency_code , NULL , '4' || to_char ( instr_assignment_id ) , '3' || to_char ( instr_assignment_id ) ) , decode ( currency_code , NULL , '2' || to_char ( instr_assignment_id ) , '1' || to_char ( instr_assignment_id ) ) ) ) , 2 ) into l_instrument_assignment_id from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'BANKACCOUNT' and cust_account_id = line_rec . orig_system_bill_customer_id and line_rec . bill_to_site_use_id = nvl ( acct_site_use_id , line_rec . bill_to_site_use_id ) and line_rec . currency_code = nvl ( currency_code , line_rec . currency_code ) and order_of_preference = ( select substrb ( min ( decode ( acct_site_use_id , NULL , decode ( currency_code , NULL , '4' || to_char ( order_of_preference ) , '3' || to_char ( order_of_preference ) ) , decode ( currency_code , NULL , '2' || to_char ( order_of_preference ) , '1' || to_char ( order_of_preference ) ) ) ) , 2 ) from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'BANKACCOUNT' and cust_account_id = line_rec . orig_system_bill_customer_id and line_rec . bill_to_site_use_id = nvl ( acct_site_use_id , li ne_rec . bill_to_site_use_id ) and line_rec . currency_code = nvl ( currency_code , line_rec . currency_code ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ; END IF ; END IF ; arp_standard . debug ( 'l_instrument_assignment_id :- ' || l_instrument_assignment_id ) ; IF l_instrument_assignment_id IS NOT NULL THEN select party_id , cust_account_id , acct_site_use_id , org_id , org_type , payment_function into l_party_id , l_cust_account_id , l_cust_site_use_id , l_org_id , l_org_type , l_payment_function from IBY_FNDCPT_payer_assgn_instr_v where instr_assignment_id = l_instrument_assignment_id and rownum < 2 ; l_payer_rec . payment_function := l_payment_function ; l_payer_rec . party_id := l_party_id ; l_payer_rec . cust_account_id := l_cust_account_id ; l_payer_rec . account_site_id := l_cust_site_use_id ; l_payer_rec . org_id := l_org_id ; l_payer_rec . org_type := l_org_type ; l_trxn_attribs_rec . originating_application_id := arp_standard . application_id ; l_trxn_attribs_rec . order_id := line_rec . customer_trx_id ; l_trxn_attribs_rec . trxn_ref_number1 := 'TRANSACTION' ; l_trxn_attribs_rec . trxn_ref_number2 := line_rec . customer_trx_id ; IBY_FNDCPT_TRXN_PUB . CREATE_TRANSACTION_EXTENSION ( p_api_version => 1.0 , p_init_ msg_list => FND_API . G_TRUE , p_commit => FND_API . G_FALSE , x_return_status => l_return_status , x_msg_count => l_msg_count , x_msg_data => l_msg_data , p_payer => l_payer_rec , p_payer_equivalency => IBY_FNDCPT_COMMON_PUB . G_PAYER_EQUIV_UPWARD , p_pmt_channel => l_payment_channel , p_instr_assignment => l_instrument_assignment_id , p_trxn_attribs => l_trxn_attribs_rec , x_entity_id => l_payment_trxn_extension_id , x_response => l_response_rec ) ; IF l_return_status = FND_API . G_RET_STS_SUCCESS THEN arp_standard . debug ( 'l_payment_trxn_extension_id :- ' || l_payment_trxn_extension_id ) ; update ra_interface_lines_gt set payment_trxn_extension_id = l_payment_trxn_extension_id where customer_trx_id = line_rec . customer_trx_id and request_id = fnd_global . conc_request_id and receipt_method_id is not null ; ELSE arp_standard . debug ( 'Processing customer_trx_id :- ' || line_rec . customer_trx_id ) ; arp_standard . debug ( 'result_code :- ' || l_response_rec . result_code ) ; arp_standard . debug ( 'result_category :- ' || l_response_rec . result_category ) ; arp_standard . debug ( 'result_message :- ' || l_response_rec . result_message ) ; arp_standard . debug ( 'l_return_status :- ' || l_return_status ) ; arp_standard . debug ( 'l_msg_count :- ' || l_msg_count ) ; arp_standard . debug ( 'l_msg_data :- ' || l_msg_data ) ; END IF ; END IF ; END LOOP ; arp_standard . debug ( 'Default Payment Transaction Extension ID()-' ) ; E XCEPTION WHEN OTHERS THEN arp_standard . debug ( 'Error in Default Payment Transaction Extension ID' ) ; arp_standard . debug ( '[' || SQLERRM ( SQLCODE ) || ']' ) ; RAISE ; END ;
0758ng3cbw07mSELECT STOP_ID FROM WSH_TRIP_STOPS WHERE BATCH_ID = :B1 FOR UPDATE NOWAIT
0fks7wk7hfq2nbegin arp_process_payinfo . default_payment_attributes ; EXCEPTION WHEN OTHERS THEN arp_standard . debug ( 'Error in arp_process_payinfo.' || 'default_payment_attributes()' ) ; arp_standard . debug ( '[' || SQLERRM ( SQLCODE ) || ']' ) ; RAISE ; END ;
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;
0wabkkyua3y3vSELECT ITEM_KEY FROM WF_ITEMS WHERE ITEM_TYPE = :B2 AND ITEM_KEY = :B1 FOR UPDATE
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
1p2p9fdwaujpvupdate MTL_TRANSACTIONS_INTERFACE MTI set TRANSACTION_HEADER_ID=:b0, LAST_UPDATE_DATE=SYSDATE, LAST_UPDATED_BY=:b1, LAST_UPDATE_LOGIN=:b2, PROGRAM_APPLICATION_ID=:b3, PROGRAM_ID=:b4, REQUEST_ID=:b5, PROGRAM_UPDATE_DATE=SYSDATE, LOCK_FLAG=1, ERROR_CODE=null , ERROR_EXPLANATION=null where (((((PROCESS_FLAG=1 and NVL(LOCK_FLAG, 2)=2) and TRANSACTION_MODE=3) and ROWNUM<=:b6) and exists (select 'X' from MTL_TRANSACTION_TYPES MTT where (MTT.TRANSACTION_TYPE_ID=MTI.TRANSACTION_TYPE_ID and MTT.TRANSACTION_SOURCE_TYPE_ID in (2, 8, 16)))) and exists (select 1 from ORG_ORGANIZATION_DEFINITIONS OOD where (OOD.ORGANIZATION_ID=MTI.ORGANIZATION_ID and NVL(OOD.DISABLE_DATE, (SYSDATE+1))>SYSDATE)))
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;
2skwhauh2cwkyselect o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
33838u0xy9fk9 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 , INVOICED_FLAG , DISTRIBUTION_ACCOUNT_ID , ENCUMBRANCE_ACCOUNT , ENCUMBRANCE_AMOUNT , COST_U PDATE_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, SOUR CE_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 ) 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, 'N', :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))
34bx0h6k0q8a1 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 = :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 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 = :B3 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, -1 COMPOUNDING_PRECEDENCE FROM ZX_SCO_RATES_B_V RT WHERE RT.TAX_RATE_CODE = :B4 AND RT.RATE_TYPE_CODE <> 'RECOVERY' AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFE CTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B3 OR RT.TAX_CLASS IS NULL) AND EXISTS (SELECT 1 FROM ZX_SCO_TAXES_B_V TAX WHERE 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') ) ORDER BY COMPOUNDING_PRECEDENCE
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 ;
3b3psftuyks81BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3wtnuzdm579hgUPDATE RA_INTERFACE_LINES_GT SET PAYMENT_TRXN_EXTENSION_ID = :B2 WHERE CUSTOMER_TRX_ID = :B1 AND REQUEST_ID = FND_GLOBAL . CONC_REQUEST_ID AND RECEIPT_METHOD_ID IS NOT NULL
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
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;
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;
608c0n36kaw62begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
66wrj78kps6jmUPDATE XLA_AE_LINES_GT AEL SET AEL.REF_EVENT_ID = -1 * AEL.REF_EVENT_ID , AEL.REF_AE_HEADER_ID = :B1 WHERE AEL.REF_AE_HEADER_ID = :B6 AND AEL.REF_EVENT_ID = -1 * :B5 AND AEL.TEMP_LINE_NUM < 0 AND AEL.LEDGER_ID = :B4 AND AEL.BALANCE_TYPE_CODE = :B3 AND AEL.REVERSAL_CODE = 'REVERSAL' AND AEL.HEADER_NUM = NVL( :B2 , 0)
6abn0zw8kkvtkbegin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :num_tax_failures , :return_status:i_return_status ) ; END ;
6mu4cfrayu648SELECT 'x' FROM WSH_PR_WORKERS WHERE ROWID = :B1 AND PROCESSED = 'N' FOR UPDATE NOWAIT
6ujg2sv6yp0w9 SELECT BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.UOM_CODE , DECODE(:B7 , -9999, NULL, :B7 ) LPN_ID , NULL SERIAL_NUMBER , SUM(BASE.PRIMARY_QUANTITY) , SUM(BASE.SECONDARY_QUANTITY) , BASE.GRADE_CODE , NULL CONSIST_STRING , BASE.DATE_RECEIVED ORDER_BY_STRING FROM WMS_TRX_DETAILS_TMP_V MPTDTV , ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , X.LOT_NUMBER LOT_NUMBER , X.LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , X.COST_GROUP_ID COST_GROUP_ID , X.STATUS_ID STATUS_ID , NULL SERIAL_NUMBER , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , X.GRADE_CODE GRADE_CODE , X.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCRESERVABLE LOCRESERVABLE , X.LOTRESERVABLE LOTRESERVABLE , NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) UOM_CODE , WMS_RULE_PVT.GETCONVERSIONRATE( NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) , X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID) CONVERSION_RATE , NULL LOCATOR_INVENTORY_ITEM_ID , NULL EMPTY_FLAG , NULL LOCATION_CURRENT_UNITS FROM ( SELECT X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , X.LOT_NUMBER , LOT.EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE , NVL(X.RESERVABLE_TYPE, 1) LOCRESERVABLE , NVL(LOT.RESERV ABLE_TYPE, 1) LOTRESERVABLE , X.LOCATOR_ID , X.COST_GROUP_ID , X.STATUS_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , LOT.GRADE_CODE GRADE_CODE , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID FROM (SELECT MOQ.ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID , MOQ.REVISION , MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE , MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID , MOQ.STATUS_ID , MILS.RESERVABLE_TYPE , MIN(NVL(MOQ.ORIG_DATE_RECEIVED, MOQ.DATE_RECEIVED)) DATE_RECEIVED , SUM(MOQ.PRIMARY_TRANSACTION_QUANTITY) PRIMARY_QUANTITY , SUM(MOQ.SECONDARY_TRANSACTION_QUANTITY) SECONDARY_QUANTITY , MOQ.LPN_ID LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) PROJECT_ID , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) TASK_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ, MTL_ITEM_LOCATIONS MILS WHERE MOQ.ORGANIZATION_ID = :B2 AND MOQ.INVENTORY_ITEM_ID = :B1 AND MOQ.ORGANIZATION_ID = MILS.ORGANIZATION_ID (+) AND MOQ.SUBINVENTORY_CODE = MILS.SUBINVENTORY_CODE (+) AND MOQ.LOCATOR_ID = MILS.INVENTORY_LOCATION_ID (+) GROUP BY MOQ.ORGANIZATION_ID, MOQ.INVENTORY_ITEM_ID , MOQ.REVISION, MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE, MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID, MOQ.STATUS_ID, MILS.RESERVABLE_TYPE, MOQ.LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_LOT_NUMBERS LOT WHERE X.PRIMARY_QUANTITY > 0 AND X.OR GANIZATION_ID = SUB.ORGANIZATION_ID AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME AND X.ORGANIZATION_ID = LOT.ORGANIZATION_ID (+) AND X.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_ID (+) AND X.LOT_NUMBER = LOT.LOT_NUMBER (+) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_ITEM_LOCATIONS LOC WHERE X.ORGANIZATION_ID = LOC.ORGANIZATION_ID (+) AND X.LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+) AND SUB.ORGANIZATION_ID = X.ORGANIZATION_ID AND SUB.SECONDARY_INVENTORY_NAME = X.SUBINVENTORY_CODE ) BASE WHERE BASE.ORGANIZATION_ID = :B2 AND BASE.INVENTORY_ITEM_ID = :B1 AND DECODE(:B11 , '-9999', 'a', BASE.SUBINVENTORY_CODE) = DECODE(:B11 , '-9999', 'a', :B11 ) AND ((EXISTS (SELECT 1 FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = :B2 AND DEFAULT_STATUS_ID IS NOT NULL ) AND EXISTS(SELECT 1 FROM MTL_MATERIAL_STATUSES WHERE STATUS_ID = BASE.STATUS_ID AND RESERVABLE_TYPE = 1)) OR ((NOT EXISTS(SELECT 1 FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = :B2 AND DEFAULT_STATUS_ID IS NOT NULL) OR BASE.STATUS_ID IS NULL) AND DECODE(:B11 , '-9999', BASE.RESERVABLE_TYPE, 1) = 1)) AND DECODE(:B10 , -9999, 1, BASE.LOCATOR_ID) = DECODE(:B10 , -9999, 1, :B10 ) AND DECODE(:B9 , '-99', 'a', BASE.REVISION) = DECODE(:B9 , '-99', 'a', :B9 ) AND DECODE(:B8 , '-9999', 'a', BASE.LOT_NUMBER) = DECODE(:B8 , '-9999', 'a', :B8 ) AND DECODE(:B7 , -9999, 1, BASE.LPN_ID) = DECODE(:B7 , -9999, 1, :B7 ) AND DECODE(:B6 , -9999, 1, BASE.COST_GROUP_ID) = DECODE(:B6 , -9999, 1, :B6 ) AND (DECODE(:B5 , -9999, -1, BASE.PROJECT_ID) = DECODE(:B5 , -9999, -1, :B5 ) OR ( :B5 = -7777 AND BASE.PROJECT_ID IS NULL)) AND (:B5 = -9999 OR NVL(BASE.TASK_ID, -9999) = :B4 OR (:B4 = -7777 AND BASE.TASK_ID IS NULL)) AND MPTDTV.PP_TRANSACTION_TEMP_ID = :B3 GROUP BY BASE.ORGANIZATION_ID , BASE.INVENTORY_ITEM_ID , BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.PROJECT_ID , BASE.TASK_ID , BASE.UOM_CODE , BASE.GRADE_CODE , BASE.DATE_RECEIVED, BASE.SERIAL_NUMBER, BASE.CONVERSION_RATE , BASE.DATE_RECEIVED ORDER BY BASE.DATE_RECEIVED DESC , BASE.SERIAL_NUMBER ASC, BASE.CONVERSION_RATE DESC
76sw2a4vnc89jbegin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7bdg2fscmus2h SELECT 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 , GLOB AL_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 , LAT EST_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 , SCHED ULE_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_ATTRI BUTE8 , 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 FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
7gtztzv329wg0select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
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
8zfgv4ck11dw9BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END;
9d8w3myb2h8bsSELECT TAX_REGIME_CODE, TAX, TAX_STATUS_CODE, TAX_RATE_CODE, TAX_RATE_ID, EFFECTIVE_FROM, EFFECTIVE_TO, RATE_TYPE_CODE, PERCENTAGE_RATE, QUANTITY_RATE, ALLOW_ADHOC_TAX_RATE_FLAG, UOM_CODE, TAX_JURISDICTION_CODE, OFFSET_TAX, OFFSET_STATUS_CODE, OFFSET_TAX_RATE_CODE, ALLOW_EXEMPTIONS_FLAG, ALLOW_EXCEPTIONS_FLAG, NULL TAX_JURISDICTION_ID, DEF_REC_SETTLEMENT_OPTION_CODE, TAXABLE_BASIS_FORMULA_CODE, ADJ_FOR_ADHOC_AMT_CODE, INCLUSIVE_TAX_FLAG, TAX_CLASS FROM ZX_SCO_RATES_B_V WHERE TAX_REGIME_CODE = :B7 AND TAX = :B6 AND TAX_STATUS_CODE = :B5 AND ACTIVE_FLAG = 'Y' AND (TAX_JURISDICTION_CODE = :B4 ) AND TAX_RATE_CODE = :B3 AND (TAX_CLASS = :B2 OR TAX_CLASS IS NULL) AND ( :B1 >= EFFECTIVE_FROM AND (:B1 <= EFFECTIVE_TO OR EFFECTIVE_TO IS NULL)) ORDER BY TAX_CLASS NULLS LAST, SUBSCRIPTION_LEVEL_CODE
a40f9h91scg23select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and CODE_COMBINATION_ID = :FND_BIND2
akz2hmcq2mppg INSERT ALL WHEN (ZX_LOCATION_MISSING = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_LOCATION_MISSING', :B30 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_LINE_CLASS_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_LINE_CLASS_INVALID', :B29 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_TRX_LINE_TYPE_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TRX_LINE_TYPE_INVALID', :B28 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_LINE_AMT_INCL_TAX_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, T RX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_LINE_AMT_INCTAX_INVALID', :B27 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_CATEG_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_CATEG_NOT_EXIST', :B26 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_CATEG_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_CATEG_NOT_EFFECTIVE', :B25 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_CATEG_COUNTRY_INCONSIS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE _LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_CATEG_COUNTRY_INCON', :B24 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (USER_DEF_FC_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_USER_DEF_FC_CODE_NOT_EXIST', :B23 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (USER_DEF_FC_CODE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_USER_DEF_FC_CODE_NOT_EFFECT', :B22 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (USER_DEF_COUNTRY_INCONSIS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_USER_DEF_COUNTRY_INCONSIS', :B21 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (DOC_FC_CODE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_DOC_FC_CODE_NOT_EFFECTIVE', :B20 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (TRX_BIZ_FC_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TRX_BIZ_FC_CODE_NOT_EXIST', :B19 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (TRX_BIZ_FC_CODE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TRX_BIZ_FC_CODE_NOT_EFFECT', :B18 , TRX_LEVEL_TYPE, INTERFACE_LI NE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (TRX_BIZ_FC_COUNTRY_INCONSIS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TRX_BIZ_FC_COUNTRY_INCONSIS', :B17 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (INTENDED_USE_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INTENDED_USE_CODE_NOT_EXIST', :B16 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (INTENDED_USE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INTENDED_USE_NOT_EFFECTIVE', :B15 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (INTENDED_USE_CONTRY_INCONSIS = 'Y') THEN INTO ZX_VALID ATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INTENDED_USE_COUNTRY_INCON', :B14 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_TYPE_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_TYPE_CODE_NOT_EXIST', :B13 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_TYPE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_TYPE_NOT_EFFECTIVE', :B12 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_FC_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_T AX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_FC_CODE_NOT_EXIST', :B11 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_LINE_CTRL_AMT_NOT_NULL = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_LINE_CTRL_AMT_NOT_NULL', :B10 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_EXEMPTION_CTRL_FLAG_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_EXEMPTION_CTRL_FLAG_INVALID', :B9 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_PRODUCT_TYPE_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE _ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_TYPE_INVALID', :B8 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_INVALID_TAX_LINES = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INVALID_TAX_LINES', :B7 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_INVALID_LINE_TAX_AMT = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INVALID_LINE_TAX_AMT', :B6 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_INVALID_TAX_FOR_ALLOC_FLG = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INVALID_TAX_FOR_ALLOC_FLG', :B5 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_INVALID_TAX_ONLY_TAX_LINES = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INVALID_TAX_ONLY_TAX_LINES', :B4 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (TAX_RATE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TAX_RATE_NOT_EXIST', :B3 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (NVL(TAX_RATE_NOT_EXISTS, 'N') <> 'Y' AND TAX_RATE_CODE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TAX_RATE_NOT_EFFECTIVE', :B2 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN ( NVL(TAX_RATE_NOT_EXISTS, 'N') <> 'Y' AND TAX_RATE_CODE_NOT_ACTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TAX_RATE_NOT_ACTIVE', :B1 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) SELECT HEADER.APPLICATION_ID, HEADER.ENTITY_CODE, HEADER.EVENT_CLASS_CODE, HEADER.TRX_ID, LINES_GT.TRX_LINE_ID, LINES_GT.TRX_LINE_ID INTERFACE_LINE_ID , LINES_GT.ENTITY_CODE INTERFACE_LINE_ENTITY_CODE, LINES_GT.TRX_LEVEL_TYPE, CASE WHEN (LINES_GT.SHIP_FROM_LOCATION_ID IS NOT NULL OR LINES_GT.SHIP_TO_LOCATION_ID IS NOT NULL OR LINES_GT.POA_LOCATION_ID IS NOT NULL OR LINES_GT.POO_LOCATION_ID IS NOT NULL OR LINES_GT.PAYING_LOCATION_ID IS NOT NULL OR LINES_GT.OWN_HQ_LOCATION_ID IS NOT NULL OR LINES_GT.TRADING_HQ_LOCATION_ID IS NOT NULL OR LINES_GT.POC_LOCATION_ID IS NOT NULL OR LINES_GT.POI_LOCATION_ID IS NOT NULL OR LINES_GT.POD_LOCATION_ID IS NOT NULL OR LINES_GT.BILL_TO_LOCATION_ID IS NOT NULL OR LINES_GT.BILL_FROM_LOCATION_ID IS NOT NULL OR LINES_GT.TITLE_TRANSFER_LOCATION_ID IS NOT NULL) THEN NULL ELSE 'Y' END ZX_LOCATION_MISSING, NVL2(LINES_GT.LINE_CLASS, CASE WHEN (NOT EXISTS (SELECT 1 FROM FND_LOOKUPS LKP WHERE LINES_GT.LINE_CLASS = LKP.LOOKUP_CODE AND LKP.LOOKUP_TYPE = 'ZX_ LINE_CLASS')) THEN 'Y' ELSE NULL END, NULL ) ZX_LINE_CLASS_INVALID, CASE WHEN (LINES_GT.TRX_LINE_TYPE NOT IN('ITEM', 'FREIGHT', 'MISC', 'MISCELLANEOUS')) THEN 'Y' ELSE NULL END ZX_TRX_LINE_TYPE_INVALID, CASE WHEN (LINES_GT.LINE_AMT_INCLUDES_TAX_FLAG IS NULL OR LINES_GT.LINE_AMT_INCLUDES_TAX_FLAG NOT IN ('A', 'N', 'S')) THEN 'Y' ELSE NULL END ZX_LINE_AMT_INCL_TAX_INVALID, NVL2(LINES_GT.PRODUCT_CATEGORY, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN 'Y' ELSE NULL END, NULL ) PRODUCT_CATEG_NOT_EXISTS, CASE WHEN LINES_GT.PRODUCT_CATEGORY IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) AND NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE) BETWEEN EFFECTIVE_FROM AND NVL(EFFECTIVE_TO, NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE)))) THEN 'Y' ELSE NULL END ELSE NULL END PRODUCT_CATEG_NOT_EFFECTIVE, CASE WHEN LINES_GT.PRODUCT_CATEGORY IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND COUNTRY_CODE IS NOT NULL) ) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND COUNTRY_CODE IS NOT NULL AND COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY)) THEN 'Y' ELSE NULL END ELSE NULL END PRODUCT_CATEG_COUNTRY_INCONSIS, NVL2(LINES_GT.USER_DEFINED_FISC_CLASS, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE CLASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN 'Y' ELSE NULL END, NULL) USER_DEF_FC_CODE_NOT_EXISTS, CASE WHEN LINES_GT.USER_DEFINED_FISC_CLASS IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE CLASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE CLASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) AND NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE) BETWEEN EFFECTIVE_FROM AND NVL(EFFECTIVE_TO, NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE)))) THEN 'Y' ELSE NULL END ELSE NULL END USER_DEF_FC_CODE_NOT_EFFECTIVE, CASE WHEN LINES_GT.USER_DEFINED_FISC_CLASS IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE CLASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND COUNTRY_CODE IS NOT NULL)) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE C LASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND COUNTRY_CODE IS NOT NULL AND COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY)) THEN 'Y' ELSE NULL END ELSE NULL END USER_DEF_COUNTRY_INCONSIS, CASE WHEN HEADER.DOCUMENT_SUB_TYPE IS NOT NULL AND FC_DOC.CLASSIFICATION_CODE IS NOT NULL THEN CASE WHEN ( LINES_GT.TAX_DATE NOT BETWEEN FC_DOC.EFFECTIVE_FROM AND NVL(FC_DOC.EFFECTIVE_TO, LINES_GT.TAX_DATE) AND (NOT EXISTS (SELECT 1 FROM ZX_TRANSACTION_LINES_GT WHERE APPLICATION_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID < LINES_GT.TRX_LINE_ID AND TRX_LEVEL_TYPE = LINES_GT.TRX_LEVEL_TYPE))) THEN 'Y' ELSE NULL END ELSE NULL END DOC_FC_CODE_NOT_EFFECTIVE, NVL2(LINES_GT.TRX_BUSINESS_CATEGORY, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.TRX_BUSINESS_CATEGORY AND (APPLICATION_ID IS NULL OR (APPLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE))))) AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN 'Y' ELSE NULL END, NULL ) TRX_BIZ_FC_CODE_NOT_EXISTS, CASE WHEN LINES_GT.TRX_BUSINESS_CATEGORY IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.TRX_BUSINESS_CATEGORY AND (APPLICATION_ID IS NULL OR (APPLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE))))) AND (COUNTRY_CODE IS NOT NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.TRX_BUSINESS_CATEGORY AND (APPLICATION_ID IS NULL OR (APPLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE))))) AND (COUNTRY_CODE IS NOT NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) AND NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE) BETWEEN EFFECTIVE_FROM AND NVL(EFFECTIVE_TO, NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE)))) THEN 'Y' ELSE NULL END ELSE NULL END TRX_BIZ_FC_CODE_NOT_EFFECTIVE, CASE WHEN LINES_GT.TRX_BUSINESS_CATEGORY IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.TRX_BUSINESS_CATEGORY AND (APPLICATION_ID IS NULL OR (APPLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE))))) AND COUNTRY_CODE IS NOT NULL)) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.TRX_BUSINESS_CATEGORY AND (APPLICATION_ID IS NULL OR (AP PLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE))))) AND COUNTRY_CODE IS NOT NULL AND COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY)) THEN 'Y' ELSE NULL END ELSE NULL END TRX_BIZ_FC_COUNTRY_INCONSIS, NVL2(LINES_GT.LINE_INTENDED_USE, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_INTENDED_USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN 'Y' ELSE NULL END, NULL) INTENDED_USE_CODE_NOT_EXISTS, CASE WHEN LINES_GT.LINE_INTENDED_USE IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_INTENDED_USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_INTENDED_USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) AND NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE) BETWEEN EFFECTIVE_FROM AND NVL(EFFECTIVE_TO, NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE)))) THEN 'Y' ELSE NULL END ELSE NULL END INTENDED_USE_NOT_EFFECTIVE, CASE WHEN LINES_GT.LINE_INTENDED_USE IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_INTENDED_USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND COUNTRY_CODE IS NOT NULL)) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_INTENDED_ USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND COUNTRY_CODE IS NOT NULL AND COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY)) THEN 'Y' ELSE NULL END ELSE NULL END INTENDED_USE_CONTRY_INCONSIS, NVL2(LINES_GT.PRODUCT_TYPE, NVL(FND.LOOKUP_CODE, 'Y'), NULL ) PRODUCT_TYPE_CODE_NOT_EXISTS, CASE WHEN (FND.LOOKUP_CODE IS NOT NULL) THEN CASE WHEN ( LINES_GT.TAX_DATE BETWEEN FND.START_DATE_ACTIVE AND NVL(FND.END_DATE_ACTIVE, LINES_GT.TAX_DATE ) ) THEN NULL ELSE 'Y' END ELSE NULL END PRODUCT_TYPE_NOT_EFFECTIVE, NVL2(LINES_GT.PRODUCT_FISC_CLASSIFICATION, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_FISCAL_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_FISC_CLASSIFICATION AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN 'Y' ELSE NULL END, NULL) PRODUCT_FC_CODE_NOT_EXISTS, CASE WHEN (LINES_GT.LINE_LEVEL_ACTION <> 'CREATE' AND LINES_GT.CTRL_TOTAL_LINE_TX_AMT IS NOT NULL ) THEN 'Y' ELSE NULL END ZX_LINE_CTRL_AMT_NOT_NULL, CASE WHEN (LINES_GT.EXEMPTION_CONTROL_FLAG IS NOT NULL AND LINES_GT.EXEMPTION_CONTROL_FLAG NOT IN ('R', 'S', 'E')) THEN 'Y' ELSE NULL END ZX_EXEMPTION_CTRL_FLAG_INVALID, CASE WHEN (LINES_GT.PRODUCT_TYPE IS NOT NULL AND LINES_GT.PRODUCT_TYPE NOT IN ('GOODS', 'SERVICES')) THEN 'Y' ELSE NULL END ZX_PRODUCT_TYPE_INVALID, CASE WHEN (LINES_GT.CTRL_HDR_TX_APPL_FLAG = 'Y' AND LINES_GT.LINE_LEVEL_ACTION <> 'LINE_INFO_TAX_ONLY' AND EXISTS (SELECT 1 FROM ZX_IMPORT_TAX_LINES_GT IMPTAXES_GT WHERE APPLICATI ON_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID = LINES_GT.TRX_LINE_ID) ) THEN 'Y' ELSE NULL END ZX_INVALID_TAX_LINES, CASE WHEN (LINES_GT.CTRL_TOTAL_LINE_TX_AMT IS NOT NULL AND EXISTS (SELECT 1 FROM ZX_TRX_TAX_LINK_GT WHERE APPLICATION_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID = LINES_GT.TRX_LINE_ID AND TRX_LEVEL_TYPE = LINES_GT.TRX_LEVEL_TYPE) ) THEN 'Y' ELSE NULL END ZX_INVALID_LINE_TAX_AMT, CASE WHEN (LINES_GT.CTRL_TOTAL_LINE_TX_AMT IS NOT NULL AND EXISTS(SELECT 1 FROM ZX_IMPORT_TAX_LINES_GT IMPTAXES_GT WHERE APPLICATION_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID IS NULL AND IMPTAXES_GT.TAX_LINE_ALLOCATION_FLAG = 'N') ) THEN 'Y' ELSE NULL END ZX_INVALID_TAX_FOR_ALLOC_FLG, CASE WHEN (LINES_GT.LINE_LEVEL_ACTION = 'LINE_INFO_TAX_ONLY' AND EXISTS (SELECT 1 FROM ZX_IMPORT_TAX_LINES_GT IMPTAXES_GT WHERE APPLICATION_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID = LINES_GT.TRX_LINE_ID AND IMPTAXES_GT.TAX_LINE_ALLOCATION_FLAG <> 'Y') ) THEN 'Y' ELSE NULL END ZX_INVALID_TAX_ONLY_TAX_LINES, CASE WHEN LINES_GT. OUTPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_OUTPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99)) THEN 'Y' ELSE CASE WHEN LINES_GT.INPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_INPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.INPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99)) THEN 'Y' ELSE NULL END END TAX_RATE_NOT_EXISTS, CASE WHEN LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_OUTPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND LINES_GT.TAX_DATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, LINES_GT.TAX_DATE)) THEN 'Y' ELSE CASE WHEN LINES_GT.INPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_INPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.INPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND LINES_GT.TAX_DATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, LINES_GT.TAX_DATE)) THEN 'Y' ELSE NULL END END TAX_RATE_CODE_NOT_EFFECTIVE, CASE WHEN LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_OUTPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND ENABLED_FLAG = 'Y') THEN 'Y' ELSE CASE WHEN LINES_GT.INPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_INPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.INPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND ENABLED_FLAG = 'Y') THEN 'Y' ELSE NULL END END TAX_RATE_CODE_NOT_ACTIVE FROM ZX_TRX_HEADERS_GT HEADER, ZX_EVNT_CLS_MAPPINGS EVNTMAP, ZX_TRANSACTION_LINES_GT LINES_GT, ZX_FC_DOCUMENT_FISCAL_V FC_DOC, FND_LOOKUPS FND WHERE LINES_GT.TRX_ID = HEADER.TRX_ID AND LINES_GT.APPLICATION_ID = HEADER.APPLICATION_ID AND LINES_GT.ENTITY_CODE = HEADER.ENTITY_CODE AND LINES_GT.EVENT_CLASS_CODE = HEADER.EVENT_CLASS_CODE AND FC_DOC.CLASSIFICATION_CODE(+) = HEADER.DOCUMENT_SUB_TYPE AND FC_DOC.COUNTRY_CODE(+) = HEADER.DEFAULT_TAXATION_COUNTRY AND HEADER.APPLICATION_ID = EVNTMAP.APPLICATION_ID (+) AND HEADER.ENTITY_CODE = EVNTMAP.ENTITY_CODE (+) AND HEADER.EVENT_CLASS_CODE = EVNTMAP.EVENT_CLASS_CODE(+) AND FND.LOOKUP_TYPE(+) = 'ZX_PRODUCT_TYPE' AND FND.LOOKUP_CODE(+) = LINES_GT.PRODUCT_TYPE
assndb4wqnd6rBEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END;
bf7uwg5pa3pj6begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bsuw7pmwrufpy SELECT reservation_id , primary_reservation_quantity - NVL(detailed_quantity, 0) , NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- INVCONV FROM mtl_reservations WHERE demand_source_header_id = :demand_source_header_id AND demand_source_line_id = :demand_source_line_id AND demand_source_type_id = :demand_source_type_id AND supply_source_type_id = :supply_source_type_id AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision) AND (:lpn_id = :l_miss_num OR ((lpn_id IS NULL) OR (:lpn_id = lpn_id))) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name) AND (primary_reservation_quantity - NVL(detailed_quantity, 0)) > 0 ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE
ccpt6a6djarcv UPDATE RA_INTERFACE_LINES IL SET PAYMENT_ATTRIBUTES = (SELECT CASE WHEN AUTHORIZED_FLAG = 'Y' THEN CASE WHEN SUM(DECODE(AUTH.SETTLE_REQ_AUTH_FLAG, 'Y', 1, 0)) > 0 THEN 'PERSISTENT-AUTH~' || EXT.INSTR_ASSIGNMENT_ID || '~' || EXT.TRXN_EXTENSION_ID ELSE 'NON-PERSISTENT-AUTH~' || EXT.INSTR_ASSIGNMENT_ID || '~' END ELSE 'NO-AUTH~' || EXT.INSTR_ASSIGNMENT_ID || '~' END FROM IBY_FNDCPT_TX_EXTENSIONS EXT, (SELECT /*+ leading(op) use_nl(summ, seft, ueft) */ OP.TRXN_EXTENSION_ID, DECODE(DECODE(SUMM.STATUS, 0, 'Y', 100, 'Y', NULL), 'N', 'Y') AUTHORIZED_FLAG, NVL(SEFT.SETTLE_REQUIRE_VRFY_FLAG, 'N') SETTLE_REQ_AUTH_FLAG FROM IBY_TRXN_SUMMARIES_ALL SUMM, IBY_FNDCPT_TX_OPERATIONS OP, IBY_FNDCPT_SYS_EFT_PF_B SEFT, IBY_FNDCPT_USER_EFT_PF_B UEFT WHERE(SUMM.TRANSACTIONID = OP.TRANSACTIONID) AND(REQTYPE = 'ORAPMTREQ') AND(TRXNTYPEID IN(2, 3, 20)) AND(DECODE(INSTRTYPE, 'BANKACCOUNT', SUMM.PROCESS_PROFILE_CODE, NULL) = UEFT.USER_EFT_PROFILE_CODE(+)) AND(UEFT.SYS_EFT_PROFILE_CODE = SEFT.SYS_EFT_PROFILE_CODE(+))) AUTH, FND_APPLICATION A WHERE EXT.TRXN_EXTENSION_ID = IL.PAYMENT_TRXN_EXTENSION_ID AND EXT.TRXN_EXTENSION_ID = AUTH.TRXN_EXTENSION_ID(+) AND AUTH.SETTLE_REQ_AUTH_FLAG(+) = 'Y' AND EXT.ORIGIN_APPLICATION_ID = A.APPLICATION_ID GROUP BY AUTH.AUTHORIZED_FLAG, EXT.INSTR_ASSIGNMENT_ID, EXT.TRXN_EXTENSION_ID) WHERE REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID AND PAYMENT_TRXN_EXTENSION_ID IS NOT NULL
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
cw171rvngr1w9begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end;
dcvv68fju01g4begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
f07y7y34utqz1SELECT SEQUENCE_NUMBER FROM WSH_DOCUMENT_INSTANCES WHERE ENTITY_NAME = :B3 AND ENTITY_ID = :B2 AND STATUS <> 'CANCELLED' AND DOCUMENT_TYPE = :B1
g2qs4xk48vcwyselect to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and (SEGMENT1 = :FND_BIND2) and (SEGMENT2 = :FND_BIND3) and (SEGMENT3 = :FND_BIND4) and (SEGMENT4 = :FND_BIND5) and (SEGMENT5 = :FND_BIND6)
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 )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced43,64215.420.03
CCursor + sql area evicted60.000.00
CPU used by this session1,965,939694.591.38
CPU used when call started1,964,917694.231.38
CR blocks created26,501,5219,363.2718.61
Cached Commit SCN referenced486,022,724171,717.09341.27
Commit SCN cached365,201129.030.26
DB time6,238,6312,204.184.38
DBWR checkpoint buffers written2,398,163847.301.68
DBWR checkpoints50.000.00
DBWR object drop buffers written1,5900.560.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes5080.180.00
DBWR undo block writes2,246,825793.831.58
DFO trees parallelized20.000.00
HSC Heap Segment Block Changes45,437,14816,053.4431.90
Heap Segment Array Inserts357,358126.260.25
Heap Segment Array Updates533,508188.490.37
IMU CR rollbacks957,016338.120.67
IMU Flushes928,857328.180.65
IMU Redo allocation size1,902,603,188672,210.301,335.94
IMU commits596,466210.740.42
IMU contention376,428133.000.26
IMU ktichg flush1,3540.480.00
IMU recursive-transaction flush2390.080.00
IMU undo allocation size2,350,786,056830,558.161,650.64
LOB table id lookup cache misses00.000.00
Number of read IOs issued120.000.00
PX local messages recv'd1,3040.460.00
PX local messages sent1,3040.460.00
Parallel operations downgraded 25 to 50 pct20.000.00
RowCR - row contention274,78197.080.19
RowCR attempts31,526,93811,138.8122.14
RowCR hits28,379,04510,026.6219.93
SMON posted for undo segment shrink720.030.00
SQL*Net roundtrips to/from client423,534149.640.30
active txn count during cleanout4,341,817,6721,534,011.173,048.67
application wait time127,21144.950.09
background checkpoints completed10.000.00
background checkpoints started00.000.00
background timeouts13,1984.660.01
branch node splits1,0600.370.00
buffer is not pinned count1,892,545,936668,656.961,328.88
buffer is pinned count3,133,555,4431,107,119.052,200.27
bytes received via SQL*Net from client128,473,55645,391.1090.21
bytes sent via SQL*Net to client154,685,36454,652.01108.61
calls to get snapshot scn: kcmgss113,330,07340,040.7479.58
calls to kcmgas33,513,98211,840.8523.53
calls to kcmgcs718,484,531253,848.36504.49
cell physical IO interconnect bytes69,212,792,32024,453,628.6048,598.82
change write time59,09820.880.04
cleanout - number of ktugct calls738,971,924261,086.78518.88
cleanouts only - consistent read gets21,725,3347,675.8015.25
cluster key scan block gets161,04656.900.11
cluster key scans133,58847.200.09
commit batch/immediate performed102,36036.160.07
commit batch/immediate requested102,36036.160.07
commit cleanout failures: block lost464,858164.240.33
commit cleanout failures: buffer being written120.000.00
commit cleanout failures: callback failure222,59278.640.16
commit cleanout failures: cannot pin330,040116.610.23
commit cleanouts11,228,6903,967.227.88
commit cleanouts successfully completed10,211,1883,607.727.17
commit immediate performed102,36036.160.07
commit immediate requested102,36036.160.07
commit txn count during cleanout2,290,726809.341.61
concurrency wait time493,674174.420.35
consistent changes1,526,006,959539,154.771,071.51
consistent gets7,904,253,9182,792,658.455,550.09
consistent gets - examination6,118,120,1482,161,598.064,295.93
consistent gets direct440.020.00
consistent gets from cache7,904,253,8742,792,658.445,550.09
consistent gets from cache (fastpath)1,685,422,053595,477.851,183.44
cursor authentications2460.090.00
data blocks consistent reads - undo records applied1,506,334,282532,204.201,057.70
db block changes249,343,16388,095.64175.08
db block gets1,175,259,987415,232.07825.23
db block gets direct1,2520.440.00
db block gets from cache1,175,258,735415,231.63825.23
db block gets from cache (fastpath)203,448,16971,880.44142.85
deferred (CURRENT) block cleanout applications3,659,0711,292.792.57
dirty buffers inspected229,88581.220.16
doubling up with imu segment00.000.00
enqueue conversions4,3821.550.00
enqueue releases7,653,6832,704.135.37
enqueue requests9,051,4003,197.966.36
enqueue timeouts1,397,717493.830.98
enqueue waits359,638127.060.25
exchange deadlocks222,45678.600.16
execute count91,150,39032,204.4264.00
failed probes on index block reclamation2,6690.940.00
file io service time00.000.00
file io wait time3,006,976,2691,062,397.262,111.39
free buffer inspected7,670,7092,710.145.39
free buffer requested33,460,85911,822.0823.50
heap block compress112,387,43239,707.7078.91
hot buffers moved to head of LRU1,138,344402.190.80
immediate (CR) block cleanout applications21,725,4247,675.8315.25
immediate (CURRENT) block cleanout applications1,275,835450.770.90
index crx upgrade (positioned)323,947114.450.23
index crx upgrade (prefetch)00.000.00
index fast full scans (full)50.000.00
index fetch by key114,115,43840,318.2280.13
index scans kdiixs171,783,02125,361.7250.40
java call heap collected bytes2,462,092,696869,884.001,728.80
java call heap collected count29,859,36410,549.6420.97
java call heap gc count5,5771.970.00
java call heap live object count3,545,5621,252.692.49
java call heap live object count max3,599,0441,271.582.53
java call heap live size424,671,536150,041.05298.19
java call heap live size max428,347,368151,339.76300.77
java call heap object count8,314,4662,937.595.84
java call heap object count max8,385,4622,962.675.89
java call heap total size2,197,815,296776,511.931,543.23
java call heap total size max2,197,815,296776,511.931,543.23
java call heap used size789,040,176278,776.43554.04
java call heap used size max794,885,688280,841.72558.14
java session heap live object count00.000.00
java session heap live object count max00.000.00
java session heap live size195,313,66469,006.43137.14
java session heap live size max195,313,66469,006.43137.14
java session heap object count00.000.00
java session heap object count max00.000.00
java session heap used size195,313,66469,006.43137.14
java session heap used size max195,313,66469,006.43137.14
leaf node 90-10 splits33,16811.720.02
leaf node splits259,17791.570.18
lob reads520.020.00
lob writes1,799,909635.931.26
lob writes unaligned1,799,909635.931.26
logons cumulative1,5450.550.00
max cf enq hold time20.000.00
messages received928,949328.210.65
messages sent928,949328.210.65
min active SCN optimization applied on CR2,190,336773.871.54
no buffer to keep pinned count400,361141.450.28
no work - consistent read gets1,707,116,256603,142.651,198.68
non-idle wait count42,398,86614,979.9829.77
non-idle wait time729,832257.860.51
opened cursors cumulative95,821,34133,854.7267.28
parse count (describe)40.000.00
parse count (failures)5280.190.00
parse count (hard)9420.330.00
parse count (total)4,572,2181,615.413.21
parse time cpu2,3340.820.00
parse time elapsed7,7102.720.01
physical read IO requests69,33324.500.05
physical read bytes1,083,924,480382,962.25761.09
physical read total IO requests74,77726.420.05
physical read total bytes1,170,538,496413,563.92821.91
physical read total multi block requests2,0620.730.00
physical reads132,31546.750.09
physical reads cache87,74631.000.06
physical reads cache prefetch25,4639.000.02
physical reads direct44,56915.750.03
physical reads direct (lob)480.020.00
physical reads direct temporary tablespace42,76915.110.03
physical reads prefetch warmup00.000.00
physical write IO requests417,317147.440.29
physical write bytes25,516,974,0809,015,423.1117,917.13
physical write total IO requests1,825,838645.091.28
physical write total bytes68,042,253,82424,040,064.6847,776.91
physical write total multi block requests180,51563.780.13
physical writes3,114,8651,100.522.19
physical writes direct39,45513.940.03
physical writes direct (lob)100.000.00
physical writes direct temporary tablespace37,76613.340.03
physical writes from cache3,075,4101,086.582.16
physical writes non checkpoint2,700,082953.971.90
pinned buffers inspected17,6486.240.01
pinned cursors current00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use00.000.00
process last non-idle time2,8701.010.00
queries parallelized20.000.00
recursive aborts on index block reclamation380.010.00
recursive calls161,344,08957,004.61113.29
recursive cpu usage1,599,234565.031.12
redo blocks checksummed by FG (exclusive)20,250,6657,154.7814.22
redo blocks written82,916,73929,295.3858.22
redo entries131,600,00246,495.7092.40
redo ordering marks1,356,434479.240.95
redo size40,714,863,07614,385,001.7728,588.57
redo size for direct writes15,1325.350.01
redo subscn max counts2,937,1551,037.732.06
redo synch time3,0711.090.00
redo synch writes8,6973.070.01
redo wastage344,559,076121,736.45241.94
redo write time35,17612.430.02
redo writes715,285252.720.50
rollback changes - undo records applied147,75452.200.10
root node splits790.030.00
rows fetched via callback67,764,79823,942.0447.58
session connect time00.000.00
session cursor cache hits13,992,9524,943.869.83
session logical reads9,079,513,9053,207,890.536,375.32
shared hash latch upgrades - no wait51,662,79618,253.0236.28
shared hash latch upgrades - wait2,743,978969.481.93
sorts (disk)100.000.00
sorts (memory)13,031,7054,604.249.15
sorts (rows)54,925,42519,405.7538.57
sql area evicted60.000.00
sql area purged100.000.00
summed dirty queue length631,885223.250.44
switch current to new buffer3,943,5451,393.302.77
table fetch by rowid2,060,569,376728,021.461,446.86
table fetch continued row41,089,73914,517.4528.85
table scan blocks gotten41,750,77214,751.0029.32
table scan rows gotten3,523,932,8051,245,043.602,474.38
table scans (cache partitions)3100.110.00
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (rowid ranges)3100.110.00
table scans (short tables)1,742,779615.741.22
total cf enq hold time1,1500.410.00
total number of cf enq holders1270.040.00
total number of times SMON posted720.030.00
transaction rollbacks102,36036.160.07
transaction tables consistent read rollbacks3750.130.00
transaction tables consistent reads - undo records applied169,69559.960.12
undo change vector size15,841,298,8925,596,902.3411,123.21
user I/O wait time31,84711.250.02
user calls497,057175.620.35
user commits1,422,897502.721.00
user rollbacks1,2690.450.00
workarea executions - onepass200.010.00
workarea executions - optimal5,847,3932,065.954.11
write clones created in background260.010.00
write clones created in foreground2,5050.890.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
opened cursors current516509
logons current9090
session uga memory max34,527,988,79251,389,917,208
session pga memory201,800,032189,077,648
session pga memory max260,323,680259,856,528
session cursor cache count470,690691,917
session uga memory272,503,528347,776,248

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)00.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
LGWR0M0.000M39.5G496.0914.30410 
DBWR0M0.000M23.6G145.298.527150 
Buffer Cache Reads686M22.00.2423710M0.000M62.3K2.67
Direct Reads348M2.49.1229521M0.05.0003530 
Direct Writes0M0.000M308M2.48.1088190 
Others83M1.92.02932469M1.56.02437869090.76
Streams AQ0M0.000M0M0.000M52.00
TOTAL:1.1G26.42.39464863.5G645.4722.964869.2K2.48

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Log File0M0.000M39.5G496.0914.3041  
Data File711M22.75.25120323.6G145.568.528922.741.07
Temp File332M1.87.117299294M2.28.1038730.000.00
Control File80M1.80.02826469M1.55.0243780.52 
TOTAL:1.1G26.43.39676863.5G645.4922.96132.410.64

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
LGWR 0M0.000M39.5G496.0914.30410 
LGWR (Log File) 0M0.000M39.5G496.0914.30410 
DBWR 0M0.000M23.6G145.348.533510 
DBWR (Data File) 0M0.000M23.6G145.348.533510 
Buffer Cache Reads 686M22.00.2423710M0.000M62.3K2.67
Buffer Cache Reads (Data File) 686M22.00.2423710M0.000M62.3K2.67
Direct Reads 348M2.49.1229521M0.05.0003530 
Direct Reads (Data File) 348M2.49.1229521M0.05.0003530 
Direct Writes 0M0.000M308M2.48.1088190 
Direct Writes (Data File) 0M0.000M308M2.48.1088190 
Others 83M1.92.02932469M1.56.02437854450.75
Others (Control File) 80M1.80.02826468M1.55.02402551080.52
Others (Data File) 3M0.12.0010591M0.00.0003533374.17
Streams AQ 0M0.000M0M0.000M52.00
Streams AQ (Data File) 0M0.000M0M0.000M52.00
TOTAL: 1.1G26.42.39464863.5G645.5222.971267.7K2.51

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_UNDOTS1 1100.001.00299,2131061,259,1680.29
APPS_TS_TX_IDX 30,757113.391.0047,065171,073,0400.49
APPS_TS_TX_DATA 26,28292.761.9233,18812670,9121.19
APPS_TS_SUMMARY 31101.771.0019,0697155,4601.11
APPS_TS_INTERFACE 5,33122.181.148,44035,217,3590.04
TEMP1 5,28920.008.096,456200.00
APPS_TS_QUEUES 24301.931.002,7411152,6101.01
SYSTEM 18603.392.40453043,9890.08
SYSAUX 19202.601.82380000.00
APPS_TS_SEED 34500.961.27780191.58
APPS_TS_ARCHIVE 2903.101.001280880.11
APPS_TS_NOLOGGING 3400.881.003305450.02
APPS_TS_MEDIA 4900.001.0014000.00
APPS_CALCLIP 1200.001.008000.00
CWMLITE 1400.001.002000.00
APPS_TS_DISCO 900.001.006000.00
DCM 1200.001.002000.00
GEOR_TBS 1200.001.002000.00
B2B_LOB 700.001.001000.00
B2B_RT 700.001.001000.00
BAM 700.001.001000.00
CTXSYS 700.001.001000.00
OLTS_ATTRSTORE 700.001.001000.00
OLTS_BATTRSTORE 700.001.001000.00
OLTS_CT_STORE 700.001.001000.00
OLTS_DEFAULT 700.001.001000.00
OLTS_SVRMGSTORE 700.001.001000.00
OPMOR 700.001.001000.00
B2B_DT 600.001.001000.00
B2B_IDX 600.001.001000.00
DISCO_PTM5_CACHE 600.001.001000.00
DISCO_PTM5_META 600.001.001000.00
DSGATEWAY_TAB 600.001.001000.00
HTMLDB 600.001.001000.00
IAS_META 600.001.001000.00
MTR 600.001.001000.00
NOETIX 600.001.001000.00
NON_APPS_TS_DATA 600.001.001000.00
OCATS 600.001.001000.00
ODM_DATA 600.001.001000.00
ORABPEL 600.001.001000.00
OWAPUB 600.001.001000.00
PORTAL 600.001.001000.00
PORTAL_DOC 600.001.001000.00
PORTAL_IDX 600.001.001000.00
PORTAL_LOG 600.001.001000.00
RE 600.001.001000.00
SYNCSERVER 600.001.001000.00
UDDISYS_TS 600.001.001000.00
WCRSYS_TS 600.001.001000.00
XDB 600.001.001000.00
APPS_OMO 300.001.002000.00
APPS_TS_DISCO_OLAP 300.001.002000.00
APPS_TS_TOOLS 100.001.001000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_CALCLIP/oasb_data/apps_calclip.dbf 300.001.002000.00
APPS_CALCLIP/oasb_data/apps_calclip1.dbf 300.001.002000.00
APPS_CALCLIP/oasb_data/apps_calclip2.dbf 300.001.002000.00
APPS_CALCLIP/oasb_data/apps_calclip3.dbf 300.001.002000.00
APPS_OMO/oasb_data/omo1.dbf 300.001.002000.00
APPS_TS_ARCHIVE/oasb_data/archive1.dbf 2903.101.001280880.11
APPS_TS_DISCO/oasb_data/disco1.dbf 300.001.002000.00
APPS_TS_DISCO/oasb_data/disco2.dbf 300.001.002000.00
APPS_TS_DISCO/oasb_data/disco3.dbf 300.001.002000.00
APPS_TS_DISCO_OLAP/oasb_data/disco_drake1.dbf 300.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interfac27.dbf 2701.111.371404860.04
APPS_TS_INTERFACE/oasb_data/apps_ts_interfac28.dbf 48402.231.188340515,9400.04
APPS_TS_INTERFACE/oasb_data/apps_ts_interfac29.dbf 48202.071.178360537,6150.04
APPS_TS_INTERFACE/oasb_data/apps_ts_interfac30.dbf 58402.121.138510507,7630.03
APPS_TS_INTERFACE/oasb_data/apps_ts_interfac31.dbf 53102.351.168560519,3680.04
APPS_TS_INTERFACE/oasb_data/apps_ts_interfac32.dbf 56001.961.138490530,3170.04
APPS_TS_INTERFACE/oasb_data/apps_ts_interfac33.dbf 56602.031.108270493,5720.04
APPS_TS_INTERFACE/oasb_data/apps_ts_interfac34.dbf 53202.461.128310517,8530.04
APPS_TS_INTERFACE/oasb_data/apps_ts_interfac35.dbf 47502.341.128220515,1150.03
APPS_TS_INTERFACE/oasb_data/apps_ts_interfac36.dbf 46002.541.178320547,3300.04
APPS_TS_INTERFACE/oasb_data/apps_ts_interface.dbf 47102.511.188100531,8500.04
APPS_TS_INTERFACE/oasb_data/apps_ts_interface1.dbf 500.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface10.dbf 500.001.003000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface11.dbf 500.001.003000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface12.dbf 500.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface13.dbf 500.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface14.dbf 500.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface15.dbf 500.001.006000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface16.dbf 500.001.003000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface17.dbf 500.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface18.dbf 500.001.003000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface19.dbf 500.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface2.dbf 500.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface20.dbf 500.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface21.dbf 1801.111.002001500.67
APPS_TS_INTERFACE/oasb_data/apps_ts_interface22.dbf 500.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface23.dbf 500.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface24.dbf 500.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface25.dbf 500.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface26.dbf 700.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface3.dbf 700.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface4.dbf 700.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface5.dbf 700.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface6.dbf 700.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface7.dbf 700.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface8.dbf 700.001.002000.00
APPS_TS_INTERFACE/oasb_data/apps_ts_interface9.dbf 700.001.002000.00
APPS_TS_MEDIA/oasb_data/media1.dbf 700.001.002000.00
APPS_TS_MEDIA/oasb_data/media2.dbf 700.001.002000.00
APPS_TS_MEDIA/oasb_data/media3.dbf 700.001.002000.00
APPS_TS_MEDIA/oasb_data/media4.dbf 700.001.002000.00
APPS_TS_MEDIA/oasb_data/media5.dbf 700.001.002000.00
APPS_TS_MEDIA/oasb_data/media6.dbf 700.001.002000.00
APPS_TS_MEDIA/oasb_data/media7.dbf 700.001.002000.00
APPS_TS_NOLOGGING/oasb_data/nologging1.dbf 700.001.002000.00
APPS_TS_NOLOGGING/oasb_data/nologging2.dbf 901.111.001205450.02
APPS_TS_NOLOGGING/oasb_data/nologging3.dbf 801.251.0011000.00
APPS_TS_NOLOGGING/oasb_data/nologging4.dbf 1001.001.008000.00
APPS_TS_QUEUES/oasb_data/queues1.dbf 1104.551.00172012,5060.79
APPS_TS_QUEUES/oasb_data/queues10.dbf 1401.431.00204010,2400.85
APPS_TS_QUEUES/oasb_data/queues11.dbf 1801.671.00200012,9600.74
APPS_TS_QUEUES/oasb_data/queues12.dbf 1802.221.00208012,6650.91
APPS_TS_QUEUES/oasb_data/queues13.dbf 1401.431.00209012,5800.92
APPS_TS_QUEUES/oasb_data/queues2.dbf 2002.501.00229012,9271.20
APPS_TS_QUEUES/oasb_data/queues3.dbf 1902.111.00250011,3011.03
APPS_TS_QUEUES/oasb_data/queues4.dbf 2701.851.00217010,6251.45
APPS_TS_QUEUES/oasb_data/queues5.dbf 2401.671.00179010,3231.64
APPS_TS_QUEUES/oasb_data/queues6.dbf 1300.001.00197012,3560.78
APPS_TS_QUEUES/oasb_data/queues7.dbf 2101.901.00186011,0431.06
APPS_TS_QUEUES/oasb_data/queues8.dbf 1601.881.00266012,6581.10
APPS_TS_QUEUES/oasb_data/queues9.dbf 2802.141.00224010,4260.80
APPS_TS_SEED/oasb_data/reference1.dbf 1200.832.173000.00
APPS_TS_SEED/oasb_data/reference10.dbf 1302.312.084000.00
APPS_TS_SEED/oasb_data/reference11.dbf 1302.312.084045.00
APPS_TS_SEED/oasb_data/reference12.dbf 1101.822.273010.00
APPS_TS_SEED/oasb_data/reference13.dbf 1201.671.5050110.00
APPS_TS_SEED/oasb_data/reference14.dbf 1100.001.004000.00
APPS_TS_SEED/oasb_data/reference15.dbf 1000.001.002000.00
APPS_TS_SEED/oasb_data/reference16.dbf 900.001.003000.00
APPS_TS_SEED/oasb_data/reference17.dbf 1100.001.002000.00
APPS_TS_SEED/oasb_data/reference18.dbf 1100.001.003000.00
APPS_TS_SEED/oasb_data/reference19.dbf 1100.001.002000.00
APPS_TS_SEED/oasb_data/reference2.dbf 1300.771.006050.00
APPS_TS_SEED/oasb_data/reference20.dbf 1100.001.005000.00
APPS_TS_SEED/oasb_data/reference21.dbf 1100.001.002000.00
APPS_TS_SEED/oasb_data/reference22.dbf 1200.831.002000.00
APPS_TS_SEED/oasb_data/reference23.dbf 1300.771.003000.00
APPS_TS_SEED/oasb_data/reference24.dbf 1501.331.002010.00
APPS_TS_SEED/oasb_data/reference25.dbf 1100.001.003000.00
APPS_TS_SEED/oasb_data/reference3.dbf 1200.831.004000.00
APPS_TS_SEED/oasb_data/reference4.dbf 1501.331.002070.00
APPS_TS_SEED/oasb_data/reference5.dbf 1400.711.002000.00
APPS_TS_SEED/oasb_data/reference6.dbf 1400.711.003000.00
APPS_TS_SEED/oasb_data/reference7.dbf 1200.001.002000.00
APPS_TS_SEED/oasb_data/reference8.dbf 1100.001.003000.00
APPS_TS_SEED/oasb_data/reference9.dbf 5702.111.544000.00
APPS_TS_SUMMARY/oasb_data/summary1.dbf 2601.541.001,322010,0391.65
APPS_TS_SUMMARY/oasb_data/summary10.dbf 2200.451.001,258010,3511.21
APPS_TS_SUMMARY/oasb_data/summary11.dbf 2001.001.001,296010,3690.96
APPS_TS_SUMMARY/oasb_data/summary12.dbf 2502.001.001,228010,0411.42
APPS_TS_SUMMARY/oasb_data/summary13.dbf 1701.761.001,29509,3700.89
APPS_TS_SUMMARY/oasb_data/summary14.dbf 1702.351.001,28207,6170.80
APPS_TS_SUMMARY/oasb_data/summary15.dbf 2401.671.001,19907,4471.70
APPS_TS_SUMMARY/oasb_data/summary2.dbf 4301.631.001,273010,2301.28
APPS_TS_SUMMARY/oasb_data/summary3.dbf 1902.111.001,322010,3131.40
APPS_TS_SUMMARY/oasb_data/summary4.dbf 2302.171.001,295019,6480.35
APPS_TS_SUMMARY/oasb_data/summary5.dbf 2701.851.001,22009,3861.48
APPS_TS_SUMMARY/oasb_data/summary6.dbf 2102.381.001,294010,1451.41
APPS_TS_SUMMARY/oasb_data/summary7.dbf 1201.671.001,28009,8681.11
APPS_TS_SUMMARY/oasb_data/summary8.dbf 802.501.001,262010,2521.03
APPS_TS_SUMMARY/oasb_data/summary9.dbf 702.861.001,243010,3840.76
APPS_TS_TOOLS/oasb_data/apps_ts_tools01.dbf 100.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data1.dbf 100.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data10.dbf 100.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data11.dbf 4801.679.08360283.21
APPS_TS_TX_DATA/oasb_data/tx_data12.dbf 5101.578.59320320.94
APPS_TS_TX_DATA/oasb_data/tx_data13.dbf 52603.061.74662011,1301.24
APPS_TS_TX_DATA/oasb_data/tx_data14.dbf 100.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data15.dbf 100.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data16.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data17.dbf 200.001.0020020.00
APPS_TS_TX_DATA/oasb_data/tx_data18.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data19.dbf 200.001.0011000.00
APPS_TS_TX_DATA/oasb_data/tx_data2.dbf 4501.789.27310431.16
APPS_TS_TX_DATA/oasb_data/tx_data20.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data21.dbf 54102.421.72708010,9401.98
APPS_TS_TX_DATA/oasb_data/tx_data22.dbf 2901.386.6221000.00
APPS_TS_TX_DATA/oasb_data/tx_data23.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data24.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data25.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data26.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data27.dbf 200.001.0011010.00
APPS_TS_TX_DATA/oasb_data/tx_data28.dbf 200.001.0012000.00
APPS_TS_TX_DATA/oasb_data/tx_data29.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data3.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data30.dbf 200.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data31.dbf 702.866.141103,1680.08
APPS_TS_TX_DATA/oasb_data/tx_data32.dbf 2602.691.8514305,7540.08
APPS_TS_TX_DATA/oasb_data/tx_data33.dbf 402.501.001208630.01
APPS_TS_TX_DATA/oasb_data/tx_data34.dbf 2101.901.861105,5330.13
APPS_TS_TX_DATA/oasb_data/tx_data35.dbf 300.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data36.dbf 300.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data37.dbf 300.001.0010000.00
APPS_TS_TX_DATA/oasb_data/tx_data38.dbf 300.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data39.dbf 6702.397.81390370.54
APPS_TS_TX_DATA/oasb_data/tx_data4.dbf 300.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data40.dbf 300.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data41.dbf 300.001.0012000.00
APPS_TS_TX_DATA/oasb_data/tx_data42.dbf 300.001.0011000.00
APPS_TS_TX_DATA/oasb_data/tx_data43.dbf 7302.197.25560671.79
APPS_TS_TX_DATA/oasb_data/tx_data44.dbf 6002.008.35460492.04
APPS_TS_TX_DATA/oasb_data/tx_data45.dbf 6401.888.16310331.82
APPS_TS_TX_DATA/oasb_data/tx_data46.dbf 6001.678.55510840.95
APPS_TS_TX_DATA/oasb_data/tx_data47.dbf 53803.181.85708011,1181.69
APPS_TS_TX_DATA/oasb_data/tx_data48.dbf 54502.041.82706010,2901.54
APPS_TS_TX_DATA/oasb_data/tx_data49.dbf 53802.451.86672011,4791.80
APPS_TS_TX_DATA/oasb_data/tx_data5.dbf 300.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data50.dbf 5601.619.20330401.00
APPS_TS_TX_DATA/oasb_data/tx_data51.dbf 56302.521.82697010,1961.80
APPS_TS_TX_DATA/oasb_data/tx_data52.dbf 400.001.0012000.00
APPS_TS_TX_DATA/oasb_data/tx_data53.dbf 55302.411.81670011,7561.19
APPS_TS_TX_DATA/oasb_data/tx_data54.dbf 53403.521.90642011,2621.51
APPS_TS_TX_DATA/oasb_data/tx_data55.dbf 55502.611.88689011,8051.21
APPS_TS_TX_DATA/oasb_data/tx_data56.dbf 53802.941.87672012,4801.22
APPS_TS_TX_DATA/oasb_data/tx_data57.dbf 57802.981.75721012,2121.37
APPS_TS_TX_DATA/oasb_data/tx_data58.dbf 56203.011.81722012,5751.12
APPS_TS_TX_DATA/oasb_data/tx_data59.dbf 57002.351.81724012,2841.08
APPS_TS_TX_DATA/oasb_data/tx_data6.dbf 400.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data60.dbf 54803.141.84698011,4661.35
APPS_TS_TX_DATA/oasb_data/tx_data61.dbf 53502.881.82705012,6131.29
APPS_TS_TX_DATA/oasb_data/tx_data62.dbf 54502.681.81714012,3541.39
APPS_TS_TX_DATA/oasb_data/tx_data63.dbf 54802.591.80657011,7111.60
APPS_TS_TX_DATA/oasb_data/tx_data64.dbf 57703.171.73719012,5371.29
APPS_TS_TX_DATA/oasb_data/tx_data65.dbf 55102.201.76697010,8801.73
APPS_TS_TX_DATA/oasb_data/tx_data66.dbf 55703.121.79678013,8851.18
APPS_TS_TX_DATA/oasb_data/tx_data67.dbf 56302.791.77689017,5110.96
APPS_TS_TX_DATA/oasb_data/tx_data68.dbf 53902.231.81737016,0291.11
APPS_TS_TX_DATA/oasb_data/tx_data69.dbf 55703.361.75716015,2521.11
APPS_TS_TX_DATA/oasb_data/tx_data7.dbf 400.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data70.dbf 56702.171.75754015,9450.94
APPS_TS_TX_DATA/oasb_data/tx_data71.dbf 53503.231.81682017,1900.78
APPS_TS_TX_DATA/oasb_data/tx_data72.dbf 52402.561.81667018,0360.98
APPS_TS_TX_DATA/oasb_data/tx_data73.dbf 52602.171.77697017,3531.12
APPS_TS_TX_DATA/oasb_data/tx_data74.dbf 50603.661.86670015,3211.18
APPS_TS_TX_DATA/oasb_data/tx_data75.dbf 49602.301.87672016,1260.95
APPS_TS_TX_DATA/oasb_data/tx_data76.dbf 52502.911.82666014,0941.02
APPS_TS_TX_DATA/oasb_data/tx_data77.dbf 52302.621.80658015,0201.06
APPS_TS_TX_DATA/oasb_data/tx_data78.dbf 52403.261.82688015,1490.89
APPS_TS_TX_DATA/oasb_data/tx_data79.dbf 51503.691.82698015,7750.99
APPS_TS_TX_DATA/oasb_data/tx_data8.dbf 500.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data80.dbf 55902.521.76661015,3981.32
APPS_TS_TX_DATA/oasb_data/tx_data81.dbf 53703.741.77683014,9781.41
APPS_TS_TX_DATA/oasb_data/tx_data82.dbf 52502.951.82710014,1001.24
APPS_TS_TX_DATA/oasb_data/tx_data83.dbf 55302.881.79691013,6361.45
APPS_TS_TX_DATA/oasb_data/tx_data84.dbf 51402.961.82680014,1031.15
APPS_TS_TX_DATA/oasb_data/tx_data85.dbf 59702.091.65704014,2041.28
APPS_TS_TX_DATA/oasb_data/tx_data86.dbf 56103.671.73703015,4801.31
APPS_TS_TX_DATA/oasb_data/tx_data87.dbf 55702.301.75692016,9211.02
APPS_TS_TX_DATA/oasb_data/tx_data88.dbf 53602.371.78673017,1020.70
APPS_TS_TX_DATA/oasb_data/tx_data89.dbf 59902.851.64729016,9671.03
APPS_TS_TX_DATA/oasb_data/tx_data9.dbf 600.001.001000.00
APPS_TS_TX_DATA/oasb_data/tx_data90.dbf 53003.041.73688015,7081.31
APPS_TS_TX_DATA/oasb_data/tx_data91.dbf 55902.271.69681015,3651.25
APPS_TS_TX_DATA/oasb_data/tx_data92.dbf 54002.201.72696015,2991.13
APPS_TS_TX_DATA/oasb_data/tx_data93.dbf 52003.061.72666012,1431.23
APPS_TS_TX_IDX/oasb_data/tx_idx1.dbf 45003.511.0045002,2990.51
APPS_TS_TX_IDX/oasb_data/tx_idx10.dbf 45603.601.00648011,1260.40
APPS_TS_TX_IDX/oasb_data/tx_idx11.dbf 43303.901.00654010,3220.44
APPS_TS_TX_IDX/oasb_data/tx_idx12.dbf 46603.371.0066209,5470.43
APPS_TS_TX_IDX/oasb_data/tx_idx13.dbf 48503.571.00749010,9580.55
APPS_TS_TX_IDX/oasb_data/tx_idx14.dbf 3002.671.00460260.38
APPS_TS_TX_IDX/oasb_data/tx_idx15.dbf 46403.281.00704010,7070.60
APPS_TS_TX_IDX/oasb_data/tx_idx16.dbf 46504.191.00721011,4660.37
APPS_TS_TX_IDX/oasb_data/tx_idx17.dbf 46503.701.00700012,2910.48
APPS_TS_TX_IDX/oasb_data/tx_idx18.dbf 51102.781.00704011,5970.62
APPS_TS_TX_IDX/oasb_data/tx_idx19.dbf 51603.181.00699011,7150.36
APPS_TS_TX_IDX/oasb_data/tx_idx2.dbf 43303.141.00691011,4830.56
APPS_TS_TX_IDX/oasb_data/tx_idx20.dbf 45303.751.00670011,3050.42
APPS_TS_TX_IDX/oasb_data/tx_idx21.dbf 44703.451.00663010,3340.47
APPS_TS_TX_IDX/oasb_data/tx_idx22.dbf 47603.111.00698010,3600.37
APPS_TS_TX_IDX/oasb_data/tx_idx23.dbf 43503.401.00640010,5060.40
APPS_TS_TX_IDX/oasb_data/tx_idx24.dbf 43103.571.00674010,7120.54
APPS_TS_TX_IDX/oasb_data/tx_idx25.dbf 47303.381.0068609,7860.63
APPS_TS_TX_IDX/oasb_data/tx_idx26.dbf 43403.761.0066409,5950.67
APPS_TS_TX_IDX/oasb_data/tx_idx27.dbf 45003.361.0068708,6350.64
APPS_TS_TX_IDX/oasb_data/tx_idx28.dbf 46603.001.0066608,6280.67
APPS_TS_TX_IDX/oasb_data/tx_idx29.dbf 45902.921.0066208,3920.56
APPS_TS_TX_IDX/oasb_data/tx_idx3.dbf 42103.681.0059509,7030.68
APPS_TS_TX_IDX/oasb_data/tx_idx30.dbf 42103.871.0062009,1270.43
APPS_TS_TX_IDX/oasb_data/tx_idx31.dbf 7803.971.00380051,3950.06
APPS_TS_TX_IDX/oasb_data/tx_idx32.dbf 7302.741.00182029,9950.03
APPS_TS_TX_IDX/oasb_data/tx_idx33.dbf 9002.781.0012801152.09
APPS_TS_TX_IDX/oasb_data/tx_idx34.dbf 50603.811.00840061,1040.11
APPS_TS_TX_IDX/oasb_data/tx_idx35.dbf 48104.201.00765034,5580.14
APPS_TS_TX_IDX/oasb_data/tx_idx36.dbf 43203.891.00729016,3430.22
APPS_TS_TX_IDX/oasb_data/tx_idx37.dbf 47203.261.0075709,2410.44
APPS_TS_TX_IDX/oasb_data/tx_idx38.dbf 46304.691.0080609,3770.41
APPS_TS_TX_IDX/oasb_data/tx_idx39.dbf 54102.901.0076009,9710.37
APPS_TS_TX_IDX/oasb_data/tx_idx4.dbf 7003.291.0012505010.20
APPS_TS_TX_IDX/oasb_data/tx_idx40.dbf 57002.861.00801010,5860.48
APPS_TS_TX_IDX/oasb_data/tx_idx41.dbf 52503.981.00794010,3720.48
APPS_TS_TX_IDX/oasb_data/tx_idx42.dbf 50903.871.00827013,3940.31
APPS_TS_TX_IDX/oasb_data/tx_idx43.dbf 51803.531.00793012,9240.29
APPS_TS_TX_IDX/oasb_data/tx_idx44.dbf 49703.541.00775055,4040.11
APPS_TS_TX_IDX/oasb_data/tx_idx45.dbf 50903.281.00825061,3810.11
APPS_TS_TX_IDX/oasb_data/tx_idx46.dbf 49103.561.00821017,7890.28
APPS_TS_TX_IDX/oasb_data/tx_idx47.dbf 48403.721.00776013,5270.35
APPS_TS_TX_IDX/oasb_data/tx_idx48.dbf 55603.531.00797014,9610.34
APPS_TS_TX_IDX/oasb_data/tx_idx49.dbf 49103.161.00879015,0560.27
APPS_TS_TX_IDX/oasb_data/tx_idx5.dbf 3602.501.0061090.00
APPS_TS_TX_IDX/oasb_data/tx_idx50.dbf 53803.011.00825014,6890.25
APPS_TS_TX_IDX/oasb_data/tx_idx51.dbf 55202.631.00806014,4130.15
APPS_TS_TX_IDX/oasb_data/tx_idx52.dbf 47503.581.00805015,5280.28
APPS_TS_TX_IDX/oasb_data/tx_idx53.dbf 55902.581.00858013,7520.24
APPS_TS_TX_IDX/oasb_data/tx_idx54.dbf 53503.831.00797014,9790.33
APPS_TS_TX_IDX/oasb_data/tx_idx55.dbf 51003.371.00890014,5490.25
APPS_TS_TX_IDX/oasb_data/tx_idx56.dbf 47703.171.00733015,6000.30
APPS_TS_TX_IDX/oasb_data/tx_idx57.dbf 51503.551.00800013,7290.36
APPS_TS_TX_IDX/oasb_data/tx_idx58.dbf 50403.191.00702014,3680.23
APPS_TS_TX_IDX/oasb_data/tx_idx59.dbf 50703.651.00726013,9330.32
APPS_TS_TX_IDX/oasb_data/tx_idx6.dbf 51703.521.00734098,8812.12
APPS_TS_TX_IDX/oasb_data/tx_idx60.dbf 53002.401.00793015,0410.18
APPS_TS_TX_IDX/oasb_data/tx_idx61.dbf 51702.611.00769013,1530.25
APPS_TS_TX_IDX/oasb_data/tx_idx62.dbf 50203.191.00747012,5620.21
APPS_TS_TX_IDX/oasb_data/tx_idx63.dbf 46403.101.00706012,0540.40
APPS_TS_TX_IDX/oasb_data/tx_idx64.dbf 41603.701.00724012,2840.42
APPS_TS_TX_IDX/oasb_data/tx_idx65.dbf 43902.891.00719012,5670.68
APPS_TS_TX_IDX/oasb_data/tx_idx66.dbf 47102.951.00723010,8360.73
APPS_TS_TX_IDX/oasb_data/tx_idx67.dbf 47603.681.00671011,1430.55
APPS_TS_TX_IDX/oasb_data/tx_idx68.dbf 40703.421.00658011,1470.93
APPS_TS_TX_IDX/oasb_data/tx_idx69.dbf 47203.241.0067409,6000.54
APPS_TS_TX_IDX/oasb_data/tx_idx7.dbf 3201.881.00500200.50
APPS_TS_TX_IDX/oasb_data/tx_idx70.dbf 44403.581.0068609,6900.55
APPS_TS_TX_IDX/oasb_data/tx_idx71.dbf 45403.241.0071309,7040.46
APPS_TS_TX_IDX/oasb_data/tx_idx72.dbf 45503.361.00670010,1180.73
APPS_TS_TX_IDX/oasb_data/tx_idx8.dbf 3001.331.00600460.22
APPS_TS_TX_IDX/oasb_data/tx_idx9.dbf 2702.221.00520310.00
APPS_UNDOTS1/oasb_data/undo.dbf 100.001.0033,67012133,5550.37
APPS_UNDOTS1/oasb_data/undo2.dbf 100.001.0032,48711132,7210.33
APPS_UNDOTS1/oasb_data/undo3.dbf 100.001.0033,24512108,4650.35
APPS_UNDOTS1/oasb_data/undo4.dbf 100.001.0033,09612114,8610.28
APPS_UNDOTS1/oasb_data/undo5.dbf 100.001.0033,02912189,0020.20
APPS_UNDOTS1/oasb_data/undo6.dbf 100.001.0036,32013175,0820.25
APPS_UNDOTS1/oasb_data/undo7.dbf 100.001.0032,47611117,9960.33
APPS_UNDOTS1/oasb_data/undo8.dbf 100.001.0031,31911187,9460.21
APPS_UNDOTS1/oasb_data/undo9.dbf 300.001.0033,5711299,5400.38
B2B_DT/oasb_data/b2b_dt.dbf 600.001.001000.00
B2B_IDX/oasb_data/b2b_idx.dbf 600.001.001000.00
B2B_LOB/oasb_data/b2b_lob.dbf 700.001.001000.00
B2B_RT/oasb_data/b2b_rt.dbf 700.001.001000.00
BAM/oasb_data/bam.dbf 700.001.001000.00
CTXSYS/oasb_data/ctx1.dbf 700.001.001000.00
CWMLITE/oasb_data/cwmlite01.dbf 700.001.001000.00
CWMLITE/oasb_data/cwmlite02.dbf 700.001.001000.00
DCM/oasb_data/dcm.dbf 600.001.001000.00
DCM/oasb_data/dcm1.dbf 600.001.001000.00
DISCO_PTM5_CACHE/oasb_data/discopltc1.dbf 600.001.001000.00
DISCO_PTM5_META/oasb_data/discopltm1.dbf 600.001.001000.00
DSGATEWAY_TAB/oasb_data/oss_sys01.dbf 600.001.001000.00
GEOR_TBS/oasb_data/apps_ts_spatial.dbf 600.001.001000.00
GEOR_TBS/oasb_data/geor_tbs02.dbf 600.001.001000.00
HTMLDB/oasb_data/htmldb.dbf 600.001.001000.00
IAS_META/oasb_data/ias_meta01.dbf 600.001.001000.00
MTR/oasb_data/opmtr01.dbf 600.001.001000.00
NOETIX/oasb_data/noetix.dbf 600.001.001000.00
NON_APPS_TS_DATA/oasb_data/non_apps_data1.dbf 600.001.001000.00
OCATS/oasb_data/oca.dbf 600.001.001000.00
ODM_DATA/oasb_data/odm.dbf 600.001.001000.00
OLTS_ATTRSTORE/oasb_data/attrs1_oid.dbf 700.001.001000.00
OLTS_BATTRSTORE/oasb_data/battrs1_oid.dbf 700.001.001000.00
OLTS_CT_STORE/oasb_data/gcats1_oid.dbf 700.001.001000.00
OLTS_DEFAULT/oasb_data/gdefault1_oid.dbf 700.001.001000.00
OLTS_SVRMGSTORE/oasb_data/svrmg1_oid.dbf 700.001.001000.00
OPMOR/oasb_data/opmor01.dbf 700.001.001000.00
ORABPEL/oasb_data/orabpel.dbf 600.001.001000.00
OWAPUB/oasb_data/owa1.dbf 600.001.001000.00
PORTAL/oasb_data/portal.dbf 600.001.001000.00
PORTAL_DOC/oasb_data/ptldoc.dbf 600.001.001000.00
PORTAL_IDX/oasb_data/ptlidx.dbf 600.001.001000.00
PORTAL_LOG/oasb_data/ptllog.dbf 600.001.001000.00
RE/oasb_data/opre01.dbf 600.001.001000.00
SYNCSERVER/oasb_data/mobile01.dbf 600.001.001000.00
SYSAUX/oasb_data/sysaux01.dbf 11202.951.34251000.00
SYSAUX/oasb_data/sysaux02.dbf 8002.132.50129000.00
SYSTEM/oasb_data/sys1.dbf 3402.353.124105,5250.11
SYSTEM/oasb_data/sys10.dbf 1701.762.066004,9630.07
SYSTEM/oasb_data/sys2.dbf 502.001.004104,0930.07
SYSTEM/oasb_data/sys3.dbf 603.331.833105300.00
SYSTEM/oasb_data/sys4.dbf 1103.641.552204570.20
SYSTEM/oasb_data/sys5.dbf 1204.171.583605,0380.09
SYSTEM/oasb_data/sys6.dbf 1504.001.933605,5860.06
SYSTEM/oasb_data/sys7.dbf 1303.854.005706,6330.05
SYSTEM/oasb_data/sys8.dbf 5904.411.328705,7120.07
SYSTEM/oasb_data/sys9.dbf 1402.146.714205,4520.08
TEMP1/oasb_data/temp1_03.dbf 99500.008.431,26600 
TEMP1/oasb_data/temp1_04.dbf 1,35800.009.101,82810 
TEMP1/oasb_data/temp1_05.dbf 2,93310.007.513,35910 
TEMP1/oasb_data/temp1_06.dbf 300.001.00300 
UDDISYS_TS/oasb_data/uddisys01.dbf 600.001.001000.00
WCRSYS_TS/oasb_data/wcrsys01.dbf 600.001.001000.00
XDB/oasb_data/xdb01.dbf 600.001.001000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D3,502,7161008,987,790,87587,7453,075,410008,576,711

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00002,398,1400

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual RedoBlksTarget RedoBlksLog Sz RedoBlksLog Ckpt Timeout RedoBlksLog Ckpt Interval RedoBlksOpt Log Sz(M)Estd RAC Avail Time
B037139544012681163015126538759011630151   
E019713365727254332340090626538759023400906   

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D2,8160.103471.241,3441918.00
D5,6320.206941.101,1931741.00
D8,4480.301,0411.071,1661709.00
D11,2640.401,3881.061,1461686.00
D14,0800.501,7361.041,1311668.00
D16,8960.592,0831.031,1221657.00
D19,7120.692,4301.031,1171652.00
D22,5280.792,7771.021,1051637.00
D25,3440.893,1241.011,0981630.00
D28,1600.993,4711.001,0861615.00
D28,4161.003,5031.001,0861615.00
D30,9761.093,8181.001,0821611.00
D33,7921.194,1650.981,0651590.00
D36,6081.294,5130.981,0591584.00
D39,4241.394,8600.971,0581582.00
D42,2401.495,2070.971,0571581.00
D45,0561.595,5540.971,0561581.00
D47,8721.685,9010.971,0551579.00
D50,6881.786,2480.971,0551579.00
D53,5041.886,5950.971,0541578.00
D56,3201.986,9420.971,0541578.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
99.48126,780665

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B6,1445,375261.350.000.000.000.00629,140
E6,1445,376260.840.000.000.000.00629,140

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K5,572,6005,572,60000
64K128K3,5833,58300
128K256K2,4242,42400
256K512K1,8821,88200
512K1024K135,880135,88000
1M2M79879800
2M4M545400
4M8M575700
8M16M545400
32M64M4424200

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
7680.13372,767.828,029.3998.0037518,962,839
1,5360.25372,767.823,159.7199.004418,720,340
3,0720.50372,767.823,155.8899.001218,720,149
4,6080.75372,767.82562.12100.00018,590,986
6,1441.00372,767.82562.12100.00018,590,986
7,3731.20372,767.820.00100.00018,562,993
8,6021.40372,767.820.00100.00018,562,993
9,8301.60372,767.820.00100.00018,562,993
11,0591.80372,767.820.00100.00018,562,993
12,2882.00372,767.820.00100.00018,562,993
18,4323.00372,767.820.00100.00018,562,993
24,5764.00372,767.820.00100.00018,562,993
36,8646.00372,767.820.00100.00018,562,993
49,1528.00372,767.820.00100.00018,562,993

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
8320.352268,2712,788,3171.007041.11136,611
1,0880.4640617,4962,788,3801.006411.01156,577
1,3440.5742818,6672,788,3891.006321.00156,578
1,6000.6842818,6672,788,3891.006321.00156,578
1,8560.7842818,6672,788,3891.006321.00156,578
2,1120.8942818,6672,788,3891.006321.00156,578
2,3681.0042818,6672,788,3891.006321.00156,578
2,6241.1142818,6672,788,3891.006321.00156,578
2,8801.2242818,6672,788,3891.006321.00156,578
3,1361.3242818,6672,788,3891.006321.00156,578
3,3921.4342818,6672,788,3891.006321.00156,578
3,6481.5442818,6672,788,3891.006321.00156,578
3,9041.6542818,6672,788,3891.006321.00156,578
4,1601.7642818,6672,788,3891.006321.00156,578
4,4161.8642818,6672,788,3891.006321.00156,578
4,6721.9742818,6672,788,3891.006321.00156,578

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
7,8880.25137,4921,196,520
11,8320.38137,4641,169,275
15,7760.50137,4231,133,997
19,7200.63137,4091,124,987
23,6640.75137,3951,107,837
27,6080.88137,3981,101,324
31,5521.00137,3681,085,476
35,4961.13137,3571,067,891
39,4401.25137,3441,062,464
43,3841.38137,3441,060,076
47,3281.50137,3441,059,425
51,2721.63137,3441,057,688
55,2161.75137,3441,057,688
59,1601.88137,3441,057,037
63,1042.00137,3441,057,037

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
640.500000
1281.000000
1921.500000
2562.000000
3202.500000
3843.000000
4483.500000
5124.000000
5764.500000
6405.000000
7045.500000
7686.000000
8326.500000
8967.000000
9607.500000
1,0248.000000
1,0888.500000
1,1529.000000
1,2169.500000
1,28010.000000

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
2560.676134381.006321.00452
3200.8328623381.006321.002,115
3841.0028623381.006321.002,115
4481.1728623381.006321.002,115
5121.3328623381.006321.002,115
5761.5028623381.006321.002,115
6401.6728623381.006321.002,115
7041.8328623381.006321.002,115
7682.0028623381.006321.002,115
8322.1728623381.006321.002,115

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block7,230,7441,8280
undo block942,3343220
undo header316,856380
1st level bmb53,460110
segment header28,68520
2nd level bmb62401
extent map7200

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 1,518,553122,0781,396,488122,0251,27110.42
HW-Segment High Water Mark 199,504199,4841439,1571303.32
TX-Transaction (index contention) 81,67081,670078,4371121.43
TX-Transaction 1,999,2331,998,747020,393241.18
SQ-Sequence Cache 167,095167,094096,377210.22
FB-Format Block 38,72538,72503,05551.53
TX-Transaction (allocate ITL entry) 210210014600.46
RO-Multiple Object Reuse (fast object reuse) 45450506.00
CR-Reuse Block Range (block range reuse ckpt) 2,7002,7000501.40
PS-PX Process Reservation 21621501200.08
DV-Diana Versioning 1,5011,5010800.13

Back to Wait Statistics
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
22,157.331,937,2341,5435470.7/830/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-Sep 12:13578,277148,64993925830/00/0/0/0/0/0
23-Sep 12:03182,08169,3741,53951760/00/0/0/0/0/0
23-Sep 11:53499,704724,32293654710/00/0/0/0/0/0
23-Sep 11:43897,272994,8891,54340770/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch2,618,7150.140.0620 
AQ deq log cmt cbk chunk latch219,9821.320.0000 
AQ deq log statistics latch100,2271.370.0000 
AQ dequeue txn counter latch225,0420.950.0000 
AQ disk delete txn counter latch220,1560.690.0000 
AQ ht cmt cbk chunk latch2,4220.00 00 
AQ small txn context latch2,496,4702.660.0030 
ASM db client latch2,9730.00 00 
ASM map operation hash table10.00 00 
ASM network state latch1540.00 00 
AWR Alerted Metric Element list30,8940.00 00 
Change Notification Hash table latch9440.00 00 
Consistent RBA719,7780.020.0000 
DML lock allocation8,607,1800.110.0000 
Event Group Locks1,5210.660.0000 
FOB s.o list latch69,5432.400.0000 
File State Object Pool Parent Latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch119,839,5190.270.72681,572,1080.06
JOX JIT latch40.00 040.00
JOX SGA heap latch3,673,8480.430.0000 
JS Sh mem access10.00 00 
JS queue access latch10.00 00 
JS slv state obj latch10.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list10.00 00 
KJCT flow control latch10.00 00 
KMG MMAN ready and startup request latch9430.00 00 
KTF sga latch160.00 08550.00
KWQMN job cache list latch211,3801.000.0800 
KWQP Prop Status3570.00 00 
KWQS pqsubs latch120,0550.00 00 
KWQS pqueue ctx latch131,5002.520.7610 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0560.00
Memory Management Latch10.00 09430.00
Memory Queue20.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch110.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process4,7680.00 00 
OS process allocation4,1210.100.0000 
OS process: request allocation3,0420.100.0000 
PL/SQL warning settings989,5740.410.0000 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch17,6970.060.1000 
SGA IO buffer pool latch3,7990.110.0003,7990.05
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch10.00 09410.00
SQL memory manager workarea list latch960,6430.230.0000 
Shared B-Tree254,3790.000.0000 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP10.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch215,4900.100.0000 
active service list6,1431.070.7701,5260.00
begin backup scn array2910.00 00 
bq:time manger info latch1010.00 00 
buffer pool10.00 00 
bufq statistics10.00 00 
business card10.00 00 
cache buffer handles31,488,41510.890.0000 
cache buffers chains15,673,081,8408.590.02265830,835,6756.69
cache buffers lru chain11,202,2600.300.01262,636,4690.87
cache table scan latch2,1190.00 02,1190.00
call allocation1,301,8022.640.0000 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch4,2531.220.0200 
channel operations parent latch28,1560.060.0000 
checkpoint queue latch11,695,9240.020.0003,194,9730.01
client/application info17,9550.060.0000 
compile environment latch1,5680.00 00 
corrupted undo seg latch545,6223.020.0000 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch1540.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch1540.00 00 
dml lock allocation1880.530.0000 
done queue latch10.00 00 
dummy allocation3,1390.860.0000 
enqueue hash chains17,129,5781.860.0015190.00
enqueues5,182,2781.490.0000 
error message lists9821.430.0000 
fifth spare latch10.00 00 
file cache latch38,1380.030.0000 
flashback copy10.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA1,4860.00 00 
global ctx hash table latch1,182,2690.020.0000 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch4550.440.00064,3430.03
hash table modification latch1260.00 00 
heartbeat check10.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch10.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kks stats4761.470.0000 
kokc descriptor allocation latch1,063,0401.430.0000 
ksfv messages10.00 00 
kss move lock210.00 00 
ksuosstats global area1910.00 00 
ksv allocation latch1940.00 00 
ksv class latch410.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch3,0421.480.0000 
ktm global data1630.00 00 
kwqbsn:qsga1,7410.290.0000 
kwqi:kchunk latch20.00 00 
lgwr LWN SCN733,0400.530.0000 
list of block allocation425,4330.180.0100 
loader state object freelist13,0600.210.0000 
lob segment dispenser latch10.00 00 
lob segment hash table latch90.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation20.00 00 
logminer work area10.00 00 
longop free list parent10.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch1,6240.00 00 
messages2,519,2611.000.0000 
mostly latch-free SCN941,09411.080.0000 
msg queue latch10.00 00 
multiblock read objects4,8260.020.0000 
name-service namespace bucket10.00 00 
ncodef allocation latch1540.00 00 
object queue header heap1,760,3020.000.00033,2240.00
object queue header operation23,457,5940.060.0000 
object stats modification4,6550.020.0000 
parallel query alloc buffer2,57710.240.0000 
parallel query stats5583.640.6500 
parameter list4,8110.040.0000 
parameter table management3,2010.090.0000 
peshm10.00 00 
pesom_free_list4,5050.00 00 
pesom_hash_node455,4970.270.0000 
pesom_heap_alloc3,1480.350.0000 
post/wait queue13,5580.00 07,8340.08
process allocation3,0783.050.0101,4296.44
process group creation3,0420.130.0000 
process queue1,5264.460.0000 
process queue reference67,4110.510.0002,0410.05
qmn task queue latch3,3194.700.0400 
query server freelists1,3991.430.0000 
query server process240.00 0240.00
queued dump request90.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation7,420,33120.190.0011130,087,6516.80
redo copy10.00 0131,606,2580.15
redo writing3,044,8120.010.0200 
resmgr group change latch8,2340.110.0000 
resmgr:active threads4,6220.020.0000 
resmgr:actses change group4,5140.00 00 
resmgr:actses change state1,4850.00 00 
resmgr:free threads list3,1380.860.0000 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config4914.290.0000 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects38,031,9468.770.00310.00
rules engine aggregate statistics109,9982.160.0000 
rules engine rule set statistics440,0150.970.0000 
rules engine rule statistics219,9170.350.0000 
second spare latch10.00 00 
sequence cache16,243,2524.510.0010 
session allocation723,3790.850.000241,1260.03
session idle bit1,233,7210.030.0000 
session queue latch10.00 00 
session state list latch9,0900.880.6100 
session switching7,7600.130.0000 
session timer1,1180.00 00 
shared pool9,204,9241.160.0050 
shared pool sim alloc80.00 00 
shared pool simulator3,7970.00 00 
sim partition latch10.00 00 
simulator hash latch423,246,8700.010.0000 
simulator lru latch2,458,0140.430.000420,593,23610.71
sort extent pool79,8510.200.0000 
space background state object latch60.00 00 
space background task latch2,0890.051.0001,8860.00
state object free list20.00 00 
statistics aggregation3360.00 00 
tablespace key chain50.00 00 
temp lob duration state obj allocation20.00 00 
temporary table state object allocation1,5801.330.0000 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch5050.00 00 
transaction allocation1,359,5340.060.0100 
undo global data4,464,462,8957.920.0097,2900.04
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains15,673,081,8401,345,769,54220,580,3371,328,532,096
undo global data4,464,462,895353,688,61726,866353,661,913
cache buffer handles31,488,4153,430,4041,0913,429,337
row cache objects38,031,9463,336,9493,2233,333,777
redo allocation7,420,3311,498,0514,4901,493,741
sequence cache16,243,252732,340140732,206
In memory undo latch119,839,519320,635231,804109,827
enqueue hash chains17,129,578318,604230318,387
shared pool9,204,924106,397439105,993
mostly latch-free SCN941,094104,2856104,279
enqueues5,182,27877,3036577,241
AQ small txn context latch2,496,47066,34031166,058
simulator hash latch423,246,87049,0472149,031
call allocation1,301,80234,33314134,199
cache buffers lru chain11,202,26034,09943533,682
messages2,519,26125,265925,256
corrupted undo seg latch545,62216,458116,457
kokc descriptor allocation latch1,063,04015,2432915,215
object queue header operation23,457,59413,9424413,903
simulator lru latch2,458,01410,5253010,496
DML lock allocation8,607,1809,48319,482
rules engine rule set statistics440,0154,28824,286
AQ deq hash table latch2,618,7153,5482153,352
KWQS pqueue ctx latch131,5003,3172,536905
AQ deq log cmt cbk chunk latch219,9822,89522,893
SQL memory manager workarea list latch960,6432,22712,226
AQ dequeue txn counter latch225,0422,13922,137
KWQMN job cache list latch211,3802,1111631,949
checkpoint queue latch11,695,9241,76121,759
list of block allocation425,4337838776
transaction allocation1,359,5347487741
session idle bit1,233,7213641363
redo writing3,044,8123255320
global ctx hash table latch1,182,2692181217
qmn task queue latch3,3191566150
process allocation3,07894193
session state list latch9,090804931
active service list6,143665128
channel handle pool latch4,25352151
parallel query stats55463018
Real-time plan statistics latch17,6971019
space background task latch2,089110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
AQ deq hash table latchkwqdlDelHt: delete elements01111
AQ deq hash table latchkwqdlChkInsHt: check and insert0104214
AQ deq log cmt cbk chunk latchkwqdlClnupCcoDl: free011
AQ deq log cmt cbk chunk latchkwqdlGetChunk: allocate011
AQ dequeue txn counter latchkwqdUpdDeqTxnCnt: update022
AQ small txn context latchkwqdlUpdSmlTxnCtx: update0311311
DML lock allocationktaiam011
In memory undo latchktiFlush: child0151,06969,024
In memory undo latchktiFlushMe058,90411,430
In memory undo latchktichg: child017,78757,828
In memory undo latchkticmt: child07,8741,776
In memory undo latchktbgfc01,330567
In memory undo latchkturbk019196,892
In memory undo latchktiFlushTopTxn0238
In memory undo latchktiTxnPoolFree0629
In memory undo latchktigetmypoollatch_2010
KWQMN job cache list latchkwqmnuji: update job item0326327
KWQMN job cache list latchkwqmndej: dequeue010
KWQS pqueue ctx latchkwqspqcbkf: updatepqs02,8972,897
Real-time plan statistics latchkeswxAddNewPlanEntry011
SQL memory manager workarea list latchqesmmIRegisterWorkArea:2011
active service listkswslogon: session logout05959
active service listkswssetsvc: PX session switch service011
cache buffer handleskcbzgs0676729
cache buffer handleskcbzfs0414362
cache buffers chainskcbchg1: kslbegin: bufs not pinned011,756,14410,785,203
cache buffers chainskcbchg1: kslbegin: call CR func07,031,4499,570,936
cache buffers chainskcbgtcr: fast path (cr pin)01,845,499339,792
cache buffers chainskcbgtcr: fast path0692,868145,299
cache buffers chainskcbgtcr: kslbegin excl0337,027356,691
cache buffers chainskcbgcur_20296,574126,880
cache buffers chainskcbgtcr_20204,008281,730
cache buffers chainskcbget: pin buffer0136,29145,679
cache buffers chainskcbzwb093,84458,095
cache buffers chainskcbrls_1054,550193,399
cache buffers chainskcbrls_2054,177325,877
cache buffers chainskcbgkcbcr046,55864,754
cache buffers chainskcbcge020,22064,807
cache buffers chainskcb_is_private018,454151,815
cache buffers chainskcbzgb: scan from tail. nowait016,5700
cache buffers chainskcbget_109,2044,816
cache buffers chainskcbgcur: fast path (shr)04,8516,410
cache buffers chainskcbnlc02,87828,026
cache buffers chainskcbget: exchange rls01,0911,606
cache buffers chainskcbget: exchange09332,787
cache buffers chainskcbgcur_506772,010
cache buffers chainskcbso1: set no access064819,127
cache buffers chainskcbgtcr: kslbegin shared0327127
cache buffers chainskcb_post_apply: kcbhq6202985,403
cache buffers chainskcbzpbuf028826,503
cache buffers chainskcb_commit026822,585
cache buffers chainskcb_pre_apply: kcbhq61026035,417
cache buffers chainskcbesc: escalate023240
cache buffers chainskcbnew: new latch again01290
cache buffers chainskcb_post_apply: kcbhq630493,810
cache buffers chainskcbbxsv0313
cache buffers chainskcbgcur_601822
cache buffers chainskcbgtcr_1080
cache buffers chainskcbbic10710
cache buffers chainskcbzhngcbk1_1070
cache buffers chainskcbnew_1012
cache buffers chainskcbzswcu0132
cache buffers lru chainkcbzgws03190
cache buffers lru chainkcbgtcr:CR Scan:KCBRSKIP_10590
cache buffers lru chainkcbgtcr:CR Scan:KCBRSKIP_20270
cache buffers lru chainkcbzswcu01768
cache buffers lru chainkcbzgb08299
cache buffers lru chainkcbbic20265
cache buffers lru chainkcbbxsv: move to being written020
cache buffers lru chainkcbbwlru012
call allocationksudlc : rec call05357
call allocationksuprc04572
call allocationksuxds04210
call allocationksursi0011
channel handle pool latchksrchconnect()01010
checkpoint queue latchkcbswcu: Switch buffers022
client/application infoksuinfos_cinfo011
corrupted undo seg latchktudiscorrupted011
enqueue hash chainsksqgtl30122116
enqueue hash chainsksqrcl09496
enqueue hash chainsksqcmi: get hash chain latch after wait01115
enqueue hash chainsksqcmi: kslgpl033
enqueuesksqgel: create enqueue04249
enqueuesksqdel01216
enqueuesksqgel: failed to get enqueue0110
global ctx hash table latchkzctxgscv: modify context010
kokc descriptor allocation latchkokcdlt: regular free0237
kokc descriptor allocation latchkokcdlt: allocation0622
lgwr LWN SCNkcs023011
list of block allocationktlabl046
list of block allocationktlbbl042
messagesksaamb: after wakeup092
mostly latch-free SCNkcslcu3056
object queue header operationkcbo_unlink_q02710
object queue header operationkcbo_sw_buf01428
object queue header operationkcbo_link_q0136
object queue header operationkcbo_ivbo092
object queue header operationkcbo_switch_cq0718
object queue header operationkcbo_switch_q_bg063
object queue header operationkcbo_switch_mq_bg028
parallel query statskxfprst: KSLBEGIN:103030
process allocationksucrp:1010
qmn task queue latchkwqmngettsk: get task036
qmn task queue latchkwqmnmvtsks: delay to ready list020
qmn task queue latchkwqmndntsk: task done but retry010
redo allocationkcrfw_redo_gen: redo allocation 103,3500
redo allocationkcrfw_redo_gen: redo allocation 307152,505
redo allocationkcrfw_redo_gen: redo allocation 202900
redo allocationkcrfw_post: more space0781,893
redo allocationkcrfw_redo_write: before write05590
redo allocationkcrf_pvt_strand_unbind020
redo writingkcrfw_post: rba scn pair030
redo writingkcrfw_cal_target_rba020
row cache objectskqreqd: reget01,791127
row cache objectskqrpre: find obj01,087385
row cache objectskqreqd02772,637
row cache objectskqrso06874
rules engine rule set statisticskwrsosb: begin collect rs stats021
sequence cachekdnssd012515
sequence cachekdnnxt: cached seq01110
sequence cachekdnss04115
session idle bitksupuc: set busy010
session state list latchkpseqd0490
shared poolkghalo0253278
shared poolkghfre0175145
shared poolkghupr101116
simulator hash latchkcbsacc: lookup dba02120
simulator lru latchkcbs_simulate: simulate set0300
space background task latchktsj_grab_task011
transaction allocationktcccadd055
transaction allocationktcccod020
undo global dataktudba: KSLBEGIN026,82226,822
undo global dataktudnx:child0178
undo global dataktusmupst: KSLBEGIN01414
undo global dataktubnd_4070
undo global dataktufrbs_20318

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpin1 4293,8730
Cursor Pinkksfbc [KKSCHLFSP2]165,6430
Library Cachekglpndl1 9575,932-0
Library Cachekglpnal1 9032,613-0
Library Cachekglhdgn2 10622,741-0
Cursor PinkksLockDelete [KKSCHLPIN6]7,1990
Cursor ParentkkscsPruneChild [KKSPRTLOC35]4,5150
Cursor PinkksCheckCursor [KKSCHLBRKN]3,6520
Cursor Pinkksxsccmp [KKSCHLPIN5]3,5150
Library CachekglIsOwnerVersionable 1212,7830
Library Cachekglget2 22,7710
hash tablekkshGetNextChild [KKSHBKLOC1]2,6220
Library Cachekgllkdl1 851,284-0
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]1,1950
Cursor Pinkkslce [KKSCHLPIN2]545-0
Library Cachekgllkc1 575330
hash tablekkscsSearchChildList [KKSHBKLOC2]1420
Cursor Pinkksfbc [KKSCHLPIN1]720
Library Cachekglic1 49640
Library Cachekglhdgh1 6430
Library Cachekglhdgn1 6225
Library Cachekglrfcl1 7920

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
ARAPPS_TS_INTERFACERA_INTERFACE_LINES_ALL TABLE952,275,16810.49
ZXAPPS_TS_TX_DATAZX_RATES_B TABLE539,361,1525.94
ONTAPPS_TS_INTERFACEOE_HEADERS_IFACE_ALL TABLE75,655,9040.83
XLATEMP1XLA_AE_LINES_GT TABLE73,428,4640.81
XLATEMP1XLA_AE_LINES_GT TABLE73,421,5680.81

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX19,83814.99
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE14,43710.91
ARAPPS_TS_INTERFACERA_INTERFACE_LINES_ALL TABLE3,1402.37
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_PKWF_ITEM49INDEX PARTITION1,0820.82
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ACTIVITY_STATUSESWF_ITEM49TABLE PARTITION1,0720.81

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX19,83828.61
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE14,43620.82
ARAPPS_TS_INTERFACERA_INTERFACE_LINES_ALL TABLE2,4483.53
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_PKWF_ITEM49INDEX PARTITION1,0821.56
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ACTIVITY_STATUSESWF_ITEM49TABLE PARTITION1,0721.55

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX19,83828.61
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE14,43620.82
ARAPPS_TS_INTERFACERA_INTERFACE_LINES_ALL TABLE2,4483.53
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_PKWF_ITEM49INDEX PARTITION1,0821.56
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ACTIVITY_STATUSESWF_ITEM49TABLE PARTITION1,0721.55

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
WSHAPPS_TS_SUMMARYMLOG$_WSH_DELIVERY_DETAILS TABLE63,0392.02
ARAPPS_TS_INTERFACERA_INTERFACE_LINES_ALL TABLE53,7641.73
XNPAPPS_TS_TX_DATAXNP_MSGS TABLE40,2581.29
ZXAPPS_TS_TX_DATAZX_LINES TABLE33,4751.07
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX29,7820.96

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
WSHAPPS_TS_SUMMARYMLOG$_WSH_DELIVERY_DETAILS TABLE10,0992.42
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX7,1651.72
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE5,7671.38
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX5,5851.34
ARAPPS_TS_INTERFACERA_INTERFACE_LINES_ALL TABLE4,3011.03

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
WSHAPPS_TS_INTERFACEWSH_PR_WORKERS TABLE376,544,41636.09
ARAPPS_TS_INTERFACERA_INTERFACE_LINES_ALL TABLE338,141,53632.41
ONTAPPS_TS_TX_DATAOE_ORDER_LINES_ALL TABLE47,412,9284.54
ARAPPS_TS_TX_IDXRA_CUST_TRX_LINE_GL_DIST_N6 INDEX34,653,9523.32
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_PKWF_ITEM49INDEX PARTITION30,919,1842.96

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
WSHAPPS_TS_INTERFACEWSH_PR_WORKERS TABLE1,394,48688.45
APPLSYSAPPS_TS_TX_DATAWF_ITEMS TABLE111,6877.08
INVAPPS_TS_INTERFACEMTL_TRANSACTIONS_INTERFACE TABLE9,7530.62
ARAPPS_TS_TX_IDXRA_CUST_TRX_LINE_GL_DIST_U1 INDEX9,1080.58
ARAPPS_TS_TX_IDXRA_CUST_TRX_LINE_GL_DIST_N9 INDEX6,0920.39

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
ARAPPS_TS_TX_IDXRA_CUST_TRX_LINE_GL_DIST_N6 INDEX2828.57
APPLSYSAPPS_TS_QUEUESSYS_IOT_TOP_139171 INDEX1414.29
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX1111.22
ARAPPS_TS_TX_IDXRA_CUST_TRX_LINE_GL_DIST_N5 INDEX99.18
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_PKWF_ITEM49INDEX PARTITION88.16

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
ARAPPS_TS_INTERFACERA_INTERFACE_LINES_ALL TABLE4,964,94971.79
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE173,7242.51
ONTAPPS_TS_TX_DATAOE_ORDER_LINES_ALL TABLE159,7632.31
APPLSYSAPPS_TS_QUEUESSYS_IOT_TOP_139171 INDEX129,2811.87
ARAPPS_TS_TX_IDXRA_CUST_TRX_LINE_GL_DIST_U1 INDEX111,2801.61

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control70.000 21
dc_constraints6450.000 6497
dc_global_oids534,2930.000 464
dc_histogram_data1,7090.000 0633
dc_histogram_defs16,3033.310 30518,937
dc_object_grants6180.000 0322
dc_objects1,833,1250.000 8510,619
dc_profiles1,4860.000 01
dc_rollback_segments1,9630.000 059
dc_segments84,2650.020 35,7555,113
dc_sequences100,8230.000 100,82377
dc_table_scns596,6990.000 015
dc_tablespace_quotas15,5720.000 04
dc_tablespaces768,2990.000 055
dc_users11,475,9750.000 0221
global database name3,4340.000 01
outstanding_alerts2191.370 753


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
APP CONTEXT55,2020.0055,2020.0000
BODY122,658-0.007,977,3750.0100
DBLINK2,9740.000 00
DIRECTORY1,5920.001,5920.0000
EDITION1,5380.003,0240.0000
HINTSET OBJECT80.0040.0000
INDEX1345.9712612.7000
JAVA DATA1,0500.000 00
OBJECT ID17100.000 00
PIPE1,6980.001,6980.0000
QUEUE113,6510.00536,5010.0020
RULESET109,9980.00109,9980.0000
SCHEMA3,0280.000 00
SQL AREA131,4020.2794,170,748-1.51745134
SUBSCRIPTION5780.525780.5200
TABLE/PROCEDURE664,5460.0014,036,1180.01120
TRIGGER8,2230.001,659,4100.0000


Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache28,416.0028,416.0028,416.0028,864.000SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target6,144.006,144.006,144.006,144.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target31,552.0031,552.0031,552.0031,552.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool384.00384.0064.00384.000GRO/IMM
large pool64.0064.000.0064.000GRO/IMM
shared pool2,304.002,304.002,304.002,304.000STA/
streams pool128.00128.000.00128.000GRO/IMM

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther166.62 1.852.0012129090
 Freeable50.880.000.782.0711 6565
 PL/SQL39.9338.130.440.29119090
 SQL4.001.120.050.07057770
EOther154.53 1.721.6811119090
 Freeable62.500.000.962.4612 6565
 PL/SQL39.9337.900.440.29119090
 SQL3.951.190.050.07057771

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers29,796,335,616 
Fixed Size2,223,136 
Redo Buffers118,501,376 
Variable Size3,019,899,872 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javaJOXLE36.2536.250.00
javafree memory346.13346.130.00
largePX msg pool7.817.810.00
largefree memory56.1956.190.00
sharedASH buffers40.5040.500.00
sharedCCUR41.2141.991.88
sharedFileOpenBlock53.1153.110.00
sharedKGLH031.1731.270.33
sharedKGLS55.2955.530.45
sharedPLMCD46.2546.250.00
sharedSQLA176.37182.943.72
shareddb_block_hash_buckets178.00178.000.00
sharedevent statistics per sess24.6724.670.00
sharedfree memory1,306.851,297.96-0.68
sharedprivate strands28.5728.570.00
streamsKTG hash buckets2.522.520.00
streamsfree memory125.45125.450.00
 buffer_cache28,416.0028,416.000.00
 fixed_sga2.122.120.00
 log_buffer113.01113.010.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonForeground CPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0923 09:34:118.570.010.00
QMON Coordinator0923 09:34:010.060.000.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

Queue NameEnq MsgsEnq Msgs/secDeq MsgsDeq Msgs/secSpill MsgsSpill Msgs/sec%Spill Msgs
APPLSYS.WF_CONTROL(414798) 00.0000.0000.00 

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

RuleEvalsNo-SQL Eval%SQL ExecsCPU(s)Ela(s)Eval /SecSQL per EvalEla(s) per EvalCPU(s) per EvalReloads
APPLSYS.WF_DEFERRED_QUEUE_M_R 109,6560.00109,8835.1410.4938.741.000.000.000
SYS.ALERT_QUE_R 70.0000.000.000.000.000.000.000
APPLSYS.FND_CP_GSM_OPP_AQ_R 10.0000.000.000.000.000.000.000

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
APPLSYS.FND_CP_GSM_IPC_AQ(414727) 00  0.000.00  
APPLSYS.FND_CP_GSM_OPP_AQ(415115) 262100.000.000.012.790.002.11
APPLSYS.WF_DEFERRED(414841) 00  0.000.00  
APPLSYS.WF_DEFERRED_QUEUE_M(414935) 109,99099,9900.009.0933.67374.050.0040.02
AR.AR_REV_REC_Q(415049) 9,9999,9990.000.001.044.170.000.00
XNP.XNP_IN_EVT_Q(415037) 199,98000.000.0066.990.000.000.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
APPLSYS.FND_CP_GSM_IPC_AQ(414727) 0.000.00  
APPLSYS.FND_CP_GSM_OPP_AQ(415115) 0.010.000.001.39
APPLSYS.WF_DEFERRED(414841) 0.000.00  
APPLSYS.WF_DEFERRED_QUEUE_M(414935) 38.8635.330.000.00
AR.AR_REV_REC_Q(415049) 3.533.530.000.00
XNP.XNP_IN_EVT_Q(415037) 70.660.000.00 

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
FNDCPGSMIPC_CARTRIDGE_1559667(378)/APPLSYS.FND_CP_GSM_IPC_AQ 000   
FNDCPGSMIPC_SERVICE_1559667(379)/APPLSYS.FND_CP_GSM_IPC_AQ 0000.000.000.00
OPP1559667(58)/APPLSYS.FND_CP_GSM_OPP_AQ 1100.000.000.00
WF_DEFERRED(1)/APPLSYS.WF_DEFERRED 0000.000.000.00
APPS(1)/APPLSYS.WF_DEFERRED_QUEUE_M 99,99099,990035.3335.330.00
INSTALL(3)/AR.AR_REV_REC_Q 000   

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total ConnectionsAvg Active ConnectionsAvg Total Shared SrvrsAvg Active Shared SrvrsAvg Total DispatchersAvg Active Dispatchers
000000

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per SecDisp Queue Per SecServer Msgs/SecServer KB/SecCommon Queue TotalDisp Queue TotalServer Total MsgsServer Total(KB)
0000.000000

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_b_tree_bitmap_plansFALSE  
_fast_full_scan_enabledFALSE  
_gby_hash_aggregation_enabledFALSE  
_like_with_bind_as_equalityTRUE  
_optim_peek_user_bindsFALSE  
_optimizer_autostats_jobFALSE  
_sort_elimination_cost_ratio5  
_swrf_mmon_dbfusFALSE  
_swrf_mmon_flushFALSE  
_system_trig_enabledTRUE  
_trace_files_publicTRUE  
aq_tm_processes1  
compatible11.2.0  
control_files/oasb_data/cntrl01.dbf, /oasb_data/cntrl02.dbf, /oasb_data/cntrl03.dbf  
cursor_sharingEXACT  
db_block_checkingFALSE  
db_block_checksumTRUE  
db_block_size8192  
db_files512  
db_nameVIS  
diagnostic_dest/oracle/VIS/db/tech_st/11.2.0/admin/VIS_app0  
dml_locks10000  
job_queue_processes2  
lock_sgaTRUE  
log_buffer63012864  
log_checkpoint_timeout1200  
log_checkpoints_to_alertTRUE  
max_dump_file_size20480  
nls_compbinary  
nls_date_formatDD-MON-RR  
nls_languageamerican  
nls_length_semanticsBYTE  
nls_numeric_characters.,  
nls_sortbinary  
nls_territoryamerica  
olap_page_pool_size4194304  
open_cursors800  
optimizer_secure_view_mergingFALSE  
parallel_max_servers24  
parallel_min_servers0  
parallel_threads_per_cpu2  
pga_aggregate_target6442450944  
plsql_code_typeINTERPRETED  
processes1000  
query_rewrite_enabledtrue  
sec_case_sensitive_logonFALSE  
session_cached_cursors500  
sessions2016  
sga_target33084669952  
shared_pool_reserved_size419430400  
shared_pool_size2415919104  
timed_statisticsTRUE  
transactions2200  
undo_managementAUTO  
undo_retention36000  
undo_tablespaceAPPS_UNDOTS1  
utl_file_dir/usr/tmp, /oracle/VIS/db/tech_st/11.2.0/appsutil/outbound/VIS_app0, /usr/tmp  
workarea_size_policyAUTO  


Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report