EBS : PA Costing : Steps of Project Costing Expenditure Booking

 

Steps of Project Costing of Expenditure Booking

1. Expenditure Entered      

 

select * from pa_expenditures_all where EXPENDITURE_GROUP ='Test' order by creation_date desc;

select * from pa_expenditure_items_all where EXPENDITURE_ID=878744;

 

2. PRC: Distribute Labor Costs -> program ran to generate cost.

 

select acct_event_id,pcd.* from pa_cost_distribution_lines_all pcd where EXPENDITURE_item_ID in (1840951,1840952,1840953);

 

3. PRC: Generate Cost Accounting Events -> Program ran to generate costing events and data will be generated in XLA

 

a.       Update eventid in pa_cost_distribution_lines_all

b.      Populate data in -> select * from xla_events where event_id in (36442497,36442498,36442499);

 

4. PRC: Create Accounting -> populate data in subledger

 

select * from xla_ae_headers where event_id in (36442497,36442498,36442499)

order by creation_date desc;

select * from xla_ae_lines where  AE_HEADER_ID in (35023524,35023525,35023526);

order by creation_date desc;

 

5. Journal Import -> create journal in GL and post it.

 

select * from gl_je_lines where reference_6 in ('36442497','36442498','36442499') --event_id

and reference_7 in ('35023524','35023525','35023526')    --ae_header_id

and je_header_id in (1685653,1685655,1685654)

 

select * from gl_je_headers  where je_category='Labor Cost' and je_source ='Project Accounting'

and je_header_id in (1685653,1685655,1685654) order by creation_date desc;