Need guidance on an Oracle EBS R12 tax account setup issue.
How can we achieve automatic division-wise tax account derivation with a single OU and multiple balancing segments in Oracle EBS R12?
Our Setup:
• Single Operating Unit
• Balancing Segment = Division (we have 11 divisions)
• Chart of Accounts format: 01.XX.00.00.000.000.XXXXXXXX.00.0000.0000
(where XX = Division segment)
Requirement:
I want to define only ONE tax code (e.g. 18% GST) but the tax account should automatically derive based on the Division (Balancing Segment) of the transaction.
Example:
• Division 11 transaction → Tax Account: 01.11.00.00.000.000.XXXXXX
• Division 12 transaction → Tax Account: 01.12.00.00.000.000.XXXXXX
Any help or guidance would be highly appreciated.