Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Generate report for Transactional tables in AP
Uma Scherer
Rank 2 - Community Beginner
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?
0
Best Answer
-
Thanks @MandeepGupta and @Sumanth V -Oracle, I have been able to achieve it by modifying!
0
Answers
-
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.
0 -
I don't think there exist any such view. There are views available but you need to modify based on your requirement:
Thanks.
1
