Thursday, May 12, 2022

Why there is no entry in AR_PAYMENT_SCHEDULES_ALL even after completing the AR Transaction in Oracle APPS

  • After completing AR Transaction there is no data or entry in AR_PAYMENT_SCHEDULES_ALL table. 
  • Possible reason is "Open Receivables" check box is not checked for the Transaction Type while creating it. 
  • If Open Receivable is set to Yes then Receivables updates Customer Balances each time you create a complete Credit Memo, Debit Memo, Chargeback, or On-Account Credit with this Transaction Type. 
  • This also includes these Transactions in the Standard Aging and Collection Processes in Receivables.


No comments:

Post a Comment

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...