My Oracle Support Banner

R12: API to Update Column TCA_SYNC_NUM_1099 (Doc ID 1998629.1)

Last updated on DECEMBER 10, 2024

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Goal

How to update the column TCA_SYNC_NUM_1099

When a supplier is created with taxpayer id, the AP_SUPPLIERS table is getting inserted with the same value in NUM_1099 and TCA_SYNC_NUM_1099.
When updating that supplier with a new taxpayer id, the system is updating a new value only in NUM_1099 but not in the TCA_SYNC_NUM_1099 field.
 

Solution

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
Goal
 How to update the column TCA_SYNC_NUM_1099
 When a supplier is created with taxpayer id, the AP_SUPPLIERS table is getting inserted with the same value in NUM_1099 and TCA_SYNC_NUM_1099.
When updating that supplier with a new taxpayer id, the system is updating a new value only in NUM_1099 but not in the TCA_SYNC_NUM_1099 field.
 
Solution
References


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