nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Generate report for Transactional tables in AP

Uma Scherer

I want to create a data extract for transactional tables (AP_BATCHES_ALL, AP_CHECKS_ALL, AP_INVOICES_ALL etc). I cannot find the Views for these tables in Financials to select all columns. Is there any alternative way to write the SQL query without having to manually write each column?

Find more posts tagged with

Accepted answers

Uma Scherer

Thanks @MandeepGupta and @Sumanth V -Oracle, I have been able to achieve it by modifying!

All comments

Sumanth V -Oracle

@User_0ONK7 -

Could you please confirm which application you are using and encountering this challenge? The table names mentioned appear to be source tables. Are you working with OTBI? Kindly confirm so we can assist further.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24037/generate-report-for-transactional-tables-in-ap

I don't think there exist any such view. There are views available but you need to modify based on your requirement:

AP_INVOICE_EXTRACT_HEADER_V

Thanks.

Uma Scherer

Thanks @MandeepGupta and @Sumanth V -Oracle, I have been able to achieve it by modifying!