1. How to use global project without Project Billing for two different leagal entities and Ledgers?
You can use Cross–Charge Client Extensions
2. PO created with 10 quantity of Computer in one line. How to Create separate asset ID for each 10 items for Projects?
You may use CIP Grouping Extension
3. Do we need to customize Purchasing and Payable account generater workflow for Project usage?
Ans: Purchasing can be used the default account generator,No setup steps are required to use the default.If you are using seeded account generator, account should be manually entered.
But you should modify the payables account generator workflow for project usage.
Oracle Projects Invoice Generation/Receivables Integration
Q1. What is the difference between running the Generate Draft Invoices process for a single project and running it for a range of projects?
A: When running the Generate Draft Invoices process for a single project, the billing cycle is ignored. Any unreleased draft invoices are deleted and a new draft invoice is created. When running the Generate Draft Invoices for a Range of Projects, the process takes the billing setup into account (i.e., bill offset and cycle days). Therefore, the system looks at the current date, adds cycle days and then determines whether or not the project is ready to bill.
Q2. What are the billing cycle requirements for invoice generation?
A: A project must meet the following billing cycle criteria before it can generate an invoice:
a. No pending (unreleased) invoices exist
b. At least one bill cycle past the bill through date (or creation date if no bill through date exists) of the last non crediting invoice
c. At least first bill offset days past the project start date (or project creation date if no start date exists) if you have not yet invoiced a particular project
d. If the billing date is calculated by a client extension, and the client extension returns a null value for the billing date, then the process will not pick up the project
Note: If unreleased invoices exist for a particular project, that project will not be picked up when the Generate Draft Invoices for a Range of Projects process is run. However, if the process is run for a single project, it will ignore the checks listed above.
Q4. How can I generate a single invoice for a project with multiple agreements?
A: AutoInvoice will break when it meets a grouping rule. AGREEMENT_ID is a mandatory grouping rule. Once AutoInvoice encounters a project/order with a different AGREEMENT_ID, it will create a new invoice. As long as there is more than one AGREEMENT_ID, multiple invoices will be generated. One remedy is to create a single invoice in Receivables for multiple invoices coming from Projects.
Q5. How is the Output Tax Code determined in Oracle Projects?
A. Oracle Projects uses the hierarchy set up in Implementation Options to determine where to look for the Output Tax Code. Sources that can be used include:
Customer Site
Customer
Project
Expenditure Type/Event Type / Retention
Client Extension
Oracle Receivables System Options
Q6. Is it possible to sort on the invoice amount column on the Invoice Review form (PAXINRVW) in Release 11.5?
A: A design change was made in Oracle Projects Release 11.5 to have brackets around the negative amounts in the invoice amount column. In order to accommodate the brackets, it was necessary to make the invoice amount column an alphanumeric column. It is not possible to sort numerically on alphanumeric columns; hence, the invoice amount is not available for sorting.
Q9. Why is the message, Invalid AR Transaction Type Passed, displayed after running PRC: Interface Invoices to Receivables (PATTAR)?
A: Projects requires the Creation Sign field on the transaction types to be A (for Any Sign). Set the value to A on the Creation Sign field for both PA Invoice and PA Credit Memo transaction types. Additionally, the "Post to GL" box must be enabled.
Q10. When attempting to transfer sales credits to from Projects to Receivables, I receive the following error, APP-11863: Invalid sales_credit_type_id (nil). Why?
A: In order to import Projects invoices with sales credits, the sales credit type must be set to value and not ID in Receivables.
Q14. Is there a way to generate an invoice for each individual task for a percent-complete project?
A: To create separate invoices by task, first create multiple agreements by task and then fund by task level. (Note that this is for a one-customer project only--funding at the task level cannot be done for a multiple-customer project.)
Invoice Generation/Receivables Integration - Credit Memos
1. Why does the Invoice Class show as Invoice instead of Credit Memo when an invoice reduction event is created?
A: This is the intended functionality. In the case of Invoice Reduction Events, there is no specific invoice to credit, therefore they are created with the class of Invoice instead of Credit Memo.
2. What accounting is performed when an invoice write-off is initiated in Projects?
A: The Revenue and Invoice Accounts function is called by AutoAccounting when the credit memo type is a Write-Off. The accounting that is performed is a credit to the Receivable Account and a Debit to the Expense Account that has been set up for Write-Offs in the AutoAccounting setup. Revenue would not be affected by a Write-Off. The expense would offset the revenue in the income statement.
3. What happens when an invoice is canceled?
A: When an invoice is canceled, the transactions that make up the invoice are returned to an unbilled status and made available for rebilling during the next billing cycle. After an invoice is canceled, the PRC: Generate Draft Invoice process creating the Credit Memo replaces the columns PA_CUST_REV_DIST_LINES_ALL.DRAFT_INVOICE_NUM and PA_CUST_REV_DIST_LINES.DRAFT_INVOICE_LINE_NUM with NULLs for the expenditure items being credited. This results in the "missing" details in the original invoice and the credit memo.
4. Why do I receive the APP-PA-19112 Total Unprocessed Write-Offs May Not Exceed Unbilled Receivables error?
A: This error occurs when you create a Write-Off Event that has an amount greater than the value of unbilled Receivables (total revenue minus total unprocessed Write-Off Events). Unprocessed Write-Off Events are those events that have not yet been processed by the revenue generation process. To reproduce the problem, create a contract project with a work/work revenue distribution rule. Create an agreement and funding for this project and baseline the approved revenue budget. Now create the Write-Off Event and you will get this error. This is the intended functionality.
5. How does Oracle Projects handle on account credit memos?
A: From a Projects perspective, the only way to manage an "on account" credit memo is to create the independent crediting invoice using a negative manual event. When the time comes to apply the credit to the proper invoice, create a positive event (debit memo) to offset the negative invoice then create a standard credit memo against the appropriate invoice.
6. How are partial write-offs handled when the invoice has tax?
A: When you do a partial write-off in Projects, it credits a small portion of each invoice line. If you need to write-off a particular line of a Projects invoice, a partial write-off should be done in Projects and interfaced to Receivables so that the two modules are in synch. From Receivables, incomplete the invoice and adjust it. Using this method will ensure that the modules stay in sync and only the lines that you want to write-off will be written off.
10. Is it possible to apply a credit memo to an invoice that has already been paid in Receivables?
A: If the Invoice Type in Receivables has Overapplication = Yes, you should be able to interface the credit to Receivables. If you do not wish to set Overapplication to Yes, you can unapply the cash receipt in Receivables and refund it to the customer or apply it to another invoice.
11. Why are credit memos against invoices interfaced to Receivables rejected with the error, You cannot supply any account assignment for your credit memo transaction?
A: Set the profile option, AR: Use Invoice Accounting For Credit Memos, to No at the site level (temporarily if required to be set to Yes for Receivables). This should be defaulted to No at the application level.
12. Why do is the error, APP-43448 Unable to locate a valid Sales Tax Rate for transaction, received during the AutoInvoice process?
A: The transaction type for invoices and credit memos must have the calculate sales tax flag disabled. Create a new transaction type for credit memos (and invoices if applicable) with the same settings, ensuring that the sales tax calculation check box is disabled. This can be accomplished using the Receivables Manager Responsibility and navigating to Setup -> Transactions -> Transaction Type.
How Can We Populate Org LOV On Provider Receiver Control In Cross Charge Setup? [ID 749623.1]
GoalTrying to setup Cross Charge between companies and we are not able to enter the details in Provider/Receiver Control screen. Under Provider Control, when we click on Receiver Operating units, the list of values is empty.
How can we get this list populated? Solution (A) If this is the 1st time setting this up, then, make sure that process "Replicate Seed Data" has been run.
If not, then run this process from the System Administrator responsibility.
(B) Please verify that Implementation Options - Cross Charge is populated for both Operating Units.
(C) 1. Do the effective dates for the operating unit include the current date
2. A legal entity has been assigned to the operating unit.
That is to say, when you query up the operating unit in the Organizations form,
and select the "Operating Unit" classification, then when you click the "Others" button,
and select "Operating Unit Information", in that DFF you have entered a value for the Legal Entity organization.
Please verify this for each OU you are expecting to see in the LOV.
3. Does the legal entity that is selected, also has effective dates that include the current date?
4. This will only return operating units for which projects has been implemented.
(D) Please check the setup of the "HR security profile" profile option for the
user/responsibility that is being used and insure that it allows access to
the organizations needed Operating Units.
13. Can we have Form based budget for few projects and HTML (Financial plan type) budget for other projects?
Once we create the budget using financial plans, oracle project does not allow to create form based budgets. it displyed the message that the budget type has been upgrated and need to create budget through financial plans
14. Can we use transaction control for billing hold ?
Yes, select billing hold yes option at TC level.
15. UDA - User Defined Attributes can be used for additional informations in HTML page
16. Created an Auto Accounting Rule with Rule Parameter and unable to get the Rule in AAR assignment window. what is the reason?
Rule Parameter selected in AAR may not be valid for the Function you are assigning.
PROJECT BURDEN COST FREQUENTLY ASKED QUESTIONS
2. What types of burden reporting are there?
A: In Oracle Projects, burden costs can be reported in three different ways depending on the Project Type setup for the project.
The Summarized Burden Transactions process is responsible for placing the expenditure item in the burden project.
4. What changes can be made to a burden structure that has been attached to a compiled burden schedule?
A: After using a burden schedule against a project, the only accepted modifications to the associated burden structure are the addition
of expenditure types. Any other modification to the burden structure will result in the following message:
Cannot add, delete, or update the burden structure. The burden structure is referenced in a burden schedule revision that has been compiled.
The Burden Structure has been associated with a compiled Burden Schedule
5. Why am I unable to view a changed burden structure in details after updating the structure on the base
schedule?
A: Updating the Structure field on the Burden Schedule (PAXCOIRS) form for an existing burden schedule only affects new burden schedule
versions created. If it were permissible to change the structure of a burden schedule revision that is already compiled, data corruption in the
PA_IND_COMPILED_SETS table would occur when that burden schedule version is re-compiled.
6. How can I make changes to a burden structure that has been attached to a compiled burden schedule?
A: Create a new burden structure and copy the compiled burden schedule to the new structure. Once you have the new structure, add any
new cost base, cost codes, and expenditure types required. The new structure should be added to the burden schedule and a new burden schedule version
created. If it is necessary to use the new structure in a prior Projects (PA) period, then the structure should be added to a project burden schedule override
for the given periods.
7. Is it necessary to populate the project burden schedule hierarchy on the Business Groups Other Information area of the Define
Organization (PERWSDOR) form?
A: In Release 11.5, it is not necessary to populate the burden schedule hierarchy on the Business Groups Other Information area of
PERWSDOR. This information is gathered from the Burden Schedule (PAXCOIRS) form.
8. What expenditure items can (not) be burdened?
A: All expenditure items that are entered directly in projects can be burdened. For expenditure items that are imported via
Transaction Import, the associated Transaction Source determines if the item can be burdened. This is based on the Transaction Source system_linkage_function
and the following flag:
PA_TRANSACTION_SOURCES.ALLOW_BURDEN_FLAG In the Transaction Sources form, this field is lableled "Import Burden
Amounts". The flag indicates if an external system will provide the burdened costs or not. If the flag is set to Y, then Oracle Projects will not burden the
expenditure items associated with that Transaction Source.
It is not possible to burden expenditure items with a Transaction Source of Inventory, Inventory Misc, or Work-In-Process since all accounting for these
costs occurs in Oracle Manufacturing.
9. Can tax lines from Payables be re-burdened?
A: No, tax lines from Oracle Payables cannot be recalculated. Payables has a tax engine that determines the amount of tax based
on the standard line attributes for the invoice. Therefore, the Transaction Source defined in Projects for Payables tax lines is setup to not allow
adjustments.
10. When using summarized burden processing, what are the ties between the Standard Raw Expenditure items and the newly created
Summarized Expenditure items?
A: When the PRC: Create and Distribute Burden Transactions (PASDUC_BURDEN) process runs, it determines what standard expenditure items need
to be processed by the value of 9999 in the BURDEN_SUM_SOURCE_RUN_ID column in the PA_COST_DISTRIBUTION_LINES_ALL table. The value in BURDEN_SUM_SOURCE_RUN_ID column of the PA_COST_DISTRIBUTION_LINES_ALL table during processing gets
changed from –9999 to some counter value.
The new summarized burden expenditure item created from the standard raw cost distribution lines gets a counter value, which is placed in the
BURDEN_SUM_DEST_RUN_ID column of the PA_EXPENDITURE_ITEMS_ALL table.
Listed below is a sample SQL to locate RAW Expenditure Cost Distribution Lines (CDLs) used in the creation of a Summarized Burden Expenditure item:
select *
from PA_COST_DISTRIBUTION_LINES_ALL cdl
where
cdl.BURDEN_SUM_SOURCE_RUN_ID in
(select ei.BURDEN_SUM_DEST_RUN_ID
from
PA_EXPENDITURE_ITEMS_ALL ei
where ei.expenditure_item_id = <Enter
Summarized Burden Expenditure item>);
The view PA_COST_BURDEN_DETAILS_V can also be used to determine which Standard Raw Cost Distribution lines where used to create the Summarized Burden
Expenditure items, and what the rates and amounts were used.
11. Why do some expenditure items get total burdened distributed even if their expenditure type, expenditure class, or
organization has not been defined?
A: Total burdened costs (TBC) are comprised of raw (RC) and burden amounts (BC). Thus, there is always some amount that is considered to be
burdened costs in the formula TBC=RC+BC. When the PRC: Distribute Total Burdened Cost process is run, it distributes all expenditure items regardless of
whether or not the expenditure type is defined in the burden structure or not. While no burden rate is applied to expenditure items that are not defined on the
burden structure, burden debit and credit CDLs are created for these items.
FAQ: Account Generator
1.What does the Account Generator process do?
The Account Generator process builds charge, budget, accrual, and variance accounts for each purchase order, release, and requisition distribution based on
the distribution’s destination type. It is a synchronous Workflow process.
2. What are the Pre-requisites to use Account Generator?
Before using the Account Generator you must:
- Define your Accounting
flexfield structure for each set of books.
- Define flexfield segment
values and validation rules.
- Set up Oracle Workflow.
- Decide
whether you want to use the Account Generator processes as seeded in Oracle Purchasing, or you need to customize them to meet your accounting needs.
3.What are the workflow item types used in Account Generator?
For Purchase Orders: POWFPOAG
For Requisitions: POWFRQAG
Each Account Generator item type contains the following top-level workflow processes:
Generate Default Account
Generate Account Using Flex Builder Rules
If you are upgrading from 10.7, and you have been using the flex builder to generate the accounts, you have an option of upgrading your existing flex builder rules for Account Generator. In which case, you should use the “Generate Account Using Flex Builder Rules” process.
4. What are the steps to generate the WFSTAT output for Account Generator?
1. Set the following profiles:
- Account Generator: Run in Debug
Mode=> Yes
- Account Generator: Purge Runtime Data=> No
PO: Set
Debug Workflow On => Yes
2. Make sure that the concurrent program "Purge
Workflow Obsolete Runtime Data" is NOT running.
3. Open Purchase Order/Requisitions form, go to the distributions window, enter necessary fields and click on charge account field to start generating the charge account. After
the account generator has done building the account, or errors out, do the following from the toolbar (DO NOT exit the form or navigate to any other block
or record, otherwise this information would be lost):
Help=> Diagnostics => Examine
Enter in 1st field => parameter
Enter in 2nd field => charge_acc_wf_itemkey
Then tab out. The Item key will appear in the
third field.
4. Now save the purchase order/requisition. If you are not able to save, then clear the distribution record and navigate back to the
shipment window and save the form. Saving the form is must, because a commit is required to save the workflow information in tables, for generating the wfstat
output.
5. If step#3 could not give you an item key, then use the following query to identify the relevant item key:
Select item_key, item_type,
begin_date
from wf_items
where item_type = '&item_type'
order
by begin_date desc;
For PO, use 'POWFPOAG' item type in above query, and
for requisition, use 'POWFRQAG'.
6. To generate the WFSTAT output,
Run
the sql in $FND_TOP/sql/wfstat.sql with above item_type and item_key. Spool the
output.
7. To get the wf debug information, run the following query:
SELECT item_key, item_type, debug_message
FROM po_wf_debug
WHERE
item_key = '&Item_key'
ORDER BY execution sequence;
5. Will the account generator build the charge account based on project information?
No. By default, the Account Generator process as seeded in Oracle Purchasing would not consider the project information to build the account. To achieve this
functionality, you should customize the Account Generator to consider the project details. There is a dummy sub process 'Build Project Related Account'
seeded in the Account Generator workflow, available for customization. You would also have to modify function PO_WF_PO_CHARGE_ACC.IS_PO_PROJECT_RELATED to return a value of "True". For more information on how to customize the Account Generator, please refer to the manual Oracle Purchasing Account Generator
Workflow Customization Example.
6. Will the account be generated for amount based/one time item lines?
No the Account will not be generated if you are using the Account Generator as seeded in Oracle Purchasing. Either the account should be manually entered or
the account generator should be customized.
7.When the charge account field is non updateable?
In the following cases the charge account field is not updateable:
1. If the destination type code is INVENTORY or SHOP FLOOR.
2. If the distribution is already encumbered.
3. If the PO is created from a encumbered Requisition
4. If the destination type code is Expense and
If the project is entered and the profile option PA: Allow Override of PA Distributions in AP/PO is set to NO
If the expense accrual code= RECEIPT
You can use Cross–Charge Client Extensions
2. PO created with 10 quantity of Computer in one line. How to Create separate asset ID for each 10 items for Projects?
You may use CIP Grouping Extension
3. Do we need to customize Purchasing and Payable account generater workflow for Project usage?
Ans: Purchasing can be used the default account generator,No setup steps are required to use the default.If you are using seeded account generator, account should be manually entered.
But you should modify the payables account generator workflow for project usage.
Oracle Projects Invoice Generation/Receivables Integration
Q1. What is the difference between running the Generate Draft Invoices process for a single project and running it for a range of projects?
A: When running the Generate Draft Invoices process for a single project, the billing cycle is ignored. Any unreleased draft invoices are deleted and a new draft invoice is created. When running the Generate Draft Invoices for a Range of Projects, the process takes the billing setup into account (i.e., bill offset and cycle days). Therefore, the system looks at the current date, adds cycle days and then determines whether or not the project is ready to bill.
Q2. What are the billing cycle requirements for invoice generation?
A: A project must meet the following billing cycle criteria before it can generate an invoice:
a. No pending (unreleased) invoices exist
b. At least one bill cycle past the bill through date (or creation date if no bill through date exists) of the last non crediting invoice
c. At least first bill offset days past the project start date (or project creation date if no start date exists) if you have not yet invoiced a particular project
d. If the billing date is calculated by a client extension, and the client extension returns a null value for the billing date, then the process will not pick up the project
Note: If unreleased invoices exist for a particular project, that project will not be picked up when the Generate Draft Invoices for a Range of Projects process is run. However, if the process is run for a single project, it will ignore the checks listed above.
Q4. How can I generate a single invoice for a project with multiple agreements?
A: AutoInvoice will break when it meets a grouping rule. AGREEMENT_ID is a mandatory grouping rule. Once AutoInvoice encounters a project/order with a different AGREEMENT_ID, it will create a new invoice. As long as there is more than one AGREEMENT_ID, multiple invoices will be generated. One remedy is to create a single invoice in Receivables for multiple invoices coming from Projects.
Q5. How is the Output Tax Code determined in Oracle Projects?
A. Oracle Projects uses the hierarchy set up in Implementation Options to determine where to look for the Output Tax Code. Sources that can be used include:
Customer Site
Customer
Project
Expenditure Type/Event Type / Retention
Client Extension
Oracle Receivables System Options
Q6. Is it possible to sort on the invoice amount column on the Invoice Review form (PAXINRVW) in Release 11.5?
A: A design change was made in Oracle Projects Release 11.5 to have brackets around the negative amounts in the invoice amount column. In order to accommodate the brackets, it was necessary to make the invoice amount column an alphanumeric column. It is not possible to sort numerically on alphanumeric columns; hence, the invoice amount is not available for sorting.
Q9. Why is the message, Invalid AR Transaction Type Passed, displayed after running PRC: Interface Invoices to Receivables (PATTAR)?
A: Projects requires the Creation Sign field on the transaction types to be A (for Any Sign). Set the value to A on the Creation Sign field for both PA Invoice and PA Credit Memo transaction types. Additionally, the "Post to GL" box must be enabled.
Q10. When attempting to transfer sales credits to from Projects to Receivables, I receive the following error, APP-11863: Invalid sales_credit_type_id (nil). Why?
A: In order to import Projects invoices with sales credits, the sales credit type must be set to value and not ID in Receivables.
Q14. Is there a way to generate an invoice for each individual task for a percent-complete project?
A: To create separate invoices by task, first create multiple agreements by task and then fund by task level. (Note that this is for a one-customer project only--funding at the task level cannot be done for a multiple-customer project.)
Invoice Generation/Receivables Integration - Credit Memos
1. Why does the Invoice Class show as Invoice instead of Credit Memo when an invoice reduction event is created?
A: This is the intended functionality. In the case of Invoice Reduction Events, there is no specific invoice to credit, therefore they are created with the class of Invoice instead of Credit Memo.
2. What accounting is performed when an invoice write-off is initiated in Projects?
A: The Revenue and Invoice Accounts function is called by AutoAccounting when the credit memo type is a Write-Off. The accounting that is performed is a credit to the Receivable Account and a Debit to the Expense Account that has been set up for Write-Offs in the AutoAccounting setup. Revenue would not be affected by a Write-Off. The expense would offset the revenue in the income statement.
3. What happens when an invoice is canceled?
A: When an invoice is canceled, the transactions that make up the invoice are returned to an unbilled status and made available for rebilling during the next billing cycle. After an invoice is canceled, the PRC: Generate Draft Invoice process creating the Credit Memo replaces the columns PA_CUST_REV_DIST_LINES_ALL.DRAFT_INVOICE_NUM and PA_CUST_REV_DIST_LINES.DRAFT_INVOICE_LINE_NUM with NULLs for the expenditure items being credited. This results in the "missing" details in the original invoice and the credit memo.
4. Why do I receive the APP-PA-19112 Total Unprocessed Write-Offs May Not Exceed Unbilled Receivables error?
A: This error occurs when you create a Write-Off Event that has an amount greater than the value of unbilled Receivables (total revenue minus total unprocessed Write-Off Events). Unprocessed Write-Off Events are those events that have not yet been processed by the revenue generation process. To reproduce the problem, create a contract project with a work/work revenue distribution rule. Create an agreement and funding for this project and baseline the approved revenue budget. Now create the Write-Off Event and you will get this error. This is the intended functionality.
5. How does Oracle Projects handle on account credit memos?
A: From a Projects perspective, the only way to manage an "on account" credit memo is to create the independent crediting invoice using a negative manual event. When the time comes to apply the credit to the proper invoice, create a positive event (debit memo) to offset the negative invoice then create a standard credit memo against the appropriate invoice.
6. How are partial write-offs handled when the invoice has tax?
A: When you do a partial write-off in Projects, it credits a small portion of each invoice line. If you need to write-off a particular line of a Projects invoice, a partial write-off should be done in Projects and interfaced to Receivables so that the two modules are in synch. From Receivables, incomplete the invoice and adjust it. Using this method will ensure that the modules stay in sync and only the lines that you want to write-off will be written off.
10. Is it possible to apply a credit memo to an invoice that has already been paid in Receivables?
A: If the Invoice Type in Receivables has Overapplication = Yes, you should be able to interface the credit to Receivables. If you do not wish to set Overapplication to Yes, you can unapply the cash receipt in Receivables and refund it to the customer or apply it to another invoice.
11. Why are credit memos against invoices interfaced to Receivables rejected with the error, You cannot supply any account assignment for your credit memo transaction?
A: Set the profile option, AR: Use Invoice Accounting For Credit Memos, to No at the site level (temporarily if required to be set to Yes for Receivables). This should be defaulted to No at the application level.
12. Why do is the error, APP-43448 Unable to locate a valid Sales Tax Rate for transaction, received during the AutoInvoice process?
A: The transaction type for invoices and credit memos must have the calculate sales tax flag disabled. Create a new transaction type for credit memos (and invoices if applicable) with the same settings, ensuring that the sales tax calculation check box is disabled. This can be accomplished using the Receivables Manager Responsibility and navigating to Setup -> Transactions -> Transaction Type.
How Can We Populate Org LOV On Provider Receiver Control In Cross Charge Setup? [ID 749623.1]
GoalTrying to setup Cross Charge between companies and we are not able to enter the details in Provider/Receiver Control screen. Under Provider Control, when we click on Receiver Operating units, the list of values is empty.
How can we get this list populated? Solution (A) If this is the 1st time setting this up, then, make sure that process "Replicate Seed Data" has been run.
If not, then run this process from the System Administrator responsibility.
(B) Please verify that Implementation Options - Cross Charge is populated for both Operating Units.
(C) 1. Do the effective dates for the operating unit include the current date
2. A legal entity has been assigned to the operating unit.
That is to say, when you query up the operating unit in the Organizations form,
and select the "Operating Unit" classification, then when you click the "Others" button,
and select "Operating Unit Information", in that DFF you have entered a value for the Legal Entity organization.
Please verify this for each OU you are expecting to see in the LOV.
3. Does the legal entity that is selected, also has effective dates that include the current date?
4. This will only return operating units for which projects has been implemented.
(D) Please check the setup of the "HR security profile" profile option for the
user/responsibility that is being used and insure that it allows access to
the organizations needed Operating Units.
13. Can we have Form based budget for few projects and HTML (Financial plan type) budget for other projects?
Once we create the budget using financial plans, oracle project does not allow to create form based budgets. it displyed the message that the budget type has been upgrated and need to create budget through financial plans
14. Can we use transaction control for billing hold ?
Yes, select billing hold yes option at TC level.
15. UDA - User Defined Attributes can be used for additional informations in HTML page
16. Created an Auto Accounting Rule with Rule Parameter and unable to get the Rule in AAR assignment window. what is the reason?
Rule Parameter selected in AAR may not be valid for the Function you are assigning.
PROJECT BURDEN COST FREQUENTLY ASKED QUESTIONS
2. What types of burden reporting are there?
A: In Oracle Projects, burden costs can be reported in three different ways depending on the Project Type setup for the project.
- Show burden costs on the same expenditure line with the raw cost.
- Create separate summarized expenditure items.
- Show burden costs on the same expenditure line with the raw cost and create separate, summarized expenditure items reported in another project setup for
just collecting the summarized burden cost expenditure items.
3. What are the required processes and order to be run for each burden type?
A: The first step for any burden process type is to run the PRC: Distribute... standard raw costing processes. The next step is to run the
burden processes as follows: - Same Expenditure items:
- PRC: Distribute Total Burden Costs
- PRC: Interface Total Burden Costs
- PRC: Tieback Total Burden Costs
- Summarized Expenditure items:
- PRC: Create and Distribute Summarized Burden Transactions
- PRC: Interface Usage and Miscellaneous Costs to GL
- PRC: Tieback Usage and Miscellaneous Costs
- Burden costs reported in another Project:
- Use the same processes in a and b above.
The Summarized Burden Transactions process is responsible for placing the expenditure item in the burden project.
4. What changes can be made to a burden structure that has been attached to a compiled burden schedule?
A: After using a burden schedule against a project, the only accepted modifications to the associated burden structure are the addition
of expenditure types. Any other modification to the burden structure will result in the following message:
Cannot add, delete, or update the burden structure. The burden structure is referenced in a burden schedule revision that has been compiled.
The Burden Structure has been associated with a compiled Burden Schedule
5. Why am I unable to view a changed burden structure in details after updating the structure on the base
schedule?
A: Updating the Structure field on the Burden Schedule (PAXCOIRS) form for an existing burden schedule only affects new burden schedule
versions created. If it were permissible to change the structure of a burden schedule revision that is already compiled, data corruption in the
PA_IND_COMPILED_SETS table would occur when that burden schedule version is re-compiled.
6. How can I make changes to a burden structure that has been attached to a compiled burden schedule?
A: Create a new burden structure and copy the compiled burden schedule to the new structure. Once you have the new structure, add any
new cost base, cost codes, and expenditure types required. The new structure should be added to the burden schedule and a new burden schedule version
created. If it is necessary to use the new structure in a prior Projects (PA) period, then the structure should be added to a project burden schedule override
for the given periods.
7. Is it necessary to populate the project burden schedule hierarchy on the Business Groups Other Information area of the Define
Organization (PERWSDOR) form?
A: In Release 11.5, it is not necessary to populate the burden schedule hierarchy on the Business Groups Other Information area of
PERWSDOR. This information is gathered from the Burden Schedule (PAXCOIRS) form.
8. What expenditure items can (not) be burdened?
A: All expenditure items that are entered directly in projects can be burdened. For expenditure items that are imported via
Transaction Import, the associated Transaction Source determines if the item can be burdened. This is based on the Transaction Source system_linkage_function
and the following flag:
PA_TRANSACTION_SOURCES.ALLOW_BURDEN_FLAG In the Transaction Sources form, this field is lableled "Import Burden
Amounts". The flag indicates if an external system will provide the burdened costs or not. If the flag is set to Y, then Oracle Projects will not burden the
expenditure items associated with that Transaction Source.
It is not possible to burden expenditure items with a Transaction Source of Inventory, Inventory Misc, or Work-In-Process since all accounting for these
costs occurs in Oracle Manufacturing.
9. Can tax lines from Payables be re-burdened?
A: No, tax lines from Oracle Payables cannot be recalculated. Payables has a tax engine that determines the amount of tax based
on the standard line attributes for the invoice. Therefore, the Transaction Source defined in Projects for Payables tax lines is setup to not allow
adjustments.
10. When using summarized burden processing, what are the ties between the Standard Raw Expenditure items and the newly created
Summarized Expenditure items?
A: When the PRC: Create and Distribute Burden Transactions (PASDUC_BURDEN) process runs, it determines what standard expenditure items need
to be processed by the value of 9999 in the BURDEN_SUM_SOURCE_RUN_ID column in the PA_COST_DISTRIBUTION_LINES_ALL table. The value in BURDEN_SUM_SOURCE_RUN_ID column of the PA_COST_DISTRIBUTION_LINES_ALL table during processing gets
changed from –9999 to some counter value.
The new summarized burden expenditure item created from the standard raw cost distribution lines gets a counter value, which is placed in the
BURDEN_SUM_DEST_RUN_ID column of the PA_EXPENDITURE_ITEMS_ALL table.
Listed below is a sample SQL to locate RAW Expenditure Cost Distribution Lines (CDLs) used in the creation of a Summarized Burden Expenditure item:
select *
from PA_COST_DISTRIBUTION_LINES_ALL cdl
where
cdl.BURDEN_SUM_SOURCE_RUN_ID in
(select ei.BURDEN_SUM_DEST_RUN_ID
from
PA_EXPENDITURE_ITEMS_ALL ei
where ei.expenditure_item_id = <Enter
Summarized Burden Expenditure item>);
The view PA_COST_BURDEN_DETAILS_V can also be used to determine which Standard Raw Cost Distribution lines where used to create the Summarized Burden
Expenditure items, and what the rates and amounts were used.
11. Why do some expenditure items get total burdened distributed even if their expenditure type, expenditure class, or
organization has not been defined?
A: Total burdened costs (TBC) are comprised of raw (RC) and burden amounts (BC). Thus, there is always some amount that is considered to be
burdened costs in the formula TBC=RC+BC. When the PRC: Distribute Total Burdened Cost process is run, it distributes all expenditure items regardless of
whether or not the expenditure type is defined in the burden structure or not. While no burden rate is applied to expenditure items that are not defined on the
burden structure, burden debit and credit CDLs are created for these items.
FAQ: Account Generator
1.What does the Account Generator process do?
The Account Generator process builds charge, budget, accrual, and variance accounts for each purchase order, release, and requisition distribution based on
the distribution’s destination type. It is a synchronous Workflow process.
2. What are the Pre-requisites to use Account Generator?
Before using the Account Generator you must:
- Define your Accounting
flexfield structure for each set of books.
- Define flexfield segment
values and validation rules.
- Set up Oracle Workflow.
- Decide
whether you want to use the Account Generator processes as seeded in Oracle Purchasing, or you need to customize them to meet your accounting needs.
3.What are the workflow item types used in Account Generator?
For Purchase Orders: POWFPOAG
For Requisitions: POWFRQAG
Each Account Generator item type contains the following top-level workflow processes:
Generate Default Account
Generate Account Using Flex Builder Rules
If you are upgrading from 10.7, and you have been using the flex builder to generate the accounts, you have an option of upgrading your existing flex builder rules for Account Generator. In which case, you should use the “Generate Account Using Flex Builder Rules” process.
4. What are the steps to generate the WFSTAT output for Account Generator?
1. Set the following profiles:
- Account Generator: Run in Debug
Mode=> Yes
- Account Generator: Purge Runtime Data=> No
PO: Set
Debug Workflow On => Yes
2. Make sure that the concurrent program "Purge
Workflow Obsolete Runtime Data" is NOT running.
3. Open Purchase Order/Requisitions form, go to the distributions window, enter necessary fields and click on charge account field to start generating the charge account. After
the account generator has done building the account, or errors out, do the following from the toolbar (DO NOT exit the form or navigate to any other block
or record, otherwise this information would be lost):
Help=> Diagnostics => Examine
Enter in 1st field => parameter
Enter in 2nd field => charge_acc_wf_itemkey
Then tab out. The Item key will appear in the
third field.
4. Now save the purchase order/requisition. If you are not able to save, then clear the distribution record and navigate back to the
shipment window and save the form. Saving the form is must, because a commit is required to save the workflow information in tables, for generating the wfstat
output.
5. If step#3 could not give you an item key, then use the following query to identify the relevant item key:
Select item_key, item_type,
begin_date
from wf_items
where item_type = '&item_type'
order
by begin_date desc;
For PO, use 'POWFPOAG' item type in above query, and
for requisition, use 'POWFRQAG'.
6. To generate the WFSTAT output,
Run
the sql in $FND_TOP/sql/wfstat.sql with above item_type and item_key. Spool the
output.
7. To get the wf debug information, run the following query:
SELECT item_key, item_type, debug_message
FROM po_wf_debug
WHERE
item_key = '&Item_key'
ORDER BY execution sequence;
5. Will the account generator build the charge account based on project information?
No. By default, the Account Generator process as seeded in Oracle Purchasing would not consider the project information to build the account. To achieve this
functionality, you should customize the Account Generator to consider the project details. There is a dummy sub process 'Build Project Related Account'
seeded in the Account Generator workflow, available for customization. You would also have to modify function PO_WF_PO_CHARGE_ACC.IS_PO_PROJECT_RELATED to return a value of "True". For more information on how to customize the Account Generator, please refer to the manual Oracle Purchasing Account Generator
Workflow Customization Example.
6. Will the account be generated for amount based/one time item lines?
No the Account will not be generated if you are using the Account Generator as seeded in Oracle Purchasing. Either the account should be manually entered or
the account generator should be customized.
7.When the charge account field is non updateable?
In the following cases the charge account field is not updateable:
1. If the destination type code is INVENTORY or SHOP FLOOR.
2. If the distribution is already encumbered.
3. If the PO is created from a encumbered Requisition
4. If the destination type code is Expense and
If the project is entered and the profile option PA: Allow Override of PA Distributions in AP/PO is set to NO
If the expense accrual code= RECEIPT