🔹 Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Cloud/Fusion Applications. 📌 Telegram Group : https://t.me/OracleApps88

💡 Facing issues copying code/scripts or viewing posts? We're here to help!
📬 Contact on Telegram : https://t.me/apps88
📱 Telegram/WhatsApp: +91 905 957 4321
📧 Email Support: OracleApp88@Yahoo.com
Showing posts with label P2P. Show all posts
Showing posts with label P2P. Show all posts

Wednesday, September 10, 2025

FAQS - Procure To Pay (P2P) Interview Questions and Answers

1. Can you walk us through the end-to-end P2P (Procure-to-Pay) process in your previous role?

Certainly. In my previous role as a Process Specialist in Accounts Payable:

 Purchase Requisition (PR): The process started when a department raised a PR.

 Purchase Order (PO): After approval, the procurement team issued a PO to the vendor.

 Goods Receipt (GRN): Upon delivery, the receiving team confirmed the goods receipt.

 Invoice Receipt: The vendor submitted an invoice, which we verified against the PO and GRN (3-way match).

 Invoice Processing: I validated invoice details—tax, amount, vendor code, and terms—before posting it in SAP.

 Exception Handling: Any mismatch or non-PO invoices were routed for resolution or manual approval.

 Payment Processing: Based on due dates and payment terms, I scheduled payments via wire transfer, ACH, or check

runs.

 Reconciliation & Reporting: Monthly vendor reconciliations and AP aging reports ensured accuracy and timely

closure.

 

2. How do you ensure accuracy and compliance during invoice processing and vendor payments?

To ensure accuracy and compliance:

 3-Way Matching: I consistently performed PO, GRN, and invoice matching.

 Tax and Legal Compliance: Verified tax codes (GST, TDS), compliance with local tax regulations, and ensured invoice

legality.

 Vendor Master Data: Maintained up-to-date vendor records to avoid duplicate or incorrect payments.

 Approvals: Followed delegated authority for non-PO invoices.

 Audit Trail: Ensured documentation and audit logs were maintained in the ERP system.

 Internal Controls: Complied with SOX controls, segregation of duties, and company policies.

 

3. Have you worked on any part of the O2C (Order-to-Cash) or R2R (Record-to-Report) cycle? Describe your involvement.

Yes, I have supported both O2C and R2R processes.

 O2C: I coordinated with the AR team for resolving customer credit memos related to duplicate payments and

ensured AP offsets where required.

 R2R: Actively involved in:

o Month-End Close: Accrual postings, prepayment amortizations, and invoice cutoffs.

o Journal Entries: Posted AP-related entries like FX revaluations and intercompany AP/AR settlements.

o Reconciliations: Prepared GR/IR and AP subledger to GL reconciliations.

o Audit Support: Provided audit schedules and responded to internal/external audit queries.

 

4. How do you handle budget tracking, forecasting, and variance analysis in AP functions?

While AP isn’t the owner of budgeting, I worked closely with the FP&A team:

 Budget Tracking: Ensured invoices were charged to the correct cost centers and projects.

 Forecasting: Shared AP open items and expected payments to help forecast cash outflows.

 Variance Analysis: Investigated significant differences between actual and forecasted spending, such as seasonal

vendor costs, early payments, or unanticipated charges.

 

5. Give an example of how you’ve used Excel/Google Sheets to automate or streamline a repetitive AP task.

I created a macro-enabled Excel dashboard that:

 Pulled AP aging data from SAP exports.

 Highlighted overdue invoices by aging buckets and vendors.

 Automated pivot tables and graphs for weekly management reviews.

This saved about 3–4 hours per week and improved reporting consistency.

 

6. Tell us about a time you juggled multiple urgent AP requests. How did you prioritize and deliver?

During a quarter-end, I received:

 A request to expedite a vendor payment for a critical service.

 A follow-up on tax deduction corrections.

 A request for AP aging data from finance leadership.

I quickly:

 Assessed urgency and impact.

 Escalated the urgent payment to treasury for immediate release.

 Delegated the data request to a team member with guidance.

 Personally, corrected the TDS entry after verifying documents.

By multitasking and leveraging the team, I met all deadlines without errors.

 

7. Describe a situation where you had to collaborate cross-functionally to resolve a procurement/payment issue.

We once had a PO mismatch where the vendor invoiced for a higher amount than the PO. The invoice was blocked.

I initiated a joint call with:

 The procurement team (to revise PO or approve the variance),

 The business unit (to confirm service completion),

 And the vendor (to clarify billing logic).

After alignment, the PO was updated, and I processed the invoice. The issue was resolved within 48 hours, maintaining

vendor trust and operational flow.

 

8. How do you handle duplicate invoice entries?

