h2内存数据库

摘要： <<Stop Server Command Order>>1.Apps Management User,cd $ADMIN_SCRIPTS_HOMEstop apps server./adstpall.sh apps/apps 2.DB Admin User,cd $RDBMS_ORACLE_HOME/appsutil/scripts/<SID_hostname>Stop DB Listener./addlnctl.sh stop mc3yd213 Stop DB Server./addbctl.sh stop abort/normal/immediate 阅读全文

摘要： /etc目录用于存放Linux/Unix系统的配置文件，/etc里的配置文件非常关键，所以要经常备份(备份方法见文章末尾)，这样不管你是重装系统还是因为系统坏掉，都能快速的恢复到早先的配置状态。文章“etc” 和“理解 Linux 配置文件”，对etc目录下的所有文件都有了一个详细的解释，可以用于查阅。这里主要写一下/etc目录下几个常用的配置文件。/etc/profile/etc/profile里边包含了系统的环境变量的设置，比如$PATH,$HOME...每次用户登陆都会加载这个文件以设置环境变量，这个文件是全局的profile文件，设置后会影响到所有用户。（/home/username/ 阅读全文

摘要： 使用sqlplus "/ as sysdba"连DB,报错:ORA-01031: insufficient privileges[oracle@bej301441 lib]$ sqlplus "/ as sysdba"SQL*Plus: Release 10.1.0.5.0 - Production on Tue Jul 3 03:58:50 2012Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:ORA-01031: insufficient privilegesEnter use 阅读全文

摘要： What's main code logic while performing query in material workbench form(INVMWBIV.fmb).Key File:INVMWBIV.fmbINVMWQMB.pls - INV_MWB_QUERY_MANAGERINVMWCTB.pls - INV_MWB_CONTROLLERKey Table:MTL_MWB_GTMPmtl_onhand_quantities_detail=====================First Delete All records from MTL_MWB_GTMP.DELET 阅读全文

摘要： 客户可以通过Help > Diagnostics > Custom Code > Personalize，来对Form做个性化的设置。如何通过脚本来查看Form做了哪些个性化SELECT * FROM FND_FORM_CUSTOM_RULES WHERE form_name = 'INVTOMAI';--Input your Form NameSELECT * FROM FND_FORM_CUSTOM_ACTIONS WHERE RULE_ID IN (SELECT ID FROM fnd_form_custom_rules WHERE form_name 阅读全文

摘要： THIS WORKS WITH ORACLE R12Here is a wonderful oracle seeded Procedure fnd_web_sec.get_guest_username_pwd which will help us to find out user password.This will be handy for consultants in resolving the issues. Please use with this care and dont misuse this.To achieve this you need to create a small 阅读全文

摘要： Oracle Apps Script to create a new User Login Account--CREATE a new user account DECLARE p_user_name VARCHAR2 (200) := 'PTIAN'; p_owner VARCHAR2 (200) := NULL; p_unencrypted_password VARCHAR2 (200) := 'welcome'; p_session_number NUMBER ... 阅读全文

摘要： 用户可以在Profile文件中加入环境变量，比如ORACLE_HOME,HOME...这样重新登录之后，这些环境变量都会得以设置，不用每次都手工设置。Unix/Linux有两个profile文件1./etc/profile:是全局profile文件，设置后会影响到所有用户2./home/username/.profile或.bash_profile是针对特定用户的，可以针对用户，来配置自己的环境变量。注意:profile是unix上才有的;bash_profile是Linux下有的(Linux下，用户目录没有.profile文件) /home/username/.profile或.bash_p 阅读全文

摘要： Oracle Apps R12下如何定义一个简单的Hello World的Concurrent Program定义一个表和一个Procedure先create table ptian_table ( message_text VARCHAR2(100) ,creation_date DATE ) ; CREATE OR REPLACE PROCEDURE PTIAN_HELLO (errbuf OUT VARCHAR2, retcode OUT VARCHAR2) IS BEGIN INSERT INTO ptian_table VALUES ('Hello World' ,S 阅读全文

摘要： 1.Using script to submit INV Manager to process MMTT/* * When prompted for user_id, resp_id and resp_appl_id, ask ct enter the correct values for * these variables. The values can be obtained by logging into Inventory * reponsibility and from menu Help->Diagnostics->Examine, select block as * 阅读全文

摘要： Transaction Type = Transaction Source Type + Transaction Actioneg.Move Order Issue = Move Order + Issue From StoresBelow is the script to check Txn Type, Txn Source Type, Txn Action(Lookups)--Txn Type SELECT TRANSACTION_TYPE_ID, TRANSACTION_TYPE_NAME,TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID 阅读全文