Generate report for Transactional tables in AP

User_0ONK7

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?

User_0ONK7

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

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.