ITPub博客

eTRM: etrm.oracle.com"EBS重要表用途与关系介绍.pdf" http://vdisk.weibo.com/s/lt2I-"R12_Table(All Module)_ER.zip" http://vdisk.weibo.com/s/lt8GM"R12_eTRM（多模块）.zip" http://vdisk.weibo.com/s/lzfIw"OracleERP表结构.xls" http://vdisk.weibo.com/s/lt38E客户地点逻辑图， http://bbs.erp100.com/thread-105524-1-1.htmlOracle_HRMS_数据字典.pdf, http://bbs.erp100.com/thread-103491-1-1.htmlORACLE 表结构关系图(GL模块全局ER图) h

Module 11i Tables R12 Tables New Tables AR 551 616 118 BOM 264 337 73 GL 186 309 140 AP 236 297 73 INV 247 274 33 PO 186 213 33 FA 179 198 19 MRP 174 174 0 ICX 155 157 2 OM 148 150 2 WMS 88 134 46 WSH 113 115 2 WIP 76 96 20 Query:SELECT PRODUCT_CODE,COUNT(*) FROM FND_TABLES A,FND_APPLICATION B WHERE A.APPLICATION_ID = B.APPLICATION_ID GROUP BY PRODUCT_CODE;

默认情况下“附件”按钮是灰显的，本文将展示如何让某个Form的附件按钮变亮，并能上传附件.以用户Form为例，我们想让用户上传自己的照片Pre-SetupsHelp > Diagnostics > Custom Code > Personalize，记录下Function Name并用Help > Diagnostics > Examine查看User Name字段和User ID字段对应的Field名称我们将会在后边的步骤里使用USER_ID和USER_NAMESetups接下来就在Application Developer职责下，要配置Atta

Oracle EBS需要什么样的硬件水平,可以参考下我搜集的一些资料ServerOracle R12 E-Business Standard Benchmark Overviewhttp://www.oracle.com/us/solutions/benchmark/apps-benchmark/ebs-standard-benchmark-overview-192676.htmlOracle E-Business Suite Standard Benchmarkhttp://www.oracle.com/us/solutions/benchmark/apps-benchmark/results-166922.htmlOracle Applications Benchmarkhttp://www.oracle.com/us/solutions/benchmark/apps-benchmark/index-166919.htmlA Primer on Hardware Sizing for O

Get APPL_TOPselect name,       node_id,       path,       shared,       created_by,       creation_date,       last_updated_by,       last_update_date,       FILE_SYSTEM_GUID,       appl_top_guidFROM APPLSYS.FND_APPL_TOPS;Get &l

SELECT PAAF.SUPERVISOR_ID MGR_ID,      PJ.JOB_ID ,      PAPF.FULL_NAME,      PJ.NAME,      PAPF.PERSON_ID PER_IDFROM PER_PEOPLE_X PAPF,      PER_ASSIGNMENTS_X PAAF,      PER_JOBS PJWHERE PAPF.PERSON_ID = PAAF.PERSON_IDAND PAAF.JOB_ID      = PJ.JOB_IDSTART WITH PAPF.PERSON_ID   = 57--Smith,Jonathan(MFG)CONNECT BY

10g引入AWR(Automatic Workload Repository),一个新的性能采集和分析工具。(10g以前使用statspack)AWR可以收集的信息有：Wait events used to identify performance problems.Time model statistics indicating the amount of DB time associated with a process from the V$SESS_TIME_MODEL and V$SYS_TIME_MODEL views.Active Session History (ASH) statistics from the V$ACTIVE_SESSION_HISTORY view.Some system and session statistics from the V$SYSSTAT and V$SESSTAT views.Object usage stati

