Costing process run results

November 30 0
Advertisement
i am trying to view my costing process using View>Payroll process Result
Payroll = Monthly payroll
Action Type= Costing
and i click on find i can see the costing date as 31-MAR-2010. i then click on the Assignment Process button and then i click on the employee that i want to view the details for costing and i click on costing button
It takes me to a screen where i must enter the Costed Run information i.e i must select a date from the lov and then i click on the details section under the Element name i can view the employee details for each element and the debit and credit entries for the each elements.
Can some one tell me the table name for this form as i want to view using sql select command.
appreciate all your help!
Advertisement
Try this query..
select pet.element_name "Element",pc.costed_value "Value", pc.debit_or_credit "Debit / Credit",pc.balance_or_cost "Balance / Cost",ppa1.date_earned,paa1.assignment_id
from pay_costs pc,
pay_cost_allocation_keyflex pcak,
     pay_input_values_f piv,
     pay_element_types_f pet,
     pay_assignment_actions paa,
     pay_payroll_actions ppa,
     pay_action_interlocks pai,
     pay_assignment_actions paa1,
     pay_payroll_actions ppa1
where pc.cost_allocation_keyflex_id = pcak.cost_allocation_keyflex_id
and pc.assignment_action_id = paa.assignment_action_id
and paa.payroll_action_id = ppa.payroll_action_id
and pc.input_value_id = piv.input_value_id
and piv.ELEMENT_TYPE_ID = pet.element_type_id
and ppa.action_type = 'C'
and paa.assignment_action_id = pai.locking_action_id
and pai.locked_action_id = paa1.assignment_action_id
and paa1.payroll_action_id = ppa1.payroll_action_id
and ppa1.action_type IN ('R','Q')
and paa1.source_action_id IS NULL
and paa1.assignment_id = :pAssignmentId
and ppa1.date_earned = :pDate
order by 1
Costing process run results

i am trying to view my costing process using View>Payroll process Result Payroll = Monthly payroll Action Type= Costing and i click on find i can see the costing date as 31-MAR-2010. i then click on the Assignment Process button and then i click on t

Error while running Actual Cost Process.

Hi, Currently i am trying to implement Actual Costing with calculation type as (PMAC). when i run the actual cost process it is showing the error below. Errors: Warning: Cannot find the previous cost period record. Warning: Total allocated GL expense

Actual Cost Process request run terminated with Error Signal 11

Hi All Could not run Actual Cost Process as it is terminated with error signal 11. Please tell me the reason/cause if any one has come across this error before in your cost running process. Thanks in advance for your valuable suggestions. I am using

Product costing Cycle run for first time to complete backlog

Dear sir, In my Company we went live in April 2011 and since then we never did settlement of Product costing as process was not stream line , but now (in Aug-2011) it is stream-line and we wanted to do Proper costing Cycle run & settlement too. Can y

Why won't new version 4.0 open on my desktop while version3.6.17 works fine. When I check the processes running on the computer the firefox is running but it won't open on the desktop(monitor)

When I updated firefox from version 3.6.16 to 4.0 the program would not open on the desktop after I double-clicked the short cut on the desk top. I checked the processes running on the computer and it showed firefox running. I followed the short cut

System Process Running out of Control - Overheating!

The other day I arrived home and went to check my e mail and found my computer running at full tilt with the fans going all out and the case quite hot.  I thought maybe I had left dashboard open all day as I have done this before with similar results

How to add process model results to the sequence file results?

After my sequence file runs, I would like to add some additional results using the process model. I need to log my equipment list which is obtained by the process model. Alternatively, I could add a sub-sequence to the end of each of my sequence file

Costing process in payroll

In oracle payroll i can see 2 processes in the conc. request LOV 1 Costing 2 Costing of Payment kindly help me as to when the two are run.If possible guide me to any docs. Appreciate all help/assistance!Hello, Based on response as follows, I am able

Filtering only the Actual cost line items resulted by confirmations in DP91

Hi, I have DIP profile and in that Material Determination Charactersitic is Activity Type. In DP91 system is pulling  the following cost line items 1.ACTUAL cost Line items resulted due to confirmations of operations and in this ACTIVITY TYPE will be

OPM Actual Cost Process not selecting all Inventory Movements

We have completed 27 Move Immediate transactions (TRNI) but only 2 of the transactions appear in the Actual Cost Transactions View so our PMAC cost is not as expected. Those 2 transactions were in Sept '09. All other transactions happened in Apr, May

Stopping Quickpay in Costing Process

Hi All I want to include the regular payroll into the costing process but I want to exclude the Quickpay getting into Costing process. I don't want to do costing for quickpay at all. How can I do this? Regards RahmanI dont think there is any configur

Plan costs calculation during results analysis of sales order

Hi Experts, I am in process of implementing sales order costing. I am facing a problem during result analysis with plan costs data. We have a sales order for which production order is generated. Cost object is sales order. Say, sales order cost estim

Process runs faster when executed independently, but runs slower when a parallel big process is running

Hi, The issue is,  a process, say "A" is running fine on certain days. On some days there are additional processes running on the server. When these additional processes are running, "Process A" suffers performance issue. Interesting p

I have a windows 7 64x SP1 and every time I install iTunes 12 I get this message when I try to ponen it:"This copy of Itunes is damaged and it has not been correctly installe. Please, install iTunes again.(-42404)". The instalation process runs smoot

I have a windows 7 64x SP1. Every time I install iTunes 12 I get this message when I try to open it:"This copy of iTunes is damaged and it has not been correctly installed. Please, install iTunes again.(-42404)". The instalation process runs smo

Two processes running at the same time in Lookout

I have installed Lookout 5.0 with 200 I/O Points onto our server computer. The application of motion control is next to the 200 I/O points through OPC PMAC server/client. Now I would like to have a second process in the same server for trouble shooti

Sale order costing process : Help required

Hello All, Belatted Happy New Year 2011 to all. I have a question related to Sale Order Costing. It goes like this, My client is into Pipe coating business who receives the pipe from the customers, coats it as per there requirements and despatches it

Unable to open a new window you must first close exsisting firefox process or restart your system. There is no firefox process running why should I receive this error msg?

I closed a Firefox process. Then clicked the FF icon to restart my browser. I received an error message. " Firefox is already running, but not responding. To open a new window you must first close existing Firefox process, or restart your system. How

How to terminate the "process" running in weblogic server by servlet

hi all !! i have executed a external command from servlet but i am not getting the output untill i logoff the weblogic server. now i want to kill the process running in my server by servlet code.how could i do this? here is my code ,it is executing t

Why are there two ns-httpd processes running for one instance of iws 6

Hi all, I'm used to iWS 4.x where there's only one watchdog and one ns-httpd process running for any given install of iWS. Now in iWS 6.x I noticed there are two processes for the admin server and two processes for the actual single web server instan

Back date change problem in run result

Dear Experts, Navigate: Work Structure>Organization>Description i implement organization structure Jan 2010 in R12 HRMS Global . now change appear in organization structure effective date Jan2011. but this change not done till date in system. i date