Answer:

We used SAP's duplicate check functionality (invoice number + vendor code + date). If a duplicate was detected manually, I

reversed the duplicate entry and flagged the vendor to avoid re-submission. I also coordinated with the vendor master team

to ensure clean data and proper invoice formats.

 

9. Describe your experience with 3-way and 2-way matching.

Answer:

For PO invoices, we followed 3-way matching (PO, GRN, Invoice). If all three matched, the invoice auto-posted. For service

POs, we used 2-way matching (PO & invoice), since no physical goods were involved. Any mismatch went into blocked status

for investigation.

 

10. How do you manage aged payables or long-outstanding invoices?

Answer:

I ran AP Aging reports weekly. For invoices nearing or over 90 days, I followed up with the business unit or vendor for any

dispute resolution. I also flagged aged payables in our month-end review meetings to ensure timely clearance or accruals.

 

11. What steps do you take before processing payments to vendors?

Answer:

1. Confirm invoice approval and GRN.

2. Validate vendor bank details (especially for new vendors).

3. Review due dates and payment terms.

4. Check if any invoices are on hold.

5. Include vendor in payment run, review exceptions, and get approvals before release.

 

12. Have you dealt with blocked invoices? How did you resolve them?

Answer:

Yes. Blocked invoices occurred due to price mismatches, missing GRN, or PO tolerance breaches. I reviewed the cause using

SAP’s MIRO and MRBR reports, then coordinated with procurement or end-users to resolve and clear the block for payment.

 

13. How do you handle urgent payment requests outside the scheduled payment run?

Answer:

I verified the urgency with the business unit, ensured invoice approvals and budget availability, then processed the payment

manually via treasury or using a special immediate payment T-Code in SAP (e.g., F-53). Proper documentation was

maintained for audit trails.

 

14. Explain how you performed vendor reconciliation.

Answer:

I obtained the vendor SOA (statement of account), matched it against our AP subledger, identified missing invoices/credit

notes/payments, and prepared reconciliation statements. Unreconciled items were escalated or corrected via debit/credit

memos or reprocessing.

 

15. Describe a time you prevented a fraudulent or erroneous payment.

Answer:

Once a vendor submitted a changed bank account via email. I flagged it for verification, escalated to the vendor master

team, and later discovered the email was spoofed. This prevented a potential fraud of INR 8 lakhs. Since then, we enforced

verbal verification.

 

16. How do you handle non-PO invoices?

Answer:

Non-PO invoices required manual validation and routing for approval via workflow or email authorization. I ensured proper

GL coding, cost centre tagging, and business unit approval before processing.

 

17. Have you handled foreign currency vendor invoices?

Answer:

Yes. I ensured the correct currency and exchange rate were picked from the system (e.g., based on forex table in SAP),

calculated tax separately, and ensured the forex gain/loss was posted accurately during payment or month-end revaluation.

 

18. How do you ensure compliance with TDS/GST or local tax requirements?

Answer:

I checked vendor types, PAN availability, and nature of service to apply the correct TDS section. For GST, I ensured correct

HSN/SAC codes, GSTIN match, and tax jurisdiction. Rejected mismatches via RCM logic and corrected entries through JV

adjustments.

 

19. What’s your process during month-end AP closing?

Answer:

 Ensure all invoices are posted for the period.

 Reconcile GR/IR and AP subledger.

 Post AP accruals for unreceived invoices.

 Review blocked invoices and clear as needed.

 Submit AP aging and liability reports.

 Assist with audit schedules and JE posting.

 

20. How do you communicate and follow up with vendors on pending issues?

Answer:

I maintained a tracker of open issues, sent weekly follow-ups via email, and scheduled vendor calls for resolution. I used a

standard format including invoice number, PO, issue type, and expected action. This built accountability and improved

turnaround time.

 

21. Describe how you updated or corrected vendor master data.

Answer:

Changes were routed via a standardized vendor change form, validated with supporting documents (GST, PAN, cancelled

cheque), and approved by authorized personnel. Then, it was updated in SAP using XK02 or via master team’s workflow tool.

 

22. What controls do you have in place to prevent duplicate or overpayments?

Answer:

 Enabled duplicate checks in ERP.

 Regular vendor reconciliations.

 Mandatory invoice number + date checks.

 Clear segregation between invoice entry and payment release.

 Approval workflow for invoices and urgent payment exceptions.

 

23. How do you train new team members in AP processes?

Answer:

I created SOPs, gave them walkthroughs of live cases, provided process flowcharts, and monitored their work in the first few

weeks. I also involved them in small reconciliations and gradually moved to invoice processing and exception handling.

 

24. Have you worked on AP automation tools or workflows?

Answer:

