随笔分类 - EBS

EBS

库存MTA

摘要：-- 库存MTASELECT c.code_combination_id, c.segment1, c.segment2, c.segment3, c.segment4, c.segment5, h.currency_code, h.period_name, to_number(to_char(h. 阅读全文

posted @ 2023-01-19 13:43 Iven_lin 阅读(19) 评论(0) 推荐(0) 编辑

查询并发程序是否启动跟踪功能-trc文件对数据库性能有

摘要：SELECT ICON_NAME, ROW_ID, USER_CONCURRENT_PROGRAM_NAME, ENABLED_FLAG, CONCURRENT_PROGRAM_NAME, DESCRIPTION, EXECUTION_OPTIONS, REQUEST_PRIORITY, INCRE 阅读全文

posted @ 2023-01-19 13:41 Iven_lin 阅读(19) 评论(0) 推荐(0) 编辑

找request的Trace文件

摘要：select 'Trace Name: '|| dest.value || '/' || lower(dbnm.value) || '_ora_' || oracle_process_id || '.trc', 'File Name: ' || execname.execution_file_nam 阅读全文

posted @ 2023-01-19 13:37 Iven_lin 阅读(20) 评论(0) 推荐(0) 编辑

删除 AP 发票相关脚本

摘要：--发票create table bak.AP_INVOICES_ALL_110707 asselect * from AP_INVOICES_ALL aiawhere aia.invoice_id in (90490,90333)--发票行create table bak.AP_INVOICE_L 阅读全文

posted @ 2023-01-19 13:35 Iven_lin 阅读(20) 评论(0) 推荐(0) 编辑