My Oracle Support Banner

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 later
Information in this document applies to any platform.


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
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’
 5)    Unable to create invoices with project information. Clicking on distributions button is giving error:  APP-SQLAP-97731: The system cannot generate distributions because tax calculation failed due to the following error: & Token1
 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
 1)    After receiving purchase order, Functional Rate Date, Project Functional Date, Project Rate Date (Getting these dates from PO) in expenditures are not matching with Item Date (Receipt Date) in expenditures
 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
 8)    User created a Security Profile to access all the Operating Units of a Business Group and set the MO:Security Profile Option at the Responsibility Level to this Security Profile. In OTL Responsibility when user tries to enter time card, the Projects LOV shows Projects from only one Operating Unit, projects from other Operating Units were not displayed
 9)    The standard hour rate is not visible in the Project-Purchasing timecard layout
 10)    PRC:Transaction Import does not import all the approved timecards to Projects. The transferred status of these approved timecards is showing as NONE in OTL and the output of Transaction import program displays as no Data found
 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
 2)    PRC: Transaction Exception Summary report and PRC: Transaction Exception Details report are  showing invoice distribution but receipt corresponding to this invoice distribution is interfaced to projects and pa_addition_flag for this invoice distribution is 'G'
 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
 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:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.