EBS R12.1 创建会计科目 GMFAACCP 性能优化建议

NOTE:1935888.1 – Recommended Patches and File versions for OPM Financials (GMF) and its related products
NOTE:2005954.1 – Create Accounting Performance Issue Troubleshooting Steps and Guidelines
NOTE:791049.1 – R12 SLA/FAH: How to Improve Performance in Subledger Accounting & Financials Accounting Hub
NOTE:2013558.1 – R12: Huge Number Of Records In XLA_DISTRIBUTION_LINKS Table
NOTE:1952504.1 – Create Accounting Low Performance for Oracle Process Manufacturing
NOTE:1512335.1 – R12 XLAACCPB PRC: Create Accounting Program Performance Is Slow During Month End

Diagnostics Apps Check - GMF: Provide the output from the Diagnostics Apps Check.

- From an Order Management responsibility, navigate to : "Reports, Requests > Run Requests > Single Request"
- Select "Diagnostics: Apps Check"
- In the "Application 1" parameter enter or select "Process Manufacturing Financials"
- In the "Application 2" parameter enter or select "Subledger Accounting"
- In the "Application 3" parameter enter or select "Oracle Landed Cost Management" and submit
- On completion, upload the output file from the concurrent request

Increase the number of processors or unit batch size
Responsibility : General Ledger Superuser :
Navigation : Setup > Financials > Accounting Setup Manager > Accounting Setups

- Search for your Ledger (or '%') and [Go]
- On the line for your Primary Ledger, select the 'Update Accounting Options' icon.
- On the line for 'Subledger Accounting Options', select the 'Update' icon.
- On the line for 'Process Manufacturing Financials', select the 'Update System Options' icon.

SELECT processes, processing_unit_size
  FROM xla_subledger_options_v
 WHERE ledger_id = 2047
   AND application_id = 555;

SELECT xh.ledger_id,
TO_CHAR( xe.event_date, 'MM-YYYY'),
xe.event_status_code,
xe.process_status_code,
COUNT(*)
FROM xla_events xe,
xla_ae_headers xh
WHERE xe.entity_id = xh.entity_id
AND xe.application_id = 555
AND xe.event_status_code IN ('I','U')
AND xe.process_status_code IN ('I','U','R','D','E')
--and xe.event_date > (SYSDATE -300)
GROUP BY xh.ledger_id,
TO_CHAR( xe.event_date, 'MM-YYYY'),
xe.event_status_code,
xe.process_status_code ;

exec fnd_stats.gather_table_stats(ownname=>'XLA',tabname=>'XLA_EVENTS',percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>48);
exec fnd_stats.gather_table_stats(ownname=>'XLA',tabname=>'XLA_AE_LINES',percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>48);
exec fnd_stats.gather_table_stats(ownname=>'XLA',tabname=>'XLA_AE_HEADERS',percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>48);
exec fnd_stats.gather_table_stats(ownname=>'XLA',tabname=>'XLA_DISTRIBUTION_LINKS',percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>48);
exec fnd_stats.gather_table_stats(ownname=>'XLA',tabname=>'XLA_TRANSACTION_ENTITIES',percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>48);

exec fnd_stats.gather_schema_statistics('GMF',DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>48);
exec fnd_stats.gather_schema_statistics('XLA',DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>48);
exec fnd_stats.gather_schema_statistics('INV',DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>48);
exec fnd_stats.gather_schema_statistics('PO',DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>48);
exec fnd_stats.gather_schema_statistics('ONT',DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>48);
exec fnd_stats.gather_schema_statistics('CUX',DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>48);

select distinct 'alter index XLA.'||dic.index_name||' rebuild partition '||dip.partition_name||' online;'
from dba_ind_columns dic,dba_ind_partitions dip
where 
dic.index_name=dip.index_name
and 
dic.index_name in ('XLA_AE_HEADERS_N1', 'XLA_AE_HEADERS_N2',
'XLA_AE_HEADERS_N3', 'XLA_AE_HEADERS_N4', 'XLA_AE_HEADERS_N5',
'XLA_AE_HEADERS_N8', 'XLA_AE_HEADERS_U1', 'XLA_AE_LINES_N1', 'XLA_AE_LINES_N4',
'XLA_AE_LINES_N5', 'XLA_AE_LINES_U1', 'XLA_DISTRIBUTION_LINKS_N1',
'XLA_DISTRIBUTION_LINKS_N3', 'XLA_DISTRIBUTION_LINKS_U1', 'XLA_EVENTS_N1',
'XLA_EVENTS_N2', 'XLA_EVENTS_N3', 'XLA_EVENTS_U1', 'XLA_EVENTS_U2',
'XLA_TRANSACTION_ENTITIES_N1', 'XLA_TRANSACTION_ENTITIES_U1')
order by 1;

set lines 160 pages 50000
Select distinct Bugs.Bug_Number as PATCH,
decode(Ad_Patch.Is_Patch_Applied('R12',-1,bugs.bug_Number),'EXPLICIT','APPLIED','NOT_APPLIED') as APPLIED
From 
(
 select '13698935' as bug_number From Dual UNION ALL
 select '14246749' as bug_number From Dual UNION ALL
 select '16887784' as bug_number From Dual UNION ALL
 select '18618110' as bug_number From Dual UNION ALL
 select '21771964' as bug_number From Dual UNION ALL
 select '22468218' as bug_number From Dual UNION ALL
 select '25210929' as bug_number From Dual
) Bugs order by 1;

统计数据收集模式：
NOTE:1234234.1 – Gather Schema Statistics End With Error When Gather Auto Option is used
NOTE:2168100.1 – Gather Schema Statistics Failed Due To Locks
NOTE:1586374.1 – Best Practices for Gathering Statistics with Oracle E-Business Suite
NOTE:1581549.1 – Best Practices for Minimizing Oracle E-Business Suite Release 12.1.3 and 12.2.n Upgrade Downtime

Patch 9542112: ERROR IN R12 FOR GATHER SCHEMA STATS WITH GATHER AUTO OPTION
Patch 13443215: FND_STATS SHOULD SUPPORT AUTO_SAMPLE_SIZE as estimate_percent for DB release 11gR1 and aboove 11
Patch 16410424: FND_STATS SHOULD CREATE HISTOGRAM ON MULTI COLUMN EXTENSION STATS
Patch 17189881: FND_STATS.RESTORE_SCHEMA_STATS FOR ALL SCHEMA IS FAILED

Select Bugs.Bug_Number as PATCH,
decode(Ad_Patch.Is_Patch_Applied('R12',-1,bugs.bug_Number),'EXPLICIT','APPLIED','NOT APPLIED') as APPLIED
From 
(
select '9542112' as bug_number From Dual UNION ALL 
select '13443215' as bug_number From Dual UNION ALL 
select '16410424' as bug_number From Dual UNION ALL 
select '17189881' as bug_number From Dual) Bugs;