oracle ebs tutorial

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

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

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

Tags: interface Web EBS OracleWhen Oracle EBS enters responsibility from the Web interface, it prompts that there is no valid liability available each time the Web interface, click on the function of a responsibility, pop-up form, will prompt the error: Sorry, there is no valid liability available.The problem was later found because the responsibility keyword are

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

The order in which oracle ebs disables and starts the database and application services to stop the Oracle Applications service is as follows: Stop the application services and then stop the database services. The order in which www.2cto.com starts the Oracle Applications service is as follows: start database-related s

Oracle EBS prompts XX to be unavailable to the current user -- XXisnotavalidresponsibilityforthecurrentuserOracle EBS prompts XX to be unavailable to the current user -- XX is not a valid responsibility for the current user has recently added a new role in EBS for switching, however, it is difficult to enter the Form o

%----------------------------------------------A. TP:INV Transaction processing Mode=on-lineB. Inv:debug Trace=yesC. inv:debug level=11D. inv:debug file (including the complete path) =A. Om:debug level = 5B. Om:debug Log directory = You can then use the following SQL to view the debug information:Select To_char (timestamp, ' dd-mon-yy HH24:MI:SS '),Message_text,ModuleLog_sequenceFrom Fnd_log_messagesWHERE trunc (timestamp) = Trunc (sysdate)and process_id = (SELECT os_process_idFrom Fnd_concurren

system/pass1234 ORACLE GLpass1234 The method of modifying all module users at once is as follows:fndcpass apps/pass1234 0 Y system/pass1234 alloraclepass1234 3.3 This class is an EBS-managed non-basic module userA separate password modification is required. Sql> Select Oracle_username from Applsys. Fnd_oracle_userid where Read_only_flag = ' X ' and Oracle_username in (select USERNAME from SYS. Dba_users);

Label:http://blog.csdn.net/pan_tian/article/details/8169339With a little tip, Oracle EBS can bypass the job and function selection process after landing, and you can open a specific form directly so that the entire landing process is faster.Method: Oracle Application Home page > Preferences > Start Page, enter the starting ' Responsibility ' and ' Page ', after a