PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PeopleCode - Having a common Loader Program for File Layout based imports

Hi There,

We are in an urge to create a common loader program that will identify the file layout from configuration, and load the data using generic code (similar to what File Layout drag-and-drop code).

But the challenge here is to have the &RS variable created to match the structure of the File Layout. As it is based on the FLD segments (or records), it changes according to File Layout been used. Other than this everything else can be considered as common code.

E.g., CreateRowset(Record.ZZ_EMP_L0, CreateRowset(Record.ZZ_EMP_L1), CreateRowset(Record.ZZ_EMP_L1_VW, CreateRowset(Record.ZZ_EMP_L2, CreateRowset(Record.ZZ_EMP_L3))));

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center