Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need table name storing reporting period and status after "Finalize Transactions for Tax".

Accepted answer
12
Views
2
Comments

We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS job finalizes the tax reporting period in Oracle Fusion.

We are developing a custom report that will include the finalized reporting period and the submission status (whether submitted or not).

If this data is stored in a temporary table, we require the table or view name where the information is held and the duration for which the temporary table retains the data after the ESS job is executed.

Best Answer

  • Hi @User_FINT4 ,

    Welcome to the Oracle Analytics community and forum.

    Your question is about data, tables, related to a Fusion product, and not an Oracle Analytics product. You are maybe using Publisher for reporting, but the data aspect isn't "owned" by Publisher as it just connects to whatever source you use it with.

    Fusion products, including data and reporting, are covered in a separate independent forum: https://community.oracle.com/customerconnect

    When you visit that forum, you see that there are a lot of categories, but almost each Fusion app has a reporting and analytics category. That will be the best place to ask your Fusion data question.

Answers