Oracle STUDY Plans

1. OCI 2025 Foundation Associate

2. OCI 2025 AI Foundations Associate
3. Oracle Fusion AI agent Studio Foundations Associate and Professional
4. OCI 2025 Generative AI professional
5. Oracle Data Platform 2025 Foundation associ

⏳TO Take Oracle Cert exam

1. PLSQL PROFESSIONAL
2. SQL associate

AI & AGENTIC AI learning

- RAG architech
- Orchestration Agents
-

List applications being used in BBY and get experience and add them in Resume

➡️ Learn Below
1. Oracle EBS Functional overview (
-- SCM , FIN Domains
-- P2P, O2C, R2R, F2A cycles
-- AP, AR, PO, FA, GL, INV, OM Modules
-- Technical Flow and Tables and Imp Jobs
--E business Tax module for Deloitte
--Manufacturing Execution
Involves: BOM, WIP, Inventory, CostManagement

2. PRACTICE all SQL , PLSQL QnA

3. Oracle APPS
Oracle Application Framework (OAF)
Oracle Applications Forms
-Forms personalization Procedures
- Forms Parameters and Triggers
- form Devlopment from scratch

OIC
OAF

Oracle XML/BI Publisher

- Concurrent registration
- what is executable for XML publisher
- How to Call one CC program from another
FND_REQUEST.SUBMIT_REQUEST(
application => 'XXCUS',
program => 'XX_CHILD_PROG',
sub_request => TRUE);
- how to call CC FROM shell script
Source EVBS utility and call through CONCSUB utility.

Oracle Workflow
Oracle Applications Reports
Oracle Interfaces, Conversions,
- AOL objects
-
[Link] Experience - end-to-end Oracle EBS enhancements
[Link] Linux and Unix shell commands, scripting

Public Profiles
[Link]

[Link]

[Link]

------------------------
1. RDBMS - relational database management system
-->Oracle, MySQL, Microsoft SQL Server, PostgreSQL, and SQLite, PLSQL
[Link]

[Link] Database-> popular RDBMS used for storing, managing, and retrieving data in various applications, including mission-critical workloads and
app development

[Link] --> Basics at 2 other Notes

[Link]

4. Oracle Performance tuning Query Optimization concepts with Oracle hints , TKPROF, EXPLAIN PLAN tool
DBMS_SQLTUNE, SQL Monitoring, and AWR report

[Link] dynamic SQL -->If we don't know SQL test till run time, use EXECUTE IMMEDIATE to run SQL
[Link]

6. Troubleshooting /debugging skills using TOAD /Oracle SQL Developer

-YouTube Videos

7. Master Data Management (MDM) processes ,ETL Processes

Data Modelling, Data Warehousing , data cleansing, data maintenance and tools

8. Agile best practices, SDLC (Software Development Life Cycle)

9. Git, GitHub, GitHub Actions ,

CI/CD (Continuous Integration/Continuous Delivery) pipeline , Jenkins

Study Links
Unix shell script command practice
Practice - in Leetcode
[Link]
[Link]

➡️ORACLE EBS cycles

P2P
[Link]

OTC
[Link]

R2R
[Link]

✅ Self Introduction
What to Include in Your Introduction:

1. Name and current role/title

2. Total years of experience and core skills
3. Modules worked on (Financials, SCM, Manufacturing, etc.)
4. Technical expertise (PL/SQL, Oracle Forms, Reports, Workflow, BI Publisher, OAF, etc.)
5. Project highlights / Domain experience (e.g., Manufacturing, Supply Chain)
6. Current company and nature of work
7. Certifications (if any)
8. What you’re looking for in your next role

🔁 Template for Self-Introduction

Hi, good evening.
My name is Vardhaman Boraganve, and I’m from Belagavi, Karnataka. I have around 6 years of experience as an Oracle EBS Technical Analyst, with a
strong focus on developing, customizing, and supporting Oracle E-Business Suite applications.

My core technical expertise lies in PL/SQL, Oracle Reports, Oracle Workflow, and BI Publisher. I’ve worked extensively on the Supply Chain
Management (SCM) and Finance modules, handling RICE components (Reports, Interfaces, Conversions, and Extensions), custom interfaces, and data
migration tasks across various project lifecycles.

Currently, I’m working with Accenture Solutions, where I’m responsible for enhancement development, issue resolution, and production support
activities in Oracle EBS.
I collaborate with cross-functional teams to ensure timely delivery and optimal performance of custom solutions.

I’m now seeking a new opportunity where I can further sharpen my EBS technical skills and contribute to complex ERP implementations, upgrades, or
transformation projects.

Outside of work, I enjoy traveling on my bike, reading books, and playing cricket, which help me stay energized and balanced.

0️⃣Roadmap to learn EBS

Step-by-step plan to help you learn

Oracle E-Business Suite (EBS) 12c,
covering both functional and technical aspects:

---

🔰 Step 1: Understand the Basics of Oracle EBS

✅ What to Learn:
Overview of Oracle EBS
Architecture of Oracle EBS 12c (latest: 12.2.x)
Key modules (Financials, SCM, HRMS, etc.)
Navigation and responsibilities

🎯 Resources:
Oracle EBS Documentation Library

YouTube channels: Oracle EBS, Oracle Fusion Apps Learning

---

🛠️ Step 2: Technical Track (Oracle EBS Technical Developer Path)

Modules to Focus:

1. Application Object Library (AOL)

2. Oracle Forms and Reports
3. PL/SQL & SQL
4. Oracle Workflow
5 Concurrent Programs
6. BI Publisher
7. Oracle APEX (optional
8. Web ADI & Alerts
9. OAF (Oracle Application Framework)

Tools to Learn:
TOAD / SQL Developer
Oracle Forms Builder
Oracle Reports Builder
Workflow Builder

Sample Topics:
Developing RICEW components
Customizing standard forms
Registering concurrent programs
Building BI Publisher reports
Working with APIs and Interfaces

---

📊 Step 3: Functional Track (Business Process Understanding)

Modules to Learn:

Pick based on domain interest:

Financials – GL, AP, AR, FA, CM

SCM – Inventory, Purchasing, Order Management

Key Concepts:

Business Flows (P2P, O2C, R2R)

Configuration through front-end

Journal Entries, Invoices, Requisitions

Functional setups (Chart of Accounts, Legal Entity, etc.)

Resources:

Oracle User Guides (from Oracle Docs)

Hands-on using Vision instance

---

🧠 Step 4: Hands-On Practice

Options:

Use Oracle Vision Instance

You can request access to Vision from vendors or use Oracle VM images (if available).

Install EBS on Oracle VM (for technical practice)

---

📘 Step 5: Learn by Project

Build Sample Project:
Technical: Create a report, register a concurrent program, use an API to insert data

Functional: Complete a P2P cycle or O2C cycle

End-to-end RICEW object delivery

1️⃣ EBS Module wise 100 QnA

100 advanced-level Oracle Apps Technical interview questions and answers, organized module-wise with 20 questions each for:

✅ Order Management (OM)

✅ Inventory (INV)
✅ Purchasing (PO)
✅ Accounts Receivable (AR)
✅ Accounts Payable (AP)
---
📦 1. Order Management (OM)– 20 Interview Q&A
---

🔹1. How do you insert a sales order using interface tables?

Use these tables:
OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
Then run Order Import concurrent program

🔹2. Which base tables are populated after Order Import?

OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
WSH_DELIVERY_DETAILS
WSH_DELIVERY_ASSIGNMENTS

🔹3. How do you debug Order Import errors?

Check:
OE_ORDER_HEADERS_IFACE_ALL.INTERFACE_STATUS
OE_ORDER_LINES_IFACE_ALL.INTERFACE_STATUS
OE_INTERFACES_ERRORS

🔹4. Which API is used to cancel an order line?

OE_ORDER_PUB.PROCESS_ORDER (action => 'CANCEL');

🔹5. How do you personalize the Order Entry form to make a field mandatory?
Use Form Personalization:

Trigger: WHEN-NEW-FORM-INSTANCE

Condition: Always True

Action: Required = TRUE

---

🔹6. What are the key attributes for Order Import?

Sold-to customer
Ship-to site
Line item
Pricing details

---

🔹7. How is order reservation handled technically?

Use:

INV_RESERVATIONS

APIs like INV_RESERVATION_PUB

---

🔹8. How can you check order hold information?

Query:

OE_HOLDS_ALL

OE_HOLD_SOURCES_ALL

---

🔹9. What workflow handles order approvals?

Order Flow - Generic with Header Level Approvals

---

🔹10. What happens when you book an order?

Order status changes

Reservations created

Workflow progresses to shipping

---

🔹11. How to fetch invoice details for a shipped order?

Join RA_CUSTOMER_TRX_LINES_ALL with OE_ORDER_LINES_ALL using LINE_ID.

---

🔹12. How to add a new DFF in Sales Order form?

Enable DFF in OE_ORDER_HEADERS_ALL or OE_ORDER_LINES_ALL and use Form Personalization.

---

🔹13. What is the role of WSH_DELIVERY_DETAILS?

Stores delivery line details linked with order lines for shipping.
---

🔹14. What is Drop Ship and how is it handled in OM?

Customer order fulfilled directly by supplier. OM creates PO through workflow → PO_HEADERS_ALL.
---

🔹15. How to reprice an order?

Use:

QP_PREQ_PUB.PRICE_REQUEST

---

🔹16. How to retry errored workflow orders?

Use: WF_ENGINE.RESETSTATUS

---

🔹17. How to find shipping status of an order?

Use:

WSH_NEW_DELIVERIES

WSH_DELIVERY_DETAILS Status = 'Shipped'

---

🔹18. Can we import partial lines in Order Import?

Yes, ensure lines are grouped properly using GROUP_ID
---

🔹19. What are key setups for OM interfaces?

Transaction types

Document sequence

Profile options (OM: Default operating unit)

---

🔹20. What if order lines fail workflow?

Use Workflow Diagnostics and check WF_ITEM_ACTIVITY_STATUSES.

---

➡️✅2. Inventory (INV) – 20 Difficult Interview Q&A

---

🔹1. What is the use of MTL_SYSTEM_ITEMS_INTERFACE?

Used to import items into Oracle Inventory.

---

🔹2. How do you assign categories to items?

Use:
MTL_ITEM_CATEGORIES_INTERFACE

Base: MTL_ITEM_CATEGORIES

---

🔹3. How is inventory reservation done programmatically?

API:

INV_RESERVATION_PUB.Create_Reservation

---

🔹4. What tables are involved in sub-inventory transfers?

MTL_MATERIAL_TRANSACTIONS
MTL_TRANSACTION_ACCOUNTS

---

🔹5. How do you enable serial control at item level?

Set:

SERIAL_CONTROL_CODE in MTL_SYSTEM_ITEMS_B

---

🔹6. What is the difference between MTL_LOT_NUMBERS and MTL_SERIAL_NUMBERS?

LOT = batch tracking

SERIAL = individual item tracking

---

🔹7. How do you import on-hand quantities?

Via:

MTL_TRANSACTIONS_INTERFACE
MTL_TRANSACTION_LOTS_INTERFACE

---

🔹8. How do you find on-hand quantity?

Query:
SELECT * FROM MTL_ONHAND_QUANTITIES

---

🔹9. How to backdate inventory transactions?

Set TRANSACTION_DATE in interface table and ensure user has date control privileges.

---

🔹10. What is INV: Transaction Date Validation profile?

Controls whether backdated transactions are allowed.
---

🔹11. How is inventory replenishment managed?

Through Min-Max Planning or Replenishment Setup.

---

🔹12. How to debug stuck inventory transactions?

Check:

MTL_MATERIAL_TRANSACTIONS_TEMP

INV_TXN_MANAGER

---

🔹13. How do you generate inventory reports in XML Publisher?

Use query based on MTL_ONHAND_QUANTITIES and MTL_SYSTEM_ITEMS_B, then build RTF layout.

---

🔹14. What are Interface Managers?

Used to process data from interface tables (e.g., Inventory Transaction Manager).

---

🔹15. What if an item is not visible in the org?

Check:

MTL_ITEM_ORGS

Run Item Status Report

---

🔹16. How to link sub-inventories to organizations?

Using:

INV_ORG_PARAMETERS

MTL_SECONDARY_INVENTORIES

---

🔹17. What is the difference between expense and asset items?

Asset: Capitalized, tracked

Expense: Consumed immediately

---

🔹18. What is locator control?

Level of granularity:
None

Prespecified

Dynamic entry

---

🔹19. How do you restrict users to specific sub-inventories?

Use subinventory locators and user-defined security rules.

---

🔹20. How to purge obsolete on-hand data?

Use Purge Inventory Transactions program.

---

➡️✅ 3. Purchasing (PO) – 20 Difficult Interview Q&A

---

🔹1. What tables are used in PO Interface?

PO_HEADERS_INTERFACE
PO_LINES_INTERFACE

---

🔹2. How do you import standard POs?

Run Import Standard Purchase Orders program.

---

🔹3. How do you approve a PO using API?

PO_DOCUMENT_ACTIONS.APPROVE_PO
---

🔹4. What is the use of PO_HEADERS_ALL and PO_LINES_ALL?

They store header and line-level information of Purchase Orders.

---

🔹5. How are suppliers linked to POs?

Via:

PO_VENDORS
PO_VENDOR_SITES_ALL

---

🔹6. How do you handle dropship PO?

Linked with OM order, creates PO automatically using workflow.

---

🔹7. How do you debug failed PO imports?

Check:

PO_INTERFACE_ERRORS
Interface status codes

---

🔹8. What is the table for PO receipts?

RCV_SHIPMENT_HEADERS
RCV_TRANSACTIONS

---

🔹9. What is the role of RCV_TRANSACTIONS_INTERFACE?

Used to load receiving transactions from external sources.

---

🔹10. How do you track PO approval history?

Use PO_ACTION_HISTORY.

---

🔹11. How to retrieve all open POs?

Query PO_HEADERS_ALL where AUTHORIZATION_STATUS = 'APPROVED' and not fully received.

---
🔹12. What is the difference between Blanket PO and Standard PO?
Standard: One-time procurement

Blanket: Agreement over time

---

🔹13. Can PO be reopened once closed?

Yes, using API or via form action → "Reopen".

---

🔹14. What profile controls auto approval limits?

PO: Approval Authority

---

🔹15. What is the workflow name for PO approval?

PO Approval Workflow

---

🔹16. What happens when a PO is cancelled?

Notification sent
Encumbrances released

---

🔹17. How to link PO to AP invoice?

Via:

RCV_TRANSACTIONS

AP_INVOICE_DISTRIBUTIONS_ALL

---

🔹18. How to handle foreign currency POs?

Ensure exchange rate is available and PO_HEADERS_ALL.CURRENCY_CODE is set.

---

🔹19. What if receiving quantity is more than PO?

System throws over-receipt warning or error based on tolerance.

---

🔹20. How to upload approved PO via API?

Use:

PO_HEADERS_INTERFACE → Import PO Program → Validate and Approve

---

💰 4. Accounts Receivable (AR) – 20 Difficult Interview Q&A

---

🔹1. What table stores invoice headers?

RA_CUSTOMER_TRX_ALL

---

🔹2. How do you create an invoice via interface?

Use:

RA_INTERFACE_LINES_ALL

RA_INTERFACE_DISTRIBUTIONS_ALL

---

🔹3. What is Autoinvoice?

Tool to import invoices into AR from other modules.
---

🔹4. Which program runs Autoinvoice?

Import Autoinvoice

---

🔹5. How to debug Autoinvoice errors?

Check:

RA_INTERFACE_ERRORS

RA_INTERFACE_LINES_ALL.LINE_STATUS

---

🔹6. How are customers stored?

HZ_PARTIES

HZ_CUST_ACCOUNTS

HZ_CUST_ACCT_SITES_ALL

---

🔹7. How to apply receipts to invoices?

Use:

AR_RECEIPT_API_PUB.APPLY

---

🔹8. What is lockbox?

Tool to import receipts from bank files.

---

🔹9. How to reverse a receipt?

Use:

AR_RECEIPT_API_PUB.REVERSE

---

🔹10. What happens after posting in AR?

Entries sent to GL via RA_CUST_TRX_LINE_GL_DIST_ALL.

---

🔹11. How to track customer balance?

Query AR_PAYMENT_SCHEDULES_ALL and AR_RECEIVABLE_APPLICATIONS_ALL.

---

🔹12. How to create DFF on customer form?

Enable at HZ_CUST_ACCOUNTS level.

---

🔹13. What is a Transaction Type?

Controls how invoice behaves (e.g., Credit Memo, Standard).

---

🔹14. How to write off small balance?

Use Adjustments form or AR_ADJUST_PUB.

---

🔹15. What is a receipt class?

Defines receipt method: automatic/manual, remittance handling.

---

🔹16. What is the difference between confirmed and unconfirmed receipts?

Confirmed: Validated by bank9

Unconfirmed: Awaiting verification

---

🔹17. How to fetch tax on AR invoices?

Join ZX_LINES, ZX_DETAILS, and RA_CUSTOMER_TRX_LINES_ALL.

---

🔹18. What is the use of RA_INTERFACE_SALESCREDITS_ALL?

Stores salesperson info for interfaced invoices.

---

🔹19. What is the use of AR_CASH_RECEIPTS_ALL?

Stores all receipt data.

---

🔹20. What are applications of AR_RECEIPT_METHODS?

Used in lockbox and manual receipt processing.
---

📤 5. Accounts Payable (AP) – 20 Difficult Interview Q&A

---

🔹1. What is the interface table for AP Invoice?

AP_INVOICES_INTERFACE

AP_INVOICE_LINES_INTERFACE

---

🔹2. What program imports invoices?

Payables Open Interface Import

---

🔹3. How to create payment using API?

Use:

AP_INV_PKG.CREATE_SINGLE_PAYMENT

---

🔹4. What tables store invoice and payments?

Invoices: AP_INVOICES_ALL

Payments: AP_CHECKS_ALL

---

🔹5. What if invoice validation fails?

Use Invoice Validation program to identify holds in AP_HOLDS.

---

🔹6. What is Matching in AP?

Linking invoices to POs and receipts (2-way, 3-way).

---

🔹7. How to reverse a payment?

Use Payment Cancelation window or AP_CANCEL_PKG.

---

🔹8. What is Withholding Tax and where is it stored?

Tax deducted on payment; stored in AP_INVOICE_PAYMENTS_ALL.

---

🔹9. How to apply prepayment to invoice?

Link via AP_PREPAY_HISTORY

---

🔹10. How to find unpaid invoices?

SELECT * FROM AP_INVOICES_ALL WHERE AMOUNT_REMAINING > 0

---

🔹11. What is the use of AP_PAYMENT_SCHEDULES_ALL?

Stores payment due dates, discounts, terms.

---

🔹12. What is the difference between standard and mixed invoice?

Standard: Payable invoice

Mixed: Payable + receivable lines

---

🔹13. How is tax calculated in AP?

Via eBTax engine; joins ZX_LINES, ZX_DETAILS.

---

🔹14. How to process recurring invoices?

Use Recurring Invoice Template and schedule generation.

---

🔹15. How to debug accounting errors in AP?

Use Accounting Events Diagnostic Report.

---

🔹16. What is Payables Approval Workflow?

Validates if invoice needs approval via AME.

---

🔹17. How to cancel an invoice?

Use Cancel Invoice API or Invoice form (if unpaid and unaccounted).
---

🔹18. How to validate supplier bank account?

Check in IBY_EXT_BANK_ACCOUNTS, IBY_PMT_INSTR_USES_ALL.

---

🔹19. How to generate payment batches?

Use Payment Process Request (PPR) from Payments Workbench.

---

🔹20. How to customize AP invoice print format?

Use XML Publisher and modify layout template.

---

Let me know if you'd like a PDF version of all 100 module-wise Q&A — I can generate it for you right away!

2️⃣ Oracle EBS Technical Foundation Modules 100 QnA

Here's the full content of the Oracle EBS Technical Foundation Modules – Interview Questions & Answers (5+ Years Experience) document, broken
down by each module:
AOL
ORACLE REPORTS
WORKFLOWS
CONCURRENT PROCESSING
OAF
BI publisher

---
➡️✅1. Oracle Application Object Library (AOL) – 20 Q&A
----------------+
1. What is AOL in Oracle Apps?
AOL provides core components like menus, responsibilities, value sets, profile options, and lookup values.

2. What are the types of value sets in AOL?

Independent
Dependent
Table
Translatable Independent/Dependent
Special
Pair

3. What is a lookup in AOL?

A predefined list of values (LOV) used throughout the application.

4. What is a profile option?

A configuration setting that controls behavior at various levels (Site, App, Resp, User).
5. What is the difference between a key flexfield and descriptive flexfield?

KFF: Used for unique identification (e.g., Item, GL Account)

DFF: Used for capturing additional information

6. What is FNDLOAD?
A command-line utility to migrate AOL objects like menus, value sets, etc.

7. What is a request group?

Logical grouping of concurrent programs accessible from a responsibility.

8. What is a function in AOL?

Points to a form or web page to be accessed via a menu.

9. What is the purpose of menus in AOL?

Defines the navigation structure and links to forms via functions.

10. What are WHO columns?

Standard columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

11. How do you register a Concurrent Program in AOL?

Create Executable → Define Concurrent Program → Attach Parameters → Add to Request Group.

12. What is the significance of CUSTOM_TOP?

Stores all custom components (forms, reports, packages).

13. What is the purpose of FND_USER table?

Stores application user credentials and associated responsibilities.

14. How to restrict a Concurrent Program to a Responsibility?

Use Request Groups attached to that Responsibility.

15. What is FND_GLOBAL?

A package to fetch session-related info like user_id, resp_id, etc.

16. Can we assign a user to multiple responsibilities?

Yes, via the User form.

17. What are seeded AOL objects?

Delivered by Oracle, not to be modified directly.

18. How do you migrate profile options or users?

Use FNDLOAD or custom scripts.

19. What is a Data Group?

Links applications with database schemas in multi-org setups.

20. How do you debug value set issues?

Check table joins (for table-type), SQL logic, and value constraints.
---

➡️✅🔹 2. Oracle Workflow

------------
1. What is Oracle Workflow?
Tool to define and automate business processes using graphical models.

2. What are components of a workflow?

Item Type, Process, Functions, Notifications, Attributes, Messages.

3. What is an activity?
A step in the process – can be a function or a notification.

4. What is a function in workflow?

A PL/SQL or Java logic executed in the process.

5. How is a workflow started programmatically?

Using WF_ENGINE.STARTPROCESS.

6. Where are workflow statuses stored?

WF_ITEMS,
WF_ITEM_ACTIVITY_STATUSES, WF_NOTIFICATIONS.

7. How can you retry a failed workflow?

Use Workflow Monitor or backend scripts.

8. What is a performer?
The recipient of a workflow notification.

9. What is the difference between function and notification?

Function executes logic;
notification sends a message to a user.

10. What is Workflow Builder?

Desktop application to design and modify workflows.

11. What is correlation ID?

Identifier used to track or link workflows to business entities.

12. Can workflows call concurrent programs?

Yes, using Function activities.

13. What is WF_ENGINE?

API package for managing workflow processes.

14. What is an Item Type?

Container for a workflow process definition.

15. How can you debug a workflow?

Workflow Monitor,
WF_ERROR table, and
SQL tracing.

16. What is background engine in workflow?

A concurrent program that processes deferred or timed-out activities.

17. How to define time-out in workflows?

Through the activity properties – set duration and result.

18. What are lookup types in workflows?

Used for defining LOVs within workflow attributes.

19. How to attach documents in workflow?

Via notification attachments using message settings.

20. What is the WF_NOTIFICATIONS table?

Stores details about sent notifications and their statuses.

---

➡️✅🔹 3. Oracle Concurrent Processing

---
1. What is a concurrent program?
A background process to perform tasks like reports or data processing.

2. How is a concurrent program created?

Register executable → Define concurrent program → Assign to request group.

3. What are types of concurrent programs?

PL/SQL, Oracle Reports, SQL*Plus, Host, Java.

4. What is a request group?

Set of concurrent programs assigned to a responsibility.

5. What are request phases and statuses?

Phases: Pending, Running, Completed.
Statuses: Normal, Warning, Error.

6. How to schedule a concurrent program?

From Submit Request → Schedule.

7. How to submit from code?

FND_REQUEST.SUBMIT_REQUEST(Req_id, Concurrent_nane, parameters.. )

8. What is a request set?

Set of concurrent programs that run in sequence.

9. What is an incompatibility?
Prevents two programs from running simultaneously.

10. How do you pass parameters?

Define parameters using value sets.

11. What is the purpose of FND_FILE?

Writes log and output files during concurrent execution.

12. What are key tables?

FND_CONCURRENT_PROGRAMS, FND_CONCURRENT_REQUESTS,
FND_EXECUTABLES,

13. How to view output/log files?

Via View Output/Log buttons or apps filesystem.
14. What is the use of concurrent manager?
Manages execution of concurrent requests.

15. How to find long-running requests?

Query fnd_concurrent_requests with phase = 'R'.

16. How to kill a running request?

Cancel from front-end or use cancel_request API.

17. What is a host-based concurrent program?

A shell or batch script run via concurrent processing.

18. What is program incompatibility?

Restricts other programs from running concurrently.

19. How to debug parameter issues?

Check log file, ensure correct parameter definitions.

20. How to monitor request history?

Use Standard Request Submission or query request tables.

---

🔹 4. Oracle Forms and Reports

1. What is [Link]?
Base template used to develop custom Oracle Forms.

2. What are WHO columns?

Created By, Creation Date,
Last Updated By, Last Update Date.

3. How to submit a request from form?

Use FND_REQUEST.SUBMIT_REQUEST in WHEN-BUTTON-PRESSED.

4. What is PRE-QUERY trigger?

Fires before query execution, can modify WHERE clause.

5. What is a lexical parameter in reports?

Replaced by a string at runtime (e.g., part of WHERE clause).

6. What is a bind parameter?

Placeholder for a variable in a report (e.g., :p_dept).

7. What is [Link]?
Built-in for writing messages in Reports.

8. How to register Oracle Reports in Apps?

Register as executable → Define program → Add to Request Group.
9. What are form personalization advantages?
No coding needed; easy to deploy; Oracle supported.

10. How to debug Oracle Reports?

Use [Link], review .out and .log files.

11. How to pass multiple parameters?

Define them in the report and register accordingly.

12. What are triggers in forms?

Event handlers like WHEN-NEW-FORM-INSTANCE.

13. How to add LOVs in forms?

Attach record group and LOV object to form item.

14. How to use PL/SQL libraries?

Attach to form and call standard logic.

15. What is difference between .fmb and .fmx?

.fmb = Source; .fmx = Compiled binary.

16. How to compile forms?

Use f60gen or frmcmp_batch.

17. Can a form call a report?

Yes, using RUN_PRODUCT.

18. Difference: Tabular vs Matrix reports?

Matrix displays cross-tab; tabular is column-row.

19. What is a Data Model in reports?

Defines queries, groups, and data logic.

20. How to handle multi-org in forms?

Use MO: Operating Unit profile and security.

---

🔹 5. Oracle BI Publisher
1. What is BI Publisher?
A reporting tool that separates data and layout using XML.

2. What is a Data Definition?

Maps XML data with template.

3. What templates are supported?

RTF, PDF, Excel, eText, XSL-FO.
4. What is bursting?
Sends report output to multiple recipients based on rules.

5. How to create a BI Publisher report?

Register Data Def → Create Template → Link to Concurrent Program.

6. How to create an RTF template?

Using Word + BI Publisher plugin.

7. How to debug BI Publisher reports?

Review XML data, RTF formatting, logs.

8. What is a layout template?

Defines final output appearance (RTF, XSL, etc.).

9. What is FO?
Formatting Object – XML layout standard.

10. What is eText used for?

EFT files, bank instructions, ASCII text.

11. What are the delivery formats?

PDF, Excel, RTF, HTML, eText.

12. How do you pass parameters?

From Concurrent Program to Data Template/XML.

13. Can you pass LOVs?

Yes, by using parameter definitions.

14. How to repeat table header on each page?

Word Table Properties > Repeat Header Row.

15. Can BI Publisher use data templates?

Yes, especially for complex queries/multiple datasets.

16. How do you secure BI templates?

Role-based access and function security.

17. How to print conditional values?

Use <?if:?> ... <?end if?> tags.

18. What is the use of bursting control file?

Defines delivery logic – email, printer, FTP, etc.

19. How to embed an image?

Use <?url:IMAGE_URL?> or base64 binary.
20. How to handle multiple layouts?
Register all layouts under same Data Def.

---

🔹 6. Oracle Application Framework (OAF)

1. What is OAF?
Oracle’s Java-based MVC framework for web-based applications.

2. What are OAF layers?

Model (EO/VO), View (Pages/XML), Controller (Java).

3. What is a BC4J?
Business Components for Java (AM, EO, VO).

4. How to deploy OAF page?

Compile and place in appropriate MDS path.

5. What is personalization in OAF?

Declarative change to UI using admin pages.

6. How to extend a VO?

Create Subclass VO → Replace in substitution.

7. How to add LOV in OAF?

Create VO and use List-of-Values UI element.

8. What is PageContext?
Provides session and page information.

9. What is setForwardURL()?
Used for page navigation.

10. What is Application Module?

Manages data access and transactions.

11. What is a Controller?

Java class that handles UI events.

12. How to debug OAF?

Use JDeveloper, enable debug profile options.

13. What is PPR?

Partial Page Rendering – refresh part of the page.

14. How to call a Concurrent Program from OAF?

Use ConcurrentRequest class in Java.
15. What is Entity Object?
Maps to database table with business logic.

16. How to show messages in OAF?

Use OAException class.

17. How to validate data?

Use EO validation or controller code.

18. What is Root AM?

Entry point for application module hierarchy.

19. Where are XML pages stored?

Under MDS repository.

20. How to extend seeded pages?

Use page personalization and substitution.

---

🔹 7. Oracle Web ADI

1. What is Web ADI?
Excel-integrated tool to upload/download data to/from Oracle Apps.

2. What are integrators?

Defines mapping between Excel and backend API.

3. What are layouts?

Defines Excel field arrangement.

4. How do you deploy a custom Web ADI?

Define integrator, interface, layout, and content.

5. How to validate data in Web ADI?

Use Value Sets, SQL LOVs, and backend validation.

6. How to log errors?

Review uploader logs and backend interface logs.

7. How are templates generated?

From the defined integrator in the front-end.

8. What is BNE_INTEGRATORS?
Table storing integrator definitions.

9. What is the interface in Web ADI?

PL/SQL or table mapping logic.
10. How to provide LOVs in Excel?
Via value sets mapped to layout.

11. Can Web ADI be used for updates?

Yes, if logic is defined to support it.

12. How do you pass parameters to the API?

Through Excel fields mapped in content definition.

13. How to restrict access to integrators?

Assign via function to specific responsibilities.

14. How to automate Excel uploads?

Use macros or backend calls.

15. How to define multi-language support?

Use separate layouts per language or translations.

16. How to handle errors in Web ADI?

Check bne_errors and upload logs.

17. What are seeded integrators?

Predefined by Oracle for GL, AP, etc.

18. How to enable audit tracking?

Use custom columns and triggers in backend.

19. Where are uploaded data stored?

In interface tables or directly in base tables via API.

20. What is a Web ADI Uploader?

Java component in Excel that uploads data.

---

🔹 8. Oracle Alerts
1. What is Oracle Alert?
Tool to notify users based on database changes.

2. Types of alerts?
Periodic and Event-Based.

3. How to define a periodic alert?

Provide SQL, frequency, and actions.

4. What actions can be defined?

Email, run concurrent program, insert/update SQL.
5. What is the purpose of an action set?
Group of actions triggered by the alert.

6. What tables are involved?

ALR_ALERTS, ALR_ACTIONS, ALR_ALERT_HISTORY.

7. Can alerts send attachments?

Yes, using email actions.

8. How to prevent duplicate alerts?

Use alert history and SQL condition filters.

9. What is a distribution list?

List of users or roles to receive notifications.

10. How are responses captured?

Use alert response actions and logging.

11. How to debug alerts?

Check concurrent log and alert execution history.

12. Can alerts execute DML?

Yes, through SQL statement action.

13. How to restrict alerts to responsibilities?

Filter conditions in SQL or use application logic.

14. What is alert escalation?

Notify higher levels on no response or failure.

15. How are alerts migrated?

FNDLOAD or redefinition.

16. Can alerts call other alerts?

Indirectly, by calling concurrent programs.

17. How to track alert logs?

Use ALR tables or concurrent program logs.

18. Can alerts handle attachments?

Yes, if defined in alert action.

19. Can alerts be used for automation?

Yes, to invoke jobs or checks periodically.

20. Best practice for alerts?

Keep SQL optimized, log actions, test thoroughly.

3️⃣ Oracle Apps Technical Basic Interview 50 QnA

🔹 1. What is Oracle E-Business Suite (EBS)?
Answer:
Oracle E-Business Suite (EBS) is a comprehensive suite of integrated business applications that automate key business functions like Finance, HR,
Supply Chain, and Manufacturing. It's built on Oracle DB and includes both functional and technical layers.

---
🔹 2. What is the architecture of Oracle EBS?
Answer:
Oracle EBS follows a 3-tier architecture:

1. Client Tier: User access via browser.

2. Application Tier: Oracle Forms, Reports, Workflow, Concurrent Manager.
3. Database Tier: Oracle RDBMS stores all data and code (PL/SQL, packages).

---
🔹 3. What is the difference between a concurrent program and a request set?
Answer:

A Concurrent Program is a single executable (PL/SQL, SQL*Loader, report, etc.).

A Request Set is a collection of concurrent programs executed in sequence or parallel.

---
🔹 4. How do you register a custom Concurrent Program?
Answer:
1. Create executable under Application Developer.
2. Define the concurrent program and attach the executable.
3. Add parameters and incompatibilities.
4. Attach to a Request Group and Responsibility.

---

🔹 5. What are the types of Value Sets in Oracle Apps?

Answer:

1. Independent
2. Dependent
3. Table
4. Special
5. Pair
6. None

---
🔹 6. What is a flexfield? Types?
Answer: A Flexfield is a configurable field used to capture extra information.

Key Flexfield (KFF): Uniquely identifies entities (e.g., Item, Account).

Descriptive Flexfield (DFF): Adds custom fields to forms.

---
🔹 7. How do you identify a DFF-enabled field on a form?
Answer: Look for a square bracket [ ] or click on Tools → Descriptive Flexfields → Segment from the menu.

---
🔹 8. Explain inbound and outbound interfaces.
Answer:

Inbound: Data from external system → Oracle Apps (e.g., using SQL*Loader, staging tables).

Outbound: Oracle Apps → External system (e.g., using UTL_FILE, XML, etc.).

---
🔹 9. What is a staging table?
Answer:
A staging table is an intermediate table used to hold data temporarily before inserting into base tables via validation and business logic.

---
🔹 10. What is a conversion?
Answer:
Conversion refers to one-time migration of legacy data into Oracle Apps during implementation (e.g., Item conversion, Customer conversion).

---
🔹 11. What is a [Link] file?
Answer:
[Link] is a special PL/SQL library used to customize standard Oracle forms without modifying them directly. It uses form-level triggers like
WHEN-NEW-FORM-INSTANCE.

---

🔹 12. How do you move code between environments in Oracle Apps?

Answer:
Use FNDLOAD, XDOLoader, Data Loader, Shell Scripts, or direct file movement via FTP/SCP depending on object type.

---
🔹 13. What is FNDLOAD?
Answer:
FNDLOAD is a command-line utility used to upload/download configuration data like concurrent programs, menus, value sets, etc.

apps/apps → apps username/password

0 Y → Standard flags (mode + validation)
.lct → Loader Control File (defines object structure)
.ldt → Data file (actual metadata)
DOWNLOAD = extract, UPLOAD = load
Use CUSTOM_MODE=FORCE to overwrite existing setups

--DOWNLOAD
FNDLOAD apps/<apps_pwd> 0 Y DOWNLOAD \
$FND_TOP/patch/115/import/<control_file>.lct \
<output_file>.ldt \
<ENTITY_NAME> \
<KEY1>="<VALUE1>" <KEY2>="<VALUE2>"

-- UPLOAD
FNDLOAD apps/<apps_pwd> 0 Y UPLOAD \
$FND_TOP/patch/115/import/<control_file>.lct \
<input_file>.ldt \
[UPLOAD_MODE]
---
🔹 14. What is a workflow?
Answer:
Oracle Workflow automates business processes and approvals (e.g., PO approval). It's used for notifications, decisions, and user responses.

---
🔹 15. What are the types of triggers in Oracle Forms?
Answer:

Pre-Form
When-New-Form-Instance
When-Validate-Item
Key-Trigger (Key-Commit, Key-Next-Item)
On-Error

---

🔹 16. What is Oracle APEX?

Answer:
Oracle Application Express (APEX) is a low-code development tool used to build web-based applications over Oracle databases.

---

🔹 17. Difference between FORM-based and TEMPLATE-based reports?

Answer:
FORM-based: Built using Oracle Forms.

TEMPLATE-based: XML Publisher/BI Publisher reports using RTF or Excel templates.

---

🔹 18. What are the base tables in the PO module?

Answer:

PO_HEADERS_ALL
PO_LINES_ALL
PO_DISTRIBUTIONS_ALL
PO_VENDORS

---
🔹 19. What is the purpose of APIs in Oracle Apps?
Answer:
Oracle provides public APIs to insert/update data safely into base tables (e.g., INV_ITEM_API, AR_CUSTOMER_API).

---

🔹 20. What is the difference between TOAD and SQL Developer?

Answer: Both are SQL IDEs. TOAD is commercial with advanced features, while SQL Developer is Oracle's free IDE.

---

🔹 21. How do you debug PL/SQL code in Oracle?

Answer: Use DBMS_OUTPUT.PUT_LINE, set breakpoints in TOAD/SQL Developer, or use logging tables.

---
🔹 22. What is a responsibility in Oracle Apps?
Answer:
A Responsibility defines what a user can access (menus, forms, reports, data security).

---
🔹 23. What is the difference between OPEN and FETCH cursor?
Answer:
OPEN: Initializes the cursor.

FETCH: Retrieves rows from the result set.

---

🔹 24. How do you handle errors in PL/SQL?

Answer:
Using EXCEPTION blocks and RAISE_APPLICATION_ERROR to return meaningful messages.

---

🔹 25. What is RAISE_APPLICATION_ERROR?

Answer:
A built-in procedure used to raise custom application errors in PL/SQL (within range -20000 to -20999).

---

🔹 26. What are Pseudo columns?

Answer:

ROWNUM
ROWID
SYSDATE
LEVEL
LIMIT
OFFSET

---
🔹 27. What is .rdf file?
Answer:
Compiled report file generated by Oracle Reports Builder for concurrent program execution.

---
🔹 28. What are the file extensions used in Oracle Forms and Reports?
Answer:
Forms: .fmb (source), .fmx (compiled)
Reports: .rdf (source), .rep (compiled)

---
🔹 29. Can we commit inside a trigger?
Answer:
No, unless using PRAGMA AUTONOMOUS_TRANSACTION, but it is discouraged.

---
🔹 30. What is PRAGMA AUTONOMOUS_TRANSACTION?
Answer:
A compiler directive that lets you commit/rollback in a procedure independently of the main transaction.
---
🔹 31. What is personalization?
Answer:
Form Personalization allows runtime changes to Oracle Forms (hide items, change labels) without [Link].

---
🔹 32. What are multi-org concepts in Oracle Apps?
Answer:

Operating Unit
Inventory Organization
Business Group
Legal Entity

Each layer supports segregation of data.

---
🔹 33. What is the difference between standard and custom reports?
Answer:

Standard: Delivered by Oracle.

Custom: Built by developers to meet unique client needs.

---
🔹 34. What is the use of fnd_user table?
Answer:
Stores user login details in Oracle Apps.

---
🔹 35. How do you secure data at the responsibility level?
Answer: Using MO: Operating Unit, Profile Options, and Data Access Sets.

---
🔹 36. What is a request group?
Answer:
A collection of concurrent programs linked to a responsibility.
---

🔹 37. How do you monitor concurrent program logs?

Answer: Go to View → Requests → Log/Output, or check files in $APPLCSF/$APPLLOG.

---

🔹 38. What is the difference between bind and lexical parameters in Reports?
Answer:

Bind: Prefixed with :, holds values.

Lexical: Substitutes text (like table names, clauses).

---
🔹 39. What is the role of AOL (Application Object Library)?
Answer: Manages security, flexfields, concurrent programs, profiles, responsibilities.

---

🔹 40. What is the use of fnd_global?

Answer: Provides global session variables like user_id, resp_id, etc.

---

🔹 41. What is the significance of .ldt files?

Answer:
They are LDT (Loader Data Text) files used by FNDLOAD to move metadata between environments.

---

🔹 42. What is a seeded report?

Answer: A report provided by Oracle by default (not custom).

---

🔹 43. How do you define concurrent program incompatibilities?

Answer: Specify programs that must not run simultaneously to avoid data conflict.

---

🔹 44. What are profile options?

Answer: Control application behavior at various levels (Site, Application, Responsibility, User).

---

🔹 45. What is UTL_FILE?

Answer:
A package used to read/write files from the database to the OS file system.

---

🔹 46. What is the use of fnd_request.submit_request?

Answer: Submits a concurrent program from PL/SQL.

---

🔹 47. Explain P2P cycle briefly.

Answer:

1. Requisition
2. Purchase Order
3. Receipt
4. Invoice
5. Payment

---

🔹 48. What are Table Aliases in Oracle Reports?

Answer:
Used to join the same table multiple times or improve clarity.

---

🔹 49. Difference between SQL*Loader and External Table?

Answer:

SQL*Loader: Batch loading tool.

External Table: Treat flat file as a table via Oracle metadata.

---

🔹 50. How do you ensure performance in PL/SQL code?

Answer:

Use bulk collect/forall

Avoid unnecessary loops

Use proper indexes

Use bind variables

4️⃣ Advanced Oracle Apps Technical Interview 30 QnA

🔹 1. How do you implement Bulk Collect and FORALL in Oracle PL/SQL? Why are they used?
Answer:
Used for performance optimization when handling large datasets.

SELECT col1, col2 BULK COLLECT INTO l_col1, l_col2 FROM table;

FORALL i IN l_col1.FIRST..l_col1.LAST
INSERT INTO target_table VALUES (l_col1(i), l_col2(i));

Improves performance by reducing context switches between SQL and PL/SQL engines.

---

🔹 2. What are Materialized Views and how do they help in Oracle EBS performance?
Answer:
Materialized Views store precomputed query results. Used for reporting in EBS to reduce load on base tables. Can be refreshed on-demand or
periodically.

---

🔹 3. Explain multi-org access control (MOAC) and how to use it in reports.

Answer:
MOAC allows access to multiple Operating Units via a single responsibility. Use ORG_ID in queries and bind it to :P_ORG_ID.

Add MO: Security Profile profile and use HR_SECURITY.VIEW_ALL_ORGS.

---

🔹 4. How do you debug a failed workflow in Oracle Apps?

Answer:

Use Workflow Monitor (Responsibility: Workflow Administrator Web)

Use [Link] or WF_DIAGNOSTICS

Check WF_NOTIFICATIONS and WF_ITEMS

---

🔹 5. How do you develop a BI Publisher report using XML data source?

Answer:

1. Create Data Definition in EBS.

2. Register XML template (RTF).

3. Use xdoxslt and XSL tags.

4. Generate layout using MS Word + BI Publisher plugin.

---

🔹 6. Explain the use of Event-Based Alerts.

Answer:
They are triggered when a condition is met (like INSERT/UPDATE on a table) and can notify users or perform an action.

---

🔹 7. What is the difference between secured and unsecured view in multi-org?

Answer:

Secured View: Includes ORG_ID security (e.g., PO_HEADERS).

Unsecured View: No security, includes all data (e.g., PO_HEADERS_ALL).

---

🔹 8. How do you handle custom error logging in Oracle Apps?

Answer: Use custom error logging table with fields: module_name, error_message, error_code, timestamp. Capture using exception block and write
using PRAGMA AUTONOMOUS_TRANSACTION.

---
🔹 9. How do you use RAISE_APPLICATION_ERROR in packaged procedures?
Answer:

RAISE_APPLICATION_ERROR(-20001, 'Invalid Supplier ID');

Used to throw custom error to users or concurrent log.

---

🔹 10. How to find the current responsibility from PL/SQL?

Answer:

fnd_global.resp_id;
fnd_global.resp_appl_id;

---

🔹 11. What are the key tables for Inventory Interface (Item conversion)?
Answer:

Staging: Custom table

Interface: MTL_SYSTEM_ITEMS_INTERFACE

Base: MTL_SYSTEM_ITEMS_B, MTL_ITEM_CATEGORIES

---

🔹 12. How do you track concurrent program execution from back end?
Answer: Use fnd_concurrent_requests to track status, phase, and log/output file names.

---

🔹 13. How can you avoid hard-coding org_id in custom SQL?

Answer: Use FND_PROFILE.VALUE('ORG_ID') or pass as a parameter in reports.

---

🔹 14. What is the role of $FLEX$ and $PROFILES$ in value sets?

Answer:

$FLEX$: Refer values from another value set (dependent sets).

$PROFILES$: Get runtime profile values (e.g., ORG_ID, User_ID).

---

🔹 15. What are Collection APIs?

Answer:
Used in Oracle Advanced Collections to insert/update customers, tasks, strategies via PL/SQL APIs.
---

🔹 16. Explain staging > interface > base table architecture.

Answer:

Staging: Temporary load from external source.

Interface: Oracle-provided structure with validations.

Base: Final Oracle table.

---

🔹 17. What is the use of FND_CONCURRENT.WAIT_FOR_REQUEST?

Answer: Used in PL/SQL to pause execution until a submitted concurrent request is complete.

---

🔹 18. How to schedule a concurrent program via PL/SQL?

Answer: Use:

fnd_request.submit_request(...);
COMMIT;

---

🔹 19. How do you audit who changed which profile option and when?
Answer: Query:

SELECT * FROM fnd_profile_option_values

JOIN fnd_user ON created_by = user_id

---

🔹 20. How to migrate BI Publisher reports between instances?

Answer: Use:

XDOLoader utility

Export .RTF, .XML, .XDO files

Move LDT via FNDLOAD

---

🔹 21. How do you debug Form Personalization issues?

Answer:

Enable FND: Diagnostics

Set FND_PERZ_DEBUG

Use Tools > Diagnostics > Custom Code > Personalize

---

🔹 22. How do you handle large data volumes in interface design?

Answer:

Use parallel concurrent programs.

Optimize SQL with indexes, hints.

Use BULK COLLECT and FORALL.

---

🔹 23. What are Global Temporary Tables and where are they used in EBS?
Answer: Tables that hold session-specific data. Used in reports/interfaces to hold temporary data without affecting other users.

---

🔹 24. How to track changes made by [Link]?

Answer: Use custom logs in [Link] and enable triggers like WHEN-NEW-FORM-INSTANCE.

---

🔹 25. What are the advantages of using Oracle APEX in Oracle EBS?
Answer:

Low-code environment

Integrates with EBS base tables

Replaces Oracle Forms with modern web UI

Easier deployment

---

🔹 26. How do you capture concurrent program logs automatically?

Answer: Query fnd_concurrent_requests, use UTL_FILE or mail the logs using UTL_MAIL.

---

🔹 27. How do you validate values passed to concurrent program parameters?

Answer:

Use value sets with validation types (Independent/Table)

Perform custom PL/SQL validation inside executable

---
🔹 28. What are seeded workflows? Can we customize them?
Answer: Yes. Seeded workflows (e.g., PO Approval) can be customized by copying to a custom workflow and modifying it.

---

🔹 29. How do you trigger custom workflows?

Answer: Use WF_ENGINE.StartProcess in PL/SQL or attach to custom event.

---

🔹 30. How to enable trace for a specific user session in Oracle Apps?
Answer:

Set profile SQL_TRACE = YES at user level.

Use ALTER SESSION SET sql_trace=TRUE;

Or enable trace via "Help → Diagnostics → Trace"

5️⃣ SQL Interview QUERY WRITING

Medium Level:
1. Write a query to find the second highest salary in an employee table
Use LIMIT 1, OFFSET 1
OR Rank on salary column select rank=2

3. Write year-on-year growth in SQL?

4. Write a query for cumulative sum in SQL?

5. How do you retrieve only duplicate records from a table?

SELECT username, email, COUNT(*)
FROM users
GROUP BY username, email
HAVING COUNT(*) > 1

6. How do you retrieve unique values from a table using SOL?

DISTINCT

[Link] a query to find the most frequently occurring value in a column.

SELECT TOP 1 Name

FROM Students

GROUP BY Name

ORDER BY Name DESC

8. Fetch records where the date is within the last 7 days from today.
Select * from table
WHERE CreatedDate BETWEEN sysdate-7 AND sysdate

9. Write a query to count how many employees share the same salary.
SELECT [Link], [Link], [Link]
FROM Staff s1 INNER JOIN Staff s2
ON [Link] = [Link]
AND [Link] <> [Link]

10. How do you fetch the top 3 records for each group in a table?
-- Retrieve top 2 salespersons per region
WITH CTE AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY Region ORDER BY Revenue DESC) AS row_num
FROM
Sales )
SELECT * FROM CTE WHERE row_num <= 3;

