My Oracle Support Banner

Payables Transactions Stuck In Projects Interface Audit Table After Running the "PRC: Interface Supplier Costs" program (Doc ID 3038902.1)

Last updated on AUGUST 02, 2024

Applies to:

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

Symptoms

Payables (AP) transactions stuck in the Projects (PA) interface tables.

Projects "PRC: Interface Supplier Costs" program (PAAPIMP_SI) executed but DOES NOT transfer the AP transactions to Projects.

The cost is being added to the projects and the AP transactions get stuck in the PA interface Audit table PA_TXN_INTERFACE_AUDIT_ALL

The output of the "Supplier Cost Interface Audit" report shows the following rejection code for all transactions:

New Transaction Creation not allowed for this project status Analysis

The log file of execution of the "PRC: Interface Supplier Costs" program shows the following set of log messages repeated for each AP transaction (Invoice_ID) processed:

07:27:07: ValidateItem: log_message: Calling pa_transactions_pub.validate_dff
07:27:07: ValidateItem: log_message: Calling pa_transactions_pub.validate_transaction
07:27:07: ValidateItem: Log: Stage:PATC:10.10.001 GET_STATUS API
07:27:07: ValidateItem: Log: IN PARAMS : Project_id:[381984] Task_id :[1930725] EI_date:[29-SEP-23]Exp Type:[Allocated Soil Analysis] non_labor_resource:[]person_id:[]quantity:[274.16]denom_currency_code:[USD]acct_currency_code:[USD]transfer_ei:[]incurre
d_by_org_id:[113]vendor_i
07:27:07: ValidateItem: Log: Actual Task Id : Task_id :[1930725}
07:27:07: ValidateItem: Log: Stage:PATC:10.10.002
07:27:07: ValidateItem: Log: Stage:PATC:10.10.003
07:27:07: ValidateItem: Log: Stage:PATC:10.10.004
07:27:07: ValidateItem: Log: Stage:PATC:10.10.008
07:27:07: ValidateItem: Log: PROCEDURE return_error_SkipTC ::
07:27:07: ValidateItem: Log: PATC ERROR:PA_NEW_TXNS_NOT_ALLOWED
07:27:07: ValidateItem: log_message: After pa_transactions_pub.validate_transaction
07:27:07: ValidateItem: log_message: Validate_transaction has failed
07:27:07: Import1: log_message: Done calling ValidateItem API
07:27:07: Import1: 19613078 Calling CheckDupItem_OTL_TM for X_trx_source:AP INVOICE
07:27:07: Import1: 19613078 Calling CheckDupItem_OTL_TM for l_OrigTxnRefTab(j):36899157
07:27:07: Import1: 19613078 Calling CheckDupItem_OTL_TM X_status:PA_NEW_TXNS_NOT_ALLOWED
07:27:07: Import1: log_message: Calling PA_GMS_API api
07:27:07: Import1: log_message: After PA_GMS_API api
07:27:07:: log_message: Updating txn interface table for txn rejected by validateitem
07:27:07:: log_message: Updated to reject count 1
07:27:07:: log_message: l_txn_rejected_sr4tab(NVL(l_SysRef4Tab(j),0) ) :90543940
07:27:07:: log_message: l_txn_rejected_sr5tab(NVL(l_SysRef5Tab(j),0) ) :90543940
07:27:07:: log_message: NVL(l_SysRef5Tab(j), 0) :12760344

 

Steps to reproduce:

  1. Log into Oracle Applications using a Payables Responsibility.
  2. Open the Invoice Workbench screen
    (N) Invoices > Entry > Invoices
  3. Create a brand new Invoice with Projects details.
  4. Switch to a Projects Responsibility
  5. Open the Standard Request Submission (SRS) screen
    (N) Other > Request > Run
  6. Run the "PRC: Interface Supplier Costs" program to try transferring the cost to relevant Projects.
  7. After complete, notice records in the Projects interface Audit table PA_TXN_INTERFACE_AUDIT_ALL

 

 

 

Cause

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
Symptoms
Cause
Solution
References


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