This appendix covers the following topics:
For information on interface tables for claims refer to the Oracle eBusiness Suite Electronic Technical Reference Manual -eTRM. eTRM is a pl/sql utility that reads design information in an Oracle database and displays its output in HTML format. It shows database design and dependency information for the Oracle eBusiness suite, including Oracle Trade Management.
Third Party Accrual from Interface table is a concurrent program which creates third party accrual for data that users import for Indirect Sales. This program uses data stored in the OZF_RESALE_LINES_INT_ALL table that does not have a batch. The program creates batches based on partner_ party_id for these lines first. It then generates utilizations based on accruals that should be applied to them. The program does not create any claim or claim lines.
Oracle Trade Management uses data stored in the following tables:
| Table | Description |
|---|---|
| OZF_CLAIMS_INT_ALL | Claim information - This table stores the data that must be imported to the OZF_CLAIMS_ALL table by the AMS-TM: Import Claim concurrent program. |
| OZF_CLAIM_LINES_INT_ALL | Claim line information - The claim lines interface table stores data that must be imported to ozf_claim_lines_all table by the AMS-TM: import Claims concurrent program. |
| OZF_RESALE_LINES_INT_ALL | Third party accruals - This claim interface table stores data that must be imported to ozf_resale_lines_all, ozf_resale_headers_all, ozf_resale_adjustments_all table by the OZF-TM: Third Party Accrual from Interface table. |