[Link] products that were never sold (hint: use LEFT JOIN).
SELECT count([Link]) AS 'number of products that have not been sold'
FROM product AS p LEFTJOIN orderDetail AS od
ON [Link] = [Link]
WHERE [Link] IS NULL ;

12. Fetch all employees whose names contain the letter "a" exactly twice.
select col from test
where regexp_count(col, 'a') = 2;

13. Write a query to calculate the running total of sales by date.

14. Find employees who earn more than the average salary in their department.
Use subquery

Challenging Level:
1. Retrieve customers who made their first purchase in the last 6 months.

2.

3. Write a query to calculate the percentage change in sales month-over-month.

--> Similar like YoY

[Link] the median salary of employees in a table.

select id, company, salary
from
( select id, company, salary,
row_number() over(partition by company order by salary) as rno,
count(*) over(partition by company) as cnt
from Employee ) x
where rno in (ceil(cnt/2), cnt/2 + 1);

[Link] all users who logged in consecutively for 3 days or more.

[Link] a query to delete duplicate rows while keeping one occurrence.

WITH CTE AS ( SELECT SN, EMPNAME, DEPT, CONTACTNO, CITY,
ROW_NUMBER() OVER (PARTITION BY EMPNAME, DEPT, CONTACTNO, CITY ORDER BY SN) AS RowNum
FROM DETAILS )
DELETE FROM CTE WHERE RowNum > 1;

