Unable to make payment for the Invoice. Due to Invoice Status: 'Selected for Payment'. But no Payment Batches created by selecting this invoice.

Run the below SQL Query. The invoice Status will be changed automatically to "Validated"

update ap.ap_payment_schedules_all 
set checkrun_id =''
where invoice_id ='57553'-- Give your Invoice_ID
and checkrun_id ='34564'--- Give your Checkrun_ID

Now you cancel the invoice or You can make the Payment for the invoice.

AP invoice accounting status not updated to ‘yes’ still it is showing ‘no’ for one invoice

Analysis: We are able to see JE for invoice when we checked view accounting from invoice screen, so the problem with only status

Solution: As it seems data corruption issues, we logged a ‘SR’ with oracle, they have provided data fix. The issue has been resolved.

2 Journals are not getting posted when auto post program run

Analysis: Journals are created after program completion that is at 11.00 pm

Solution: We asked user to wait until next run so that it will get posted

Not able to account payment document when I tried from action window of payment work bench

Analysis: Associated invoice not accounted hence payment not getting accounted

Solution: Account the invoice and then account payment

Invoice not getting validated

Analysis: Quantity Received hold is placed on invoice, customer using 3 way matching, but still receiving transaction not created in oracle for this PO, hence it could not be validated.

Solution: Require to update received qty for this PO. So this invoice will get validated

There are 10 assets under one corporate book in which user want to calculate depreciation for 7 assets

Solution: (disable) depreciation check box at asset workbench for which depreciation should not calculate.

Unable to add bank statement lines manually to imported bank statement

Solution: Enable allow adding lines imported statement in system parameters.

User not able to create invoice for supplier but PO already created for same supplier.

Analysis: While creating supplier user forget to enable payment purpose at address and site level

Solution: Payment purpose at address and site level.

Account Payable Supporting Issues in Oracle Appps

Issue 1: When we run create accounting program payment not getting accounted and error message showing cash clearing account not assigned
Solution: Assign cash clearing A/c to Bank Account and then we ask the user to run create accounting program so that it got accounted.

Issue 2: While running Payment Process Request (PPR) system has selected more than 200 Invoices but able to view the Invoices till
200 Invoice. 
Solution: Need to Increase limit for Profile Option: "FND: View Object Max Fetch Size".

Issue 3: India Creditor Trail Balance Report(Customized) showing wrong Functional balance(In INR).
Solution:  Incase of Exchange rate gain or Loss,  System is taking till date Values. Update Query to consider for only time range entered in Report Parameters.

Issue 4:  Unable to apply prepayment In case of Prepayment with TDS and Standard Invoice with GST & TDS.
Solution: In Prepayment, For GST Taxes Amount is created in Seperate Lines and TDS Tax not Attached. Now Standard Invoice for Tax amount (Miscellaneous Invoice Type) TDS not attached. Insure both Prepayment standard and Standard Invoice Deduct similar Amount of TDS. While application of Prepayment to Standard Invoice no Problem will appear.

Issue 4: While running Create Accouting the following Error appears.
Error: Error No: 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.  
Solution: Download and apply Patch 18997204:R12.AP.B