PDF Password Protection in BI Publisher
Go to File->Info->Properties>Advanced Settings and follow the Screen shot A and Screen shot b Screen shot A In the Custom Tab add one XDO as xdo-pdf-open-password and in the value filed type the…
Read MoreUSING APEX_ERROR NOTIFICATIONS TO MANAGE CUSTOM ERROR MESSAGES
Include User Notifications or Custom Messages and Error Messages in Oracle APEX’s default Success and Error Message style. Default Success message : Default Error message : Steps in APEX :…
Read MoreJQUERY AUTOCOMPLETE FOR TEXT FIELD ITEM IN ORACLE APEX
Process of enabling users to quickly find and select from a list of values as they type, searching and filtering without Native text with auto-complete in APEX. This process works…
Read MoreEBS to FUSION PA (Project Accounting) Table Changes
EBS Tables—————————————– FUSION Tables——————————————- PA_PROJECTS_ALL —————————————– PJF_PROJECTS_ALL_B PJF_PROJECTS_ALL_TL——————————————- PA_PROJECT_TYPES_ALL —————————————– PJF_PROJECT_TYPES_B PJF_PROJECT_TYPES_TL——————————————- PA_PROJECT_STATUSES —————————————– PJF_PROJECT_STATUSES_B PJF_PROJECT_STATUSES_TL——————————————- PA_PROJECT_STATUS_CONTROLS—————————————– PJF_PROJ_STATUS_CONTROLS——————————————- PA_PROJECT_ACCUM_ACTUALS—————————————– PJO_PROJECT_PLAN_ACTUALS——————————————- PA_TASKS —————————————– PJF_PROJ_ELEMENTS_B PJF_PROJ_ELEMENTS_TL PJF_TASKS_V——————————————- PA_BUDGET_TYPES—————————————– PJO_PLAN_TYPES_B——————————————- PA_EXPENDITURE_TYPES —————————————– PJF_EXP_TYPES_B…
Read MoreQA Collection Elements creation
API used for EAM preventive collection plan creation and its Elements insertion. Basically this QA tables are used for capturing daily meter reading of asset in EAM and then This…
Read MoreEAM Preventive maintenance Last service reading API
API used for while generating Preventive Maintenance work orders for an asset. This API used to insert last service meter reading for an asset while generating work orders. …
Read MoreEAM Construction Estimation Creation
API used to create EAM Construction Estimation headers and lines creation. This used in for creation any construction like building etc to estimate how much labour and how much cost…
Read MoreEAM Asset Number activity association creation API
API used for to maintain asset in proper manner during work order generation. After generating work order for an asset . Users will follow the asset activities for an asset…
Read MoreGL Revaluation Accounts Query – FUSION
SELECT DISTINCT o101368.book_currency AS c_1, (o101368.converted_journal_total_dr * o101368.currency_conversion_rate ) AS c_2, o101368.converted_journal_total_cr…
Read MoreEAM Asset Failure code,Cause,Resolution creation
API used for EAM asset maintenance during work order failure. This API used to create failure code and its cause and its resolution for an asset in an asset group.…
Read More