oracle ebs implementation

Tags: object business Control Panel identify counting plan priority definition enforcement Overview of Oracle EBS WMS features (ii)(Copyright notice, I original or translation of the article to be reproduced, such as reproduced for personal study, please specify the source.) Otherwise please contact with me, offenders must investigate)Shipping Logistics Logic mainly includes1. Packaging. Ability to package

Under normal circumstances, you can change the user password in Oracle EBS in System administrator> Define user form, but sometimes, you need to change the password more quickly during development or implementation, you can use the script below DECLARE Rochelle success boolean; BEGIN Rochelle success: = FND_USER_PKG.ChangePassword ('Operations','Welcome12

Enable HTTPS secure link (SSL) and ebsr12 for Oracle EBS R12 E-Business Suite R12.1.1 provides Advanced Configuration wizards that make it easier to deploy features such as SSL and load-balancing. apps administrators can use these wizards to make configuration changes online through Oracle Applications Manager (OAM) and then run AutoConfig on the applications tie

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

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

Objective:Sometimes, due to certain needs, we need to know what Oracle's form is used in order to make decisions.For example, if a form is used in a very high number of times, the associated SQL code for this form should be prioritized to reduce server load and thus provide a system run speed.Or, (especially) when the system is going to be upgraded, this data is very important: decide which form should be left and which form should be taken away.Of course, this information is only the reference

Prediction and offset of Oracle ebs mrp module, ebsmrpThe Oracle ebs mrp module defines the basic concepts of prediction and subtraction based on the original prediction. It uses the planned sales order to reduce the corresponding prediction quantity to get the current prediction. Current prediction = original predicti

1. Create a cux userSQL> Conn/As sysdba;Connected.SQL> Create tablespace pai_ntk_cux datafile '/EBS/proddata/pai_st/data/cuxd01.dbf'Size 50 m autoextend on next 1 m;Tablespace created. SQL> create user cux identified by cux default tablespace 1__ntk_cuxTemporary tablespace temp; SQL> grant connect, resource to cux; Grant succeeded. SQL> grant select any table to cux; Grant succeeded. 2. Create a cux directory under $ appl_top and ensure that the

Tags: r12.2 customized module Adsplice EBSThe following steps describe EBS R12.2 How to register a customized module, refer to the Oracle SupportCreating a customapplication in Oracle e-business Suite Release 12.2 (document ID 1577707.1)1 download patch 3636980 Span lang= "ZH-CN" style= "Font-family:simsun", copy 3636980\ Izu\admin 3 .txt file to /tm

Oracle EBS R12-garbled when you view a request in Excel for a "text" output formatPrerequisites for Recurrence:The output format is "text" for concurrent programs: effective responsibility and user.How to see Excel options when viewing the output: System administrator installation browser options Add a row of "file format" to "Text" records, "MIME type" and "description" selected "File format" is the line o

Oracle EBS does not allow you to log on again for a long time. oracleebsZookeeper how to avoid logon for a long time (English environment) 1. Set the value of the configuration file ICX: Session Timeout to null 2. Set the ICX: Limit time to a slightly larger value, for example, 8 hoursProfile description:ICX: Session TimeoutThis profile option determines the length of time (in minutes) of inactivity in a us

Problem: a project is being developed today. It requires that when the slave block is saved, the field data of the master block changes and is saved to the database. Originally, it was assigned a value from the pre-insert trigger of the block. The interface data has changed but is not saved to the data table. However, the data remains unchanged during the re-query! Analysis: when the form data changes and is saved in Oracle

Label:Quickly view information such as output file or log for a request in ORACLE EBS On the project, there are often requests to report yellow and other issues reflected on the technical consultant side, but due to certain restrictions, sometimes even the system administrator responsibility can only see a request information, but cannot view its output File. The following method can be very convenient to v

Tags: EBS session logon profile limit time  How to avoid a long time without logging in again(English environment) 1, set the value of the profile icx:session timeout to null 2, the icx:limit time setting slightly larger, such as 8 hoursProfile Description:icx:session TimeoutThis profile option determines the length of time (in minutes) of inactivity in a user's session before the session is dis abled. If the user does not perform any operation in

Label:A summary of the monthly knot1, what is called the month Knot: from the literal meaning, namely for the end of the month checkout.2, the purpose of the monthly knot 1) Accounting instalment 2) Financial report 3, what is called reconciliation: will be two sets of accounts check. In Oracle, the main point is to reconcile the sub-module's account with the general ledger. 4, why to reconcile: General Ledger received financial information and sub-m

Sometimes, the EBS reports insufficient connections. Therefore, we try to improve processes and sessions. After EBS is installed, the default value of the init parameter processes is 200, and the default value of sessions is 400. here I increase the processes and sessions of DB to 500 and 1000.Processes = 500 # Max. no. of users x 2Sessions = 1000 #2 X processes After modification, restart the database and

Label: Http://www.cnblogs.com/bruce_zhao/p/3809886.html Oracle Ebs R12 SLA vs. GL Relationship Changes SLA concept: SLA (subledger Accounting) Sub-Ledger is the abbreviation for Subledger accounting, which literally means sub-Ledger ledger entries SLAGL Relationship: the R12 function module is enabled with the MOAC feature, new submodule and tax module, OPM and discrete inventory are also integrated, all s

Oracle EBS reports cannot be copied.A long time ago, my colleague mentioned that EBS reports cannot be copied ..You can set the font size in the upper-right corner ..We can solve the problem that cannot be copied. Click "tool" to copy the file.In the pop-up window, select Microsoft Excel and the browser to view the results.Microsoft ExcelYou will be prompted to d

Tags: phenomenon sharing effect filter Inference Nan complex mil top First, the phenomenonThis address: http://blog.csdn.net/sunansheng/article/details/50952758When our EBS Lov SQL is more complex to write. or more data volume, Lov pop-up display speed, or directly fill in the number and then move to the other input box (Validate from list open case) will appear busy status, users need to wait!Second, analysis1. Click the Lovbutton pop-up selection bo

easy to detect, but they are a very unfriendly mistake. Workaround:1. Concurrent Program output HTML reportThis type of report output is an HTML tag (or XML tag), this kind of report is truncated in the time of the output, the field is placed in the = "", for example, the Plsql code fragment is:fnd_file.put_line (fnd_file.output, ' into:fnd_file.put_line (fnd_file.output, ' orfnd_file.put_line (fnd_file.output, ' Explanation:The previous method, in Excel, = represents a formula, and in double