I. Exception Handling
Many people prefer to set exception to 'null'. It should be said that this is a bad habit. If a specific exception is not defined, at least the database error information should be completely reported.Incorrect syntax:ExceptionWhen others thenNULL;End;Correct syntax:ExceptionWhen others thenFnd_file.put_line (fnd_file.output, sqlcode );Fnd_file.put_line (fnd_file.output, sqlerrm );End;
Ii. Output and log of concurrent requests are not classified
Some people do not know how
Label: 1. Suppose you have an EBS environment apps user password that can break the user's application password Reference: How to hack user password under Oracle EBS R12 2, assuming no apps user password. Also want to crack the environment apassword. To see "Luck", suppose there is a corresponding clone environment B,ebs DBA has not changed $context_file content
The Oracle system must follow a certain operation sequence when processing the monthly business.These businesses involve the corresponding modules, including: payable module, procurement module, inventory module, receivables module, salary module, fixed assets and general ledger module.
In Oracle, the general ledger module is at the core of financial accounting. It receives financial information from other modules.The financial information received by the general ledger must be consistent with t
Windows 7 flagship edition 64-bit
VMware 7
Oracle Linux Release 5
E-Business R12.1.1 Linux x8
In the linux graphic interface, add the dba group and the oracle and applmgr users. These two users are automatically selected during EBS installation.
The Virtual Machine hard disk is set to 400 GB. When the demo database is installed, there is not enough space. Instead, it is changed to fresh for installation.
Linux graphic sub-character interface s
1. If you have an EBS environment app user password, you can crack the app user password
Refer to: how to crack the user password in Oracle EBS R12
2. If you do not have A password for the APPS user, you also want to crack the password for Environment. It depends on luck. If the Clone environment B is available, the EBS DBA has not modified the content of $ C
As the company needs to install Oracle EBS for form development, it starts the painful Oracle EBS installation process. Just started to install EBS in the VM Win2003 server, I do not know whether my own level is too poor or bad luck, according to the installation of EBS in the network, installed through the detection i
A certain sequence of operations is required when the Oracle system processes the monthly-knot business.These operations involve the corresponding modules, including: Coping module, purchasing module, Inventory module, receivable module, payroll module, Fixed assets and General Ledger module, etc.In Oracle systems, the General ledger module is at the heart of financial accounting, and it receives financial information from other modules.General Ledger received financial information and sub-modul
Set the EBS report output default type HTML and open it in the browser here we set the Resource Transaction Report view output to open directly in the browser. Blog post that is associated with the resource Transaction report: http://blog.csdn.net/crazygolf/article/details/48448525. We found the template code from the above blog: Wiptrtxn_xml. 1. Enter the relevant duties.2. Locate the corresponding report.3. Click Update.4. Default Output type Sel
EBS multi-OU and multi-account customization implementation (I) Multi-OU Summary 1. form multiple OU Implementation 1) create a Table, take CUX_AP_CHECK_HEADER_ALL as An Example 2) create two Synonym tables (one excluding _ ALL and one ending with _ ALL): CUX_AP_CHECK_HEADER and CUX_AP_CHECK_HEADER_ALL3) to Synonym: CUX_AP_CHEC without _ ALL
EBS multi-OU and multi-account customization implementation (I) Mu
The EBS modules I usually use are as follows: PO, INV, and OM. therefore, you often need to collect related log information. if an error is reported on the interface, you can easily see the code execution error in the log. this blog summarizes the methods for collecting the above logs, and the OM mode, which is the main record of sqltrace and frdlog.1.OMlog.
The EBS modules I usually use are as follows: PO,
Recently, I was suddenly interested in learning EBS R12. After downloading and installing an EBS R12, I couldn't do it in English. I had to prepare a Chinese package. I had to find a few points on the Internet, it is estimated that they are hand-written and not detailed. I am a newbie who can hardly understand it. After several days of exploration, I have finally completed the process. Now I will write it i
Set the default type of EBS report output HTML and open it in the browserSet the default type of EBS report output HTML and open it in the browser. Here we set "resource Transaction Processing Report" to view that the output is opened directly in the browser. Blog related to "resource Transaction Processing Report": http://blog.csdn.net/crazygolf/article/details/48448525. The template code WIPTRTXN_XML is f
This is the second article on multi-organization access.Article, Translated fromAnilPassiOfMultiOrg R12
We all know thatOracleMultiple organizational models (Multi orgIs changed. It is called multi-organization access control (Multi org access control, MOAC ). I will tell you the reason for this change and how it will affect you. I will also tell you how to avoid affecting your existing settings at all. [if you do not want to useMOAC-multi-organization access control]
If you are not famili
HTTP://BLOG.ITPUB.NET/26687597/VIEWSPACE-1207571/based on Oracle EBS R12, a webservice is developed to return a master data, When the amount of data requested is very large (more than 6000 rows of data), the Oracle Application server always returns a $ Internal server Error. When the requested data volume is small, the webservice runs without problems and can return the request data normally. Client received an error: The server encountered an interna
Prerequisites for Recurrence:
The output format is "text" of the Concurrent Program: effective responsibility and user.
How to show Excel options when viewing output: System administrator installation browser options Add a row of "file format" to "Text" records, "MIME type" and "description" select "File format" is the same line in Excel.
EBS needs to have installed Simplified Chinese language, so "effective responsibility and user" inside will hav
Prerequisites: Oracle EBS Enterprise Tax Reform Scheme (i)-business needs collation and foundation SetupOracle EBS System version: 11.5.10Open purchase orders are more cumbersome to handle than open sales, because the underlying table schema and logic for purchase orders, such as purchase receipt, will not be split. In particular, many companies to PR, PBA, quotation or standard PO, etc. than the depth of c
Introduction to the Binding method (Binding Style) in Oracle EBS OAF VO (View Object) Development
Wei Hongsheng
In the development of oaf Vo, Binding style is primarily used to dynamically transfer values to VO's WHERE clause, which has a total of three ways
1. Oracle Named
2. Oracle positional
3. JDBC Positional
Oracle Positional
Oracle positional is one of the most common ways to introduce Oracle documentation
This style represents parameters as co
First, Wsh_mode_of_transport mode of transport setup10_OM_ Order Management Super users > Settings > Shipping > CodeThe access level at EBS 12.1.3,wsh_mode_of_transport is: System. So you can only modify the meaning and description, you cannot add or delete rows.The access level at EBS 12.2.2,wsh_mode_of_transport is: extensible.Modify the meaning and description of the parcel code to: other.Second, Wsh_ser
Tags: Internet Explorer scripting XSS Oracle EBSThe Login to Oracle EBS form encounters a problem Internet Explorer has modified this page to the Help prevent Cross-site scriptingThe form that landed on Oracle EBS today encountered a problem with Internet Explorer have modified this page to the help prevent Cross-site scripting.The solution is this:1. Open the Internet Explorer Internet Options.2. Select th
Oracle Official Document Libraryhttp://tahiti.oracle.com/Http://www.oracle.com/technetwork/documentation/index.html#appsThe new EBS is 12.1.3 and 12.2.2, which mainly includes the User Guide and Implementation guide of each module.Oracle e-business Suite Online documentation Library Release 12.1.3+Http://docs.oracle.com/cd/E18727_01/index.htmOracle e-business Suite Online documentation Library Release 12.2.2Http://docs.oracle.com/cd/V39571_01/current/
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.