Oracle EBS - Oracle Alert Details Query

SELECT alr.application_id,

       alr.alert_id,

       alr.alert_name,

       alr.start_date_active,

       alr.description,

       alr.sql_statement_text

  FROM alr.alr_alerts alr

 WHERE 1=1

 --  AND alr.created_by <> 1      -- show only custom alerts

   AND alr.enabled_flag = 'Y';

Oracle EBS - Not able to create Payment in Past Date

 

Issue: 

While Creating Payment and Enter Payment Date for Past Open Period getting below error message

Error:

APP-SQLAP-10026: The Payment Date must be on or after the System Date.

Resolution:

Navigation: Payable Responsibility > Setup > Payable Option > Payment Tab > Check All Pre-Date

Oracle Fusion: Po Status is Closed for Receiving. PO not able to closed due to PO and Invoice amount is not matching.

 

Issue: PO Created, Received, Delivered, Partial Invoiced - PO Status is Closed For Receiving but not Closed. How to Close the PO.

Invoice Amount is not matching with PO amount. That’s why PO not closed.

Resolution:
Step1: Navigation: Procurement > My Receipt > Task > Manage Receipt > Search with PO Number.

Step2: Click on receipt and Select Correct Button.

Step3: Put the same Invoice Amount in Correct Quantity Field & Click on Submit

Step4: Open the PO > Click on Action > Click on Edit
Step5: Add the Header Description for Change Order and Edit the line amount with same Invoice Amount.
Step6: Click on Submit.
Step7: If change Order required Approval Than User need to complete the Approval Process After That PO Get closed Automatically.