Home » Applications » Oracle Fusion Apps & E-Business Suite » Service Contracts Program R12 (EBS R12)
Service Contracts Program R12 [message #583258] Sun, 28 April 2013 21:05
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.
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.


Previous Topic: Partitioning in standard tables to improve performance. (2 Merged)
Next Topic: Oracle payables invoice status
Goto Forum:

Current Time: Wed Aug 23 06:38:53 CDT 2017

Total time taken to generate the page: 0.01602 seconds