Yes. We used Basware integrated with SAP for invoice capture and approval workflow. It automated invoice scanning, OCR

matching, routing to approvers, and reduced manual entry by ~60%. I also worked on se􀆫ng up rules for auto-coding based

on vendor and cost centre.

 

25. How do you handle credit memos from vendors?

Answer:

Credit memos were validated against the original invoice or overpayment. I ensured correct posting with negative amounts,

adjusted in the next payment run, or offset via manual clearing (F-44 in SAP). Documentation was attached for audit trail.

Wednesday, July 30, 2025

P2P - Oracle Cloud/Fusion Procure to Pay (P2P) Setups and Process Flow

 


P2P - Oracle Cloud/Fusion Procure to Pay (P2P) Setups and Process Flow


Pre-requisite Setups P2P Process:

1. Employee/User – Supervisor Setup

2. Buyer Setup

3. Supplier Setups

a. Supplier

b. Supplier Address

c. Supplier Sites

d. Supplier Contacts

4. Payment Setups

a. Payment Templates

b. Payment Formats

c. Payment Document

d. Payment Process Profile (PPP)

e. Payment Process Request Template (Optional)

5. Approval Setups

a. Requisition Approval

b. Purchase Document Approval

c. AP Invoice Approval


P2P Process Flow:

01. Create Requisitions

02. Approve Requisitions

03. Create Purchase Orders

04. Approve Purchase Orders

05. Receive Goods

06. Create Payables invoice with Match PO Lines

07. Invoice Payment to Supplier with Electronic Method

08. Transfer Payables data to General Ledger

09. Transfer Payments data to General Ledger

10. Verify the Journal Batches


Friday, March 27, 2020

Oracle Cloud (Fusion) Technical Training Manual


































Configuring Fusion Security
            01: Creating an Employee
02: Adding Roles to User and Resetting the Password
03: Create the Custom Role
04: Create (Inherit) the Custom Role with Standard Role
05: Verify the user in Manager Users
06: Add Business Unit Data Access to User
07: Setup Vacation Rule for a User
08: Setup Printer in Cloud Application
09: Run User and Roles Synchronization Process.
10: Setup the Manage Procurement Agent


AOL Concepts in Fusion
01: Lookups with example
02: Value sets with Example
03: Descriptive Flexfield (DFF) with Example
04: Profile Options with Example
05: Enabling DFF through Personalization with Sandbox

Conversions - Data Loading (Inbound Integrations)
            01: HDL - Create the Employee/User with HDL template
            02: HDL - Adding the Roles to User with HDL template
            03: FBDI - Creating Supplier with FBDI template
            04: ADFDi  - Creating a Journal with Spreadsheet


Reports - Data Extraction (Out Bound Integrations)
01: BIP – Customizing Standard Templates
02: BIP – Developing New BI Publisher Reports
03: OTBI - Oracle Fusion Transactional Business Intelligence Reports 
    1. Navigating to Reports and Analytics
    2. Roles Required to Run/Create/Modify the OTBI Reports
    3. Running Oracle Standard Report
    4. Creating Analysis Report for Supplier Details
        a. Adding the new column to the existing Report
        b. Remove the Column from the existing Report
        c. Applying the Prompt (Filter) to the existing Report Column
    5. Creating BI Report (Using Data Model) for Purchase Order Details
    6. Creating Ad Hoc Report for Expense Details
    7. Creating Dashboard Report
    8. Creating Dashboard Report with Prompt (Filter)
    9. Creating Master-Child Analysis Report with Prompt (Filter)
    10. Creating Analysis Report with Multiple Subject Areas
04: Smart View Setup and Process



BPM - Approval Management (Business Process Management)
01: Key Components Overview
02: Approval Key Concepts
03: Payables Approvals Overview
04: Available Attributes
05: Considerations
06: Vacation Rules
07: Escalation Policies
08: Expiration Settings
09: Renew Settings
10: Reminder Settings
11: Approval Notifications

P2P - Procure to Pay Life Cycle Process flow
01. Create Requisitions
02. Approve Requisitions
03. Create Purchase Orders
04. Approve Purchase Orders
05. Receive Goods
06. Create Payables invoice with Match PO Lines
07. Approve Invoice
08. Invoice Payment to Supplier with Electronic Method
09. Approve Payments
10. Verify the Transaction Life Cycle
11. Transfer Payables data to General Ledger
12. Transfer Payments data to General Ledger
13. Verify the Journal Batches
14. Verify the Notifications in Mail


O2C - Order to Cash Life Cycle Process Flow
01. Create Sales Order
02. Create Pick wave
03. Create Pick Confirm
04. Create Ship Confirm
05. Transfer to Receivables
06. Verify the Transaction
07. Create a Receipt and Apply the transaction
08. Transfer Invoice to General Ledger
09. Transfer Receipt data to General Ledger
10. Verify the Journal Batches