使用awrrpt.sql来生成AWR Report，脚本运行完毕的时候报下边的错误,select output from table(dbms_workload_repository.awr_report_html( :dbid, * ERROR at line 1: ORA-00904: : invalid identifier 解决方法：需要使用sys或者system用户来执行AWR脚本

General Ledger Useful SQL Scripts – Oracle Applications 11iContentsGL Set of Books Configuration Overview                                                                 &

System Admin下有一个Profile："Hide Diagnostics menu entry"(中文环境叫“隐藏诊断菜单项”)，可以用这个Profile来设置是否显示Diagnostics菜单项。注：设置之后，需重新登陆设置成Yes，Diagnostics菜单项就隐藏起来，以防不明真相的用户操作设回成No，Diagnostics 菜单又显示出来。Related Topic:Profile:Utilities : Diagnostics

select distinct d.user_name from apps.fnd_logins a,v$session b, v$process c, apps.fnd_user d where b.paddr = c.addr and a.pid=c.pid and a.spid = b.process and d.user_id = a.user_id and (d.user_name = \'USER_NAME\' OR 1=1);

How Inventory Passes Journals To General Ledger (GL)Inventory Transactions transfer to GL normally done by Program called INCTGL.The accounting information related to transactions in INV module is transferred to GL by running the ‘Transfer Transactions to GL’ concurrent program. This is part of ‘Period End Process\' . However, you can run explicitly any time during an open period. When you run this process and in case if more than one period is open, all the transactions from the earliest

下图为Oracle EBS关闭期间的时候，各个模块的相互依赖的关系，顺着箭头逐步关闭各模块的期间。比如，Order Management会直接影响应收(Receivables)模块，所以OM模块应先于应收模块关闭。如果图中某个模块没有使用，则可以跳过它，进入下一个模块。每个特定模块期间中,Transactions的账户信息在关闭时最终都会Transfer to General Ledger.所以期间关闭基本是下边这个流程：1. Order Management /

(V45) Trigger Execution Sequence in Forms 4.5 ============================================= Introduction This document lists the order in which triggers fire in Oracle Forms 4.5:  o The first column, Action, describes the function to be performed     (e.g. deleting a record).  o The second column, Trigger Firing Order, describes the order     in which triggers fire after a function is performed.  o The third col

For Interface Transactions,INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS DOES below things:1)validate_group (Validate a group of MTI records in a batch together)2)validate_lines(Validate each record of a batch in MTI)3)tempinsert(insert records from MTI into MMTT)4)calling inventory transaction Manager(insert records from MMTT into MMT)For Pending Transactions,INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS DOES below things:calling inventory transaction Manager(insert records from MMTT into MMT)

一个Concurrent Manager可以调用多个进程(Worker)来同时做事务处理,如何修改Concurrent Manager所能调用的进程数(Worker数)System Admin >Concurrent > Define > Work ShiftsProcesses的数量就是将来Concurrent Manager能够调用的进程数量。更改完后，去Concurrent > Manager > Administer可以看到，Actual和Target也相应的发生了改变。ps:In administer concurrent manager form there are two columns labelled as actual and target. What ar

Permission Modes 7 5 5 user group world r+w+x r+x r+x 4+2+1 4+0+1 4+0+1 = 755 Read 4 - Allowed to read filesWrite 2 - Allowed to write/modify fileseXecute 1 - Read/write/delete/modify/directory 7 4 4 user group world r+w+x r r 4+2+1 4+0+0 4+0+0 = 744Permission 0000 to 0777 chmod 0 ---------- chmod 1 ---------x chmod 2 --------w- chmod 3 --------wx chmod 4

SyntaxFND_PROFILE.SAVE(<Profile_Option_Name>,                  <Profile_Option_Value>,                  <Level SITE/APPL/RESP/USER>,                  <Level_Value>,            &nb

这里演示一下，开发一个最简单BI Publisher Report的流程，下图为开发的基本流程.Data Template(.xml) 作为Data Source，用于数据源的定义，以及取数的SQL语句;Template(.rtf) 用于定义输出展示(Layout); (RTF:Rich Text Format)1.首先创建一个Demo数据CREATE TABLE demo_products ( product_code NUMBER, product_name VARCHAR2 (100)); INSERT INTO demo_products VALUES (569, \'Oracle Cost Management\'); INSERT INTO demo_products VALUES (

安装完BI Publisher之后，然后试图在Word中打开BI Publisher的插件，报：自动化(Automation)错误（Automation Error）这个错其实不是BI Publisher的问题，而是Word的问题。解决方法：The solution is to unregister and re-register the C:\Windows\System32\MSCOMCTL.OCX fileIf on a 64-bit machine, type the following: regsvr32.exe /u C:\Windows\SysWOW64\MSCOMCTL.OCX Hit ENTER then type regsvr32.exe C:\Windows\SysWOW64\MSCOMCTL.OCXIf on a 32-bit machine, type the