How to FIX Accounts Pay Code Combination ID is invalid (Oracle Payables Recurring Invoices)

How to FIX Accounts Pay Code Combination ID is invalid (Oracle Payables Recurring Invoices) :

Bug :Accounts Pay Code Combination ID is invalid

Fix : Enter Liability Account

Procure to Pay process

prepaid expense Exemple

hwo undo accounting works in R12

Pay On Receipt AutoInvoice

What is Pay On Receipt?

Pay on Receipt (also known as ERS (Evaluated Receipt Settlement) or Self-Billing) is an Oracle Purchasing concurrent program, which automatically creates invoices 
in Oracle Payables and matches them with PO's automatically for the received amount. The short name for the program is POXPOIV.

What is the minimum setup required?

a. In Oracle Purchasing responsibility, navigate to Supply base ->Suppliers. Query the supplier to be used in the PO and Query the site to be used in PO. In the General Tab, check the checkboxes for PAY SITE and PURCHASING. In the Purchasing tab, the Pay on field should have a value of' Receipt'. The invoice summary level should also have the value of 'Receipt'.
b. Apart from the above set-up in R11i, a value need to be selected for the Pay on field in the Terms window of the PO.

(Video) How to Link Xla Tables to GL Tables ?

How to join GL tables with XLA (SubLedger Accounting) table

• GL_JE_BATCHES (je_batch_id) => GL_JE_HEADERS (je_batch_id)
• 
  
• GL_JE_HEADERS (je_header_id) => GL_JE_LINES (je_header_id)
• 
  
• GL_JE_LINES (je_header_id, je_line_num) => GL_IMPORT_REFERENCES (je_header_id, je_line_num)
• 
  
• GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id) => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id)
• 
  
• XLA_AE_LINES (application_id, ae_header_id) => XLA_AE_HEADERS (application_id, ae_header_id) 
• 
  
• XLA_AE_HEADERS (application_id, event_id) => XLA_EVENTS (application_id, event_id) 
• 
  
• XLA_EVENTS (application_id, entity_id) => XLA.XLA_TRANSACTION_ENTITIES (application_id, entity_id) 

How to link XLA to GL

Query to Link AP Invoices/AP Payments, GL and SLA Tables: R12 AP GL XLA

SELECT   SUM (xal.accounted_cr), SUM (xal.accounted_dr)
    FROM xla.xla_transaction_entities xte,
         xla_ae_headers xah,
         xla_ae_lines xal,
         gl.gl_import_references gir,
         gl_je_lines gjl,
         gl_je_headers gjh
   WHERE 1 = 1
     AND P_INVOICE_ID OR P_CHECK_ID = NVL ("SOURCE_ID_INT_1", (-99))
     AND xte.entity_code = 'AP_INVOICES' OR 'AP_PAYMENTS'
     AND xte.application_id = 200
     AND xte.entity_id = xah.entity_id
     AND xah.ae_header_id = xal.ae_header_id
     AND xal.gl_sl_link_id = gir.gl_sl_link_id
     AND xal.gl_sl_link_table = gir.gl_sl_link_table
     AND gir.je_header_id = gjl.je_header_id
     AND gir.je_line_num = gjl.je_line_num
     AND gjl.je_header_id = gjh.je_header_id
    

AP-GL Reconciliation

To reconcile your accounts payable activity for April, make the following calculation:
"Accounts Payable Trial Balance" as of March 31 +
"Posted Invoice Register" for the period between April 1 and April 30 -
"Posted Payment Register" for the period between April 1 and April 30 =
"Accounts Payable Trial Balance" as of April 30

Customizing Automatic Withholding Tax

If you are using Payables to automatically withhold tax, you may want to customize the AP_CUSTOM_WITHHOLDING_PKG to perform special behavior. This PL/SQL package contains two procedures that are called when you automatically withhold tax. Both procedures are empty (perform nothing), but can be modified.
AP_SPECIAL_RATE is called any time you automatically withhold tax. Modify this procedure if you want to use Penalty type AWT rates, or any other user-defined AWT Rate Type. For example, you may want to use a Penalty type rate for a specific supplier. The AP_SPECIAL_RATE procedure is located in the following directory and is called:

