Commonly used Tables in Oracle E-Business Suite Payables

 In Oracle E-Business Suite (EBS), the following tables are commonly used to store payable invoice information:

1. AP_INVOICES_ALL: This table stores header information for invoices entered into Payables. Each record represents an invoice.

2. AP_INVOICE_LINES_ALL: Contains information about the individual lines (line items) of each invoice, such as item description, amount, tax details, etc. 

3. AP_INVOICE_DISTRIBUTIONS_ALL: Stores distribution information for each invoice line, including the account code combination, amount, and other accounting details.

4. AP_PAYMENT_SCHEDULES_ALL: If an invoice is scheduled for multiple payments, this table stores the payment schedule information, including due dates and payment amounts.

5. AP_CHECKS_ALL: If payments are made by checks, this table contains information about the issued checks, including check numbers, amounts, and payment dates.

6. AP_PAYMENT_HISTORY_ALL: Stores payment history information, such as payment numbers, dates, and status.

7. AP_PAYMENT_SCHEDULES_PAY: Contains detailed payment schedule information for scheduled payments.

8. AP_CHECKS_ALL: This table stores information about payments made by checks, including check numbers, amounts, and payment dates.

9. AP_CHECKS_ALL: This table contains information about payment batches, including batch numbers, status, and processing dates.

10. AP_BANK_ACCOUNTS_ALL: Stores details about bank accounts used for payments, including bank account numbers, names, and other relevant information.

These are some of the key tables in Oracle EBS Payables where invoice and payment-related information is stored. Depending on the specific needs of your organization and the configuration of your EBS instance, there may be additional tables or variations in table names. Always refer to Oracle's official documentation or consult with your system administrator for the most accurate and up-to-date information.

How to Learn Power BI for Free

 

Learning Power BI for free is easy if you follow a structured approach. Here’s a step-by-step guide with the best free resources:

Step 1: Understand the Basics

Start by learning what Power BI is and how it works. Microsoft offers a great introduction:
🔹 Microsoft Power BI Overview

Step 2: Take Free Courses

✅ Microsoft Learn Power BI Course (Official & Best for Beginners)
🔗 Microsoft Learn Power BI

✅ EDX - Analyzing Data with Power BI (Free course by Microsoft)
🔗 EDX Course

✅ YouTube Tutorials (Practical video learning)

• Guy in a Cube – YouTube Channel
• Curbal – YouTube Channel
• Palium Skills - YouTube Channel

Step 3: Get Hands-On Practice

📌 Download Power BI Desktop (Free Tool)
🔗 Power BI Download

📌 Use Free Datasets for Practice
🔗 Kaggle Datasets
🔗 Data.gov

Step 4: Join Communities & Forums

💬 Power BI Community – Join Here
💬 Reddit - r/PowerBI – Visit Here

Step 5: Work on Real Projects

✔️ Recreate dashboards from YouTube tutorials
✔️ Analyze your own data (e.g., expenses, sales, or business metrics)
✔️ Participate in Power BI challenges

🚀 Consistency is key! If you practice daily, you’ll master Power BI in a few weeks! Need help with a specific topic? Let us know!

Palium Skills offers instructor led guided courses to help individuals learn Power BI more easily. It also conducts corporate programs on Power BI for employees working in an organization and help them develop interactive dashboards and data extraction, transformation and loading activities. For details about the Power BI courses in Kolkata, contact us through email or better still call them!

About Palium Skills

Palium Skills is a professional training institute located in Kolkata, India, offering a diverse range of courses in Information Technology and foreign languages. Established in 2012, the institute has garnered immense popularity and positive reviews for its quality education and experienced faculty.

Course Offerings:

• Information Technology:

  • Programming Languages: Java, Python, C/C++
  • Data Analysis: Advanced Excel, Business Analytics
  • Database Management: SQL Fundamentals, Oracle
  • Software Testing: Selenium Automation
  • Cloud Computing: AWS
  • Project Management: PMP, ITIL, Prince2, DevOps

• Foreign Languages:

  • French
  • German
  • Spanish
  • Japanese
  • Chinese
  • Korean
  • Spoken English, IELTS, TOEFL

The institute offers flexible learning modes, including both online and offline classes, to cater to the diverse needs of its students. 

For more detailed information about their courses, schedules, and enrollment procedures, you can visit their official website: https://paliumskills.com

 

How to create a Vendor or Supplier in Oracle E-Business Suite Payables module

 Creating a vendor (supplier) in Oracle E-Business Suite (EBS) Payables involves the following steps:

1. Sign In to Oracle EBS: Log in to your Oracle E-Business Suite instance using your credentials.

2. Navigate to Suppliers: Access the Suppliers form within the Payables module. You can typically find this under the "Supplier" or "Payables" menu depending on your organization's setup.

3. Enter Supplier Information: Once in the Suppliers form, click on the "Create" or "Enter" button to start creating a new supplier.

4. Provide Basic Supplier Information: Fill out the necessary fields with basic information about the supplier. This usually includes the supplier name, address, contact information, and other relevant details.

5. Supplier Site Information: Enter details specific to the supplier site, such as the address where goods or services are received.

6. Supplier Contacts: Add contact details for individuals associated with the supplier, such as accounts payable contacts or other relevant personnel.

7. Additional Details: Depending on your organization's requirements, you may need to provide additional information such as payment terms, payment methods, tax information, bank account details, etc.

8. Save Supplier: Once all necessary information is entered, save the supplier record.

9. Review and Confirm: Review the supplier details to ensure accuracy. Make any necessary adjustments before confirming the creation of the supplier record.

10. Submit: After reviewing and confirming the details, submit the supplier record for processing.

11. Confirmation: You may receive a confirmation message indicating that the supplier has been successfully created.

It's important to note that the exact steps and terminology may vary slightly depending on your organization's specific configuration and the version of Oracle EBS you are using. If you encounter any difficulties or uncertainties during the process, refer to your organization's internal documentation or consult with your system administrator for guidance.