My Oracle Support Banner

ERS9.2: Error “Decimal Division By Zero Occurred. (180,109)” Appears on Job Spy Page, if Interest Level is Set To Blank in Resource’s Profile. (Doc ID 1923021.1)

Last updated on SEPTEMBER 15, 2023

Applies to:

PeopleSoft Enterprise FIN Resource Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


If Interest Level is set to blank for a competency in a Resource's Profile then in Job spy page, below error message appears.


Decimal division by zero occurred. (180,109) RS_MATCHENGINE.RsReverseSearch.OnExecute Name:processDataRequest PCPC:7704 Statement:95
Called from:RS_MATCHENGINE.RsMatchEngine.OnExecute Name:buildOtext Statement:381
Called from:RS_MATCHENGINE.RsReverseSearch.OnExecute Name:getRawResultSet Statement:10
Called from:RS_MATCHENGINE.RsMatchEngine.OnExecute Name:getResultSetChunk Statement:78
Called from:RS_MATCHENGINE.RsMatchEngine.OnExecute Name:getResultSet Statement:69
Called from:RS_SEARCH.RsRevSearch.OnExecute Name:RevSrchLoadData Stat

A division by zero occurred. Review the PeopleCode executed to determine why the error occurred. Make sure that zero values are checked for and that appropriate error handling exists.

1. Create a new employee into the system and establish him as a Resource in the system.
     Travel and Expenses > Manage Employee Information > Update Employee Detail
     Resource Management > Establish Resources > Create Resources
2. Set up competencies for this resource and make sure the Interest Level is set to blank for them.
     Resource Management > Maintain Resource Profiles > Maintain Resource Profile (Qualification tab)
3. Create a new Service Order, requesting the competencies just entered in the Resource’s Profile.
     Resource Management > Request Resources > Create or Review Service Order
4. Run the Cache Administration AE Process (RS_CACHE_AD).
     Set Up Financials/Supply Chain > Common Definitions > Resource Search > Setup RM Cache Administration
5. In Job Spy page, select "All requests" in Search Options and click the Search button
     Resource Management > My Assignments > Job Spy


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.