You have encountered an unexpected error. Please contact the System Administrator for assistance. Unable to Open Supplier OAF Page

Solution: Need to Set MO: Operating Unit at Site Level(Specify your Operating Unit)

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.

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

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

Issue1: 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.

Issue2: 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.

Issue3: Request for new tax code creation

Solution: Prepare a template to get details from use and get approval from the super user and define

Tax code

Issue4: Defining accounting segment values

Define Security rule

Defining CVR rules

Issue5: Unable to add bank statement lines manually to imported bank statement

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

Issue6: 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.

Issue7: 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

Issue8: 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

                                                                                                                   

Issue9: 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

Issue10: 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.

Issue11: Bank statement line status not updated to ‘Reconciled’, when we reconcile for payment document still it is showing ‘unreconciled’ status

Solution: - As it seems data corruption issues we logged a ‘SR’ with oracle, they have provided data fix, then the issue has been resolved. {All things in AP payment document and Bank Statements}

Issue12: There is difference between AP and GL when we reconcile GL balance is greater than AP trial balance report

Analysis: This difference is because of manual JE which is created by another user for adjustment purpose

Solution: We informed to user, so that it has been resolved after reversing JE

Issue13: There are 5 assets under one asset category. Now user is requesting to change asset cost account in asset category

Solution: 1. Create new category (New Asset Account)

    2. Perform Mass Reclassification

Issue14: Expenses report not getting imported into AP as a invoice (Setup Related issue)

Analysis:-Home address not defined in employee record in HR, hence invoice had not been created

Solution: Address has been created in employee record after taking necessary approvals

Issue15: Cash A/C not updated in receipt class when user modified Cash A/C in Bank A/C

Solution: End date old receipt method in receipt class hen create new receipt method

Issue16: User requesting separate payment numbers for manual payments

Solution: Enable allow restricted to manual payment check box at payment document so that it can be used for only manual payments

Unable to apply Prepayment to standard Invoice. System not showing any error Message.

Problem Identification: In Prepayment Invoice distribution line the user has reversed the distribution line and then, the negative amount reversal line he made it zero and validated the invoice. As header amount and distribution are equal. System has validated the invoice. while applying standard invoice to Prepayment system is not showing prepayment invoice.
Solution: From SQL Query, I have verified the AP_Invoices_All and AP_Invoice_distributions_all Tables and found that, reversal_flag column as 'Yes' (Which should be Nil) and Prepayment_remaining_amount column as nil(As prepayment status is available Prepayment_remaining_amount column should have available prepayment amount value). Now, with update SQL Query, we have set Reversal_flag column as null and Prepayment_remaining_amount column with available amount. Now, system show Prepayment invoice, while applying with standard Invoice.

User is unable to Void the payment.

Illustration- 1 : User is unable to Void the payment.
Solution: You cannot void payment on a payment document that pays a prepayment that you have applied. You must first unapply prepayment, and then Account the Prepayment Unapplied Event on Standard Invoice. 

Illustration -2: Unable to release the system generated hold.
Solution: 

Step 1: Disable the trigger ja_in_ap_aida_before_trg 
ALTER TRIGGER ja_in_ap_aida_before_trg DISABLE; 
Step 2: Release the hold. 

Step 3: Cancel the Invoice 

Step 4: Enable the trigger again 
ALTER TRIGGER ja_in_ap_aida_before_trg ENABLE; 

Illustration-3: User is unable to Void the payment.
The payments are made against the invoices in the payment window. 
Invoice No's
1) MDPL/RENT/12-13/010
2) MDPL/RENT/12-13/011
3) MDPL/RENT/13-14/001.
These payment status should be "Cleared" but the payment status is showing as "Reconciled". 

Now I want to void the payment but can not do so.
 The void option is disabled and we are not using the cash management for reconciliation.
Solution: Received the patch from oracle support.

Issue: APP-SQLAP-10000: ORA-20010: Error while validating  TDS AP Invoice.

Solution: The above is shown when wrong TDS code is attached to distribution line, In such case reverse the wrong tds attached distribution line and Update a new line with correct TDS tax code and validate and apply prepayment.

Illustration:   Query which is used to change the PO status from "Pre- Approved" to "Incomplete"
Module: Purchasing
update po_line_locations_all 
set closed_code='', 
closed_date='', 
CLOSED_FLAG='N', 
Qty_Rcv_Exception_Code='NONE'
where po_header_id in(335398)   ---Update PO header Id         
and   org_id= 595;                         ---- Update Org ID

update po_lines_all 
set closed_code='', 
closed_date='', 
CLOSED_FLAG='N' 
where po_header_id in(335398)      
and   org_id= 595; 

update po_headers_all 
set closed_code='', 
closed_date='' , 
WF_ITEM_TYPE = NULL,
APPROVED_DATE='',  
APPROVED_FLAG='',
Authorization_Status='INCOMPLETE'  
where po_header_id in(335398,335370)         

and   org_id= 595; 

==============================================
Select * from PO.PO_headers_All where Segment1='4709' and org_id=''

==============================================