Skip to main content


Showing posts from 2017

How is the Payment Schedules on Invoices Calculated?

If Payables Options "Recalculate Scheduled Payments" is set to Yes, then the invoice validation will change the payment schedule based on the following: Case 1 : If Invoice IS NOT PO matched: =============================== a) The Start Date is the most recent date of the following:  Invoice Date on the invoice header. Terms Date on the invoice header. Goods Received Date on the invoice header. b) The Payment Term is the Payment Term on the invoice header. Case 2 : If Invoice IS PO matched: =========================== a) The Start Date is the most recent of the following: Invoice Date on the invoice header. Terms Date on the invoice header. Goods Received Date on the invoice header, PO received date. b) The Payment Term is the most favorable of the following:    Payment Term on the invoice header    Payment Term on the Purchase Order. Note: If you just want to use the invoice header information to calculate the payment schedule (not the PO information), p

How to Match Credit Memos To Matched Invoices or Non-Matched Invoices

Case 1 : Steps to match a credit memo to a matched invoice: ================================================= Create PO, Quantity = 100, unit price = 1, Save it and approved it. Create an invoice for amount = 100, Match to the PO, Save it and validate it. Create a credit memo for amount = -100, On the header, still set Match Option = PO, Then press the Correction button, Then fill in the Invoice number which is matched to the PO, Then press Find button, Then fill in correction Amount = -100, Press Correct button, A corrected invoice line and distributions will be auto created for you. Case 2 : Steps to match a credit memo to a non-matched invoices: ====================================================== Create an invoice for amount = 100, Not match, Save it and validate it. Create a credit memo for amount = -100, Set Match Option = Invoice on the header, Press Corrections button, Only can find non-matched invoices to be corrected. Find Documents for Co

Overview of Mass Additions Process

The mass additions process lets you add new assets or cost adjustments from other systems to your system automatically without reentering the data. For example, you can add new assets from invoice lines brought over to Oracle Assets from Oracle Payables, or from CIP asset lines sent from Oracle Projects.

Steps to create Invoice for a Service Contract

Here are the steps to create an Invoice for a Service Contract in Oracle Applications (R12) 1. Login to US Service Contract Manager. 2. Create a service Contract, by entering the necessary fields. 3. Do QA Check for the service contracts and ensure everything is fine. 4. Switch to AR Super user responsibility. Navigate to Run -> Single Request 5. Enter the following Concurrent program: Service Contracts Main Billing      - Provide the Contract number as input to the program. 6. Submit the program. 7. Now, select the responsibility US AR Super User 8. Navigate to Interfaces -> AutoInvoice -> Single Request 9. Select the Concurrent program: Autoinvoice Master Program 10. Enter the parameters:       - Invoice Source: OKS_CONTRACTS 11. Now you can verify, that for the service contract created, there would a record created in RA_CUSTOMER_TRX_ALL table.

What is the Difference Between Procurement and Purchasing?

Many people use the terms  purchasing  and  procurement  interchangeably, but despite their similarities they do have different meanings. The Procurement Process - Procurement involves the process of selecting vendors, establishing payment terms, strategic vetting, selection, the negotiation of contracts and actual purchasing of goods. - Procurement is concerned with acquiring (procuring) all of the goods, services and work that is vital to an organization. - Procurement is, essentially, the overarching or umbrella term within which purchasing can be found. Aligning your procurement function with your corporate strategy is only one part of the ultimate goal of procurement. Goods and services also need to be purchased. The process of purchasing these good and services is known as the  Procure-To-Pay Cycle . The entire Procure-To-Pay Cycle can be an involved process with numerous steps: §   Identification of Requirement §   Authorization of Purchase Request §   App

'Transfer Journal Entries to GL program' Functionality and FAQs

1. What are the tables involved in the Transfer to GL and GL posting?  Subledger Tables XLA_AE_HEADERS       XLA_AE_LINES       XLA_DISTRIBUTION_LINKS Transfer Journal Entries to GL (XLAGLTRN) process takes the Subledger journals and inserts records into the Interface Tables. Interface Tables             GL_INTERFACE / XLA_GLT_<groupid>           Journal Import (GLLEZL) then reads from the interface table and creates records in the GL Tables GL Tables   GL_JE_BATCHES GL_JE_HEADERS GL_JE_LINES GL_IMPORT_REFERENCES 2. What are the different methods to transfer Subledger journals to GL? ONLINE MODE GL Transfer can be spawned during Online Accounting using the "Final Post" option for a specific document (Example: AP Invoice and AR Transaction). Example: Navigation in Payables: Invoices/Entry/Invoices: Action: Create Accounting/Final Post. This spawns the GL Transfer, the Journal Import, Data Manager and the GL Postin

Issue with 12.2 E-Business Suite Import/Export of OAF Personalizations

  While trying to import/export Personalizations from 12.2.4 onwards, it fails with the following error:  Error: Cannot Display Page Documents Imported You cannot complete this task because of the following events caused a loss of page data: - Your login session has expired. - A system failure has occurred. Sometimes the Documents are imported and the import is successful, other times the import fails and only the above error is received. Reproducible Steps: The error occurs under the following navigation path: Functional Administration -> Personalizations ->Import/Export -> Exported Personalizations 1. Select a OAF Personalization  2. Click on Import from File System button Solution: To resolve the issue test the following steps in a development instance and then migrate accordingly: 1. Download  Patch 23119976 :R12.FWK.C, "ORACLE APPLICATION FRAMEWORK (F