Skip to Main Content

AI Services

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Selecting data from ZX_LINES

Patryk BanasiakMar 11 2024

Hello,

There is no index on column, "last_update_date" in table FUSION."zx_lines" table. - as a result, the data takes a very long time to download - or the query ends with an error

What other table can we use to retrieve data for reports?

So far, we have downloaded data from ZX_lines:APPLIED_FROM_EVENT_CLASS_CODE
TAX_JURISDICTION_CODE
PLACE_OF_SUPPLY_TYPE_CODE
TAX_DATE
TAX_POINT_DATE
TAX_AMT_TAX_CURR
TAX_AMT_FUNCL_CURR
TAXABLE_AMT_TAX_CURR
TAXABLE_AMT_FUNCL_CURR
EXEMPT_CERTIFICATE_NUMBER
CANCEL_FLAG
TAX_AMT_INCLUDED_FLAG
SETTLEMENT_FLAG
TAX_ONLY_LINE_FLAG
TAX_POINT_BASIS
WHT_GROUP_ID

Comments
Post Details
Added on Mar 11 2024
0 comments
49 views