Oracle Project Costing Troubleshooting Guide Including Integration Flows
(Doc ID 1965211.1)
Last updated on JUNE 21, 2023
Applies to:
Oracle Project Costing - Version 12.1.3 and laterInformation in this document applies to any platform.
Purpose
This document has been created to identify and provide troubleshooting assistance for common issues in the Oracle Project Costing area--including Purchasing to Payables flow integration, OTL integration, upgrade issues, etc. This guide will help identify bugs frequently seen by development and provide users with basic issue resolution and debugging techniques.
Troubleshooting Steps
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Troubleshooting Steps |
| PA-AP Integration PRC: Interface Supplier Costs/ Interface Expense Report from Payables Issues : |
| 1) Validated invoice is not interfacing to projects by running PRC: Interface Supplier Cost |
| 2) While running PRC: Interface Supplier Cost, records are getting rejected with rejection reason ‘The expenditure organization is not active’ (PA_EXP_ORG_NOT_ACTIVE) |
| 3) Discount is not interfacing to projects |
| 4) Discount lines are not interfaced to projects. These are being reported in EXC: Transaction Exception reports |
| 5) Invoices matched to purchase order are not getting interfaced to projects in Grants project |
| 6) The base amount for a Purchase Order matched Invoice did not get interfaced to Projects although its exchange rate variance did |
| 7) User is facing issue with discarded Self Assessed Tax lines which are not interfacing to Projects |
| 8) PRC: Interface Supplier Cost finished with the following error: ORA-20003: import1_prog:ORA-00060: deadlock detected while waiting for resource |
| 9) Supplier invoice is not getting interfaced to Projects |
| 10) Payables Credit Memo matched to a Purchase Order is not getting interfaced to Projects in R12 |
| 11) User wants variances from Payables to not get interfaced to Projects |
| 12) Error "Functional and transaction currency costs must be equal" is encountered while running PRC: Interface Supplier Cost |
| 13) PRC: Interface Expense Report is erroring out with error code 100 |
| 14) Expense Reports are not getting interfaced to Projects. |
| 15) Performance issue with PRC:Interface Supplier Costs. |
| 16) User cannot view the credit account of AP related transactions in View Accounting |
| Payables Invoice/Expense Report Entry/Validation Issues : |
| 1) Invoice form allows expenditure_item_date to be entered outside employee active dates which is later failing with no-assignment error |
| 2) Invoice batch validation errors out while tax calculation when neither invoice number nor operating unit is not given as input |
| 3) User is able to create payables invoices with project information, having an invoice date beyond project start and end dates. Revenue and billing can also be generated for such invoices |
| 4) When user enters the task information to create an invoice, following error is encountered: ‘APP-PA-19270: The task is not chargeable’ |
| 6) Invoice validation for projects related invoices errors with “An unexpected error has occurred. Please contact your system administrator. Call to EBTax api Calculate Tax failed” |
| 7) Payables Open Interface Import process for the intercompany AP invoices from Projects are rejected with: PA Flexbuild Failed - Project Flexbuilder failed with error |
| 8) When attempting to create expense report, an error is encountered : APP-SQLAP-97734: The system cannot generate distributions for line 1 because: &TOKEN2 |
| Reconciliation Issues : |
| 1) Rounding issue between PA and AP discounts |
| Distribute Supplier Cost Adjustments/Distribute Expense Report Adjustment Issues : |
| 1) User is running PRC: Distribute Supplier Invoice Adjustment Costs and getting "Invalid Accounting Flexfield" as exception in the output report |
| 2) PRC: Distribute Expense Report Adjustments completes in error : Warning in Flex Validation for line '5888451:ALL:Y:122.64' Null GL# 50388 key flexfield is not allowed |
| 3) PAVDVC: PRC: Distribute Supplier Cost Adjustments Gives ORA-1403 errors in the PAVDVC logs even if there are no exceptions. |
| Expenditure Inquiry Issues : |
| 1) Unable to view Employee/Supplier details in the Expenditure Inquiry screen for upgraded Supplier transactions |
| Supplier/Procurement Tab Issues : |
| 1) Unable to view Payment Number on the Supplier tab of Projects home page |
| Upgrade Issues : |
| 1) UPG: Upgrade Transaction Attributes is not updating the Supplier attributes |
| 2) User is expecting the system_reference4 and system_reference5 columns of pa_cost_distribution_lines_all to be populated for AP invoice transactions in R12 |
| 3) Datafix Needed for Release 12.2.3 for Corruption Found in 13833481 |
| PA-PO Integration |
| 2) When user issues a return to supplier for a Purchase Order, two entries are being sent to Projects when running PRC: Interface Supplier Costs leading to inflation in costs |
| 3) On Upgraded 11i Receipt, Accrue on receipt flag is Y but still invoice is getting interfaced to projects / 11i Accrue on receipt flag is Y still receipt is not getting picked |
| 4) PO receipts are not getting interface to projects due to rounding limit |
| 5) In 11i, User expects only receipt cost to get interfaced to Projects for a PO distribution with Accrue at Receipt checked. The cost is getting interfaced from invoices instead |
| 6) After R12 upgrade the quantity shown in Expenditure Inquiry is not quantity but the dollar value from the PO Line |
| 7) User cannot view the credit account of receipt accruals in View Accounting |
| 8) Receipts on POs linked to a trackable item do not get imported to Projects |
| 9) Receipt is not getting interfaced to projects |
| 10) Receipt is not getting interfaced to projects |
| PA-OTL Integration |
| 1) Labor costs are getting transferred to GL even when implementation option to interface labor cost to GL is set to No |
| 2) PRC: Transaction Import for source 'ORACLE TIME AND LABOR', fails with ORA-20002: pre_import:ORA-01422: exact fetch returns more than requested number of rows |
| 3) When attempting to import OTL transactions via PRC: Transaction Import process, NO_ASSIGNMENT error is encountered |
| 4) When a project is set to Pending Close status, new timecards cannot be created for the project in OTL although existing timecards can be viewed |
| 5) After upgrade to 12.1 HRMS RUP5, when User runs a custom program to create projects related timecards using OTL responsibility, error "Invalid Project" is encountered |
| 6) Some timecards remain in status “In Progress” and do not get imported to Projects after running PRC:Transaction Import |
| 7) When attempting to create a timecard using Projects-Payroll layout, receive the error : Invalid expenditure type and expenditure type class combination |
| 9) The standard hour rate is not visible in the Project-Purchasing timecard layout |
| 11) User is unable to create a timecard against any project/task combination for a Purchase Order that has Non-Contingent Worker enabled project information stamped, in the Services Procurement flow |
| 12) User tries to enter a timecards using Projects-Purchasing layout. Entering a project and task and then clicking on the PO Number LOV displays duplicate PO numbers |
| 13) User is unable to find a desired Purchase Order in the PO Number LOV after entering a Project and Task in the Projects-Purchasing layout |
| 14) PRC: Transaction Import is not creating reversal line for adjusted timecards which are already Interfaced to projects |
| 15) User feels that timecard has not been imported to the correct OU in Projects |
| 16) Operating Unit Derivation for Oracle Time and Labor Timecard Entry |
| Exception Report Issues |
| 1) Invoice is not showing up in exception report when run by GL period for current open period. However same invoice is showing up when run by PA period for current open period |
| Patching Issues |
| 1) Patch 17861729:R12.PJ_PF.B (cumulative release 1 on the top of 12.1.3 delta6) is failing with invalid object PAAPIMP_PKG |
| 2) Getting error ORA- 01476 on view pa_proj_po_distributions |
| Others |
| 1) Project Search Inquiry(PSI) is not showing the hours properly if the unit of measurement(UOM) at expenditure items level is having translation of 'Hours' |
| 2) Work In Progress (WIP) transactions are stuck in transaction import |
| 3) PRC:Transaction Import is reporting duplication transaction exceptions for custom transaction source |
| Critical Patches and Datafixes: |
| Integrating components consolidated critical codefix patches: |
| Diagnostics Necessary to Work the Issue: |
| 1) Issue Class: Interfacing of invoices to projects. |
| 2) Issue Class: Interfacing of receipt to projects. |
| 3) Issue Class: Interfacing of timecards to projects. |
| 4) Issue Class: Payroll Related Issues. |
| 5) Issue Class: Workflow Related Issues. |
| 6) Issue class: Performance Related Issues: |
| References |