Sales Transactions from External Sources
Our structure: Our company sales insurance and each policy is treated the same for commission purposes. E.g. 1 policy sale = $400. The sales transactions come from an external database. In addition, we have two other transactions that can originate from a policy sale. One is a chargeback if the policy holder decides to cancel within a specified period and the other is an annual renewal for the policy if the member is still enrolled at the beginning of the following year.
The question is...can we effectively use the AR tables within Oracle (assuming that they are properly licensed) to load and manage the commissionable transactions or do we need to build a custom interface to create the chargeback and renewal transactions for commission purposes? My goal is to have as little custom development work as possible.