Home » Applications » Oracle Fusion Apps & E-Business Suite » FNLOAD DOWNLOAD to extract data from db (Oracle EBS 12.2.2 / (11.2.0.3))
FNLOAD DOWNLOAD to extract data from db [message #610227] Tue, 18 March 2014 10:50 Go to next message
matspring1
Messages: 6
Registered: June 2012
Location: UK
Junior Member
Hi I'm trying to extract data from db into ldt file to then load onto another db, however my ldt file only contains data for a single row. The DOWNLOAD sql held within the lct returns multiple rows when run against the db.

Is there a setting in either the xdf or the lct file that controls how many rows can be displayed in the ldt file.

Contents of the ldt is as follows (expecting 23 sets of XXCP_SYS_ENGINE_CTL_X data):


# $Header$

# dbdrv: exec fnd bin FNDLOAD bin &phase=daa checkfile:~PROD:~PATH:~FILE &ui_apps 0 Y UPLOAD @FND:patch/115/import/xxcp_sys_engine_ctl.lct @~PROD:~PATH/~FILE
LANGUAGE = "US"
LDRCONFIG = "xxcp_sys_engine_ctl.lct"

#Source Database valencia

#RELEASE_NAME 12.2.2

# -- Begin Entity Definitions --

DEFINE XXCP_SYS_ENGINE_CTL_X
KEY PREVIEW_CTL VARCHAR2(3)
BASE SOURCE_ID VARCHAR2(4)
BASE SHORT_CODE VARCHAR2(4)
BASE ENGINE_INTERFACE_VIEW VARCHAR2(30)
BASE PREVIEW_INTERFACE_VIEW VARCHAR2(30)
BASE TARGET_TABLES VARCHAR2(1)
BASE PASS_THROUGH VARCHAR2(1)
BASE FORCAST VARCHAR2(1)
BASE CREATED_BY VARCHAR2(15)
BASE CREATION_DATE VARCHAR2(20)
BASE LAST_UPDATED_BY VARCHAR2(15)
BASE LAST_UPDATE_DATE VARCHAR2(20)
BASE LAST_UPDATE_LOGIN VARCHAR2(15)
BASE MD_ID VARCHAR2(22)
BASE SETTLEMENT VARCHAR2(1)
BASE ENGINE_CTL_NAME VARCHAR2(50)
BASE ARCHIVE_INTERFACE_NAME VARCHAR2(30)
END XXCP_SYS_ENGINE_CTL_X

# -- End Entity Definitions --


BEGIN XXCP_SYS_ENGINE_CTL_X "0"
SOURCE_ID = "1"
SHORT_CODE = "GL"
TARGET_TABLES = "Y"
PASS_THROUGH = "Y"
FORCAST = "N"
CREATED_BY = "-1"
CREATION_DATE = "12-MAR-14"
SETTLEMENT = "Y"
END XXCP_SYS_ENGINE_CTL_X


Re: FNLOAD DOWNLOAD to extract data from db [message #616247 is a reply to message #610227] Sat, 14 June 2014 04:37 Go to previous message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Paste the lct file, which is used for this extraction.

By
Vamsi
Previous Topic: Disable/Enable a free text parameter depending on value entered in another parameter in concurrent p
Next Topic: Setup Required to run "Item Organization Assignment" program
Goto Forum:
  


Current Time: Thu Dec 25 13:23:15 CST 2014

Total time taken to generate the page: 0.05588 seconds