Oracle Application Blog

Manual AP Invoice Creation with GST

Manual AR Invoice. Please find the below steps for creating AR Transaction with GST Responsibility: India Local Receivables Navigation: Oracle Receivables > Transactions > Transactions Provide the Source, Select the…

Read More

Oracle SQL to get Profile Option Values at Responsibility level

SELECT frv.responsibility_name,   fpo.profile_option_name,   fpot.user_profile_option_name,   fpov.profile_option_value FROM fnd_profile_options_tl fpot,   fnd_profile_options fpo,   fnd_profile_option_values fpov,   FND_RESPONSIBILITY_VL frv WHERE fpot.profile_option_name = fpo.profile_option_name AND fpo.profile_option_id      = fpov.profile_option_id…

Read More

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