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: Oracle forms
Next Topic: purchase order
Goto Forum:

Current Time: Fri Nov 26 18:06:33 CST 2021