Error Number 0 & 95353 in Oracle Payables: The account on the gain or loss line is invalid. - Oracle EBS R12

https://aporaclepayables.blogspot.com/2019/07/error-number-0-95353-in-oracle-payables.html

Issue:

Line	Error Number	Error Message
3	0	The account on the gain or loss line is invalid. If you have a gain/loss journal line type defined, please verify the account derivation rule attached to it on the journal line definition.  If not, verify the value of the source mapped to the accounting attributes Exchange Gain Account and Exchange Loss Account.

Line	Error Number	Error Message
	95353	Subledger Accounting was unable to derive an accounting code combination using the account derivation rule Exchange Rate and Tax Exchange Rate Variances owned by Oracle. Please review the account derivation rule and make sure it derives a valid accounting flexfield combination for the source values passed for the transaction.

Data Corruption in Financials Options possibly because the account added at the financial options have been incorrectly modified.

1. Run the following query to determine if this is an issue.

select ASP_RATE_VAR_gain_CCID
, ASP_RATE_VAR_loss_ccid
, asp_org_id
from AP_SYSTEM_PARAMETERS_EXTRACT_V;

If the query returns -1 for ASP_RATE_VAR_GAIN_CCID or ASP_RATE_VAR_LOSS_CCID then proceed.

Solution:

1. Navigate to Financials Options in AP

2. Populate the PO Rate Gain and Loss fields. If already populated then change the value to itself and save it.

3. Run the query again to be sure all the values are not -1.

4. Please run Create Accounting and Verify.

View Accounting Function in Oracle Payables in not visible - Oracle EBS R12

https://aporaclepayables.blogspot.com/2019/07/view-accounting-function-in-oracle.html

View Accounting Function in Oracle Payables in not visible through Reports>View Accounting in Invoice Workbench and Tools>View Accounting in Payments Workbench

Please add the below functions in your Menu

• SLA: View Accounting - Lines Inquiries

AP Supplier jsp Page error: ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02902: Multi-Org profile option is required - Oracle EBS R12

https://aporaclepayables.blogspot.com/2019/06/ap-supplier-jsp-page-error-errno-20001.html

ERROR
"You have encountered an unexpected error. Please contact the System Administrator for assistance".
The exception details show the following errors:
JBO-30003: The application pool
(erpdb.maxims.comprod1521oracle.apps.pos.supplier.server.SuppSummAM) failed to checkout an
application module due to the following exception:
oracle.jbo.JboException: JBO-29000: Unexpected exception caught:
oracle.apps.fnd.framework.OAException, msg=Application: FND, Message Name: FND_GENERIC_MESSAGE.
Tokens: MESSAGE = java.sql.SQLException: ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT,
N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02902: Multi-Org profile option is required.
Please set either MO: Security Profile or MO: Operating Unit profile option.
ORA-06512: at "APPS.FND_MESSAGE", line 509
ORA-06512: at "APPS.MO_GLOBAL", line 36
ORA-06512: at "APPS.MO_GLOBAL", line 757
ORA-06512: at "APPS.MO_GLOBAL", line 700
ORA-06512: at line 1

-------------------------------------------------

Set the 'MO: Security Profile' profile option at Responsibility level as required.

Run Security List Maintenance concurrent program (from HRMS responsibility).

Restart Apache server.

Which Date is Applicable for WHT Deduction when WHT Deduction is at Payment Time - Oracle EBS R12

https://aporaclepayables.blogspot.com/2019/06/which-date-is-applicable-for-wht.html

Apply Withholding Tax: At Payment Time

Payment Date must be grater than or Equals to (>=) Effective Date of Withholding Tax when WHT Deduction is at Payment time.

If Payment date is less then Effective Date of WHT, then the below error will occur

How to Apply Credit Memo to invoice in Oracle Payables - Oracle EBS R12

https://aporaclepayables.blogspot.com/2019/06/how-to-apply-credit-memo-to-invoice-in.html

In this below post, We will Create the Credit Memo in Oracle Payables and then Apply this credit Memo in the Standard Payables Invoice.

These are the Below Steps We will perform to Apply Credit Memo in Oracle Payable.

1: Enter a Credit/Debit Memo in the Invoice Workbench. Enter a negative amount. Do not manually enter the distributions. 

2: In the Match Action field scroll to Match Action field. Using drop down select Invoice. 