7. Create a query to calculate the ratio of sales between two categories.

-->divide the sales of the first category by the sales of the second category

8. How would you implement a recursive query to generate a hierarchical structure?

9. Write a query to find gaps in sequential numbering within a table.

select rownum from dual connect by rownum <= (select max(STUD_ID) from stud)
minus
select STUD_ID from STUD;
[Link] a comma-separated string into individual rows using SQL

Advanced Problem-Solving:
1. Rank products by sales in descending order for each region.
SELECT TOP 5 item_id , items_sold
FROM sales_details ORDER BY items_sold DESC

2. Fetch all employees whose salaries fall within the top 10% of their department.
PERCENT_RANK() -->Calculates the relative rank of each employee’s salary within the dataset.(For example: 0.1, 0.2 etc) Ranks range from 0 (lowest
salary) to 1 (highest salary)

3. Identify orders placed during business hours (e.g., 9 AM to 6 PM).

4. Write a query to get the count of users active on both weekdays and weekends.

5. Retrieve customers who made purchases across at least three different categories.

7️⃣Oracle EBS Standard APIs

Note: Always prefer public APIs (*_PUB, *_API) instead of direct DML on base tables.
1️⃣ General Ledger (GL)
Common APIs
API
Purpose
GL_JE_BATCHES_PUB.CREATE_JE_BATCH
Create journal batch
GL_JE_HEADERS_PUB.CREATE_JE_HEADER
Create journal header
GL_JE_LINES_PUB.CREATE_JE_LINE
Insert journal lines
GL_JE_BATCHES_PUB.POST
Post journals
GL_PERIOD_STATUSES_PKG.OPEN_PERIOD
Open accounting period
Real Use Case
✔ Journal upload from legacy system
✔ Automated posting after validation
2️⃣ Accounts Payable (AP)
Common APIs
API
Purpose
AP_INVOICES_PUB.CREATE_INVOICE
Create AP invoice
AP_INVOICE_LINES_PUB.CREATE_INVOICE_LINE
Add invoice lines
AP_PAYMENTS_PUB.CREATE_PAYMENT
Create payment
AP_HOLDS_PUB.RELEASE_HOLD
Release invoice hold
AP_VENDOR_PUB_PKG.CREATE_VENDOR
Create supplier
Use Case
✔ Invoice import automation
✔ Vendor creation from portal
3️⃣ Accounts Receivable (AR)
Common APIs
API
Purpose
AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE
Create AR invoice
AR_RECEIPT_API_PUB.CREATE_CASH
Create receipt
AR_RECEIPT_API_PUB.APPLY
Apply receipt
AR_ADJUST_PUB.CREATE_ADJUSTMENT
Adjust invoice
Use Case
✔ Auto invoice creation
✔ Cash receipt integration
4️⃣ Purchasing (PO)
Common APIs
API
Purpose
PO_HEADERS_INTERFACE_SV5
Import PO
PO_CHANGE_API1_S.UPDATE_PO
Update PO
PO_DOCUMENT_ACTION_PUB.DO_ACTION
Approve / Cancel PO
PO_REQIMPORT_PUB.CREATE_REQ
Create Requisition
Use Case
✔ PO creation from external system
✔ Automated approval
5️⃣ Inventory (INV)
Common APIs
API
Purpose
INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS
Inventory transaction
INV_ITEM_PUB.CREATE_ITEM
Create item
INV_ITEM_PUB.UPDATE_ITEM
Update item
INV_LOT_API_PUB.CREATE_LOT
Lot creation
Use Case
✔ Inventory adjustment
✔ Item master integration
6️⃣ Order Management (OM)
Common APIs
API
Purpose
OE_ORDER_PUB.PROCESS_ORDER
Create / update sales order
OE_ACTIONS_PUB
Book / cancel order
OE_MSG_PUB.GET
Retrieve OM messages
Use Case
✔ Sales order creation from website
✔ Auto booking
7️⃣ Bills of Material (BOM)
APIs
API
Purpose
BOM_BO_PUB.CREATE_BILL
Create BOM
BOM_BO_PUB.UPDATE_BILL
Update BOM
BOM_RTG_PUB.CREATE_ROUTING
Create routing
8️⃣ Work in Process (WIP)
APIs
API
Purpose
WIP_JOB_SCHEDULE_PUB.CREATE_JOB
Create job
WIP_JOB_SCHEDULE_PUB.RELEASE_JOB
Release job
WIP_MTL_TXN_PUB.PROCESS
Material issue
9️⃣ HRMS
APIs
API
Purpose
HR_EMPLOYEE_API.CREATE_EMPLOYEE
Create employee
HR_PERSON_API.UPDATE_PERSON
Update person
HR_ASSIGNMENT_API.UPDATE_ASSIGNMENT
Update assignment
🔟 Fixed Assets (FA)
APIs
API
Purpose
FA_ADDITION_PUB.DO_ADDITION
Asset addition
FA_TRANSFER_PUB.DO_TRANSFER
Transfer asset
FA_RETIREMENT_PUB.DO_RETIREMENT
Retire asset
1️⃣1️⃣ Cash Management (CE)
APIs
API
Purpose
CE_RECONCILIATION_PUB.RECONCILE
Bank reconciliation
CE_STATEMENT_LOADER_PUB.LOAD_STATEMENT
Load bank statement
1️⃣2️⃣ AOL / System Admin
APIs
API
Purpose
FND_USER_PKG.CREATEUSER
Create user
FND_RESPONSIBILITY_PUB.ADD_RESPONSIBILITY
Assign responsibility
FND_PROFILE.SAVE
Set profile option
FND_CONCURRENT_PROGRAMS_PKG
CP registration
1️⃣3️⃣ Workflow
APIs
API
Purpose
WF_ENGINE.STARTPROCESS
Start workflow
WF_ENGINE.SETITEMATTR*
Set parameters
WF_NOTIFICATION.SEND
Send notification
WF_EVENT.RAISE

