PAXTRTRX module: PRC: Transaction Import Failed in GET_PATC api sqlerror:100 (Doc ID 1569632.1)

Last updated on AUGUST 25, 2016

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

PAXTRTRX module: PRC: Transaction Import shows the following error.

10:39:23:  ValidateItem: log_message: Calling pa_transactions_pub.validate_transaction
10:39:23:  ValidateItem: Log: Stage:PATC:10.10.001 GET_STATUS API
10:39:23:  ValidateItem: Log: IN PARAMS : Project_id:[1089] Task_id :[13293] EI_date:[31-MAY-13]Exp Type:[51150A Resident] non_labor_resource:[]person_id:[273]quantity:[-1160.47]denom_currency_code:[USD]acct_currency_code:[USD]transfer_ei:[]incurred_by_or
g_id:[207]vendor_id:[]Sys
10:39:23:  ValidateItem: Log: Stage:PATC:10.10.002
10:39:23:  ValidateItem: Log: Stage:PATC:10.10.003
10:39:23:  ValidateItem: Log: Stage:PATC:10.10.004
10:39:23:  ValidateItem: Log: Calling Check_fin_Task_published
10:39:23:  ValidateItem: Log: Failed in GET_PATC api sqlerror:100
10:39:23:  ValidateItem: log_message: After pa_transactions_pub.validate_transaction
10:39:23:  ValidateItem: log_message: Validate_transaction has failed
10:39:23: Import1: log_message: Calling PA_GMS_API api
10:39:23: Import1: log_message: After PA_GMS_API api
10:39:23:: log_message: Updating txn interface table for txn rejected by validateitem
10:39:23:: log_message: Updated to reject count 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms