Sairam Nimmagadda

Using WSH_DEBUG_SV package for a better Debug method for Order Management and Shipping modules. Use wsh_debug_sv.start_debugger procedure to get the debug messages at Performance Statement Procedure Event Exception Error Unexpected Error level Define the profile option WSH:Debug Enabled at User Level. Define the profile option  WSH:Debug Level at one of the values mentioned above The default value is at Procedure, but for the user level you can set this at any level. Create a directory on the application server and set up a directory for the debug log. Define the profile option WSH:Debug Log Directory   to the directory created. When using in the code Define the parameters       file_name                   VARCHAR2 (100);       return_status            ...

  select   g.request_group_name, fr.responsibility_name     from   fnd_request_groups g, fnd_responsibility r, fnd_responsibility_tl fr    where       fr.responsibility_name = 'Responsibility Name'            and g.request_group_id = r.request_group_id            and r.end_date is null            and r.responsibility_id = fr.responsibility_id            and fr.language = 'US' order by   fr.responsibility_name

One of the functions that came in handy for me the Is_number function. This function would consume a string and figure out if its a number or not. If the string is a number, the return value is '1' if not it will return '0'  FUNCTION is_number (p_string IN VARCHAR2)       RETURN INT    IS       v_new_num   NUMBER;    BEGIN       v_new_num := TO_NUMBER (p_string);       RETURN 1;    EXCEPTION       WHEN VALUE_ERROR       THEN          RETURN 0;    END is_number;

XLA_AE_HEADERS xah XLA_AE_LINES xal XLA_TRANSACTION_ENTITIES xte XLA_DISTRIBUTION_LINKS xdl GL_IMPORT_REFERENCES gir Below are the possible joins between these XLA Tables: xah.ae_header_id = xal.ae_header_id xah.application_id = xal.application_id xal.application_id = xte.application_id xte.application_id = xdl.application_id xah.entity_id = xte.entity_id xah.ae_header_id = xdl.ae_header_id xah.ae_line_num = xdl.ae_line_num xah.event_id = xdl.event_id xal.gl_sl_link_id = gir.gl_sl_link_id xal.gl_sl_link_table = gir.gl_sl_link_table xah.application_id = (Different value based on Module) xte.entity_code = 'TRANSACTIONS' or 'RECEIPTS' or 'ADJUSTMENTS' or 'PURCHASE_ORDER' or 'AP_INVOICES' or 'AP_PAYMENTS' or 'MTL_ACCOUNTING_EVENTS' or 'WIP_ACCOUNTING_EVENTS' xte.source_id_int_1 = 'INVOICE_ID' or 'CHECK_ID' or 'TRX_NUMBER' XLA_DISTRIBUTION_LINKS table join based on Sou...

Alter Table xx_tbl Modify (column_name varchar2(100) );

One way of creating a full date value is to create a view in the database, assign the view to a value set and assign the value set to the parameter of a concurrent program or to Descriptive Flexfield. create or replace view date_time_v AS (SELECT     (TO_DATE (SYSDATE - 1 + LEVEL, 'DD-MON-RRRR HH24:MI:SS')) cdate              , (TO_CHAR (SYSDATE - 1 + LEVEL, 'Month, DD RRRR HH24:MI:SS')) cdate_word     FROM       DUAL x     CONNECT BY LEVEL <= 1000); Selet * from  date_time_v; the output would be CDATE_        CDATE_WORD 10/17/2014    October  , 17 2014 08:02:21 10/18/2014    October  , 18 2014 08:02:21 10/19/2014    October  , 19 2014 08:02:21 10/20/2014    October  , 20 2014 08:02:21 10/21/2014    Octob...

When you have more than one image to be displayed conditionally, you can use the dynamic Images concept for the BI Publisher Templates. Look for media directory under the custom top.Place the image files (in gif format) From the data definitions (xml) or report (rdf) derive the image_path of the image and store in xml tags. Place a dummy image in the template. Right Click on the image, Format Picture. Go to Alt Text => Under the Description =>  Enter the following url:{//Image_path} ** This CANNOT be tested when you are making changes and running a preview from your template. Since the word on the computer cannot access the file server for images