Posts by Doyensys

Oracle SQL to get the Menu and Submenu list against a responsibility

SELECT FRV.responsibility_name,   fm.menu_name,   FMEV.ENTRY_SEQUENCE,   FMEV.PROMPT,   FMEV.DESCRIPTION,   SUB_MENU_FMEV.USER_MENU_NAME SUB_MENU_NAME,   SUB_MENU_FMEV.DESCRIPTION SUB_MENU_DESCRIPTION,   FFFT.USER_FUNCTION_NAME,   FMEV.GRANT_FLAG FROM apps.FND_MENU_ENTRIES_VL FMEV,   apps.FND_MENUS_TL SUB_MENU_FMEV,   APPS.FND_FORM_FUNCTIONS_TL FFFT,  …

Read More

ORA-30006: resource busy; acquire with WAIT timeout expired and ORA-00054: resource busy and NOWAIT specified

ORA-30006 and ORA-00054 errors raised when update operation is performed against a record, that has been locked by the user or some session FOR UPDATE. To fix this, before performing the update, check…

Read More

Manual AP Invoice Creation and Cancellation with GST

Manual AP Invoice Creation and Cancellation with GST: Please find the below steps for Manual AP Invoice Creation and Cancellation with GST Responsibility: India Local Payables Navigation: Invoices > Entry…

Read More

Bill of Entry Process after GST Implementation

Bill of Entry Process after GST Implementation: Item Needs to be assigned as GST & GST customs and recoverable tax to be given as Y Item Definition -> Define Item…

Read More

Sales Order Loader API from Blanket Sales Agreement

CREATE OR REPLACE PACKAGE XX_SO_PROG_PKG as –*************************************************************************************************** — —                            All rights reserved –*************************************************************************************************** — — Package Name …

Read More

Oracle Blanket Sales Agreement Loader API

CREATE OR REPLACE PACKAGE      XX_BSA_LOAD_PKG IS –================= — Global Variables –=================    gn_request_id          NUMBER := apps.fnd_global.conc_request_id;    gn_prog_appl_id        NUMBER := apps.fnd_global.prog_appl_id;…

Read More

Update and assign project Roles using PA_PROJECT_PARTIES_PUB

DECLARE l_project_id_PREM         PA_PROJECT_PARTIES.PROJECT_ID%TYPE  :=NULL; l_project_role            VARCHAR2(240) :=NULL; l_resource_name           PER_ALL_PEOPLE_F.FULL_NAME%TYPE :=NULL; l_start_date_active       DATE :=NULL; l_end_date_active     …

Read More

Update Task Information using PA_TASKS_PKG.UPDATE_ROW, PA_PROJ_TASK_STRUC_PUB.UPDATE_TASK_STRUCTURE2 in Oracle Projects

DECLARE   l_return_status                    VARCHAR(10);   l_msg_count                        VARCHAR(240);   l_MSG_DATA   …

Read More

Create Project party in oracle projects accounting using PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY

DECLARE l_project_id_PREM         PA_PROJECT_PARTIES.PROJECT_ID%TYPE  :=NULL; l_project_role            VARCHAR2(240) :=NULL; l_resource_name           PER_ALL_PEOPLE_F.FULL_NAME%TYPE :=NULL; l_start_date_active       DATE :=NULL; l_end_date_active     …

Read More

Create or Update HR location in oracle apps

SET DEFINE OFF; CREATE OR REPLACE PACKAGE      apps.xxal_hr_location_cre_upd_api AUTHID DEFINER IS    l_count         NUMBER;    l_location_id   NUMBER;    PROCEDURE create_location (       p_validate …

Read More