Raise business event

Interview Tips ⭐
✔ Mention RETURN_STATUS, MSG_COUNT, MSG_DATA
✔ Always call FND_GLOBAL.APPS_INITIALIZE
✔ Use MO_GLOBAL.INIT for R12
✔ Avoid direct DML on base tables
One-Line Interview Summary

6️⃣SQL Theory 30 QnA

1.) Explain order of execution of SQL

FROM, WHERE, GROUP BY, HAVING,
SELECT, DISTINCT,
ORDER BY,
and LIMIT

2.) What is difference between where and having?

--> WHERE filters rows before grouping, while HAVING filters groups after grouping (using GROUP BY) and is used with aggregate functions.

3.) What is the use of group by?

-->GROUP BY clause in SQL is used to group rows with the same values in one or more columns, often used in conjunction with aggregate functions
(like COUNT, SUM, AVG, MAX, MIN) to summarize data

4.) Explain all types of joins in SQL?

->NATURAL JOIN
INNER JOIN (returns only matching rows),
LEFT JOIN(returns all rows from the left table and matching rows from right),
RIGHT JOIN (returns all rows from the right table and matching rows from the left),
FULL OUTER JOIN (returns all rows from both tables),
CROSS JOIN (returns all possible combinations),
SELF JOIN (joins a table to itself

5.) What are triggers in SQL?