$AP_TOP/admin/plsql/apcmawtb.pls
After you modify this file, execute the following command:

$ sqlplus <APPS username>/<APPS password> @apcmawtb.pls
AP_SPECIAL_ROUNDING is called only when you automatically withhold tax during payment batch processing. Modify this procedure if you want to perform rounding of tax amounts during withholding. For example, you may want to round all withholding tax amounts up to the nearest dollar. The AP_SPECIAL_ROUNDING procedure is located in the following directory and is called:

$AP_TOP/admin/plsql/apcmawtb.pls
After you modify this file, execute the following command:

$ sqlplus <APPS username>/<APPS password> @apcmawtb.pls

Withholding Tax Groups

Use this window to define withholding tax groups that include multiple Withholding Tax type tax names. You can assign the same tax name to more than one group. When you assign a withholding tax group to an invoice or distribution, Payables calculates invoice withholding tax based on every tax name in the withholding tax group. For example, you assign a withholding tax group to an invoice or distribution if you need to withhold taxes at both the local and country level, each withheld at different rates and remitted to different tax authorities. You define and assign to the invoice or distribution a Withholding Tax Group that includes both taxes.
You rank all of the tax names in a withholding tax group when you define the group. When you enter an invoice and enter a withholding tax group, Payables calculates the taxes in order of rank. Lower ranked taxes are applied to the amount of the invoice or distribution amount less the previous withholding tax amounts. For example, you define a withholding tax group with two tax names, and you give tax A (rate = 10%) a rank of 1 and tax B (rate = 5%) a rank of 2. When you assign this group to an invoice, Payables calculates the withholding tax for a $100 invoice as follows: tax A = $10, tax B = $4.50 (.05(100 - (100 * .10))).

If you want to define a withholding tax group with only one Withholding Tax type tax name, you can enable the Create Record Group option in the Withholding Tax Details region of the Tax Names window to automatically create a withholding tax group with the one Withholding Tax type tax name.

You can assign a default withholding tax group in the Payables Options window. Payables automatically assigns the Payables default withholding tax group to all new suppliers. The suppliers value defaults to any new supplier sites for the supplier. Supplier sites assign the default to any new invoices you enter for the supplier site. You can override any withholding tax group default at any time.

To create withholding tax groups:

1. In the Withholding Tax Groups window, enter a unique name for your withholding tax group, and enter a description of the group. The name and description will appear on a list of values whenever you need to select a withholding tax group.

2. If you want to inactivate this withholding tax group on a certain date, enter an Inactive Date.

3. Assign a rank to each tax name in the tax group. 1 is the highest rank. You can assign the same rank to more than one tax name. For example, if you want to use the gross invoice amount to calculate withheld amounts for each tax name, assign each tax name a rank of 1.

Enter each Withholding Tax type tax name that you want to assign to this group.

Payables automatically displays the Description, Tax Authority Name, and Tax Authority Site that are associated with each tax name.

4. Save your work.

How To Avoid The Error "java.lang.NullPointerException at oracle.apps.ap.oie.server.ExpensesAMImpl.isRejected" When Creating Expense Report

GOAL : How does one avoid the error below when trying to create an expense report?

SOLUTION : 
Ensure that there is the following:

- At least one Expense Report Template enabled for Internet Expenses with at least one Expense Item defined.
- ICX_HR_PERSON_ID is defined for the User.
- MO: Operating Unit profile option is set to appropriate value at the Expenses Responsibility level.

AP/AR Netting: Is there an API to Create an AP/AR Netting Batch ?

There is NO public Api's to create an AP/AR Netting Batch.

There are however some Receipt APIs that you may find useful:

AR_RECEIPT_API_PUB.apply_open_receipt - Creates a receipt-to-receipt application (payment netting).
AR_RECEIPT_API_PUB.unapply_open_receipt - Unapplies a receipt-to-receipt application.