Sreekanth Reddy Pothula's Oracle ERP Blog

Whenever you change the email address of a HR Employee record you will notice that this change in the email address is not reflected within the user account. For example for the below employee I changed the email address through a correction update in HR. On the account of this user to which the HR Employee record is assigned this change is not reflected. In other words the email address assigned to the user and to the related employee do not match. This will generate problems with workflow notifications if they are being sent through the Workflow Notification Mailer. Currently there is no direct update functionality from HR to the FND_USER table. Oracle will only execute an update to the WF_LOCAL_ROLES table from the APPLSYS schema (for future assignments of the employee to a user). Also after running concurrent program Workflow Directory Services User/Role Validation only the WF_LOCAL_ROLES table is updated and not FND_USER. SELECT  ...

SQL to retrieve a list of descriptive flexfields with column usages and value-set definitions For a little project I needed to retrieve E-Business Suite Descriptive Flexfields for all applications together with the column usages and value set assignments and settings. So, here you go...of course adjust the statement per your requirements. SELECT   A.APPLICATION_NAME,   FDF.APPLICATION_TABLE_NAME,   FDFT.TITLE,   FDF.DESCRIPTIVE_FLEXFIELD_NAME,   FDF.FREEZE_FLEX_DEFINITION_FLAG,   FDCF.DESCRIPTIVE_FLEX_CONTEXT_CODE,   FDFCU.COLUMN_SEQ_NUM SEQUENCE_NUMBER,   FDFCU.END_USER_COLUMN_NAME PARAMETER_NAME,   FFVS.FLEX_VALUE_SET_NAME VALUE_SET,   FFVS.DESCRIPTION VALUE_SET_DESCRIPTION,   T.FORM_LEFT_PROMPT PROMPT,   FDFCU.DEFAULT_VALUE DEFAULT_VALUE,   FDFCU.ENABLED_FLAG,   FDFCU.REQUIRED_FLAG,   FDFCU.SECURITY_ENABLED_FLAG,   FDFCU.DISPLAY_FLAG,   FDFCU.DISPLAY_SIZE FROM   FND...

Issue Summary : Unable to view Value Set Values in Oracle EBS R12.2 - Oracle E-Business Suite (EBS) value sets do not appear in the List of Values (LOV) in the Values form FNDFFMSV after upgrading to Oracle E-Business Suite 12.2.2 or higher. - Users are not able to insert or update any independent or dependent value set values after the upgrade     Analysis   - Release 12.2.2 includes a new security feature, flexfield value set security, to control who can create or modify flexfield values in the Flexfield Values setup form (FNDFFMSV).  Because this is a security feature, it is enabled by default. - After the upgrade, users will not be able to create or modify any independent or dependent value sets in the Flexfield Values setup form (FNDFFMSV) until access is specifically granted to that user by setting up the feature. 1. Release 12.2 onwards Oracle has introduced a new feature of 'Flexfield value set security'.  2. This features control...

Error Description      java.lang.IllegalArgumentException: peerExceptions list should only contain OAException elements Environment       Oracle E Business Suite R12.1.x   Steps to Reproduce 1. Go to Oracle iExpenses responsibility 2. Create an Expense Report 3. Hit 'Step-2' button. Error is thrown Solution 1. Go to Human Resources, Vision Enterprises Responsibility 2. Go to Employee definition (for which you were trying to create a new expense report) 3. Go to Assignments -> Purchasing Order Information tab 4. Check the supervisor Section, If not, make sure that the supervisor field is populated 4. Assign a 'Ledger' and 'Default Expense Account'. Ledger  : Vision Operations (USA) Default Expense Account - 01-000-0000-0000-000 5. Go back and retest the issue

SQL Developer Link: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Workflow Builder client 2.6.3 / XML Gateway Message Designer - Patch 6970344: Workflow Client for Oracle EBusiness Suite R12  ( Recommended Set Up for Client/Server Products with Oracle E-Business Suite 11i & R12 Note 277535.1) -  11i - 12 How To Download and Install the Latest Oracle Workflow Builder (Client Tool) and XML Gateway Message Designer for E-Business Suite (Doc ID 261028.1)  

SELECT   poh.po_header_id,    poh.type_lookup_code PO_TYPE,   poh.authorization_status PO_STATUS,   poh.segment1 PO_NUMBER,   pov.vendor_name SUPPLIER_NAME,   povs.vendor_site_code Location,   hrls.location_code Ship_To,   hrlb.location_code Bill_to,   pol.line_num ,   msib.segment1 Item,   pol.unit_price,   pol.quantity,   pod.amount_billed Amount,   pod.destination_subinventory,   ppf.full_name Buyer_Name,   poh.closed_Code  FROM   PO_HEADERS_ALL poh,   PO_LINES_ALL pol,   mtl_system_items_b msib,   PO_LINE_LOCATIONS_ALL poll,   PO_DISTRIBUTIONS_ALL pod,   po_vendors pov,   po_vendor_sites_All povs,   hr_locations_all hrls,   hr_locations_all hrlb,   per_all_people_f ppf,   po_line_types polt WHERE   1                         =1 AND polt.line...

Query to find the operating unit org_id for the blanket agreement header, the approval status, and the style id value. select segment1, creation_date, po_header_id, org_id, authorization_status, style_id from po_headers_all where segment1 in ('&BPAorGBPA-Number') order by po_header_id desc Query to find the document styles, and style_allowed_values for various PURCHASE_BASES (Purchase Basis) values select * from po_doc_style_values where style_id in (select distinct style_id from po_headers_all where segment1 in ('&BPAorGBPA-Number') ) and STYLE_ATTRIBUTE_NAME = 'PURCHASE_BASES' Query to find  the line types that use the same Purchase Basis as those used on the BPA or GBPA select * from po_line_types_b where purchase_basis in ( select distinct style_allowed_value from po_doc_style_values where style_id in (select distinct style_id from po_headers_all where segment1 in ('&BPAorGBPA-Number') ) and STYL...