No labor Rate found for this employee - SCM - Asset Lifecycle Management (ALM)(Archived)

Hi all,
When doing Resource Transactions for Work Order in Oracle eAM am getting this note message
"No labor Rate found for this employee"
Because of this error, my labor cost is not getting calculated.
I had defined Resources with costed flag enabled, defined a standard Rate and assigned Instances(Employees) to resources since then am getting this note..
pls help am in a middle of a production issue.
Thanks
Raja 

Hi,
When you are using the resource instance( labour),what ever the instances( employees r lablours) you added to that particular operation for that you need to define labour rates.
WIP -->Setup-->Employee--> Labour rate
Find the employee name( Instance) from LOV and give the rate there.
Now do the transactions.
Thanks
Vijay

Related

Inventory Average Costing Question

Hi,
I'm convering onhand quantity from legacy inventory system to Oracle Inventory and we use Average Costing.. Here are the steps.
1. Converting the items via item import.
2. Convering onhand quantity with Misc receipts using transactions interface
3. updating the Average cost of these items via transactions interface .
When i convert the onhand quantity there is no cost for these items and all the mtl_trasnaction_accounts transactions were created with 0$.. With the average cost update, mtl_trasnaction_accounts transactions were created with $ amount..
What is the best sequence for reconcilation point iof view with the inventory and GL???
Please suggest..
Thanks,
Shree 
Hi, in my experience the steps you indicates are correct. Anyway, you can avoid step 3 if you put the unit cost directly in the transaction open interface. This is correct only if your costs are not divided in more than one element (eg. you have only the material cost element). If you do in this way, you will see your miscellaneous transactions will have costs and related records on MTL_TRANSACTION_ACCOUNTS will be created with a positive amount.
As you will know, also when you perform a miscellaneous transactions by using the form, you have the possibility to inidcate the unit cost. Normally you do this if your actual average cost is not correct for your transaction, or if the average cost is 0.
If you follow this indications, you should not have problem at the moment of the reconciliation with GL. 
Hi Riccardo,
I have created Average Costing organization and I created an Inventory item. Then I went to BOM, created the Routing and Bill for my item. I would like to know should I need to run the Assembly cost roll-up and Cost update for my item.
Please explain and steps for cost roll-up and Cost update in case of Average costing organization. Theritically I belive these steps are not required in case of Average costing organization.
Thanks in advance
NR

Rate Schedule

Hi,
When I am doing any transaction for the Pre-Approved Timecard then the Cost is calculated as per the COST RATE of Employee Rate Schedule but its not happening same with Non-Labor Rate Schedule. It giving the error message as "Missing Cost Rate".
If I assign that Exp. Type to the Non-Labor Resources then the Cost is calculated as per the COST RATE in Non-Labor Resources setup but it is not calculating the Cost as per the COST RATE from Non-Labor Rate Schedule.
What could be the reason? For Employee its using Employee's Rate Schedule Cost Rate but in the case of Non-Labor its not same.
Regards,
Khan. 
Hi
The system has different method of costing for non labor which is classified as Usage, and that with is not Usage.
For expenditure types which are classified as Usage the system will look first look if the expenditure item is associated with a non-labor resource and resource owning organization, and looks for a cost rate for that. Only if a combination does not exists, and no effective rate is found, the system goes to the second choice.
The second choice for Usage, and the only choice for any other non labor expenditure is to look for a cost rate entered for the expenditure type.
The system is not using, as standard functionality of costing, the Rate Schedules form, which has a tab of non-labor.
Dina 
Thanks for the information............
Yes, I have notice that before also that the System is first considering the Rate which is associated with a non-labor resource or else it will look for the Cost Rate in Expenditure. If the system doesn't find any rate in both cases then its giving error message "Missing Cost Rate".
So, what is the use of defining Cost Rate in Rate Schedule under non-Labor Tab. I checked Rate Schedule is having a clear affect of Employee Tab & Resource Class Tab but I am unable to understand why Non-labor Tab does not have any affect in the transaction.
Where exactly Non-labor Rate from Rate Schedule is impacting and in what scenario.
Appreciate your reply.
Regards,
Khan. 
Hi
The rate schedule may be used for labor costing.
The Rate Schedule for labor and for non labor may be used for Billing. You can see that on the setup of Project Type, billing tab.
If you use Project Management, you may also use the rate schedules for calculating planning amounts.
Using Budgets on FORMs you may develop budget client extension to look at the rate schedule, when calculating budget amount for a line.
Dina 
Hi,
Yes, we use Resource Class Rate from Rate Schedule for Planning Budgets in Project Management.
May be Non-labor Rate from Rate Schedule is use for Billing which I dont know. I need to check.
Thanks for the information.
Appreciate your replies in this Forum.
Regards,
Khan. 
Hi,
Pls help me 2 understand wat z non-labor cost??for which scenario itz n picture?? anybody plzz help me...
in my implementation only Labor tab enabled no other tabs active.....
Thanks a lot in advance.... 
Hi
The costs for a project may include both labor and non-labor resources.
Non Labor resources may be charge for usage of equipment, complex laboratory, charges for cars or other services.
If you utilize such resources on your projects you could setup a non-labor resource and the cost rate for each hour or for miles of travel, etc. The rate for the non-labor resource may be setup in the rate schedule.
Dina 
Thank u so much 4 ur reply...
Can anybody help me on finding Rate schedule table name??
How 2 find table names of the oracle forms??(exact table name where the source data lying) plzz help me... 
Hi
Usually, when on the form, select the record of the rate value, go to Help > Examine
There you can see the table name, and fields name.
Dina 
Thanks a lot 4 ur prompt reply each time....
Do the Examine function shows the view or seeded table name??-( in general)
Thank u n advance.....
Edited by: prety on May 12, 2010 10:46 PM 
Hi Dina,
as most of the tasks use material resources also, can we use material resources as non-labour resource?
Can you please let me know where can we find the rate schedule?
Regards 
Hi
Material is non-labor.
However, usually material transactions are imported to Projects as already costed, and you should not need to cost them in PA.
You could see materials on PO receipt accrual transactions, on AP supplier invoices or on Inventory transactions.
Dina 
Hi HawkerHunter,
I think, you already got reply for your first ques from Dina.
abt ur 2nd ques, you could see the rate schedule with below path.
Setup > Expenses > Rate Schedules. 
Okay I got it. P.O shall have the material rates. From there it shall be costed.
Thanks Dina.
Regards

