Oracle ERP系统借贷关系表
成本核算会计信息归纳,按照事务处理的来源类型归纳。一、 采购接收入库和退货: 1.接收: 借:材料采购 (订单价格) 贷:应计负债 (订单价格) 2.入库: 借:原材料 (标准成本) 贷:材料采购 (订单价格) 借或贷:材料成本差异_材料订单价格 3.退货至接收时产生与上面第2步相反的分录,退货至供货商时产
FRM-90926: Duplicate parameter on command line
After Logining Oracle EBS, System Error out with:FRM-90926: Duplicate parameter on command line.Then check URL of apps in IE,saw belowYou can see there are two "record=collect" in URL, That\'s why system tell us "Duplicate parameter"Solution:Login apps with other user and modify profile "ICX: Forms Launcher",remove "?record=collect" from value
adstpall.sh:Exiting with status 137
Can not stop Oracle Apps Server,error information:-----------------------------[oracle@bej301441 scripts]$ adstpall.sh apps/appsYou are running adstpall.sh version 120.10.12010000.4The logfile for this session is located at /u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441/logs/appl/admin/log/adstpall.log/u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441/admin/scripts/adstpall.sh: line 242: 15124 Done  
Job Completion/Return Process in Oracle MES
How to perform a WIP job Completion in Oracle MES ,Below is basic flow for completion.Define BOM,and Routing, Then Create a Job in Oracle Application(Supply type:Assembly Pull for this demo case)Responsibility:MES Supervisor, Enter the organization,then press \'Start\' buttonAction:Search Jobs,And GoSearch your job name, You will see the job details. Now we need move transaction.(Queue:3)After express move, you will see,\'To Move\' got changed to 3,and \'Queue\' is zero.Now we can complete Job
JDeveloper经常黑屏的问题(Windows 7)
Windows 7下,使用JDeveloper(我的版本:10.1.3.3.0)过程中,屏幕经常会黑掉(尤其是拖动滚动条的时候),好像断电似的,并且会很慢,过一会才恢复过来,有时还会报“显示器驱动程序已停止响应,并且已恢复”的警告。解决方法:$JDEV_HOME\jdevbin\jdev\bin\jdev.conf中增加下边的选项AddVMOption -Dsun.java2d.noddraw=true其实配置文件是有这项的,只不过默认安装下,被注释掉了,重新E
7 Tips For Better JDeveloper Experience
7 Tips For Better JDeveloper Experience from shay.shmeltzer
Low-level Diagnostic Logging is turned on. This may temporarily reduce performance.
登陆EBS后,主界面有一个Warning:Low-level Diagnostic Logging is turned on. This may temporarily reduce performance.去除Warning的方法:Option 1: FND: Debug Log Enabled = NoOption 2:FND: Debug Lot Level级别设高些,比如Exception,Error,Unexpected就不会有这个warning了.如果设置级别为Statement,Procedure,Event就会有warning提示。
How to Check Debug Log on OAF Pages
1. Profile \'FND: Diagnostics\' = Yes at user level.This will make \'Diagnostics\' menu display.2. Login to Personal Home Page as that user and select the \'Diagnostics\' icon at the top of the page.3.In list box, Choose \'Show Log on Screen\',and Select Statement4.Once this is done , when you go to any page you would be able to see log at the bottom of the page .----------------------------------------------------------------------------------------------------------------------------------
How to Generate SQL Trace In OAF
1. Profile \'FND: Diagnostics\' = Yes at user level.This will make \'Diagnostics\' menu display.2. Login to Personal Home Page as that user and select the \'Diagnostics\' icon at the top of the page.3. Select \'Set Trace Level\' and click Go4. Select the desired trace level and click Save5. Write down the trace id number(s).6. Perform the activity that you want to trace7. Return to the \'Diagnostics\' page.8. Select `Set Trace Level\' and click Go9. Select \'Disable Trace\' and click Go.10. Wr
OAF Sample Code
Get the VO from the AMOAViewObject objAssessmentVO = (OAViewObject)yourAM.findViewObject("yourVO"); MtlLotNumbersVOImpl vo= (MtlLotNumbersVOImpl)findViewObject("MtlLotNumbersVO1"); MtlLotNumbersVORowImpl voi=(MtlLotNumbersVORowImpl)(vo.getCurrentRow()); mLotDetailValuesHT.put("StatusId",voi.getStatusId());First get the AM where your VO is attached, then get the VO from that AM.Get the RootAM and get all the VOs under that AM, usingwriteLog(pageContext, "
OAF MVC Architecture
MVCM:The Model is the place containing the business logic. V:The View is the presentation layer. C:The Controller manages the flow between pages.OAF MVC Architectureor1] ModelBC4J(Business Components For Java) have three basic component classes:Application Module - a container for related BC4J ObjectEntity Objects - encapsulate business rulesView Objects - present data to the Framework pageBC4J is used to Business Logic and Data Handling ModelModel contains the components which handles data di
Error:'Please set up the forwarding function parameter "wipnp" in the workstation star
In JDev,Lanuch MES Home Page,Encounter a Error:\'Please set up the forwarding function parameter "wipnp" in the workstation startup function!\'Reason:In JDEV Project Properties,Runtime Connection information is not correct.Old Value:Application Short Name:INV,Responsibility Key:InventoryAfter correct to new value,the MES page got started successfully.New Value:Application Short Name:WIP,Responsibility Key:WIP_WS_SUPERVISOR
Due to "No space left on device", Many Concurrent Manager are under 'No Manager' S
Found Many Concurrent Managers are under \'No Manager\' Status, Then I tried to restart Concurrent Manager like(http://blog.csdn.net/pan_tian/article/details/7765256)Then saw following error:--------------------------------------------------------------------------------------------------------------[oracle@bej301441 scripts]$ adcmctl.sh start apps/apps diag=YYou are running adcmctl.sh version 120.17.12010000.5Starting concurrent manager for mc3yd213 ...Starting mc3yd213_0127@mc3yd213 In
Oracle Manufacturing Execution Systems(MES) Overview
MES is a new addition to oracle discrete manufacturing family in R12. MES enhances the basic WIP functionality with additional MES supervisor workbench and MES workstation feature. Oracle MES for Discrete Manufacturing Have two parts:MES Workstation: For shop floor OperatorMES Supervisor Workbench: For shop floor SupervisorThe MES Workstation for the operator provides a single interface to perform multiple shop floor functions, without navigating to a number of transacti
BOM API - uses the BOM_BO_PUB.PROCESS_BOM API to create bill header and add components to the bill
CREATE OR REPLACE PROCEDURE SU_PROCESS_BOM AS -- API input variables l_bom_header_rec Bom_Bo_Pub.bom_head_rec_type := Bom_Bo_Pub.g_miss_bom_header_rec; l_bom_revision_tbl Bom_Bo_Pub.bom_revision_tbl_type := Bom_Bo_Pub.g_miss_bom_revision_tbl; l_bom_component_tbl Bom_Bo_Pub.bom_comps_tbl_type := Bom_Bo_Pub.g_miss_bom_component_tbl; l_bom_ref_designator_tbl Bom_Bo_Pub.bom_ref
MetaData Service (MDS) in OA Framework
OAF的XML文件有:UIX Pages and Regions.OAF PersonalizationsBC4J Substitutions (EO, VO Substitutions)BC4J Components (EO.xml, VO.xml, AM.xml, AO.xml, VL.xml)OAF的很多组件都是以XML的形式存在,但到最终的系统里,OAF的XML文件会存储到数据库表中(JDR_表)。MDS提供API(JDR_UTILS)从JDR表读取,并构建XML的定义。TableDetailsJDR_PATHSStores document paths, packages and there parent child relationship. Primary Key: PATH_DOCIDJDR_COMPONENTSStores components o
Get Oracle Home & Oracle SID from PLSQL
DECLARE LC$ORACLE_HOME VARCHAR2 (2000); LC$ORACLE_SID VARCHAR2 (256); BEGIN DBMS_SYSTEM.GET_ENV (\'ORACLE_HOME\', LC$ORACLE_HOME); DBMS_SYSTEM.GET_ENV (\'ORACLE_SID\', LC$ORACLE_SID); -- Oracle Home DBMS_OUTPUT.PUT_LINE (\'ORACLE_HOME = \' || LC$ORACLE_HOME); -- Oracle SID DBMS_OUTPUT.PUT_LINE (
Does Subinventory Transfer Transaction create Accounting Entries?
Answer is \'Maybe\'.One subinventory xfer creates 2 inventory transactions. (mmt records)Those inventory transactions do NOT create a/c entries if both subinventories are tied to the same accounts.However, if the 2 subinventories are tied to different accounts, then both inventory transactions create accounting records.Check if your subinventories are tied to same accounts. If they are same, you should not see any a/c records.source:https://forums.oracle.com/forums/thread.jspa?messageID=441801
How to Run Standard OA Framework Pages from JDeveloper
1.FTP ClassesFTP All the .class & .xml files from $JAVA_TOP/oracle to your local PC, and put them into jdev/jdevhome/myclasses2.Source FilesFrom 1st step files,Also need copy necessary PROD files into source file directory: jdev\myprojects\oracle\apps\eg.If you want to run a WIP module page,Then you can only copy $JAVA_TOP/oracle/apps/wip/xxx/ to jdev\myprojects\oracle\apps\For source files, we don\'t need class files, so we can delete all the *.class files from jdev\myprojects\oracle\apps
How to check which responsiblity we are using
DECLAREp_userid NUMBER;p_respid NUMBER;p_applid NUMBER;x_resp_name VARCHAR2(50);BEGIN SELECT user_id INTO p_userid FROM fnd_user WHERE user_name =\'MFG\'; SELECT responsibility_id INTO p_respid FROM fnd_responsibility_tl WHERE responsibility_name = \'Purchasing, Vision Operations (USA)\'; p_applid := 201; -- Puchasing Module fnd_global.apps_initialize(p_userid, p_respid, p_applid); SELECT fnd_profile.value(\'RESP_NAME\') IN