Hmm, thinking about it, it's more likely to be the ID flex segments that are giving this issue. What value sets if any are on the actual grade segments?

Hi CT

Thanks a million!!!!!

It was due to the fact that i had the character - in my grade band column, and basically when loaded into oracle via sql*loader it showed up as a dark square, which is odd, because i was storing - in a varchar2 column which should accept most characters.

So band value set in segment1 column of grade flexfield disagreed for that reason.

Now carrying on working through the br100, i have agreed with the client i will manually setup:

Grade Rates, Pay Scale, Point Scale and Grade Scale

Instead of using API's, as theres not allot of data there apart from grade rates!

Glad they agreed, but what follows the above is positions which are created against jobs, and theres way too many to do manually, so i will have to write api code for them.

Hopefully i can start my Positions code later on today or tommorow once the bove grade related info has been created, i will leave the value sets out for the grade desc flexfield where it causes problems with the data file.

I wanted to attach my code for your reference however theres no place here so i stuck it in pastebin which lasts a month i think:
http://pastebin.com/maad5d71

Thanks again!

Kind Regards

Tovia Singer

Tovia

It's a bit quirky, but I understand that if you edit your post, it should give you the option of attaching files. However, tread carefully as you may be infringing the client's copyright. Unless any specific provisions have been made, you can usually take it that whatever code you write on behalf of a client, the IPR is automatically vested in the client. Someone please correct me if I am wrong here.

One caveat with the grade DFF value sets being removed(?) from the grade structure definition: doing that will of course allow you to load any old data into those DFF segments - however, if you are intending to reintroduce those value sets after the loading, you may well run into difficulties either at the point of changing the DFF segment to point to a value set, or at the point when you try and change something about the grade. Problem is, it will always try and validate the entire record prior to actually changing whatever data item being changed, at which point you may well see failures occurring on fields that haven't been changed.

As far as position loading is concerned, there's no real issue with it apart from you need to get hold of the appropriate job id and organisation id as a minimum in order that those values may be passed to the API.

Hi CT

I cant work out why i cant save grade rate:
http://www.hrmsaces.co.uk/ubbthreads7/ubbthreads.php?ubb=showflat&Number=3424#Post3424

Have looked in lookutypes and checked all grades exist under:
workstructures > grades > description

thanks in advance


Tovia Singer

Sorry, I haven't been able to reproduce this problem in my R12 instance.

Hi CT

I just remmember looking back through my documentation, i didnt well i couldnt find the conc process on 11i (11i version 11.5.10):

Run Concurrent Request: Security List Maintenance (Obsolete)

Now what i understand is from reading that i have to run this process after all teh flexfields have been created and before ntering data for jobs,positions,grades, to make them available etc.

Has the concurent process name chnaged? do you know anything about security list mainatence?

thanks in advance

Tovia Singer

There's a new one without the word obsolete in it!

Hi CT

I need to run the security list maintenance proces, however concurrent manager is down on development, and i dont have access to dba for this instance untill call request goes through (edenbrook), we run on win 2k, client is updating in october to unix hpux, however the concurrent manager is up as a process, but when i run any request i get:

Phase - inactive
status - No Manager

Alternative is to migrate all my setup that i have done so far onto another isntance (will take me a while, i have allot of repsonsibilities, and setup data.

I cleared out:
fnd_concurrent_processes as per article:
http://www.tek-tips.com/viewthread.cfm?qid=62090&page=15

In sql*Plus:
user: APPLSYS
delete from fnd_concurrent_processes;
pdate fnd_concurrent_queues set running_processes=0;

Is there a diagnostic script i can run to find out why it didnt start?

I mean the service is started but as soon as i run a request i get the above messages highlighted in yellow.

I logged in as sysadmin:
concurrent > Manager > Administer >
Internal Manager - Actual = 1, Target =1, Pending = 0
Conflict Resolution Manager - Actual = 0, Target =1, Pending = 19
Scheduler/Prereleaser Manager - Actual = 0, Target =1, Pending = null (no value)
Session History Cleanup - Actual = 0, Target =1, Pending = 0
Standard Manager - ctual = 0, Target = 3, Pending = 99

And so on.. Many are inactive but i think the above are the only ones i need, is there a workflow process i need to run?

I mean theres no activate button fo rthe above managers i have listed.

Thanks in advance

Tovia Singer



Theres quiet a few

Hi Geoff

Regards my problem with creating grade rates:
Basically its really bizarre another finding:

I can assign the grades i created to jobs via the jobs description form, grades tab,

But when i navigate to grade rates, and try to create a grade rate before proceeding to the detail section i get: ORA-01403: no data found ORA-0

Does thi mean i still need to run the security list mainatenance process, eventhough it seems grades are availble to assign top jobs, ?

Just for your info, it seems create grade rates form is a payroll form i found out:

help > about oracle applications:

Login
----------------------------------------
Site : UNKNOWN
Application : Human Resources
Responsibility : XXX UK HRMS Manager
Security Group : Standard
User Name : SINGER

----------------------------------------
Database Server
----------------------------------------
RDBMS : 9.2.0.5.0
Oracle Applications : 11.5.10
Machine : MPC
User : APPS
Oracle SID : DEV

----------------------------------------
Current Form
----------------------------------------
Form Application : Payroll
Form Name : PAYWSGEV



Thanks in advance

Tovia Singer

I don't see the relevance of the Sec List Maint process to be honest.

Go to the Grade Rates Form - to be certain, have you created a Grade Rate with the Unit 'Money'?