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
--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
is another way of saying: You can wait until Month-end and the "Order flow–generic" workflow will close it for you. ordershipping transactions Status Summary
Step
Order Header Status
Order Line Status
Order Flow Workflow Status (order Header) Line
Flow Workflow Status (Order line)
Shipping Transaction Status (released_status in WDD)
1. Enter an Order
Entered
Entered
Book Order Manual
Enter–line
N/A
Attachment Download FunctionUsing the Fnd_lobs table in conjunction with the FND_GFM package to download files, you can download files that already exist in the Fnd_lobs table, or you can manually write some content into the Fnd_lobs table, and then display in the browser:--1. Download files that already exist in the Fnd_lobs table:DECLAREv_file_id Number;URLVARCHAR2( -);BEGIN--get The file_id of the file which you want to download in Fnd_lobsv_file_id: = xxxxxx;--get the Download URLURL: = F
If you don't see the diagram, you can visit this page. Http://note.youdao.com/share/?id=82c1b694241ecc15eee9348e767756c7type=notefor occasional Tomcat pages when accessing an Oracle EBS system, Oracle technical support suspects that the OS was installed with some Tomcat service packages. Because Tomcat uses 8080 ports, we also use 8080 ports. So it is possible to redirect Tomcat while accessing the page. Oracle has confirmed that this page has nothing
Tags: des java using data for IOTerminology in Oracle EBS Web ADI(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 me, violators will investigate)asynchronous invocationAsynchronous calls are like this, and unlike processes in an Oracle application that introduce data from an interface table, uploading data to an interface table is a
be matched is taken from the issue of the blanket agreement, and the price is based on the date of issuance to match the price of the vendor's blanket agreement segment date (two development).According to the above, it is not difficult to see that the standard consignment function of R12 system can not be popularized in domestic manufacturing industry. In order to apply this consignment function, we optimized the business process, and carried out a number of two development, only to be able to
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.