6.) What is stored procedure in SQL, Diff b/w procedure & packages

7.) Explain all types of window functions? (Mainly rank, row_num, dense_rank, lead & lag)

8.) What is difference between Delete and Truncate , DROP?

9.) What is difference between DML, DDL and DCL?

10.) What are aggregate function and when do we use them? explain with few example
11.) Which is faster between CTE and Subquery?
CTE - Common Table Expressions

12.) What are constraints and types of Constraints?

NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, and DEFAULT

13.) Types of Keys?

-Candidate, Super, Primary, Alternate and Foreign ,composite

14.) Different types of Operators?

arithmetic, relational, logical, bitwise, assignment, and conditional operators.

15.) Difference between Group By and Where?

16.) What are Views?

view , complex, materilized view

17.) What is difference between varchar and nvarchar?

NVARCHAR uses Unicode, allowing it to store characters from multiple languages and scripts. VARCHAR stores each character using a single byte,
NVARCHAR columns typically consume twice as much storage space as equivalent VARCHAR columns

18.) Similar for char and nchar?

19.) What are index and their types?

indexes are database structures that speed up data retrieval by allowing the database engine to quickly locate rows based on specific column values,
like an index in a book.
The main types are clustered, non-clustered, unique, composite, and filtered indexes

20.) List the different types of relationships in SQL