3: Click on the Correction button.

4: Enter search criteria for the invoice, in the Find Documents for Correction window. Click on the Find button. 

Payables navigates to the Invoice Corrections window.

To see more information about an invoice, you can select it and click on the Invoice Overview button.

5: Select the invoice and enter a Credit Amount.
You can do the line level matching by clicking on Select Lines button.
Select each invoice line you want to match to and enter a Credit Amount.

6: Choose the Correct button to correct the invoice.
To review the new invoice lines, choose the lines tab from the Invoices window.

------------------------------------------------------------------------------------------------------------

Steps to match a credit memo to a matched invoice:
=====================================

• Create PO,
• Quantity = 10, unit price = 1,
• Save it and approved it.

• Create an invoice for amount = 10,
• Match to the PO,
• Save it and validate it.

• Create a credit memo for amount = -10,
• 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 = -10,
• Press Correct button,
• A corrected invoice line and distributions will be auto created for you.

Steps to match a credit memo to a non-matched invoices:
=========================================

• Create an invoice for amount = 10,
• Not match,
• Save it and validate it.

• Create a credit memo for amount = -10,
• Set Match Option = Invoice on the header,
• Press Corrections button,
• Only can find non-matched invoices to be corrected.
• Find Documents for Correction window should appear
• Enter the Invoice Number you wish to correct,
• Results will be displayed,
• Select the invoice you wish to correct,
• Then fill in correction Amount = -10,
• Press Correct button,
• A corrected invoice line and distributions will be auto created for you.

Steps to match a credit memo to a line of a Standard invoice:
============================================

• Create a standard invoice, validate it.

• Create a new credit memo for the same supplier site,
• Set Match Option = Invoice on the header level,
• Then create a new Line, save it,
• Then press Corrections button,
• Enter the Invoice Number you wish to correct,
• Find the invoice, then press Select Lines button,
• Then you can select the line you wish to correct,
• Then press Correct to match to the line.

• A new distribution will be created in the credit memo where the charge
• Account has been taken from the matching invoice.

How to finish Partial Credit of a Supplier (Non Payable Amount) - Oracle EBS R12

https://aporaclepayables.blogspot.com/2019/06/how-to-finish-partial-credit-of.html

Please Copy Paste the URL in your Browser

https://drive.google.com/open?id=15ZPXu_0Ee3u31Qli53cknu3grtIiIPt0

Oracle AP Period Closure and Reconciliation- Oracle EBS R12

https://aporaclepayables.blogspot.com/2019/04/oracle-ap-period-closure-and.html

Before Period Closure Check List Items Oracle Processes Ensure that all AP Interfaces are Processed Run Custom Interface Processes Ensure that there is no Data in AP Invoice Interface and if there is any Data, Import the same Payables Open Interface Import Program Ensure that all required Expense reports which are approved are audited and Imported into AP Expense Report Export Program Ensure that all Invoices are Validated, Accounted and transferred to GL Invoice Validation, Create Accounting Ensure that all required PPR Processes are either confirmed or cancelled Oracle Payment Process Request Ensure that Asset Purchase related to AP Invoices are Interfaced to AP Module Oracle Mass Addition Process Ensure that there are no Exceptions for the period under Subledger Exceptions Reports Oracle Subledger Exception Report

Close the period, if there are Exceptions, then system will give an Option to Sweep he Transactions to the Next Period

After Period Closure: Internal Reconciliation

Previous Month AP TB + Current Month Payables Posted Invoice Register - Current Month Payables Posted Payment Register = Current Month AP TB

External Reconciliation

Run AP Trial Balance Report and the Balance in this Report should match with GL Account Inquiry for AP Liability Account For Example: A JUL-18 AP TB                 1,656,600.00 B AUG-18 Payables Posted invoices Register                       40,000.00 C AUG-18 Payables Posted Payments Register                       25,000.00 D AUG-18 AP TB (A+B-C)                 1,671,600.00

Some Common Reasons for Reconciliation issue between AP and GL: AP related Journal entries are deleted in GL before Posting Manual entries are passed directly in GL using AP Liability Account AP related Transactions are transferred to GL  but not yet Posted AP related Journals are Updated (for some reason) in GL before Posting Revaluation Journals in GL AP related Journal are Reversed in GL after Posting AP related Journals Stucked in GL Interface for some Reason