ebs backup

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 sub-module accounting entries can be configure

(1) To obtain a set of standard currency--Get current account set standard currencySELECT Gsob.currency_codeFrom Gl_sets_of_books GSob,Hr_operating_units HouWHERE gsob.set_of_books_id = hou.set_of_books_idand hou.organization_id = Fnd_profile.value (' org_id ');(2) conversion between currency types--The exchange rate for the day that the specified currency (for example, HKD) is diverted to the current set of currency (for example: CNY)SELECT gdr.conversion_rateFrom Gl_daily_rates_v GDRWHERE gdr.

EBS Patch error via Adpatch/usr/lib/gcc/x86_64-redhat-linux/4.4.7/32/libgcc_s.so:undefined reference to ' [email protected]_2.4 'Collect2:ld returned 1 exit statusMake: * * * [/soft/ebs12/erpdb/apps/apps_st/appl/ad/12.0.0/bin/adwrknew] Error 1Done with link of ad executable ' adwrknew ' on Tue Nov 22:41:15 CST 2014Relink of module "Adwrknew" failed.See error messages above (also recorded on log file) for possibleReasons for the failure. Also, please c

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 download a text file. Open.BrowserOpen the bro

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 prediction-customer order. The first type of prediction method is automatic offset when the order

EBS modifies the password of Database User apps, sysadmin for Web login, and ebssysadmin 1) change the password of the apps user logging on to the database. The app must be stopped without stopping the database. FNDCPASS apps/apps 0 Y system/system system applsys versions 2 View output logs after execution 2) modify the logon user password on the EBS system page $ Sqlplus apps/ipv2declare l_success boo

Professional database and oacle EBS monitoring tools Http://www.bgs-soft.cn/index.html Databases and applicationsProgramOptimization can greatly improve the system performance.In some cases, performance optimization can improve the performance by 80% or higher.In the field of database and Oracle 11i program optimization, We have rich experience and applied it to our B .g. s product. B .g. S is also released to centrally monitor a large number of

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 EBS, the entire form is ex

Download Trace Analyzer and open traceanalyzer. BAT in Bin. The trace file of EBS can be analyzed in a graphical interface, without tkprof You need to configure javahome to confirm that the Java version is 1.6 or later. Java-version Effect Http://blog.csdn.net/xiaofan23z/article/details/7978998 1 swingbench1.1 OverviewThis isOracleAn employee of UK developed on the basis of a abandoned project. The current stable version is 2.2, the latest versio

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

: Pending/immediate TRX stuck in rcv_transaction_interfaceBugs: 4649123-pending/immediate TRX stuck in rcv_transaction_interface The following are some of my actual business phenomena:1) input two rows of data on the output interface of po_requisition_lines, with the same material2) input two rows of data on the output interface of po_requisition_lines. The materials are different. After approval, perform the following operations in EBS:1) import an i

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 view the output of the request and log informa

Implementation of add-on functions in EBS form development (5) (Copyright notice, I original or translated articles for reprint, such as reprinted for Personal learning, please specify the source; otherwise please contact me, the offender must investigate) Continue using the last created form and add an attachment feature to it. In the EBS form development implementation of the attachment function is very s

Purge function background data analysis for cycle count (periodic counting) in EBS EBS, we can purge ABC assignment group,abc compiles and cycle count at the corresponding interface And according to the interface hint, if want to purge ABC compiles, must first purge ABC assignment Group; If you want to purge ABC assignment Group, you must first purge cycle count; When purge collects the corresponding SQL

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 /tmp such as: Izuprod.txt renamed to Cux Hdprod.txtIzuterr.txt renamed to Cuxhdterr.txt2 ,

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 O

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

http://www.cnblogs.com/lzsu1989/archive/2012/10/17/2728528.htmlOracle EBS provides various forms of development and output of reports, and because of the obvious advantages of MS excel in processing data, report output is a common development item to open in Excel. but because Excel is "too smart to be smart", it sometimes causes output fields to be processed automatically by Excel, resulting in data errors. For example: The System internal field, th

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

1. Back up database Concept: it refers to backing up all data files and control files of the database, and also backing up parameter files and password files. Note: When backing up a database, do not back up redo logs. 1.1 Consistent backup Concept: Database Consistency backup refers to the method for backing up all data files and control files after the database is disabled. When the SHUTDOWN command is u