Showing posts with label Oracle Technical. Show all posts
Showing posts with label Oracle Technical. Show all posts

Friday, January 30, 2015

How to Define Segment Values in Accounting Flex field in Release 12.2

How to Define Segment Values in Accounting Flex field in Release 12.2 

Not able to Search Value sets in R12.2

In Release 12.2 Value set Insert/Update depends on Security access. To Insert/Update the Accounting Flex filed segment values for a specific user, User need to follow below steps
By Default in R12.2 a user will not be able to see any values in the value set / Key Flexfield values Form and will receive an error
FRM-40212: Invalid value for field FLEX_VALUE_SET-NAME




To Insert/Update the Accounting Flex filed segment values for a specific user, User need to be provided with appropriate Grants.
Please follow below steps toad Grants for User to Insert and update Value Sets.

Responsibility : Functional Administrator
Go to Navigation : Security à Grants à  Create Grant

1.Name            :Give Name as Required
2.Grantee Type :Select as Specific User
3.Grantee         :Select the Required User Name from List of Values
4.Object           :Select Object as ''Flexfield Value Set Security Object(1)'' from List of Values
5.Set               :Select the Set as ''Flexfield Value Set Security Insert/Update Set'' from List of values .
6. Click on ''Apply'' Button


Add the Object Data Context : All Rows



Select the Set as ''Flexfield Value Set Security Insert/Update Set'' from List of values






After creating the grants from functional administrator, we will be able to perform the following in Value set and Key Flex field Values form:

i) Access the values in Name field LOV, when we Find Values By Value Set.
ii) Access the values in Application,Title,Structure & Segment field LOV's, when we Find Values By Key 
Flexfield
iii) Access the values in Application,Title,Structure & Segment field LOV's, when we Find Values By 
Descriptive Flexfield
iv) Access the values in Application, Name & Parameter LOV's, when we Find Values By Concurrent Program.


Sunday, January 26, 2014

WebADI Common Errors

WebADI Common Errors

Web ADI Configuration Error    
     BNE_UIX_PHYSICAL_DIRECTORY is not configured.

This error can occur under several conditions:
  • Unable to open WebADI
  • After running Autoconfig on nodes not able to upload files
  • When selecting the 'Desktop Integrator' Responsibility the seeded menu options produces the error
  • After installing Oracle E-Business suite R12 and attempting to create a hierarchy using the create spreadsheet functionality(WebADI)
  • When creating a Layout as Trade Management Administrator
  • When attempting to do an Import inside the activity screen in Marketing Online the error occurs

Some Helpful metalink Notes:

  • WebADI - Web Applications Desktop Integrator BNE_UIX_PHYSICAL_DIRECTORY is not configured Error in Release 11i and R12.x (Doc ID 1312156.1)
  • Error BNE_UIX_PHYSICAL_DIRECTORY Is Not Configured in R12 When Attempting to Use WebADI Spreadsheet to Create Hierarchies (Doc ID 430991.1)
  • WebADI Create Layout In Trade Management Error: "BNE_UIX_PHYSICAL_DIRECTORY is Not Configured." (Doc ID 413289.1)
  • BNE_UIX_PHYSICAL_DIRECTORY Is Not Configured Error (Doc ID 888386.1)

Monday, March 4, 2013

General Ledger - Sub-ledger Accounting Dril Down


As Part of regular Designing and Trouble shooting of General Ledger and Subledger Accounting Analysis it is required to have knowledge of Technical Drill Down and Link between GL and Subledger Tables.

Please see the Below mentioned select Statement to Identify relation between various tables for DrillDown from GL To Subledger and Vice Verse.



select
GL.NAME,GJH.JE_HEADER_ID,GJH.JE_CATEGORY,GJH.JE_SOURCE,GJH.NAME,GJH.STATUS, GLL.JE_LINE_NUM,GCC.CONCATENATED_SEGMENTS,XAL.ACCOUNTING_CLASS_CODE,xal.*
,8,GIR.*,8,XAH.*,8,XAL.*,8,XDL.*--,8,PCD.*
from
APPS.GL_JE_HEADERS GJH,
APPS.GL_JE_LINES GLL,
APPS.GL_CODE_COMBINATIONS_KFV GCC,
APPS.GL_IMPORT_REFERENCES GIR,
APPS.GL_LEDGERS GL,
APPS.XLA_AE_LINES XAL,
APPS.XLA_AE_HEADERS XAH,
APPS.XLA_DISTRIBUTION_LINKS XDL
WHERE 1=1
AND GJH.LEDGER_ID = GL.LEDGER_ID
AND GJH.JE_HEADER_ID = GLL.JE_HEADER_ID
AND GJH.JE_HEADER_ID = GIR.JE_HEADER_ID
AND GLL.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND GLL.JE_LINE_NUM = GIR.JE_LINE_NUM
AND GIR.GL_SL_LINK_ID = XAL.GL_SL_LINK_ID
AND XAL.AE_HEADER_ID = XAH.AE_HEADER_ID
AND XAL.AE_HEADER_ID = XDL.AE_HEADER_ID
AND XAL.AE_LINE_NUM = XDL.AE_LINE_NUM
--AND XDL.SOURCE_DISTRIBUTION_ID_NUM_1 = PCD.EXPENDITURE_ITEM_ID
--AND TRUNC(GJH.CREATION_DATE) > TRUNC(SYSDATE-10)
--AND GCC.SEGMENT6 != '000'
--AND UPPER(GJH.JE_CATEGORY) LIKE UPPER('PROJECT%')
--AND UPPER(GJH.JE_SOURCE) LIKE UPPER('Project Accounting%')
and gjh.je_header_id = <je header ID>
and gll.je_line_num =<JE LINE NUMBER>