Oracle EBS R12 Technical

Oracle Cloud (SAAS) Technical

AOL Concepts

Concurrent Programs

Jobs

Request Sets

Job Sets

Flex Fields

Flex Fields

Value Sets

Value Sets

Profile Options

Profile Options

Lookups

Lookups

Conversions / Interfaces
Data Loading (Inbound Integrations)

Conversions

FBDI Loader, HDL for HCM

Interfaces

Third Party tool Mulesoft, Dell boomi

Web ADI

ADFDi -Spreadsheet loader

Data Loader

NA

Reports - Data Extraction
(Out Bound Integrations)

Oracle Reports
XML/BI Reports
PL/SQL Reports

OTBI Reports
BI/Analysis Reports

UTL_FILE (SFTP)

OTBI Reports with SFTP

Discoverer Reports

NA

Forms / Personalizations

Forms Development

NA

Forms Customizations

NA

Forms Personalizations

Personalizations with Sandbox

Workflow - Approval Management

Workflow Development

NA

AME - Approval Management Engine

BPM - Business Process Management

P2P - Procure to Pay

Create Requisitions

Create Requisitions

Approve Requisitions

Approve Requisitions

Create Purchase Orders

Create Purchase Orders

Approve Purchase Orders

Approve Purchase Orders

Receive Goods

Receive Goods

Create Payables invoice with Match PO Lines

Create Payables invoice with Match PO Lines

Approve Invoice

Approve Invoice

Invoice Payment to Supplier with Electronic Method

Invoice Payment to Supplier with Electronic Method

Transfer Payables and Payments data to GL

Transfer Payables and Payments data to GL

O2C - Order to Cash

Enter and Book the Sales Order

Create and Submit the Sales Order

Launch Pick Release

Create Pick wave

Pick Confirm The Order

Create Pick Confirm

Ship Confirm The Order

Create Ship Confirm

Transfer to Receivables

Transfer to Receivables

Create the Receipts and Apply the transaction

Create Receipt and Apply the transaction

Transfer Invoice and Receipt to GL

Transfer Invoice and Receipt to GL



Configuring Security    

1: Creating an Employee

Creating an employee from HCM’s Hire an Employee page.

1. Navigate to My Workforce/My Client Groups àNew Person.



 2. Click the Tasks panel tab > Hire an Employee.



 









3. Enter the following required fields:

Field                                      Value

Hire Date                             Today (defaults)

Hire Action                         Hire

Legal Employer                 US1 Legal Entity

Last Name                           Chinthapatla

First Name                          Raju

 

4. Click Next.



 

Note: If you get a Matching Person Records window, click Continue.

5. Enter Address details: 100 Main Street, Genoa, TX 77034, and Harris County.

Hint: Type in the street address and then the postal code to have the system complete the rest of the address.

6. Under E-Mail Details, click Add Row.

 7. Enter:

Field                      Value

Type Work          E-Mail

E-Mail                   OracleApps88@Yahoo.com

 

8. Click Next.



 

9. Scroll down to the Assignment tab, select or enter:

Field                                      Value

Business Unit                     US1 Business Unit

Department                        Finance US

Location                               Chicago

 

10. Accept all other defaults.

11. Click Next.



 

12. Scroll down and expand Expenses Information. (This is needed for Expense Reporting.)

13. Enter or select:

Field                                                                      Value

Default Expense Account                              101.10.60501.121.000.000

Expense Check Send-to Address                Home

 

14. Click Next.



 

15. Scroll down to the bottom of the page to verify that the Employee role is automatically assigned.

16. Click Submit.



 

17. Click Yes.



 

18. Click OK.



 

19. Navigate to: Directory > Directory.



 

Note: If you cannot see the entire Navigator, use Control and Scroll Down to minimize the screen.

20. Enter your Raju Chinthapatla Employee.

21. Click the Search icon.



 

22. Click your name to see details.



 














23. Review the details and go back



 


Once Employee/user is created, Application will send a mail notification to user and manager

 

User Mail Notification

User will get some of the company mandatory task in a mail notification



 


User will get the Reset the password URL in welcome email notification



 

Reset the password and log into application



 


And also Manger will get employee creation mail notifications



 

And also manager will get company action required email notifications























Please click on the below link for more details:

OracleApps88 - Oracle Cloud (Fusion) Technical Training Manual
https://drive.google.com/file/d/1YtyMd73ZnBq4wVGiJz7NirRD3gG2wQ9T


Thanks & Regards,
Raju Chinthapatla




If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect