My Oracle Support Banner

Third Party Accrual (TPA) Interface Table Program FAQ (Doc ID 874762.1)

Last updated on AUGUST 31, 2020

Applies to:

Oracle Trade Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Purpose

FAQ about Third Party Accrual (TPA) Concurrent Request And Flow Of  : Third Party Accrual From Interface Program

 

 

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 1. What does Third Party Accrual From Interface Program do?
 2. What does Third Party Accrual From Resale Table Program do?
 3. Where are TPA Concurrent codes located?
   3.1 OZF-TM: Third Party Accrual From Interface Table
   3.2 Third Party Accrual From Resale Table
 4. What are the main steps for Third Party Accrual Processes ?
  4.1 Is It Possible To Import Third Party Accrual via WebADI :
  4.2 Other Option Is To Insert Data in OZF_RESALE_LINES_INT_ALL
 5. Testcase
  5.1  Flow
  5.2  How To Detect If Adjustments had been Created ?
 6. How does the code flow for Third Party Accrual From Interface Program ?
  6.1 Manage Cursors
  6.2 Insert Data from data in ozf_resale_lines_int_all table to ozf_resale_batches_all (as batch does not exist)
  6.3 Insert rows in OZF_RESALE_BATCHES_ALL
  6.4OZF_TP_ACCRUAL_PVT.Process_orderUpdate Rows in OZF_RESALE_LINES_INT_ALL
  6.5 Insert Row In OZF_RESALE_LINES_ALL and OZF_RESALE_BATCH_LINE_MAPS_ALL
  6.6 Insert Row In OZF_SALES_TRANSACTIONS_ALL
  6.7 Utilization Creation (Third Party Accrual)
 Community Discussions
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.