Enterprise Resource Planning and Integrations BlogSpot

Skip to content

iExpense

Are Credit Card Transactions Released If An Imported Expense Report Invoice Is Deleted In Payables?

  • by Yogesh Pachpute
  • Posted on October 13, 2017October 13, 2017
  • iExpense

Goal: If an expense report containing credit card transactions is approved and imported, then the associated invoice is deleted in Payables, are the credit card transactions then released for use with a new expense report […]

Read More

Credit Card Transactions are not Reinstated When an Associated Invoice is Canceled

  • by Yogesh Pachpute
  • Posted on October 13, 2017October 13, 2017
  • iExpense

Goal: After an expense report with credit card transactions has been cancelled in Accounts Payable the expense report correctly shows a status of Cancelled, however, the credit card transactions on the expense report are not […]

Read More

Is it Possible To Reinstate an Expense Report That Has Already Been Imported Into Payables and Deleted As An Invoice?

  • by Yogesh Pachpute
  • Posted on October 13, 2017October 13, 2017
  • iExpense

Goal : A credit card related expense transaction was exported to AP successfully however the user noticed an anomly so they decided to cancel the invoice, purge data and retry to import the credit card […]

Read More

Can An Expense Report be Entered For a Terminated Employee?

  • by Yogesh Pachpute
  • Posted on October 13, 2017October 13, 2017
  • iExpense

To enter an Expense report for an employee, the employee has to be Active. The expense code looks at the Hire Date and the Actual Termination Date to determine if an employee is Active. The […]

Read More

Query to find if the Expense Report Preparer and Award Manager are Same

  • by Yogesh Pachpute
  • Posted on August 17, 2017August 17, 2017
  • iExpense

1 2 3 4 5 6 7 8 9 10 SELECT Decode(Count(*), 0, 'false', 'true') FROM apps.ap_expense_report_headers_all WHERE report_header_id = :transactionId AND employee_id IN (SELECT ap_web_ame_pkg.Getawardmanagerid(award_id, sysdate) FROM apps. ap_exp_report_dists_all dist WHERE report_header_id = :transactionId […]

Read More

Account Generation Logic in Oracle iExpenses

  • by Yogesh Pachpute
  • Posted on August 17, 2017August 17, 2017
  • iExpense

This article discussed how the accounting flexfield is generated in Oracle iExpenses when employee submits his or her expense report. For simplicity sake, let’s assume the expense report does not have any multi-currency or credit […]

Read More

How To Enter Internet Expense Reports For Other Persons

  • by Yogesh Pachpute
  • Posted on August 17, 2017October 30, 2017
  • iExpense

This feature is called “Authorized Delegate”. To have the ability to enter expense reports, withdraw expense reports, etc. for other individuals, do the following: Authorization Preferences (Self-Service Delegate Assignment) Users can now maintain their own list […]

Read More

Custom expense report number in Oracle iExpense

  • by Yogesh Pachpute
  • Posted on August 17, 2017August 17, 2017
  • iExpense

Use the Expense Report Number client extension to generate custom expense report numbers. You can, for example, customize the format of the expense report number to match your company’s numbering system. You create custom expense […]

Read More

Logic for Oracle Expense Reports ‘Invoice’ Date

  • by Yogesh Pachpute
  • Posted on August 17, 2017August 17, 2017
  • iExpense

Once the Expense Repot is converted to Invoice using the standard ‘Expense Report Export Program’ The invoice date is nothing but ‘week_end_date’ column populated on the ap_expense_report_headers_all table. Below is the logic used behind the screens […]

Read More

Oracle iExpense Report Tables with Policy Violation Details

  • by Yogesh Pachpute
  • Posted on August 17, 2017August 17, 2017
  • iExpense

Below are queries for Oracle iExpense to find out the Policy violation detail for iExpense reports. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 […]

Read More

Posts navigation

Older posts

Categories

  • AR Reconciliation (8)
  • BI Publisher (3)
  • Cash Management (4)
  • Concurrent Processing in R12 (4)
  • Conversion (2)
  • Fixed Asset (23)
  • General Ledger (19)
  • GRC (5)
  • iExpense (21)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Fusion Financial (11)
  • Oracle Database (2)
  • Oracle Fusion HCM (9)
  • Oracle Fusion HCM Technical (4)
  • Oracle Fusion Technical (9)
  • Oracle Installations (3)
  • Oracle Inventory (1)
  • Oracle SQL (4)
  • Order Management (1)
  • Payables (47)
  • Payables Period Close (10)
  • Payables Reconciliation (10)
  • Payments (29)
  • Payroll (1)
  • Perl and Unix Scripting (1)
  • Purchasing (4)
  • Receivables (16)
  • Receivables Period Close (15)
  • Receiving Subledger (3)
  • SubLedger Accounting (25)
  • Supply Chain Managment (1)
  • TCA – DQM (1)
  • Uncategorized (2)
  • Useful SQL Scripts (4)
  • Workday (7)

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 17 other followers

Calendar

Calendar

March 2021
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Apr    
Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×