HR模块薪资要素接口开发实例代码

shanjinno1

HR模块薪资要素接口开发实例代码

wushi8

感谢分享。

317799091

下了，虽不怎么样，还是顶顶。。。

xjc845

下了，虽不怎么样，还是顶顶。。。

yuanguozhi

正在学习中，

xjc845

感谢分享。

lai_ke

感谢分享{:soso_e112:}

yuanguozhi

大侠，你好！
我下载了您这个案例，表和包都建好了，怎么导入数据啊？
OPTIONS (SKIP=1)
LOAD DATA
--INFILE 'D:\Oracle EBS\Development\interface\CBIZ CODE\CBIZ CODE_test'
INFILE '&1'
APPEND INTO TABLE XXUSP_CBIZ_DIA_DATA_STG
FIELDS TERMINATED ","
OPTIONALLY ENCLOSED '"'
TRAILING NULLCOLS
(
FILE_TYPE CONSTANT 'CBIZ',
NATIONAL_IDENTIFIER "LTRIM(RTRIM(:NATIONAL_IDENTIFIER))",
LAST_NAME "LTRIM(RTRIM(AST_NAME))",
FIRST_NAME "LTRIM(RTRIM(:FIRST_NAME))",
ELEMENT "LTRIM(RTRIM(:ELEMENT))",
FROM_DATE "LTRIM(RTRIM(:FROM_DATE))",
COVERAGE "LTRIM(RTRIM(:COVERAGE))",
CONTRIBUTION CHAR "TO_NUMBER(LTRIM(RTRIM(:CONTRIBUTION)))",
AMOUNT CHAR TERMINATED BY WHITESPACE "TO_NUMBER(LTRIM(RTRIM(:AMOUNT)))",
Status CONSTANT 'NEW',
CREATION_DATE Sysdate,
CREATED_BY CONSTANT '-1',
LAST_UPDATE_DATE Sysdate,
LAST_UPDATED_BY CONSTANT '-1',
PROGRAM_UPDATE_DATE Sysdate
)

xycm

下了，看看

jiang774256182

HR模块薪资要素接口开发实例代码  thks sharing