My Oracle Support Banner

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

Last updated on NOVEMBER 17, 2022

Applies to:

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


This example of a 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:[9999] Task_id :[99999] EI_date:[31-MAY-13]Exp Type:[51150A Resident] non_labor_resource:[]person_id:[111]quantity:[-1160.47]denom_currency_code:[USD]acct_currency_code:[USD]transfer_ei:[]incurred_by_or
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


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

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