ebs backup

--- EBS query online users Select u. USER_NAME,APP. APPLICATION_SHORT_NAME,FAT. APPLICATION_NAME,FR. RESPONSIBILITY_KEY,FRT. RESPONSIBILITY_NAME,FFF. FUNCTION_NAME,FFT. USER_FUNCTION_NAME,ICX. FUNCTION_TYPE,ICX. FIRST_CONNECT,ICX. LAST_CONNECTFROM ICX_SESSIONS ICX,FND_USER U,FND_APPLICATION APP,FND_APPLICATION_TL FAT,FND_RESPONSIBILITY FR,FND_RESPONSIBILITY_TL FRT,FND_FORM_FUNCTIONS FFF,FND_FORM_FUNCTIONS_TL FFTWHERE 1 = 1And u. USER_ID = ICX. USER_ID

IMPORT EXTERNAL BANK ACCOUNTS R12 ORACLE APPS Item Categories deletion through API in Oracle Apps (inv_item_category_pub. Delete_category) Item Categories updation through API in Oracle Apps (inv_item_category_pub. Update_category) Item categories creation through API in Oracle Apps (inv_item_category_pub. Create_category) Item categories in Oracle Apps R12 Item import based on Item template in R12 (Insert script) Oe_holds_pub. Apply_holds--Apply hold Script Oe_holds_pub. Releas

, p_old_category_id = l_old_category_id, p_category_id = l_record.po_category_id, p_category_set_id = l_category_set_id, p _inventory_item_id = x_item_rec.inventory_item_id, p _organization_id = x_item_rec.organization_id);DELETE Item INV CATEGORYInv_item_category_pub.delete_category_assignment (p_api_version = ' 1.0 ',

View descriptive elastic field titles from form form forms Sometimes we need to look at the descriptive elastic field definition on the form and need to know the title first There are usually two ways of doing this: Directly open the explanatory elastic domain, the window name is the title name, individuals generally directly based on the search here. By "help" → "check", find the $DESCRIPTIVE_FLEXFIELD$ block, find the corresponding elastic field field, you can get t

DeclareL_hold_count number;L_funds_code Varchar2 (30);L_approve_status Varchar2 (120);BeginAp_approval_pkg.approve (p_run_option = Null,p_invoice_batch_id = Null,P_begin_invoice_date = Null,P_end_invoice_date = Null,p_vendor_id = Null,P_pay_group = Null,p_invoice_id = 99014,p_entered_by = Null,p_set_of_books_id = Null,P_trace_option = Null,P_conc_flag = ' N ',P_holds_count = L_hold_count,P_approval_status = L_approve_status,P_calling_mode = Null,p_calling_sequence = ' cux_3_ar_inter_pkg ',P_fund

ORDER BY 1 desc) where rownum = 1unionselect ' Product installation List: ' From dualunions Elect ' Product InstallatioN: ' | | patch_level| | ': ' | | Decode (status, ' I ', ' Installed ', ' S ', ' Shared ', ' not installed ') from Fnd_product_installationswhere application_id in ( 401, 385, 201, 431, 702, 703) Order by 1Results Demo Sample:Application environment:ml3ys211, Host:rws60075rems, Application release:12.1.1, DB version:11.1.0.7.0current Applica tion release:12.1.1 (7303030) Current

fordependencies:libxi i6861.7.2-2.1. el7Base thektransaction Summary===========================================================================================================Install1Package (+1Dependent Package) Total Download size: -kinstalled Size: thekdownloading Packages:----------------------------------------------------------------------------------------------------------- Total1.7MB/s | -Kbxx:xx:xxRunning Transaction checkrunning transaction testtransaction test suc

/oracle/apps/pos/supplier/webui/byraddcntctpgOracle.apps.pos.supplier.webui.ByrAddCntctCOOracle.apps.pos.supplier.server.ByrSuppAM // pseudo-code co if ("Byraddcont" .equals (Comingfrom)) {... long1 = (Long) oaapplicationmodule2.invokemethod ("Addcontact" , aserializable4, ACLASS4);} // am public Long Addcontact (long long1, long long2, String s) throws Exception {... l = Posbyrcontacthelper.createcontact (Oadbtransaction, Long1.longvalue (), Poscontinfoamimpl);..... long L2 =

1. When establishing a reference column for a descriptive elastic field, if you do not want to refer to the field in this table, but want to refer to a variable in the system, you can write$PROFILES $. user_id2. In a multi-layered elastic domain, if the next layer of elastic domain wants to reference the value of the previous elastic field, it can be written in the where statement setting of the set of values referenced by the next layer of elastic fields:$FLEX $. Province, where province is the

TRIGGER judgment variable to do refresh action on form CUXOMWBNavigate from one window to another (all two windows are open), use When–form–navigate to pass parameters, remember not to encode the trigger directly, but to use global variables to pass parameters. To do this, use global variables globally in a custom trigger. When_form_navigate to pass parameters. The When–form–navigate trigger is also triggered when navigating to another window using the Go_form built-in procedure.Example: Queryi

Logging issue: http://blog.csdn.net/cymm_liu/article/details/29234919-time zone in Oracle databasehttp://www.itpub.net/thread-835665-1-1.html-time Zone: TimeZone problem solution?http://blog.csdn.net/pan_tian/article/details/7689535--Settings for Ebs:timezone conversionsDescription: Server in East Eight, client in East DistrictBecause there are other time zone users, there is no change to the configuration file, the program uses current_date instead of SysdateDECLARE l_time_zone number; BEGIN S

fadtxd-language 00-xdo_file_type Xml-data-template-file_name$FA _top/patch/115/publisher/defs/fadtxd.xmlExecute command:Adjava-ms128m-mx256m-nojit Oracle.apps.xdo.oa.util.XDOLoader UPLOAD-db_username (Description= (address_list= (Load_balance=yes) (Failover=yes) (Address= (PROTOCOL=TCP) (host=-lob_type template_source-apps_short_name ofa-lob_code fadtxd-language en-territory Us-xdo_file_type rtf-translate Y-file_name$FA _top/patch/115/publisher/templates/us/fadtxd.rtfNote: Modify the following

--Find Run request time, parameters, etc. (can be a user's, a report)Select C.user_name,Papf.full_name,B.user_concurrent_program_name,A.request_date,A.argument_text,(a.actual_completion_date-a.actual_start_date) * minutes,A.actual_start_date,A.actual_completion_date,A.REQUEST_ID,A.outfile_nameFrom Fnd_concurrent_requests A,FND_CONCURRENT_PROGRAMS_VL B,Fnd_user C,Per_all_people_f PAPFwhere a.concurrent_program_id = b.concurrent_program_idand a.requested_by = c.user_idand C.user_name = Papf.employ

In the EBS development process, you sometimes need to call host files through concurrent requests, such as FTP file transmission and transmission. The process of defining Host-Based Concurrent requests is as follows: 1. Define the execution method as: Concurrent executable of the host 2. Define concurrencyProgram(Parameters can be defined) 3. Compile a shell script file, for example, ftp_test.prog. Note: If the suffix is prog, whether it must be

Oracle EBS payment settings are flexible, and some settings are not clear yet. The specific parts are as follows: Cutoff day: from the end of the day, that is, beyond this day, will be in the next payment cycle Due DAYE: the number of days to be pushed in the future. It is generally used to pay for the goods on a daily basis. Due date: Specifies to postpone the payment to that day, basically no need Due day of month: With months ahead, after the m

1. Ssh Application Server applprod User Password :*** Manage scripts in$ Admin_scripts_home Adstrtal. Sh starts all services and commandsAdstrtal. Sh apps/cmd_password Status 0 indicates normal in the log 2. Check whether the process exists: PS-Ef | grep VNC 3. Check whether the graphic interface is normal in vncviewer: ========================================================== ====================================== [Email protected] $ PS-Ef | grep VNC Applprod 6946962 2621648 0 08:42:52

Fresp, Fnd_user FU, (SELECT FL. User_id,flr. Responsibility_id,max (FLR. start_time) Max_start_time from fnd_login_responsibilities flr,fnd_logins FL WHERE FLR. login_id=FL. login_id GROUP by FL. User_id,flr. responsibility_id) Resp_login WHERE1=1and FU. USER_ID=Fresp. USER_ID and Resp_login. USER_ID (+) =Fresp. USER_ID and Resp_login. RESPONSIBILITY_ID (+) =Fresp. Responsibility_id and ((Sysdate-Resp_login. Max_start_time) >= -OR Resp_login. Max_start_time is NULL) and sysdate between FU. Star

I can only solve the situation I have encountered, there may be other problems have not met.Problem Symptom:Login ebs, normal, click the form you need to pop form, errorThe prompts are as follows:Internet Explorer has modified this page to help prevent Cross-site scriptingSolution:Click IE9 's "Tools"-"Internet Options", go to the Security tab, open "Custom Level" under "Internet", and find "Enable XSS Filters" In the Security Settings dialog box, ins

In the EBS system that you maintain, you suddenly find that you cannot view the logs and outputs (log and output) of the request (concurrent requests), and it will report the error ' an ' occurred while attempting to establish a n Applications File Server connection with the node fndfs_appltop_ xxxx ", the workaround is as follows 1. Backing up files $INST _top/ora/10.1.2/network/admin/tnsnames.ora 2. Add the following alias to the above file #tavor a

Tags: des ar using SP bs TT type file harQuery table Space usage:Select UPPER (f.tablespace_name) "Table space name",D.TOT_GROOTTE_MB "Table space size (M)",D.tot_grootte_mb-f.total_bytes "used Space (M)",To_char (ROUND ((d.tot_grootte_mb-f.total_bytes)/d.tot_grootte_mb * 100,2), ' 990.99 ') | | '% ' "use ratio",F.total_bytes "free Space (M)",F.max_bytes "Max Block (M)"From (SELECT Tablespace_name,ROUND (SUM (BYTES)/(1024x768 * 1024x768), 2) Total_bytes,ROUND (MAX (BYTES)/(1024x768), 2) max_byte