| Service Contracts Program R12 [message #583258] |
Sun, 28 April 2013 21:05 |
 |
ronniekyan
Messages: 2
Registered: April 2013
|
Junior Member |
|
|
Hi all,
Does anyone has any scripts/tables/etc which can map against the Service Contracts Interface table on what are the values that should be populate?
I'm not looking for mandatory columns, I'm looking for from Interface table where will it store to the based tables.
eg:
OKS_HEADERS_INTERFACE.CONTRACT_NUMBER => apps.okc_k_headers_all_b.contract_number
OKS_HEADERS_INTERFACE.START_DATE => apps.okc_k_headers_all_b.start_date
etc ...
Currently I'm looking for all the columns in Interface tables (OKS_HEADERS_INTERFACE,OKS_LINES_INTERFACE,OKS_COV ERED_LEVELS_INTERFACE,OKS_USAGE_COUNTERS_INTERFACE ,OKS_SALES_CREDITS_INTERFACE) because I need to map which is the based tables and columns to put as input for the Interface tables.
Reason for this is because I need to create a new contract based on a old contract to be replicate. So I need to identify all the column required to be populate to the interface tables.
Please do share on how to populate the information for all the column required.
Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
