Skip to Main Content
Forums

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Position data Update changes the Standard hours of incumbents

User_S8BJTSep 10 2018

Hello,

We are in 9.2.25 with tools version of 8.56.07

Right now when we are adding a new row in Postion Data and change the Jobcode with reason as UPD, the STD_HOURS of the incumbents attached is getting updated to whatever std_hours is there in JOb code.The client requirement is that Job data should get updated with Salary Plan and Grade however, should not update their std_hours.To meet the first part we are checking the flag, Include Salary Plan/Grade and Update incumbents.

However it seems for the std_hours we might need to do some customizations. I have found one function copy_job in FUNCLIB_HR.UPdate_incumbents.field formula where this code needs to be modified. BUt that alone is not helping us. Has anyone else had this requirement, can you please let me know - Is there any other place where we might need to make modifications?

Any help here is appreciated.

Thanks, Pooja.

Comments

User_LM318

Found the cause... In my WEB API I was returning a string but APEX seems to be expecting an HTTP response.
So changed:
public string Put(Department dep)
{
try
{
string query = @"
update dbo.Department set DepartmentName=
'" + dep.DepartmentName + @"'
where DepartmentId="+dep.DepartmentId+@"
";
DataTable table = new DataTable();
using (var con = new SqlConnection(ConfigurationManager.
ConnectionStrings["EmployeeAppDB"].ConnectionString))
using (var cmd = new SqlCommand(query, con))
using (var da = new SqlDataAdapter(cmd))
{
cmd.CommandType = CommandType.Text;
da.Fill(table);
}

           **return "Successfuly updated row!";**  
       }  
       catch (Exception)  
       {  
           **return "Could not update row!";**  
       }  
   }

to

public HttpResponseMessage Put(Department dep)
{
try
{
string query = @"
update dbo.Department set DepartmentName=
'" + dep.DepartmentName + @"'
where DepartmentId="+dep.DepartmentId+@"
";
DataTable table = new DataTable();
using (var con = new SqlConnection(ConfigurationManager.
ConnectionStrings["EmployeeAppDB"].ConnectionString))
using (var cmd = new SqlCommand(query, con))
using (var da = new SqlDataAdapter(cmd))
{
cmd.CommandType = CommandType.Text;
da.Fill(table);
}

           **return Request.CreateResponse(HttpStatusCode.OK, table);**  
       }  
       catch (Exception)  
       {  
           **return Request.CreateResponse(HttpStatusCode.NotFound, "Could not update row!");**  
       }  
   }

Hope it helps someone!

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 8 2018
Added on Sep 10 2018
0 comments
79 views