one-to-one, one-to-many, many-to-one, many-to-many & self referencing relationship

21.) Differentiate between UNION and UNION ALL

UNION removes duplicate rows from the combined result set,
while UNION ALL includes all rows, including duplicates.

22.) How many types of clauses in SQL?

SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY

23.) Difference between Primary Key and Secondary/alternative Key?

a primary key uniquely identifies each row in a table,
while a secondary key (or alternate key) provides alternate access to data and can be used for indexing and sorting, but is not the primary identifier

24.) What is the difference between where and having?

25) Do we use variable in views?

--> NO

26) What are the limitations of views?

potential performance degradation due to query translation,
restrictions on DML operations on views derived from multiple tables, the inability to create indexes or triggers directly on them
No Physical Data Storage

27) Difference between Function and Store procedure?

Purpose:
F@ Designed to perform a specific calculation or transformation and return a single value.
SP@ Designed to perform a set of tasks, which can include data manipulation, retrieval, and processing.
Return Value:
F@ Must return a single value
SP@ Can return zero, one, or multiple values (using output parameters or result sets).
Parameters:
F@ Can only accept input parameters (IN parameters).
SP@ Can accept input, output, and input/output parameters.
Invocation:
F@ Can be called from various contexts, including SELECT statements, other stored programs, and client applications.
SP@ Can be called using the CALL statement.
Data Modification:
F@ Cannot modify the database (no DML statements).
SP@ Can modify the database (DML statements like INSERT, UPDATE, DELETE

28. How do you optimize a slow-running SQL query?

Use indexes effectively.
Avoid SELECT * and retrieve only necessary columns.
Optimize JOIN operations.
Minimize the use of subqueries.
Avoid redundant or unnecessary data retrieval.
Utilize stored procedures.
Consider partitioning and sharding.
Normalize database tables.

29. What are subqueries and how do you use them?

Scalar Subqueries: Return a single value.
Multiple-Row Subqueries: Return multiple rows.
Correlated Subqueries: The subquery's result depends on the outer query's row

30. How do you use 'PARTITION BY' and 'ORDER BY in window functions?
PARTITION BY divides the result set into partitions, and
ORDER BY defines the logical order of rows within each partition, allowing for calculations across related groups of rows
OVER (PARTITION BY column1, column2 ORDER BY column3, column4)

31. How do you handle NULL values in SQL, and what functions help with that (e.g., 'COALESCE', 'ISNULL")?

32. Normalize database tables

9️⃣EBS Manufacturing and SCM

Here’s a comprehensive overview of Oracle E-Business Suite (EBS) Manufacturing and Supply Chain Management (SCM) modules — essential for
companies involved in production, inventory, planning, procurement, and distribution.

---

🔧 ORACLE EBS MANUFACTURING MODULES

These modules handle end-to-end production processes.

1. Oracle Bills of Material (BOM)

Defines the components (parts) needed to build a product.

Supports version control and engineering changes.

Key Table: BOM_BILL_OF_MATERIALS, BOM_COMPONENTS.

2. Oracle Work in Process (WIP)

Manages shop floor operations and work orders.

Tracks labor, machine, and material consumption.

Supports discrete, repetitive, and flow manufacturing.

Key Table: WIP_DISCRETE_JOBS.

3. Oracle Cost Management (CST)

Calculates product cost, variance, and overhead.

Integrates with Inventory and WIP.

Supports standard costing, average costing, and actual costing.

4. Oracle Engineering (ENG)

Manages engineering items, revisions, and prototypes.

Controls product lifecycle and design approval.

5. Oracle Quality

Captures quality inspection data across manufacturing and inventory.

Supports collection plans and non-conformance management.

6. Oracle Manufacturing Execution System (MES)

Real-time tracking of shop floor activities.

Improves productivity and quality compliance.

---

🚚 ORACLE EBS SUPPLY CHAIN MANAGEMENT (SCM) MODULES

These modules handle planning, sourcing, logistics, and inventory.

1. Oracle Inventory (INV)

Manages stock levels, transactions, and reservations.

Supports lot, serial, and subinventory tracking.

Core for all modules needing inventory data.

2. Oracle Purchasing (PO)

Manages requisitions, RFQs, POs, and supplier negotiations.

Integrates with AP, Inventory, and iProcurement.

Supports centralized and decentralized procurement.

3. Oracle Order Management (OM)

Captures and manages sales orders from customers.

Handles pricing, shipping, invoicing, and credit checks.

4. Oracle Shipping Execution (WSH)

Manages picking, packing, and shipping of goods.

Interfaces with OM and Inventory for fulfillment.

5. Oracle Advanced Supply Chain Planning (ASCP)

Provides material and resource planning using constraint-based logic.

Replaces legacy MRP module.

6. Oracle iProcurement

Web-based self-service portal for employee purchase requests.

Integrates with PO and Approvals.

7. Oracle iSupplier Portal

Allows vendors to view POs, acknowledgments, shipment notices.

Improves supply collaboration.

8. Oracle Sourcing

Automates RFQ, auction, and negotiation processes with suppliers.

9. Oracle Transportation Management (OTM)

Handles carrier selection, freight payment, routing.

Integrates with WSH and external logistics systems.

10. Oracle Warehouse Management System (WMS)

Advanced capabilities for warehouse operations, putaway, picking.

Supports barcode, LPN, mobile devices.

---

🔄 TYPICAL SCM & MANUFACTURING FLOWS

🔹 Procure to Pay (P2P)
> PR → PO → Receive → Inspect → AP Invoice → Payment
Involves: iProcurement, Purchasing, Inventory, Payables

🔹 Order to Cash (O2C)

> Customer Order → Pick → Ship → Invoice → Receipt
Involves: Order Management, Inventory, Shipping, Receivables

🔹 Manufacturing Execution
> Create Work Order → Issue Components → Track Operations → Complete Assembly → Cost
Involves: BOM, WIP, Inventory, Cost Management
---

🗃️ INTEGRATION ACROSS MODULES

Area Integrated Modules

Procurement PO, iProcurement, INV, AP

Planning ASCP, BOM, INV, WIP

Production WIP, BOM, ENG, CST

Fulfillment OM, WSH, INV, AR

Supplier iSupplier, Sourcing, PO

Quality Quality, INV, WIP

---

📌 KEY TABLES (Few Examples)

Table Description

WIP_DISCRETE_JOBS Work Orders

BOM_BILL_OF_MATERIALS Header info for BOM

MTL_SYSTEM_ITEMS_B Master Item

PO_HEADERS_ALL, PO_LINES_ALL Purchase Orders

OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL Sales Orders

RCV_TRANSACTIONS Receiving transactions

MTL_MATERIAL_TRANSACTIONS Inventory transactions

CST_COST_DETAILS Item cost breakdown

---

📊 Reports & Concurrent Programs

WIP Job Costing Report

BOM Explosion Report

ASCP Plan Run (Concurrent Program)

Purchase Order Summary

Pick Release and Ship Confirm

Inventory Valuation Report

8️⃣FND_* Tables

Below is a comprehensive list of key FND_* tables in Oracle E-Business Suite, along with descriptions of their purpose within the system:
---
🧩 Core Application Foundation Tables
Table Description

FND_APPLICATION / FND_APPLICATION_TL Stores registered applications and their translated names .

FND_TABLES Lists tables that are registered within Oracle Apps, with metadata on ownership, type, and descriptions .

FND_COLUMNS Contains column-level details for registered FND tables.

FND_VIEWS Stores registered database views; also has a translation table (_TL).

---

👤 User/Security Management Tables

Table Description

FND_USER Contains application user data .

FND_RESPONSIBILITY / FND_RESPONSIBILITY_TL Stores user responsibility definitions and their translations .

FND_USER_RESP_GROUPS Lists responsibilities assigned to users.

FND_SECURITY_GROUPS Used in multi-tenant Service Bureau setups .

---

🗂️ Menu & Function Security Tables

Table Description

FND_MENUS / FND_MENUS_TL Defines menu structures and their translated names .

FND_MENU_ENTRIES Stores individual entries (functions) under each menu .

FND_RESP_FUNCTIONS Links responsibilities to functions and menus, controlling access .

---

⚙️ Concurrent Processing Tables

Table Description

FND_EXECUTABLES Lists executable definitions for concurrent programs .

FND_CONCURRENT_PROGRAMS / FND_CONCURRENT_PROGRAMS_TL Stores registered concurrent program details and translations .

FND_REQUEST_GROUPS Defines groups of concurrent programs tied to responsibilities .

FND_CONCURRENT_REQUESTS Tracks execution history of individual concurrent requests .

FND_CONC_REQ_OUTPUTS Stores log/output references from concurrent runs .

FND_CONCURRENT_PROCESSES Info about concurrent manager processes .

FND_CONCURRENT_PROCESSORS Intermediate library processes used by Oracle .

FND_CONCURRENT_QUEUES Defines which managers handle which requests .

FND_CONCURRENT_QUEUE_SIZE Manages concurrent queue sizes per shift .

FND_CONCURRENT_REQUEST_CLASS Defines types/categories of requests .

---

🧾 Flexfields & Lookups

Table Description

FND_DESCRIPTIVE_FLEXS / _TL Descriptive Flexfield definitions and translations .

FND_FLEX_VALUE_SETS Stores Value Set definitions .

FND_FLEX_VALUES Stores valid values for Flexfield segments .

FND_LOOKUP_TYPES Defines types of lookup lists.

FND_LOOKUP_VALUES Stores actual LOV entries under lookup types .

---

🌐 Translation & Multi-language Support

Many core tables have translation variants suffixed by _TL, e.g.:

FND_APPLICATION_TL
FND_MENUS_TL
FND_RESPONSIBILITY_TL
FND_CONCURRENT_PROGRAMS_TL
This supports multilingual use .

---

🌍 Localization & Master Data Tables

Table Description

FND_CURRENCIES Lists currencies used in apps .

FND_LANGUAGES Stores available languages and dialects .

FND_TERRITORIES Country/territory definitions for localization .

---

🔧 System Infrastructure Tables

Table Description

FND_APP_SERVERS Tracks EBS application server data .

FND_DATABASES Defines database connections for EBS .

FND_DATABASE_INSTANCES Stores database instance-specific info .

FND_SEQUENCES Registry of application-wide sequences .

---

📄 Document & Attachment Tables

Table Description

FND_DOCUMENTS, FND_ATTACHED_DOCUMENTS Core document metadata and links .

FND_DOCUMENTS_LONG_RAW, _LONG_TEXT, _SHORT_TEXT, FND_LOBS Stores BLOBs, CLOBs, long attachments .

---

🔍 Want the FULL list?

There are dozens more—like FND_FLEX_VALUE_CHILDREN, FND_DATA_GROUPS, FND_PRIMARY_KEYS, etc.—which are all accessible via the FND Data
Dictionary page in EBS .

---

✅ Summary:
These core tables power the foundational framework of Oracle EBS: security, concurrent processing, flexfields, localization, logging, and documents.
If you need column-level details or SQL queries to explore them, just let me know!

1️⃣0️⃣EBS cycles—OTC, P2P, FA & R2R

1️⃣ Order-to-Cash (OTC / O2C)🔄 Process Flow:

1. Sales Order ▶
OE_HEADERS_IFACE_ALL,
OE_LINES_IFACE_ALL
▶ run Order Import (OEOIMP).

2. Book Order ▶ base tables: OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL.

3. Reservation ▶
INV_RESERVATIONS, using INV_RESERVATION_PUB.

4. Pick Release ▶
WSH_RELEASE_HEADER, WSH_RELEASE_LINES_ALL.

5. Ship Confirm ▶
WSH_DELIVERY_DETAILS, WSH_DELIVERY_ASSIGNMENTS.

6. Invoicing ▶
AR_INVOICE_INTERFACE, Autoinvoice program.

7. Receipt ▶
AR_CASH_RECEIPTS_ALL, AR receipt API.

8. Transfer to GL ▶
GL_INTERFACE, run Create Accounting.

📋 Key Concurrent Programs:

Order Import – OEOIMP
Pick Release – WSHRPRLC
Ship Confirm – WSHCONF
AutoInvoiceImport RA_IMPORT_CUSTOMER_TRX
Create Accounting – GL_INTERFACE

🧩 Tables:
Interface: OE_HEADERS_IFACE_ALL, OE_LINES_IFACE_ALL, AR_INVOICE_INTERFACE
Base: OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, AR_INVOICE_LINES_ALL, WSH cycles

---

🔄 Process Flow:
2️⃣ Procure-to-Pay (P2P)

1. Requisition ▶
PO_REQ_HEADERS_INTERFACE, PO_REQ_LINES_INTERFACE.

2. Import Req ▶ Requisition Import populates PO_REQUISITION_HEADERS_ALL, PO_REQUISITION_LINES_ALL, PO_REQ_DISTRIBUTIONS_ALL.

3. PO Creation ▶
PO_HEADERS_ALL,
PO_LINES_ALL,
PO_DISTRIBUTIONS_ALL.

4. Receipt ▶
RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES,
RCV_TRANSACTIONS.

5. Inspection/Quality ▶ QA_RESULTS.

6. Invoice ▶ AP_INVOICES_INTERFACE,import to AP_INVOICES_ALL,

AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL.

7. Payment ▶ AP_INVOICE_PAYMENTS_ALL, via Payables Workbench.

8. Transfer to GL ▶ GL interface.

📋 Key Concurrent Programs:

Requisition Import – POXPRQIM
Purchase Order Import – POXPOIIM
Receipt Transaction Import – RCVTXN
Invoice Import – APXPIXXR
Payment Program – AP Payment Process

🧩 Tables:
Interface: PO_REQ_…, PO_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE, AP_INVOICES_INTERFACE
Base: PO_HEADERS_ALL, RCV_SHIPMENT_HEADERS, AP_INVOICES_ALL, AP_INVOICE_LINES_ALL

---
3️⃣ Fixed Assets (FA) – Asset-to-GL
🔄 Process Flow:
1. Asset Creation/Addition ▶ FA_ADDITIONS_INTERFACE ▶ FA_ADDITIONS_ALL.

2. Depreciation Calculation ▶ program Run Depreciation.

3. Asset Transfer/Disposal ▶ FA_TRANSFER_INTERFACE,

FA_TRANSFER_ALL.

4. GL Transfer ▶ Create Asset Accounting → GL_INTERFACE_FLAT.

📋 Key Concurrent Programs:

Assets Additions Import – FAADDIM
Run Depreciation – FAGLDPYN
Transfer to GL – FA_POSTING
🧩 Tables:
Interface: FA_ADDITIONS_INTERFACE, FA_TRANSFER_INTERFACE
Base: FA_ADDITIONS_ALL, FA_DEPRN_DETAILS, FA_ASSET_EVENTS

---

4️⃣ Record-to-Report (R2R) – General Ledger

🔄 Process Flow:
1. Subledger Transfer – Create Accounting:
AR/AP/FA → GL_INTERFACE.

2. Import Journals – Import Journals → GL_IMPORT_REFERENCES,

GL_IMPORT_FILES.

3. Validate – Validate Journals program.

4. Post Journals – Post Journals → GL_JE_HEADERS,

GL_JE_LINES.

5. Close Periods – Period Close.

6. Reporting – Trial balances, financial analysis.

📋 Key Concurrent Programs:

Create Accounting – GL_INTERFACE
Import Journals – GL_IMPORT
Validate Journals – GL_VALIDATE
Post Journals – GL_POST
Period Close – GL_CLOSE

🧩 Tables:
Interface: GL_INTERFACE, GL_IMPORT_FILES
Base: GL_JE_HEADERS, GL_JE_LINES, GL_PERIOD_STATUSES

---

🔁 Cycle Integrations & Key Interfaces

Cycle Step Downstream Tables / APIs Concurrent Program

Order Import(OEOIMP) OE_ORDER_HEADERS_ALL

AutoInvoice

AR_INVOICE_LINES_ALL RA_IMPORT_CUSTOMER_TRX

Requisition Import PO_REQUISITION_HEADERS_ALL POXPRQIM

PO Import PO_HEADERS_ALL POXPOIIM

Receipt Import RCV_TRANSACTIONS RCVTXN

Po Invoice Import AP_INVOICES_ALL APXPIXXR

Assets Add Import FA_ADDITIONS_ALL FAADDIM

Create Asset GL GL_INTERFACE_FLAT FA_POSTING

Subledger to GL GL_INTERFACE GL_INTERFACE

Journal Load GL_IMPORT_FILES + GL_JE_LINES GL_IMPORT, GL_VALIDATE, GL_POST

Period Close GL_PERIOD_STATUSES GL_CLOSE