You can also view the Oracle application post in more ordered manner at below link
Forms Server Architecture Forms Server use a three-tier architecture, consisting of the following components:• Client – A Java Applet running on the client PC that handles the UI presentation.• Middle tier – The Web Listener and the Form run-time that handles the logic.• Database tier – Data-intensive logic and data management. The Forms run-time consists …
Forms Server Architecture in 11i Read More »
Apache is widely used Web server. Oracle HTTP server is based on Apache web server and includes modules developed specifically by Oracle. Here in this section we will have discussion about Apache (Oracle HTTP server) used in EBS 11i and R12 Important Directive in httpd.conf Listen:The Listen directive instructs Apache to listen to more than …
All about Apache(Oracle HTTP Server) in EBS 11i/R12 Read More »
Steps to upgarde 11i Application database to 11gR1 1) Oracle Application Prerequisites patches before upgrade : Interoperability notes for Oracle Applications 11i with 11gR1 – 452783.12) Install Oracle 11.1.0.x software 3) run pre upgrade tool 4) collect stats on database 5) Check for Connect Role and get user or role list which are having the …
Steps to upgarde 11i Application database to 11gR1 Read More »
The AOL/J Setup Test suite consists of Java Server Pages (JSPs) designed to trouble-shoot AOL/J setup problems. These JSPs exercise various features of AOL/J and provide feedback on the results. The test suite is accessed from the URL http://:/OA_HTML/jsp/fnd/aoljtest.jsp where host_name and port_number correspond to the host name and port number of your instance’s Apache …
“Gather Schema Statistics” program reported the following errors in request log files : Error #1: ERROR: While GATHER_TABLE_STATS: object_name=GL.JE_BE_LINE_TYPE_MAP***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt*** Error #2: ERROR: While GATHER_TABLE_STATS: object_name=GL.JE_BE_LOGS***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt*** Error #3: ERROR: While GATHER_TABLE_STATS: object_name=GL.JE_BE_VAT_REP_RULES***ORA-20001: invalid column name or duplicate columns/column …
ORA-20001 in R12 Gather schema statistics on 11g(FND_HISTOGRAM_COLS) Read More »
Followings steps are to be followed to rebuild the queue (1) Check to see what records will be backed up on the wf_queue_temp_jms_table backup table. select wfjd.corr_id corrid, msg_state state, count(*) COUNTfrom applsys.aq$wf_java_deferred wfjdwhere msg_state IN(‘READY’, ‘WAIT’)group by corr_id, wfjd.msg_state; (2) Shut down the Workflow Agent Listener Service and backup the records on the WF_JAVA_DEFERRED …
how to rebuild the wf_java_deferred queue Read More »
