Entries by Oracle ERP Apps Guide

, ,

API – Customer Level Attribute Updation (Customer Class , Etc)

declarep_cust_account_rec    HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE;x_return_status       VARCHAR2(2000);x_msg_count           NUMBER;xio_p_object_version  NUMBER;x_msg_data            VARCHAR2(2000);v_account_id          NUMBER;V_OBJECT_VERSION      NUMBER;BEGIN —    FND_GLOBAL.APPS_INITIALIZE(<user_id>,<resp_id>,<resp_applicarion_id>);—    MO_GLOBAL.INIT(‘AR’);—    MO_GLOBAL.SET_POLICY_CONTEXT(‘S’, <org_id>);      FND_GLOBAL.APPS_INITIALIZE(1535,50930,222);     MO_GLOBAL.INIT(‘AR’);     MO_GLOBAL.SET_POLICY_CONTEXT(‘S’, 807);        BEGIN      SELECT  –HCSU.SITE_USE_ID,               hcas.CUST_ACCOUNT_ID,                    HCS.OBJECT_VERSION_NUMBER            INTO    V_ACCOUNT_ID,                    V_OBJECT_VERSION            FROM    HZ_PARTIES HP,                    HZ_PARTY_SITES HPS,                    HZ_CUST_ACCT_SITES_ALL HCAS,                    HZ_CUST_SITE_USES_ALL HCSU,                    hz_cust_accounts_all hcs            WHERE   HP.PARTY_ID = HPS.PARTY_ID            AND     HPS.PARTY_SITE_ID = HCAS.PARTY_SITE_ID            AND     HCAS.CUST_ACCT_SITE_ID =HCSU.CUST_ACCT_SITE_ID            AND     HCSU.SITE_USE_CODE = ‘BILL_TO’            AND     HCS.CUST_ACCOUNT_ID […]

/by
, , ,

Query to find Parameters and Value Sets associated with a Concurrent Program

The following query will fetch the Parameter List and associated Value Sets of a Concurrent Program.SELECT        fcpl.user_concurrent_program_name “Concurrent Program Name”,        fcp.concurrent_program_name “Short Name”,        fdfcuv.column_seq_num “Column Seq Number”,        fdfcuv.end_user_column_name “Parameter Name”,        fdfcuv.form_left_prompt “Prompt”,        fdfcuv.enabled_flag ” Enabled Flag”,        fdfcuv.required_flag “Required Flag”,        fdfcuv.display_flag “Display Flag”,        fdfcuv.flex_value_set_id “Value Set Id”,        ffvs.flex_value_set_name “Value Set Name”,        flv.meaning “Default Type”,        fdfcuv.DEFAULT_VALUE “Default […]

/by
, ,

Open Interface – GL Interface

CREATE OR REPLACE PROCEDURE XX_GL_INTERFACE ISBEGIN/*SELECT * FROM GL_INTERFACE MANDATORY FIELDS              STATUS             ACCOUNTING_DATE             CURRENCY_CODE             DATE_CREATED             CREATED_BY             ACTUAL_FLAG             USER_JE_CATEGORY_NAME             USER_JE_SOURCE_NAME */ —  GL > JOURNALS  >   IMPORT   >  RUN   INSERT INTO GL_INTERFACE (                          LEDGER_ID                     ,                          STATUS                        ,                                                            SET_OF_BOOKS_ID               ,                                  USER_JE_SOURCE_NAME           ,                                  USER_JE_CATEGORY_NAME         ,                                ACCOUNTING_DATE               ,      […]

/by
,

Verifying Form Personalizations

— To verify Personalization Rules   SELECT   ffcr.SEQUENCE “Seq”, ffcr.description “Description”,         DECODE (ffcr.rule_type,                 ‘F’, ‘Form’,                 ‘A’, ‘Function’,                 ‘Other’                ) “Level”,         ffcr.enabled “Enabled”, ffcr.trigger_event “Trigger Event”,         ffcr.trigger_object “Trigger Object”, ffcr.condition “Condition”,         DECODE (ffcr.fire_in_enter_query,                 ‘Y’, ‘Both’,                 ‘N’, ‘Not in Enter-Query Mode’,                 ‘O’, ‘Only in Enter-Query Mode’,                 ‘Other’                ) “Processing Mode”    FROM apps.fnd_form_custom_rules ffcr   WHERE ffcr.function_name = ‘ONT_OEXOEORD’     AND […]

/by
, ,

MULTI ORG in Oracle Application

The ability to define multiple organizations and the relationships among them within a single installation of Oracle Applications is called multi organization or Multi-org. Multi Org is the future used to store the data of multiple organizations in a single Database instance.Basic Business Needs: Use a single installation of any Oracle Applications product to support […]

/by