What Is The Table Name of Item Category and Account on Edit Mapping Set? (Doc ID 2011596.1)

Last updated on FEBRUARY 18, 2017

Applies to:

Oracle Fusion Purchasing - Version 11.1.11.1.0 and later
Oracle Fusion Purchasing Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

Where to get the relation between Item category Name (input) and Account (output: CUENTA) on the Edit Mapping Set: Purchasing Natural Account for Transaction Account Builder?

Business Case:
write a Query to obtain this information to develop a report.

Step:

1. Setup and Maintenance > Manage Implementation Projects –
2. Task Lists and Tasks: Procurement > Define Common Procurement Configuration > Define Transaction Accounting for Procurement > Define Transaction Account Rules > Define Transaction Accounts > Manage Mapping Sets: Purchasing
3. Select Purchasing Natural Account for Transaction Account Builder
4. Edit Mapping Set: Purchasing Natural Account for Transaction Account Builder


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms