Saturday, April 5, 2014

Programs which determine cost in Project Costing module

Programs which determine cost in Project Costing module



We should run the below programs to determine the costs in Project Costing Module

To determine labor costs run the below programs

1/  PRC: Distribute Labor Costs (or)  PRC: Distribute Labor Costs for a Range of Projects

To determine cost for usage and miscellaneous transactions run the below program

1/ PRC: Distribute Usage and Miscellaneous Costs

To determine the supplier cost run the below programs

1/ PRC: Interface Supplier Costs

2/ PRC: Distribute Supplier Cost Adjustments (or) PRC: Distribute Supplier Costs Adjustments for a Range of Projects

To determine expense report cost run the below programs

1/ PRC: Interface Expense Reports from Payables

2/ PRC: Distribute Expense Report Adjustments

To determine costs for borrowed and lent accounting run the below program


1/ PRC: Distribute Borrowed and Lent Amounts


To determine the burden cost run the below program

1/ PRC: Create and Distribute Burden Transactions


The above program creates burden transactions for projects based on the method to store burden costs.


To determine total burdened cost run the below program


1/ PRC: Distribute Total Burdened Costs


The above program creates total burdened cost distribution lines for all transactions on a burdened project.


References:-

Oracle Documentation

Friday, April 4, 2014

How to resolve APP-PA-19947 Mean in the Expenditure Types (PAXSUDET) Form?

How to resolve APP-PA-19947 Mean in the Expenditure Types (PAXSUDET) Form?

When users try to create an expenditure type you may get the below message:-

APP-PA-19947 There are expenditure types existing which are not associated with a expenditure type class. These expenditure types will not be acceessbile during expenditure entry.

To resolve the above message, please follow the below steps:-

1/ Execute the below SQL Query and note down the expenditure types

Select distinct expenditure_type from PA_expenditure_types where expenditure_type not in (select distinct expenditure_type from PA_expend_typ_sys_links);

2/ For each type returned in the above query execute the below steps:-

2.1/ Navigation: Projects Responsibility > Setup > Expenditures > Expenditure Types

2.2/ Query the expenditure type returned in the 1st Step.

2.3/ Enter the expenditure type class

2.4/ Save the record.

Thursday, April 3, 2014

ERROR: You Do Not Have The Authority To View Financial Plans For This Project

ERROR: You Do Not Have The Authority To View Financial Plans For This Project

This post is related to the PA Module in Oracle EBS Version 11i to R12.X+.

Sometimes users get the below error when they try to access the financial plans:-

You Do Not Have The Authority To View Financial Plans For This Project

Solution:-

Set the profile option, 'PA: Cross Project User -- Update' to 'Yes' for the affected responsibilities.

If the issue still doesnt resolve please check the metalink note: 236704.1

Oracle Report Error - REP-1401: '': Fatal PL/SQL error occurred.

This post is related to Oracle Reports in Oracle EBS Version 11.5.5 to R12+.

Sometimes when you run a report you encounter the below errors:-

REP-1401: '': Fatal PL/SQL error occurred.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error: 

The most common reason for the above error is:-
No return value in one of your functions defined in the report definition.

Solution:-
Ensure that all the functions defined in the report definition has a return value. Also ensure that there is return value outside the             'if condition' statements