"Invalid or Inactive Vendor code": Since the upgrade to 15.8.1, the transactions generated by XOG are failing when the Post Transactions to Financials job runs.

book

Article ID: 195818

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

STEPS TO REPRODUCE:
1. Create a labor transaction in the Clarity UI
2. On the Invalid Transaction page, you see with Status New
3. Post Transactions to Financials job
4. Transaction gets posted
5. Create a transaction via XOG
6. On the Invalid Transaction page, you see with Status New
7. Post Transactions to Financials job

Expected results: The transaction gets posted
Actual result: The transaction fails with error: "Invalid or Inactive Vendor code"

Cause

This is caused by Oracle Bug id 18650065:

Wrong Results on Query with Subquery Using OR EXISTS or Null Accepting Semijoin

 

Environment

Release : 15.8.1

Component : CA PPM FINANCIAL MANAGEMENT

Resolution

Affected Oracle versions: 12.1.0.1 and 12.1.0.2

alter system set "_optimizer_null_accepting_semijoin"=false;

Additional Information

Here a sample used to XOG a transaction:

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_transaction.xsd"><Header action="write" externalSource="NIKU" objectType="transaction" version="15.8.0.260"/><Transactions><Transaction chargeCode="Planning" externalID="Q-GBP-PROJ_UK_STD2-37299-4" chargeable="1" inputTypeCode="Billable" projectID="PR1028"
  resourceID="adrianaRamos" taskID="5001314"
  transactionDate="2020-07-23" transactionType="L" units="10" voucherNumber="222" groupId="7981235002058">
  </Transaction></Transactions>
  </NikuDataBus>