Monthly Archives: June 2015

Sql Script For Form Personalisations with Office and Vision Form Personalisations details

Posted on June 28, 2015 by santosh kumar adda oracleapps

Office and Vision Form Personalisations SELECT fcr.id, fff.user_function_name, FCR.FORM_NAME FORM, FCR.SEQUENCE SEQ, FCR.DESCRIPTION, CASE WHEN fcr.rule_type = ‘F’ THEN ‘FORM’ WHEN fcr.rule_type = ‘A’ THEN ‘FUNCTION’ ELSE ‘UNKNOWN’ END P_LEVEL, FCR.ENABLED, FU.USER_NAME, FCR.TRIGGER_EVENT, FCR.TRIGGER_OBJECT, FCR.LAST_UPDATE_DATE FROM APPLSYS.FND_FORM_CUSTOM_RULES FCR, APPS.FND_USER FU, … Continue reading →

Posted in Form Personalisation | Leave a comment

SWIFT Bank Statement Format Mapping Loader Details For CM with attachment 752532.1, (optional -852640.1)

Posted on June 6, 2015 by santosh kumar adda oracleapps

SWIFT Bank Statement Format Mapping Loader Details For CM with attachment 752532.1, (optional -852640.1)   How To Load Bank Statements In Format Other Than BAI2/SWIFT940 ? [ID 852640.1] Mapping BAI2, SWIFT Bank Statement Format Masking: BANK_ACCOUNT_NUM, BANK_TRX_NUMBER, BANK_ACCOUNT_TEXT, Agent Bank … Continue reading →

Posted in Cash Management | Leave a comment

Oracle Budget Inquiry Process & Reporting Process

Posted on June 6, 2015 by santosh kumar adda oracleapps

Oracle Budget Inquiry Process & Reporting Process Budget Setup Defining Budget GL  èBudgets èDefine èBudgetèDefine Budgets GL  èBudgets èDefine èOrganizationsè Defining Budget Organizations First Account Assignment, than Accounts Range Assignment GL è BudgetsèJournals è Entering Budget Journals   Oracle Budget … Continue reading →

Posted in General Ledger | Leave a comment