Most common reasons of above error are :

1. Check the column RA_INTERFACE_LINES_ALL.interface_status value, it should not be equal to 'P'.

2. Ckeck the column RA_INTERFACE_LINES_ALL.request_id column, it should have a null value.

3. If using Multi-Org check the value of RA_INTERFACE_LINES_ALL.ORG_ID column to make sure that value assigned to this column is equal to your responsibility ORG_ID (from where you are running AutoInvoice).

Update due date of an invoice

To update due date of a transaction, you need to set the AR:UPDATE DUE DATE profile to 'YES' but Oracle never recalculate the payment terms. The only place in SC that you may change the due date is the Account Details window.  Navigate to Collections->Account Details

Lockbox Interface : Load Overpayment/Remaining Amount as On-Account

Navigate to Setup->Receipt->AutoCash Rule Sets and select the one you are using. Change the default value of Unapplied to On Account for Remaining Amount field.

Autocash Rule sets are attached at System Options and at the Customer profile Class level. If there is no rule attached to
the profile Class level, the rule at the system option would be used as a default Rule.

Return to : Oracle Database, SQL, Application, Programming Tips