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"
This is caused by Oracle Bug id 18650065:
Wrong Results on Query with Subquery Using OR EXISTS or Null Accepting Semijoin
Release : 15.8.1
Component : CA PPM FINANCIAL MANAGEMENT
Affected Oracle versions: 12.1.0.1 and 12.1.0.2
alter system set "_optimizer_null_accepting_semijoin"=false;
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>