- ORACLE PROJECTS TO FA FLOW
- oracle pojects capture the expenses, distribute and account.
- Generate Assets - wich will disply in CIP Cost
- Interface Asset to FA - Will disply in Interfaced CIP cost.
- FA will post asset cost in GL and clear CIP and RWIP cost
accounts.
PURPOSE -------
This bulletin is designed to help troubleshoot Project Accounting (PA) to Fixed Assets (FA) interface issues. It is also intended to highlight the programs that need to be run in PA before running the interface to FA. It will identify the information which should be transferred and information not expected to be transferred to FA.
Interfacing a Capital Project to Fixed Assets
---------------------------------------------
You have a capital project in PA that is ready to be added as an asset to FA, so what needs to be done?
Here is a list of things to do in PA:
1) Distribute all Expenses
2) Distribute Burden Costs
3) Post to GL (everything) and Tieback.
4) Summarize the costs (Update or Refresh Project Summary Amounts)
5) PRC:Generate Asset Lines
6) PRC:Interface Assets
It is after all the above has been completed that the lines will be sent to the FA_MASS_ADDITIONS interface table.
In PA, there are two ways to define a Capital Project:
1) If you check the Require Complete Asset Definition box in the Setup Project Types form, the asset lines will be sent to FA in the POST queue.
2) If you do not check the Require Complete Asset Definition box, the lines will be sent over to FA in the NEW queue, and you will have to Prepare Mass Additions lines fully before putting it in the POST queue.
Then in FA, run Post Mass Additions (FAMAPT) to create the assets.
Common Questions
Q) I've run the PRC:Interface Assets process, but when I look in the Prepare Mass Additions form, I cannot see the invoice number/supplier information.
A) You are not supposed to see this information. A project can consist of many invoices and many suppliers. The FA_MASS_ADDITIONS table cannot hold all this information. However, once the asset has been created (by running Post Mass Additions) you can then drilldown to AP (View Source Lines) then into PA. It is at this level that you will see the same information as on the Capital Projects form, since this is looking at a view of the PA_PROJECTS_ALL table.
Q) I have sucessfully interfaced asset lines to FA, but no asset details appear in the Prepare Mass Additions form.
A) The Capital Project setup did not have the Require Complete Asset Definition box checked. You can either add this information into the FA_MASS_ADDITIONS table via the Prepare Mass Additions form, or change the setup of the project or project template to require a complete asset definition. Remember, in this case, the mass addition lines will be created automatically in the POST queue.
Q) The request PRC:Generate Asset Lines did not create asset lines for all assets. There is a message in the concurrent request log file saying there is incomplete asset information.
A) Not all required information has been entered on the project. Query back the project in the Project Workbench. Then, go to the Asset Information on the project. All the information on this form needs to be filled in (Asset Category, Name, Corporate Book, Depreciation Account). Summarize all the expenditure lines by running Update Project Summary Amounts (just to check that this has been done). Check that the expenditure lines have been transferred to GL and tied back. Run PRC:Generate Asset Lines again. Then, check that all the asset information is put on these new lines. Run PRC: Interface Assets again (there is NO debug for this process) and the lines should go into FA_MASS_ADDITIONS interface table.
Submitting Processes
When you are ready to place your CIP assets in service, you can interface the asset costs to Oracle Assets. You interface asset cost lines
by running the Oracle Projects process PRC: Interface Assets. You can run this process whenever you are ready and as many times during an
accounting period as you want. You can run the process for a single project or for a range of projects. You can choose to interface costs for
assets that are placed in service as of a date you specify in the processing parameters.
Prerequisites
• Interface and tie back labor, usage, and miscellaneous transaction costs to Oracle General Ledger by running the appropriate
streamline process in Oracle Projects.
• Interface expense report and supplier invoice costs to Oracle General Ledger by running the Payables Transfer to General
Ledger process in Oracle Payables.
• If you are interfacing burdened asset costs to Oracle Assets, Interface Burden Costs to Oracle General Ledger ) by running
the appropriate streamline process in Oracle Projects.
• Post all asset costs previously interfaced to the FA Mass Additions table by running the Post Mass Additions process in
Oracle Assets.
• Assign the asset an appropriate in service date in the Capital Projects Workbench.
• Run the Generate Asset Lines process in Oracle Projects to create asset cost lines.