Here is the SQL Query for Link Between PO-RCV-XLA-AP. SELECT DISTINCT A.PO_NO, A.LINE_NUM, A.DIST_NUM, A.ITEM_CATEGORY, A.IS_CAPITAL, A.SEGMENT2 PO_ACCT, A.ACCT PO_ACCT_DESC, A.UNIT_PRICE, A.AMOUNT_ORDERED, NVL ( (SELECT TO_CHAR (RT.TRANSACTION_DATE, ‘yyyy-mm-dd’) […]
To Access OAF Personalization in Oracle Apps, we need to set the values of following profiles options to enable Personalization Page link in OAF Pages. You can enable these profile options at all levels (Function, Site, Responsibility, User) These four profile options are mandatory for working on OAF personalization in apps. To Assign these Profile Options, […]
In R12, We Can’t just directly get the Code Combination ( i.e Accounting Flex Field) Description from a single table. But Oracle has provided a package, which will help to get the description easily. Script:SELECT GCC.CODE_COMBINATION_ID, GCC.SEGMENT1, GCC.SEGMENT2, GCC.SEGMENT3, GCC.SEGMENT4, GCC.SEGMENT5, GCC.SEGMENT6, […]
–Information can be retrieved from the table:XLE_LE_OU_LEDGER_V –Query for Ledger, Operating Unit, Legal Entity, balancing segment:select HRL.COUNTRY, HROUTL_BG.name BG, HROUTL_BG.ORGANIZATION_ID, LEP.LEGAL_ENTITY_ID, LEP.name LEGAL_ENTITY, HROUTL_OU.name OU_NAME, HROUTL_OU.ORGANIZATION_ID ORG_ID, HRL.LOCATION_ID, HRL.LOCATION_CODE, GLEV.FLEX_SEGMENT_VALUEfrom XLE_ENTITY_PROFILES LEP, XLE_REGISTRATIONS REG, HR_LOCATIONS_ALL HRL, HZ_PARTIES HZP, FND_TERRITORIES_VL TER, HR_OPERATING_UNITS HRO, HR_ALL_ORGANIZATION_UNITS_TL HROUTL_BG, HR_ALL_ORGANIZATION_UNITS_TL HROUTL_OU, HR_ORGANIZATION_UNITS GLOPERATINGUNITSEO, GL_LEGAL_ENTITIES_BSVS GLEVwhere LEP.TRANSACTING_ENTITY_FLAG = ‘Y’and […]
While Accessing Web ADI Responsibility some times we will get the below error message. To Fix this issue we need to disable one profile option value. Error: Desktop Integration is not a valid responsibility for the current user. Please contact your System Administrator. Solution: By default below Profile Option is either Null or Yes. Just […]
Recent Comments