Costs Incurred for Resource Cost is not getting calculated in WIP(Std Cost)

Dear All,
Please note that we had made Standard Costing for a new Operating Unit.
Now when we complete the WIP job, the Resource Cost is not calculating for the 'Costs Incurred' in the WIP Valuation Summary.
Why this is not getting calculated.
Is there any setup that we missed out?
Please update..
Many thanks.... 
Hi
Check you had setup the cost rate for each resource.
Dina 
Hi Dina,
Many thanks for your response...
Please note that..,
The Cost rate is setup, still the Costs Incurred is not getting callculated...
regards, 
Hi
There may be some errors that prevent costing of transactions.
Check for exceptions. You may also if inventory transaction entered before and after the wip completion for the same item had been costed. Since Cost Manager process transaction by the order they were entered, it may be that there are exceptions for earlier transactions.
Dina 
Hi Dina,
Thanks for your response..
The issue was with we have not included the 'Frozen' Cost type in the Resource - Overheads...
After setting the Overheads with both Frozen and Pending. It started coming up correctly...
--------------------------------------------
Now the Overhead Cost sub-element is not getting the values... What could be the cause for this...?
Please update...
Many thanks once again....
regards..., 
Hi,
Just like standard rate you have to assign the overheads for the resource, if you have already done that make sure that the Overheads are also present at the Dept to which this costed resource is attached.
Karthik.

Error When making Resource TXN

Hi all,
When doing Resource Transactions for Work Order in Oracle eAM am getting this note message
"No labor Rate found for this employee"
Because of this error, my labor cost is not getting calculated.
I had defined Resources with costed flag enabled, defined a standard Rate and assigned Instances(Employees) to resources since then am getting this note..
pls help am in a middle of a production issue.
Thanks
Raja 
Can you confirm that there is defined Labor rate value for the employee?
Navigation: Setup>>Employees>>Labor Rates

FRM 40350: Query Caused no records to be retrieved in INVTVTXN

Dear All,
When Trying to View the Material Distributions for the Transaction Type Sales Order Issue. I am unable to get the accounting entries for the Transaction. On selecting the form the error shows :
FRM 40350: Query Caused no records to be retrieved
Please help
Thanks
Dinesh 
Ensure that the cost manager is running (Inventory -> Setup -> Transactions -> InterfaceManager )...and ensure that you are giving the correct date range.
normally you should be able to see distributions as Inv valuation Cr and Deferred Cost of Goods Sold Dr ...
Some times Cost Manager shows as Active but it does not process transaction records, take help from your system administrator/ DBA to get cost manager restarted.
Thanks,
Hrishikesh 
did it work? 
Hrishikesh,
Cost manager is Active.
But Material Transaction Manager is Inactive.. But am getting Costed = Yes in Material Transactions for the particular txn type. i.e., Sales Order issue.
But for a normal Sales Order flow, the material distributions for sales order issue happens correctly
Is that for Internal Drop shipment transaction we need to do some additional Setups??
Please help
Thanks
Dinesh

Categories

Resources