You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL query/Table to fetch Transaction type from Review Cost Accounting Distribution Tab

in Costing 8 comments

Hi Support,

 I need Base Table information to get Type 'Acquisition cost Adjustment' as Yellow highlighted field in provided screenshot.

Navigation —> Supply Chain Execution —> Cost Accounting —> Task —> Review Cost Accounting Distributions —> Give parameter (as shown in image) —> Click on Search.

Currently we are fetching details from cst_all_cost_transactions_v table. We can see the Transaction type as 'Acquisition Cost Adjustment' in cst_all_txn_types_v. As per latest discussion with Support they said, "Acquisition Cost Adjustment records will not be available in fusion.cst_all_cost_transactions_v."

Please help me with the backout query or tables to fetch the Acquisition Cost Adjustment details as as per given screenshot.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!