FNDLOAD in Oracle ERP

To FNDLOAD Request groups

FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_REP_GROUP.ldt REQUEST_GROUP REQUEST_GROUP_NAME="GROUP_NAME" APPLICATION_SHORT_NAME="PER"

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_REP_GROUP.ldt


------------------------------------------------------------------------------------------


To FNDLOAD Concurrent Programs

FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CUSTOM_ORACLE_INTERFACE_PROG"

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt


------------------------------------------------------------------------------------------


To FNDLOAD Oracle Descriptive Flexfields

$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_PO_REQ_HEADERS_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME=PER DESCRIPTIVE_FLEXFIELD_NAME='PO_REQUISITION_HEADERS'

$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_PO_REQ_HEADERS_DFF.ldt

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_FND_COMMON_LOOKUPS_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME=FND DESCRIPTIVE_FLEXFIELD_NAME='FND_COMMON_LOOKUPS'

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_PA_EXPENDITURE_TYPES_DESC_FLEX_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME=PA DESCRIPTIVE_FLEXFIELD_NAME='PA_EXPENDITURE_TYPES_DESC_FLEX'

------------------------------------------------------------------------------------------


To FNDLOAD Oracle Menus

$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct CUS_PER_MENU.ldt MENU MENU_NAME="CUS_PER_MENU"

$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct CUS_PER_MENU.ldt


----------------------------------------------------------------------------------------------------------------------------

FND Messages to download a single message

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUS_MESSAGE.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='PER' MESSAGE_NAME=XX_ICX_POR_LIFECYCLE_PAY_TIP

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUS_MESSAGE_OO.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='PER'


FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUS_MESSAGE_OO.ldt


----------------------------------------------------------------------------------------------------------------------------

Lookup values

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD aflvmlu.lct XX_LOOKUP_LDT.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME ='PER' LOOKUP_TYPE="XX_LOOKUP_LDT"

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD aflvmlu.lct XX_LOOKUP_LDT.ldt

----------------------------------------------------------------------------------------------------------------------------

Responsibility

FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct XX_RESP_NAME.ldt FND_RESPONSIBILITY RESP_KEY="XX_RESP_NAME"


FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XX_RESP_NAME.ldt


----------------------------------------------------------------------------------------------------------------------------
Forms personalizations

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_PERWSHRG.ldt FND_FORM_CUSTOM_RULES function_name="PERWSHRG-404"

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_HZ_ARXCUDCI_STD.ldt FND_FORM_CUSTOM_RULES function_name="HZ_ARXCUDCI_STD"

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_AP_APXVDMVD.ldt FND_FORM_CUSTOM_RULES function_name="AP_APXVDMVD"


FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_PERWSHRG.ldt

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_HZ_ARXCUDCI_STD.ldt

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_AP_APXVDMVD.ldt

Write me for any more clarification.

Stay tuned !!!!!

"Team Work" More We Less Me.

Welcome to Oracle Self Learning!

Oracle Payroll - GL  Interface query.

SELECT gl.*
  FROM pay_payroll_actions ppa,
       pay_assignment_actions paa,
       pay_costs pcv,
       gl_interface gl
 WHERE     ppa.payroll_action_id = 201496               -- for costing process
       AND ppa.action_type = 'C'
       AND pcv.transfer_to_gl_flag = 'Y'
       AND ppa.payroll_action_id = paa.payroll_action_id
       AND paa.assignment_action_id = pcv.assignment_action_id
       AND gl.user_je_source_name = 'Payroll'
       AND pcv.ASSIGNMENT_ACTION_ID = 1275993 -- for costing process
       AND gl.reference22 = TO_CHAR (pcv.cost_allocation_keyflex_id)

Team Work More "We" Less "Me"

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS

Changing Employee number generation from Manual to automatic without affecting current employee numbers unchanged. 

Attach concurrent program : "Change Person Numbering to Automatic" to your responsibility.
And run the program with parameter as Employee.

This will automatically change Business Group Info value of Employee Generation from Manual to automatic, So new employee will be given there employee number automatically.

Technically this program creates an entry at per_number_generation_controls with BG and next value.

Sameer Patil
"Team Work" More We Less Me.