CodeAutonetics

API to create Accounting Key Flexfield Concatenated Segment description in Oracle Apps R12 API: GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION A key flexfield is a field you can customize to enter multi-segment values such as part numbers, account numbers, and so on. A descriptive flexfield is a field you customize to enter additional information for which your Oracle Applications product has not already provided a field. SELECT gcc.concatenated_segments,        gl_flexfields_pkg.get_concat_description( gcc.chart_of_accounts_id,                                                  gcc.code_combination_id                    ...

API to delete Responsibility to user FND_RESPONSIBILITITY A responsibility is a level of authority in Oracle Applications that lets users access only those Oracle Applications functions and data appropriate to their roles in an organization. Each responsibility allows access to: A specific application or applications , such as Oracle General Ledger or Oracle Planning.   Deleting a Responsibility to an Oracle User in R12 Oracle Apps using API -- FND_USER_PKG.DELRESP to Delete responsibility ‘System Administrator’ for the user 'USERNAME' using the API. DECLARE    v_user_name            VARCHAR2 (100) := 'USERNAME';    v_responsibility_name  VARCHAR2 (100) := 'System Administrator';    v_application_name     VARCHAR2 (100) := NULL;    v_responsibility_key   VARCHAR2 (100) := NULL;    v_security_group     ...

API to delete JTF_NOTES JTF_NOTES_B JTF_NOTES_B stores all non–translated information about Notes. Notes may be created for any object mapped for object usage in JTF_OBJECTS; the JTF_OBJECT that the note is linked to is stored as the source_object_code and source_object_id. The actual text of the note, which is stored in the JTF_NOTES_TL, is split into two parts under columns NOTES and NOTE_DETAILS. Typically, the NOTES should hold the short form or the first part of the note. NOTE_DETAILS for added details, or whenever the note is longer than the 2000 character limit for the NOTES column. The NOTE_STATUS flags the note as being personal (P), Internal (I), or Publish(E).   set serveroutput on DECLARE   CURSOR c_notes IS     SELECT jtf_note_id       FROM jtf.jtf_notes_b     where jtf_note_id = 94492027     ;   l_ret_status VARCHAR2(3);   l_msg_data   VARCHAR2(...

API to create JTF_NOTES JTF_NOTES_B JTF_NOTES_B stores all non–translated information about Notes. Notes may be created for any object mapped for object usage in JTF_OBJECTS; the JTF_OBJECT that the note is linked to is stored as the source_object_code and source_object_id. The actual text of the note, which is stored in the JTF_NOTES_TL, is split into two parts under columns NOTES and NOTE_DETAILS. Typically, the NOTES should hold the short form or the first part of the note. NOTE_DETAILS for added details, or whenever the note is longer than the 2000 character limit for the NOTES column. The NOTE_STATUS flags the note as being personal (P), Internal (I), or Publish(E).   DECLARE    x_return_status   varchar2 (1);    x_msg_count       number;    x_msg_data        varchar2 (200);    x_jtf_note_id     number;    x_msg_...

To Check whether a given table is used in any of the oracle form Using unix command : Login to you host using Putty/ SSH tectia, after connection cd < your fmb location, this is AU or Custom AU Path > grep -Hrn MTL_SYSTEM_ITEMS_B  -H causes the filename to be printed (implied when multiple files are searched) -r does a recursive search -n causes the line number to be printed mtl_system_items_b table name to search path/to/files can be . to search in the current directory Further options that I find very useful: -I ignore binary files (complement: -a treat all files as text) -F treat search term as a literal, not a regular expression -i do a case-insensitive search --color=always to force colors even when piping through less . To make less support colors, you need to use the -r option: grep -Hrn search . | less -r --exclude-dir=dir useful for excluding directories like .svn and .git . Result [yourUser@host US]$ cd /apps/db...