Tableau Connector for Oracle Fusion Cloud Financials

Build 26.0.9770

JointVentureTransactionsTransactionChanges

Returns the change history records for joint venture transactions, capturing updates to attributes such as stakeholder, ownership definition, project, and status.

Columns

Name Type SupportedFinders Description
JointVentureTransactionstransactionId [KEY] Long The unique identifier of the joint venture transaction.
TransactionChangeId [KEY] Long The unique identifier of the joint venture transaction change.
ChangeReason String The reason for the manual change to the joint venture transaction.
ChangeReasonDetails String Additional text to describe the reason the joint venture transaction was manually changed.
BeforeTransactionDate Date The previous transaction date assigned to the transaction.
AfterTransactionDate Date The new transaction date assigned to the transaction.
BeforeStatus String The previous status assigned to the transaction.
AfterStatus String The new status assigned to the transaction.
BeforeOwnershipDefinition String The previous ownership definition assigned to the transaction.
AfterOwnershipDefinition String The new ownership definition assigned to the transaction.
BeforeStakeholder String The previous name of the direct billed stakeholder assigned to the transaction.
BeforeStakeholderDescription String The previous description of the direct billed stakeholder assigned to the transaction.
AfterStakeholder String The new name of the direct billed stakeholder assigned to the transaction.
AfterStakeholderDescription String The new description of the direct billed stakeholder assigned to the transaction.
CreationDate Datetime TransactionFinder The date and time when the joint venture transaction change was created.
CreatedBy String TransactionFinder The user who created the joint venture transaction change.
BeforeAssignmentRule String The previous ownership definition assignment rule assigned to the transaction.
AfterAssignmentRule String The new ownership definition assignment rule assigned to the transaction.
BeforeDistributionOnlyFlag Bool The previous distribution only value assigned to the transaction.
AfterDistributionOnlyFlag Bool The new distribution only value assigned to the transaction.
BeforeProject String The name of the previous project assigned to the transaction.
BeforeProjectNumber String The previous project number assigned to the transaction.
AfterProject String The name of the new project assigned to the transaction.
AfterProjectNumber String The new project number assigned to the transaction.
BeforeTask String The name of the previous task assigned to the transaction.
BeforeTaskNumber String The previous task number assigned to the transaction.
AfterTask String The name of the new task assigned to the transaction.
AfterTaskNumber String The new task number assigned to the transaction.
BeforeExpenditureType String The previous expenditure type assigned to the transaction.
BeforeExpenditureTypeDescription String The description of the previous expenditure type assigned to the transaction.
AfterExpenditureType String The new expenditure type assigned to the transaction.
AfterExpenditureTypeDescription String The description of the new expenditure type assigned to the transaction.
BeforeExpenditureItemDate Date The previous expenditure item date assigned to the transaction.
AfterExpenditureItemDate Date The new expenditure item date assigned to the transaction.
BeforeExpenditureOrganization String The previous expenditure organization assigned to the transaction.
AfterExpenditureOganization String The new expenditure organization assigned to the transaction.
BeforeExpenditureBusinessUnit String The previous expenditure business unit assigned to the transaction.
AfterExpenditureBusinessUnit String The new expenditure business unit assigned to the transaction.
SysEffectiveDate Date TransactionFinder Effective date of the query.
AccountingDate Date TransactionFinder The date used to determine the accounting period for the joint venture transaction.
AccountingPeriod String TransactionFinder The name of the accounting period associated with the joint venture transaction.
Agreement String TransactionFinder The name of the carried interest agreement associated with the joint venture transaction.
AssignmentRule String TransactionFinder The name of the ownership assignment rule applied to the joint venture transaction.
BasisSource String TransactionFinder The source of the amount used as the basis for the overhead calculation.
CreatedByJointVentureFlag String TransactionFinder Indicates whether the transaction was created by joint venture processing.
DirectBilledStakeholder String TransactionFinder The name of the direct billed stakeholder assigned to the joint venture transaction.
DistributionType String TransactionFinder The type of transaction that the distribution represents, such as expense or revenue.
ExpenditureBusinessUnit String TransactionFinder The name of the business unit that incurred the expenditure.
ExpenditureItemDate Date TransactionFinder The date on which the expenditure was incurred.
ExpenditureOrganization String TransactionFinder The name of the organization that incurred the expenditure.
ExpenditureType String TransactionFinder The name that identifies the expenditure classification.
Finder String A named finder reference used to filter or locate specific joint venture transaction changes when querying.
JointVenture String TransactionFinder The name of the joint venture associated with the transaction.
LastUpdateDate Date TransactionFinder The date and time when the joint venture transaction was last updated.
LastUpdatedBy String TransactionFinder The user who last updated the joint venture transaction.
Ledger String TransactionFinder The name of the ledger associated with the joint venture transaction.
Method String TransactionFinder The unique name of the overhead method applied to the joint venture transaction.
OriginalDirectBilledStakeholder String TransactionFinder The name of the original direct billed stakeholder assigned to the joint venture transaction.
OriginalOwnershipDefinition String TransactionFinder The name of the original ownership definition used to distribute the joint venture transaction.
OwnershipDefinition String TransactionFinder The name of the ownership definition used to distribute the joint venture transaction.
Project String TransactionFinder The name of the project associated with the joint venture transaction.
ProjectNumber String TransactionFinder The unique number of the project associated with the joint venture transaction.
SearchAllText String TransactionFinder A search value used to identify joint venture transaction changes that contain the specified text in any of their string attributes.
Source String TransactionFinder The source of the joint venture transaction.
Status String TransactionFinder The status of the joint venture transaction.
Task String TransactionFinder The name of the project task associated with the joint venture transaction.
TaskNumber String TransactionFinder The unique number of the project task associated with the joint venture transaction.
TransactionDate Date TransactionFinder The date of the joint venture transaction.
TransactionDescription String TransactionFinder The description of the joint venture transaction.
TransactionId Long PrimaryKey The unique identifier of the joint venture transaction.
TransactionType String TransactionFinder The type of the joint venture transaction.
EffectiveDate Date This query parameter is used to fetch resources which are effective dated as of the specified start date.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770