Recent Posts by Hitesh Mishra

ISSUE: During planned maintenance period (e.g. patching/upgrade), the ESS Processor are placed on hold and released after completion. The scheduled ESS Jobs, during this period of time accumulated and are picked up by ESS Processor for execution once the System is back online. There is parameter called “EXECUTE_PAST” which can be used (from UI, by Customers) to control such backlogs.   EXECUTE_PAST Specifies whether instances of a repeating request with an execution time in the...

------------------------------------------- DB_GATEWAY_THREAD_RANGE ------------------------------------------- Specifies the minimum and maximum number of threads in the Oracle Business Intelligence Database Gateway thread pool, according to SERVER_THREAD_RANGE. When multi threaded connections is selected, Oracle BI Server terminates idle physical queries (threads). When not selected, one thread is tied to one database connection (number of threads = maximum connections). Note:-...

Oracle Fusion Transactional Business Intelligence (OTBI) is a real time (ad-hoc query), self service reporting solution for Oracle Fusion application customers to create ad hoc reports and analyze them for daily decision-making (real time analysis). OTBI Analyze very recent data such as Today’s date or this week’s data on Transactional Database.  Due to nature of requirement (transactional data – data changing constantly), the caching is not enabled. Caching is turned off by...

When attempting to login to the AtkHomePage application the worklist does not show any notifications. When the issue occurs the following error displays. Error: Error show tasklist. Possible reasons could be : SOA server connection information is not available. 2. If it is run in federated mode, the default server may be down. Configurable Timeout Solution Steps:  1. On the "Worklist: applications and approvals" frame, click on the "View" combo-box and choose the only available...

Request Processor A job request processor is bound to a particular Oracle Enterprise Scheduler server, and is responsible for allocating threads for job requests. Request Dispatcher A job request dispatcher polls for job requests STEPS: To Disable “Request Processor” 1) Login to Web Logic EM URL 2) Expand “Scheduling Services -- > ESSAPP (ESSCluster) -- > Right Click On (ESSAPP(ess_server1)) -- > Request Processor -- > Configure” 3) As show in the screen shot,  UNCHECK the checkbox...

ISSUE: Data Security Policies are not being created for the generated data roles.  Database Resources (FND_OBJECTS) records are not found. They are needed for creating the data security policies. RESOLUTION: The JVM parameter "-Doracle.jdbc.createDescriptorUseCurrentSchemaForSchemaName=true" is missing This issue only happens if the server is started using the "startWebLogic.sh" script, since a properties file does not get picked up when using this method.The Data Sources were...

Email notification are not being sent/received to approvers. Invoices are appearing in the approvers BPM worklist Notification Mode was set to 'None'. This needs to be set to All. With the Notification Mode set to 'None', no email notifications will be sent From Enterprise Manager: Farm_FinancialDomain SOA, Expand Right click on the soa server SOA Administration Right click Workflow Properties Check the value of 'Notification Mode' If not set to 'All', click on the link: More...

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.9.2.0 to 11.1.9.2.0 [Release 1.0] Fusion Applications Release 11.1.9.0.0 delivers a new security feature called Security Console. This feature is now available for all the Fusion Cloud customers who are on Release 11.1.9.x.0. However, several issues have been reported that indicate that the feature is not working as per expectation. Some of the common symptoms have been listed as under:1) The ESS Job named...

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.9.2.0 and later Fusion Applications Release 11.1.9.0.0 delivers a new security feature called Security Console. 1. When searching for a role using the new Security Console icon from the SUI homepage no data is returned. There are no standard roles or custom roles appearing in the search results. 2. The Compare Roles page does not allow roles to be selected for comparison eitherSolution:After the upgrade The...