Hello,
I need to retrieve Chart of Accounts (COA) mapping data from the following tables:
- GL_COA_MAPPINGS
- GL_COA_MAP_SEGMENT_RULES
- GL_COA_MAP_ROLLUP_RULES
Currently, I use a SQL query to get this information, but I am looking for a standard Oracle API or web service (REST or SOAP) that can provide this data.
- Does Oracle provide any API or web service to access COA mapping data from these tables?
- If not, what is the recommended approach for programmatically retrieving this data?
- I am not able to find the BICC PVO for this data. Is there a relevant PVO available?
Sample query-
SELECT
rr.FROM_FLEX_VALUE_LOW AS COST_CENTER,
rr.TO_FLEX_VALUE AS BUSINESS_AREA
FROM
GL_COA_MAPPINGS m
JOIN GL_COA_MAP_SEGMENT_RULES sr
ON m.COA_MAPPING_ID = sr.COA_MAPPING_ID
JOIN GL_COA_MAP_ROLLUP_RULES rr
ON sr.SEGMENT_RULE_ID = rr.SEGMENT_RULE_ID
WHERE
m.NAME = 'COA Mapping IND'
AND rr.FROM_FLEX_VALUE_LOW = :P_CostCenter
Thank You