Customizing Payables Period Close Exceptions Report
Summary: My client is looking to customize the Payables Period Close Exceptions Report. They need additional fields in both the report parameters and the report output. However, it appears that the standard report utilizes the AP_PERIOD_CLOSE_EXCPS_GT table, which is a temporary table used internally by Oracle.
Has anyone worked on a similar customization, or does anyone have a suitable SQL query or suggestions on how to approach this customization while addressing the limitations of the temporary table?
Appreciate any guidance or examples.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):