Oracle Concurrent Processing Information Center (Doc ID 1304305.1

Concurrent Processing Resources Resources every user new to Concurrent Processing should know about to ensure successful production operations. Best Practices for Performance for Concurrent Managers in E-Business Suite REQCHECK.sql - Diagnostic Script for Concurrent Requests Concurrent Manager Questions and Answers Relating to Generic Platform Enhancing Oracle Applications Concurrent Processing Potential Output Post Processor Failures Due to a Multi-Node Setup Concurrent Processing Tables and Purge Concurrent Request and/or Manager Data Program (FNDCPPUR) Concurrent Report Access Level Concurrent Manager Not Running Concurrent Manager Status Column Shows 'System Hold Fix Manager before resetting counters' R12 RBAC Unable to View Output of Requests Submitted by other Users Purge Concurrent Request FNDCPPUR Does Not Delete Files From File System or Slow performance Concurrent Processing (CP) / APPS Reporting Scripts Virtual Hostnames With Concurrent Managers R12.1.2 Documentation Library Complete Library - All Products & Releases E-Business Courses From Oracle Education (Search on "Concurrent Processing")

News & Hot Topics Read all the latest Concurrent Processing Hot Topics and Solutions within the CP community Starting Workflow Service Gives ORA-24067: Exceeded Maximum Number of Subscribers for Queue APPLSYS.FND_CP_GSM_IPC_AQ New document detailing the steps to handle subscriber errors for Queue APPLSYS.FND_CP_GSM_IPC_AQ. After Doing a Clone All the Concurrent Managers Do Not Start This document discusses concurrent manager related cloning issues. All Concurrent Reports Are Failing With Error REP-0004,REP-0082 and REP-0104 Latest details on CP requests and Report (REP) related errors Reports Fail With REP-0004 REP-3000 REP-0069 REP-57054 On a Cloned R12 (12.0.4) Instance Latest details on CP requests and Report (REP) related errors Concurrent Request Fails Due to Timeout of the Post Processing Action Latest Output Post Processor issues related to timeouts and request failures FDPSTP Failed Due to ORA-20100: File o0017164.tmp Creation for FND_FILE Failed Latest on FDPSTP related CP errors and potential solutions Concurrent Request Completes with Errors ORA-00164 and APP-FND-01564 Latest on ORA-00164 related CP errors and potential solutions Apache and Mod PL/SQL Listener Cannot be Managed by GSM at the Same Time Latest GSM related CP errors and potential solutions An error Occurred While Attempting to Establish an Applications File Server Connection with Node FNDFS Error Latest on FNDFS related CP errors and potential solutions. Post ATG RUP7 XML Publisher German Reports Give FRM-41072: Cannot create Group req_layout Error New ATG RUP7 document with req_layout potential solutions.

Diagnostics and Debugging Want more info on how to debug a Concurrent Processing issue? Check out the latest notes and diagnostic scripts for capturing information to use in the process. ANALYZEREQ.SQL - Detailed Analysis of One Concurrent Request (Release 11 and up)(Note 134035.1) CCM.sql Diagnostic Script for Concurrent Manager(Note 171855.1)This script will collect relevant Concurrent Manager Diagnostic information How To Trace a Concurrent Request And Generate TKPROF File (Note453527.1) Steps for generating Concurrent Request debug logs and traces 11i : Oracle Application Object Library Concurrent Processing Data Collection Test 11i Concurrent Processing Data Collection Diagnostic Test 11i : Oracle Application Object Library Concurrent Manager Setup Test11i Concurrent Processing Setup Diagnostic Test Complete Diagnostic Catalogs for Each Release: Release 11i (note 179661.1, Release 12.0.4 (note 469721.1), Release 12.0.6+ (note 741601.1), Release 12.1 (note 783319.1), Release 12.1 (note 942527.1), Find transaction based diagnostics in these catalogs for the product/feature where the tax problem is occurring.

FAQ's & Business Requirements Implementing Concurrent Processsing requires users identify solutions related to their specific business process requirements. The features section helps you by providing a general understanding of common Concurrent Processing issues. This section looks to assist with common business requirements and how they can be satisfied. CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables (Note 134007.1) Steps To Clean Nonexistent Nodes or IP Addresses From FND_NODES (Note 260887.1) APP-FND-00222 Error When Submitting a Custom Concurrent Request Registered With a Custom Application (Note 150993.1) Concurrent Requests Fail with FDPSTP failed due to ORA-20100: File o0002712.tmp creation for FND_FILE (Note 148262.1) Default Layout Format for XML Publisher Concurrent Request Is Always PDF (Note 401328.1) ORA-00060: Deadlock Detected - UPDATE FND_CONCURRENT_QUEUES(Note 866298.1) Service Manager Processes Are Not Starting After A Restart - usdsop cannot redirect standard output (Note 733901.1) Concurrent Report Access Level (Note 736547.1) Java Concurrent Program FAQ (Note 827575.1) Concurrent Manager Not Running Concurrent Manager Status Column Shows 'System Hold Fix Manager before resetting counters'(Note 1209773.1) CONC-SM TNS FAIL In Internal Concurrent Manager (ICM) Log File With Virtual Hosts Configuration(Note 961216.1) How to Register a Host Concurrent Program in Applications (Note 156636.1) How to Cancel a Concurrent Request Stuck in the Queue? (Note 749748.1) Creating a Conflict Domain for a Concurrent Program (Note 267167.1) How to Setup Resource Profiles for Concurrent Managers to Limit CPU Usage?(Note 394562.1) Concurrent Manager Fails with ORA-00604 & ORA-00018 (Note 110202.1) APP-FND-01270 ERROR GENERATING JULIAN SYSDATE in Forms and REP-1416:'C_bal_segment_promptformula' in Reports (Note 565307.1) (More)

Concurrent Processing on RAC Information Center Want more info on how to implement Concurrent Processing in a RAC environment? Check out the latest notes and configurations for Concurrent Processing in RAC enabled environments. How to run a concurrent program against a specific RAC instance with PCP/RAC setup? (Note 1129203.1) How to Setup Parallel Concurrent Processing using Shared APPL_TOP for RAC Environment (Note 278816.1) How To Ensure Load Balancing Of Concurrent Manager Processes In PCP-RAC Configuration(Note 762024.1) How to Setup and Test Failover of PCP on Non-RAC Environments. (Note 743716.1) Parallel Concurrent Processing Failover/Failback Expectations (Note 271090.1) RAC Configuration Setup For Running MRP Planning, APS Planning, and Data Collection Processes (Note 279156.1) Concurrent Managers Will Only Start on One Node in PCP/RAC Environment (Note 264296.1) Concurrent managers not running/failing over to correct node in PCP/RAC environment (Note 790624.1) Concurrent Manager Setup and Configuration Requirements in an 11i RAC Environment (Note 241370.1)

Latest Recommended Documents from Support Analysts All the latest documents recommended by CP Support subject matter experts ANALYZEPENDING.SQL - Analyze all Pending Requests (Note 134033.1) Concurrent Manager Setup and Configuration Requirements in an 11i RAC Environment (Note 241370.1) sh: line 71: 12370 Segmentation Fault Core Dump on Linux RHAS (Note 343249.1) How to Create The Service Manager 'FNDSM' on Oracle Applications (Note 218893.1) Failover Of Concurrent Manager Processes Takes More than 30 Minutes (Note 551895.1) Why Does OPP Intermittently Completes With Warnings and Error 'java.lang.OutOfMemoryError'? (Note 978495.1) Why are Concurrent Programs Calling FND_GLOBAL.APPS_INITIALIZE Using DBLinks Failing? (Note 466800.1) How to Determine Which Manager Ran a Specific Concurrent Request?(Note 343575.1) What is FNDREVIVER and How Is It Set? (Note 466752.1) How to Create a Custom Concurrent Manager(Note 170524.1) How Do You Run A Unix Host Script From Concurrent Managers On MS Windows Platform?(Note 412392.1) Concurrent Processing (CP) / APPS Reporting Scripts (Note 213021.1) Can a Concurrent Manager Tier be Added Without Setting Up PCP? (Note 389876.1) Concurrent Managers Fail to Start After Cloning With 11i.ATG_PF.H.delta.5 or 6 / 12.0.2 (Note 434613.1) (More)

Concurrent Processing Features (Setup and Troubleshooting) Want to learn more about a particular Concurrent Processing feature or need help troubleshooting a problem? Pick the feature below and take advantage of the documents to find answers to your questions. Concurrent Processing Setup How to Set Up Parallel Concurrent Processing (PCP) in Apps 11i? (Note 388495.1)Step by step guide for 11i PCP setup How to Activate Parallel Concurrent Processing - More Facts (Note 602899.1) Generic Service Management (GSM) in Oracle Applications 11i (Note 210062.1) Virtual Hostnames With Concurrent Managers (Note 734506.1) How To Create a Java Concurrent Program? (Note 827563.1) How to Register a Host Concurrent Program in Applications (Note 156636.1) Output Post Processor (OPP) in Concurrent Processing Using the Output Post Processor (OPP) in Oracle Applications Concurrent Processing (Note 291792.1) How to start the Output Post Processor (OPP)?(Note 762454.1) Troubleshooting Concurrent Processing Troubleshooting ORA-20100 on Concurrent Processing (Note 261693.1) How to Troubleshoot Concurrent Manager Start Up Issue Related to Service Manager (Note 735148.1) Troubleshooting Concurrent Manager (Unix specific) (Note 104452.1) Troubleshooting FNDFS and FNDWRR Issues on the Oracle E-Business Suite (Note 847844.1) Internal Manager Log File is having Messages like "Could Not Initialize the Service Manager FNDSM__" for Non Concurrent Processing Nodes (Note 754698.1) Concurrent Managers Fail to Start, No Service Manager Process Spawned (Note 470100.1) How to run the Purge Concurrent Request and/or Manager Data program and which tables does it purge? (Note 1086013.1)

Concurrent Processing Integration with EBS Modules Note: Additional integrations exist for Payables, Contracts, Latin Tax Engine, Golden Tax Adaptor, India Global Taxes, Projects and more. Content will be added as it is available for these integration topics

Receivables Integration Sample Code to Call Customer Interface RACUST Program using FND_SUBMIT Api in 11i and R12 (Note 429278.1 ) How to Add Concurrent Programs Upload, Import and Validate Accounting Definition to Receivables? (Note 808675.1) How to add 'Transfer Journal Entries to General Ledger' Concurrent Program to Receivables Reports Group(Note 734495.1) How do you find/check storage of report parameters? (Note 74962.1) Subledger Accounting Balances update concurrent program wrong balances (Note 876017.1 ) Order Management Integration Order Management Diagnostic Concurrent Programs(Note 201231.1) Order Management Exception Management: Retry Activities in Error Concurrent Program(Note 376040.1) Payables Integration How to run a Payables Concurrent Program in Debug Mode (Note 198799.1) the Concurrent Programs "Payables Transfer To General Ledger" And "Payables Transfer to GL" Fail In R12 (Note 1179363.1) APXIIMPT: Payables Open Interface Import Concurrent Program Shows No List of Values for Parameter Operating Unit (Note 947303.1) R12 Payables Suppliers: Supplier Merge silently fails to submit when HR is not installed. Suppliers Not Merged (Note 1304936.1) R12: 'Online Accounting Could Not Be Created For This Transaction' On Create Accouting (Note 745232.1) R12: Problems with the creation process and accounting transfer (AP X GL) - JLARAPAC (Note 1054066.1) E-Business Suite: Oracle Payables Information Center (Note 1196096.1) Purchasing Integration Using the Concurrent Manager for Troubleshooting Purchasing Documents Stuck at Deferred Activities (Note 1249175.1) Possible Causes Resulting In The PO Approval Failing At "Wait for Concurrent Program" (Note 1288874.1)

Oracle SOA Suite 10g Release 3 (10.1.3.x) Backup and Recovery Recommendations

Oracle SOA Suite 10g Release 3 (10.1.3.x) Backup and Recovery Recommendations [ID 557994.1]
		Modified 22-FEB-2011 Type BULLETIN Status PUBLISHED

In this Document
Purpose
Scope and Application
Oracle SOA Suite 10g Release 3 (10.1.3.x) Backup and Recovery Recommendations
References

---

Applies to:

Oracle Fusion Middleware - Version: 10.1.3.1.0 to 10.1.3.5.0 - Release: AS10gR3 to AS10gR3
Information in this document applies to any platform.
Oracle Application Server 10g Enterprise Edition - Version: 10.1.3.1.0 to 10.1.3.5.0
Checked for relevance on 30-Jun-2009

Purpose

This document provides Backup and Recovery recommendations for Oracle SOA Suite 10g Release 3 (10.1.3.1+) deployments. This includes components like BPEL, ESB and OWSM. The recommendations are provided for both Middle Tier Backup/Recovery and database repository Backup/Recovery.

Scope and Application

This document is targeted at system administrators responsible for the planning and implementation of backup and recovery solutions for architectures, which include Oracle SOA Suite 10g Release 3 (10.1.3.1+)

Oracle SOA Suite 10g Release 3 (10.1.3.x) Backup and Recovery Recommendations

SOA Backup and Recovery

Oracle SOA Suite 10g Release 3 (10.1.3.1+) components like BPEL, ESB and OWSM have configuration data elements in middle-tier ORACLE_HOME. They also have associated metadata in the database-based repository. It is important to understand the consistency requirements between the middle-tier configuration data and metadata (in metadata repositories) for different components.

It is recommended to configure Database hosting the SOA component repository schemas in Archive Log mode to allow for online DB backups and database point-in-time recovery.

Middle-tier backups are recommended after any patching or upgrade. If the patching/upgrade process also involves update to metadata repositories, then a consistent middle-tier and repository database backup is recommended. This can be achieved by taking both the backups in the same time frame.

1. BPEL Backup and Recovery

BPEL has the following Data elements of interest from the Backup and Recovery perspective:

1.1. Middle-tier configuration

BPEL stores the following configuration in middle-tier file system inside ORACLE_HOME on an Application Server Instance:

• Product binaries (which typically change with patching/upgrade)

• Process definitions: For 10.1.2 releases ONLY, the process definitions in deployed BPEL suitcases is maintained on middle-tier file system as well as is copied in to DB repository (dehydration store) . Hence, when a new process is deployed, the middle-tier file system gets updated. From 10.1.3 onwards, process definitions are maintained only in DB repository (dehydration store). When a new BPEL suitcase is deployed to a BPEL Process Manager instance, the BPEL PM engine picks up the suitcase.jar and writes it to dehydration store. It subsequently removes the suitcase jar file from the middle-tier file system. Temporary scratch files are generated during suitcase deployment but these can be removed without any consequence. All successfully loaded processes are copied to database repository and removed from the middle-tier file system. During engine startup, the deployed suitcases are downloaded from database repository and unzipped on the middle tier file system. This implies that deployed processes do not need any files in the mid tier file system to be in sync with the dehydration sore (see backup and recovery recommendations bellow)

• Configuration data, pertaining to things like JGroup Configuration, Resource Adapter configuration, Datasource Configuration, Adapter configuration, global fault policies, etc.

1.2. Metadata

BPEL stores the following metadata in a DB-based Metadata Repository (aka dehydration store, ORABPEL Schema)

• Process definition. This changes when a new process (packaged as BPEL Suitcase) is deployed.

• Process dehydrated state. This is the run time data generated when a process gets dehydrated.

1.3. BPEL Backup Recommendation

• After any configuration change to middle-tier (including changes to global fault policies, callback classes for workflows and resource bundles that can potentially be outside the suitcase) or ORACLE_HOME, take a middle-tier online backup.

• After deploying a new process or redeploying a proccess, for 10.1.2 release, take middle-tier backup as well as database repository backup at the same time. For 10.1.3 deployment taking database backup after new process deployment or redeployment is sufficient. Take periodic scheduled backup for DB Repositories.

1.4. BPEL Recovery Recommendation

Always ensure that metadata repository state is at a same or later point in time than middle-tier state.

• Database Repository Recovery: Always try to recover database to the most current state, using point-in-time recovery (if DB configured in Archive Log Mode). This will typically be a time right before the DB failure occurred. This ensures that latest process definitions and in flight instances are restored back. Please note that this may result in potential re-execution of process steps, based on the state to which the processes get recovered. It is recommended to strive for idempotent BPEL processes. If the system contains processes that are not idempotent these would need to be cleaned up from the dehydration store before starting the middle tiers post recovery. This is required to prevent their re-execution. Refer to BPEL PM Documentation for information on process’ clean up post recovery.

• Middle-tier Recovery: Recover to a time at or after last configuration change was performed. Some considerations to keep in mind:

New Processes:

• For 10.1.2 systems, new deployed processes need to be in sync in the DB and file system restore. This forces the midtier restore to be performed to any point in time that is posterior to the deployment of any new process that appears in the database restore. Possible data loss derived from (as it would be the case of forcing the database restore to a previous point in time to the last midtier backup available) can be minimized by applying the backup methodology recommended above.

• For 10.1.3 systems, middle tiers can be restored to any point containing configuration changes that are not process deployment since instances obtain the process definition and artifacts entirely from the database.

Re-deployed processes:

• For 10.1.2 systems if recovered middle-tier process definition for some reason is older than that in the database repository, then the in-flight instances of the newer processes, which got dehydrated in the database repository, will not execute after recovery. They will have to be manually removed.

• For 10.1.3 systems a DB recovery will ensure consistency between the dehydrated in-flight processes and their corresponding definition since the process definition is stored in DB repository where dehydrated instances get stored as well. A

2. ESB Backup and Recovery

ESB has following data elements from Backup and Recovery perspective:

2.1. Middle-tier configuration

ESB stores following configuration in middle-tier file system inside ORACLE_HOME on an Application Server Instance.

• Product binaries (which typically change with patching/upgrade)

• ESB Configuration data for OC4Js (Datasource configuration, Adapter configuration, Resource Adapter configuration etc. Specially, OH/integration/esb/config/ and OH/j2ee\home\application-deployments\esb-rt\esb-jca-rt\oc4j-ra.xml as they contain relevant ESB information.

2.2. Metadata

Following metadata gets stored in ESB repository (ORAESB Schema):

• Cluster definitions: ESB RT reads cluster name from esb_config.ini and then uses that value to query database to get systems for that cluster.

• System definitions, Service Definitions, End Point Definitions etc. This gets created/changed whenever a new system/service/end point etc. is created or modified.

• JMS messages for Asynchronous ESB Calls. This gets created/changed with every asynchronous service invocation.

2.3. ESB Backup Recommendation

• After any configuration change to middle-tier ORACLE_HOME, take a middle-tier backup.

• After deploying a new system, creating a cluster, creating an end point etc, take a database repository backup and midtier backup, specially esb_config.ini Take periodic scheduled backup for DB Repositories.

2.4. ESB Recovery Recommendation

• DB Recovery : Always try to recover database to the most current state, using point-in-time recovery (if DB configured in Archive Log Mode). This will typically be a time right before the DB failure occurred.

• Middle-tier recovery : Recover to a time at or after last configuration change was performed.

3. OWSM Backup and Recovery

OWSM has following data elements from Backup and Recovery perspective

3.1. Middle-tier configuration

OWSM stores following configuration in middle-tier file system inside ORACLE_HOME on an Application Server Instance.

• Product binaries (which typically change with patching/upgrade)

• Configuration for Gateways, Agents etc.

• Protected applications which get deployed on OC4Js

3.2. Metadata

OWSM stores following metadata in a DB based Metadata Repository (ORAWSM Schema):

• Configuration data pertaining to deployed components like Gateways, Agents etc.

• Policies pertaining to deployed applications (Policy Manager). This data

• Runtime metric (monitor, like requests processed, how many success, how many failure etc. This data gets generated with every request)

3.3. OWSM Backup Recommendation

• After any configuration change to middle-tier ORACLE_HOME, take a middle-tier online backup. At the same time take DB Repository backup.

• Take periodic scheduled backup for DB Repositories.

3.4. OWSM Recovery Recommendation

Always ensure that metadata repository state is at a same or later point in time than middle-tier state.

• DB Recovery : Recover database to the most current state, using point-in-time recovery (if DB configured in Archive Log Mode). This will typically be a time right before the DB failure occurred.

• Middle-tier recovery : Recover to a time at or after last configuration change was performed.

Backup and Recovery Tools

Middle-tier backups can be performed using Oracle Fusion Middleware Backup and Recovery tool. Please refer to Admin Guide in product documentation for more information.
Oracle Fusion Middleware BR Tool also supports DB backups. Optionally, RMAN can be used for Database backups as well. Please refer to Oracle Database documents for further details on RMAN.
Oracle Fusion Middleware backups for both middle-tier and database can be performed in online mode. Offline Backup mode can be considered if there are any custom application requirements.

Oracle Application Server Tips and Tricks

Oracle Application Server Tips and Tricks

General

• Master Note Index for Oracle Application Server (Fusion Middleware) - Read Article
• Master Note for Oracle Application Server 10g Common Administrative Tasks - Read Article

Network Configuration

• How to Move Oracle Application Server 10g Instances to New Hostname and/or IP Address? - Read Article

SSL Configuration

• An Introduction to PKI and SSL - Read Article
• Configuring HTTP Server to use SSL in Oracle Application Server 10g (10.1.2 - 10.1.3) - Read Article
• Configuring Web Cache with SSL in Oracle Application Server 10G Release 2 (10.1.2.X.X) - Read Article
• Troubleshooting Oracle Wallet Manager Problems in Oracle Application Server - Read Article
• Troubleshooting Oracle HTTP Server with SSL and Common Errors - Read Article

Java Configuration

• How to Update the Default JDK Installed in Application Server 9.0.4 and 10.1.2 - Read Article
• How to Update the Default JDK Installed in Application Server 10.1.3 - Read Article

Oracle Application Server Best Practices Patching

• Oracle Fusion Middleware Recommended Patches- Read Article
• How to Obtain Application Server 10g Media, Patchsets, and Patches - Read Article
• Oracle Application Server 10g Examples for Critical Patch Updates - Plus FMW 11g - Read Article
• OPatch for Oracle Application Server 10g (10.1.2, 10.1.3, 10.1.4)- Read Article
• Understanding How AS 10g Patch Sets Update the AS Metadata Repository - Read Article

High Availability

• Understanding OracleAS 10g High Availability - A Roadmap - Read Article
• What is the Recommended Approach to Disaster Recovery for OracleAS 10g? - Read Article
• Examples of Building Highly Available, Highly Secure, Scalable OracleAS 10g Solutions - Read Article
• Storage Solutions for OracleAS 10g R2 and OracleAS 10g R3 - Read Article
• How to Configure A Middle Tier Only OracleAS 10.1.3 Architecture For Disaster Recovery? - Read Article
• Guidelines for Configuring OracleAS 10g Rel 2 Forms/ Reports Services For High Availability - Read Article

Diagnostics and Logging

• OracleAS Diagnostic Logging (ODL), Execution Context ID's (ECID), and Log Rotation - A Master Reference - Read Article
• Running RDA and Health Checks for Oracle Application Server 10g Environments - Read Article
• Running RDA Against Oracle Fusion Middleware 11g - Read Article

Backup and Recovery

• Oracle SOA Suite 10g Release 3 (10.1.3.1) Backup and Recovery Recommendations - Read Article

Install and Upgrade Planning

• What are the Current Supported Versions of Oracle Application Server? - A Quick Overview - Read Article
• Installation Planning for Oracle Application Server 10g - FAQ - Read Article
• Upgrade Planning for Oracle Application Server 10g - FAQ - Read Article
• Upgrading to Oracle Identity Management 10.1.4.x - Planning and Known Issues - Read Article
• Upgrade Planning for Fusion Middleware 11g - FAQ - Read Article
• How to Obtain Pre-Requisites for Oracle Application Server 10g Installation - Read Article

Performance Tuning

• How to Find the Oracle Application Server 10g Performance Guide - Read Article

Oracle Application Server Product Specific OracleAS 10g Rel 2

• Oracle Application Server 10g Release 2 (10.1.2) Support Status and Alerts - Read Article
• Steps to Maintain Oracle Application Server 10g Release 2 (10.1.2) - Read Article

OracleAS WebCache

• Web Cache Patchsets and Upgrade Path - Read Article

OracleAS HTTP Server

• Everything You Wanted to Know About the Apache-Based OHS Version - Read Article
• Steps to Maintain Oracle Database 10.2 Companion CD Home (for Oracle HTTP Server) - Read Article

Oracle Identity Management 10.1.4

• Oracle Identity Management 10g (10.1.4) Support Status and Alerts - >Read Article

Metadata Repository Creation Assistant / Repository Creation Utility

• Metadata Repository Creation Assistant (MRCA) Information - Read Article
• Oracle Database 11g Release 1 (11.1) Certification for Oracle Application Server 10g (10.1.2, 10.1.3, 10.1.4) - Read Article
• Oracle Database 11g Release 2 (11.2) Certification for Oracle Application Server 10g (10.1.2, 10.1.3, 10.1.4) - Read Article

Certification and Lifecycle

• How to Find Certification Details for Oracle Application Server 10g and Oracle Fusion Middleware 11g - Read Article

Fusion Middleware 11g

• Oracle Fusion Middleware 11g - Getting Started FAQ - Read Article
• Upgrade Planning for Fusion Middleware 11g - FAQ - Read Article
• Steps to Maintain Oracle Fusion Middleware 11g - Read Article

OracleAS 10g Rel 3

• Oracle Application Server 10g Release 3 (10.1.3) Support Status and Alerts - Read Article

Oracle Application Server White Papers Product Features

• Oracle Application Server 10g Release 3 (10.1.3) - New Features - Read Document

Security

• Oracle Application Server 10gR2 Security White Paper - Read Document
• Oracle Application Server 10gR3 Security White Paper- Read Document

High Availability

• Oracle Application Server 10g R2 High Availability White Paper - Read Document
• Oracle Application Server 10g R3 High Availability White Paper - Read Document
• Oracle Fusion Middleware Disaster Protection Frequently Asked Questions - Read Document
• Oracle Fusion Middleware Disaster Protection Statement of Direction - Read Document
• Oracle Fusion Middleware Disaster Protection Frequently Asked Questions. The table in the document summarizes current certification of Oracle Fusion Middleware components with Oracle Application Server Guard.

Scripts to Check the Setup of the General Ledger Calendar [ID 76503.1]

Scripts to Check the Setup of the General Ledger Calendar [ID 76503.1]
		Modified 18-MAR-2011 Type TROUBLESHOOTING Status PUBLISHED

Applies to:

Oracle General Ledger - Version: 10.7.16.1 to 12.1 - Release: 10.7 to 12.1
Information in this document applies to any platform.
Checked for relevance on 15-Jul-2010
Executable:GLOOAP - Open Period
Form:GLXSTCAL.FMB - Calendar

Purpose

When investigating problems in this area the solution is often in the relevant White Paper which also provides a useful insight into the Topic. Please refer to the White Paper General Ledger Calendar Setup and Usage at Note:130539.1 .

There is also a GL Calendar Diagnostic now available, per Note 1225833.1.

Last Review Date

July 15, 2010

Instructions for the Reader

A Troubleshooting Guide is provided to assist in debugging a specific issue. When possible, diagnostic tools are included in the document to assist in troubleshooting.

Troubleshooting Details

Follow these steps to check the Calendar definitions and period statuses for Oracle Financial Applications that use the Calender defined by General Ledger.
This script will return the Calendar definitions, and the statuses of the periods for the different Oracle Financial Applications installed, for a specific Set of Books/Ledger.

1. Log into SQL*Plus as apps user:-
sql> /

2. At the SQL prompt type:

SQL> spool

Assuming you would like to save the output to the directory C:\TEMP and name the output file as
"calendar", type :

SQL> spool C:\TEMP\calendar.txt

3. Run the following queries to check the calendar:
(You can copy and paste the following query to Notepad, save it, then log into SQL*Plus from your
desktop by going to Start/Programs/Oracle for Windows/SQL Plus and log into your database and type
the following:

@\

Scripts to Check the Setup of the General Ledger Calendar [ID 76503.1]

Scripts to Check the Setup of the General Ledger Calendar [ID 76503.1]
		Modified 18-MAR-2011 Type TROUBLESHOOTING Status PUBLISHED

Applies to:

Oracle General Ledger - Version: 10.7.16.1 to 12.1 - Release: 10.7 to 12.1
Information in this document applies to any platform.
Checked for relevance on 15-Jul-2010
Executable:GLOOAP - Open Period
Form:GLXSTCAL.FMB - Calendar

Purpose

When investigating problems in this area the solution is often in the relevant White Paper which also provides a useful insight into the Topic. Please refer to the White Paper General Ledger Calendar Setup and Usage at Note:130539.1 .

There is also a GL Calendar Diagnostic now available, per Note 1225833.1.

Last Review Date

July 15, 2010

Instructions for the Reader

A Troubleshooting Guide is provided to assist in debugging a specific issue. When possible, diagnostic tools are included in the document to assist in troubleshooting.

Troubleshooting Details

Follow these steps to check the Calendar definitions and period statuses for Oracle Financial Applications that use the Calender defined by General Ledger.
This script will return the Calendar definitions, and the statuses of the periods for the different Oracle Financial Applications installed, for a specific Set of Books/Ledger.

1. Log into SQL*Plus as apps user:-
sql> /

2. At the SQL prompt type:

SQL> spool

Assuming you would like to save the output to the directory C:\TEMP and name the output file as
"calendar", type :

SQL> spool C:\TEMP\calendar.txt

3. Run the following queries to check the calendar:
(You can copy and paste the following query to Notepad, save it, then log into SQL*Plus from your
desktop by going to Start/Programs/Oracle for Windows/SQL Plus and log into your database and type
the following:

@\

Scripts to Check the Setup of the General Ledger Calendar [ID 76503.1]

Scripts to Check the Setup of the General Ledger Calendar [ID 76503.1]
		Modified 18-MAR-2011 Type TROUBLESHOOTING Status PUBLISHED

Applies to:

Oracle General Ledger - Version: 10.7.16.1 to 12.1 - Release: 10.7 to 12.1
Information in this document applies to any platform.
Checked for relevance on 15-Jul-2010
Executable:GLOOAP - Open Period
Form:GLXSTCAL.FMB - Calendar

Purpose

When investigating problems in this area the solution is often in the relevant White Paper which also provides a useful insight into the Topic. Please refer to the White Paper General Ledger Calendar Setup and Usage at Note:130539.1 .

There is also a GL Calendar Diagnostic now available, per Note 1225833.1.

Last Review Date

July 15, 2010

Instructions for the Reader

A Troubleshooting Guide is provided to assist in debugging a specific issue. When possible, diagnostic tools are included in the document to assist in troubleshooting.

Troubleshooting Details

Follow these steps to check the Calendar definitions and period statuses for Oracle Financial Applications that use the Calender defined by General Ledger.
This script will return the Calendar definitions, and the statuses of the periods for the different Oracle Financial Applications installed, for a specific Set of Books/Ledger.

1. Log into SQL*Plus as apps user:-
sql> /

2. At the SQL prompt type:

SQL> spool

Assuming you would like to save the output to the directory C:\TEMP and name the output file as
"calendar", type :

SQL> spool C:\TEMP\calendar.txt

3. Run the following queries to check the calendar:
(You can copy and paste the following query to Notepad, save it, then log into SQL*Plus from your
desktop by going to Start/Programs/Oracle for Windows/SQL Plus and log into your database and type
the following:

@\