SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product, glcc.segment6 channel, glcc.segment7 project, (SELECT flex_value || ‘ ‘ || fvt.description FROM apps.gl_code_combinations glc, apps.fnd_flex_values fv, apps.fnd_flex_values_tl fvt WHERE…
Read MoreSELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product, glcc.segment6 channel, glcc.segment7 project, (SELECT flex_value || ‘ ‘ || fvt.description FROM apps.gl_code_combinations glc, apps.fnd_flex_values fv, apps.fnd_flex_values_tl fvt WHERE…
Read MoreSELECT glcc.segment1 co, glcc.segment2 loc, glcc.segment3 cc, glcc.segment4 acct, glcc.segment5 prod, glcc.segment6 chan, glcc.segment7 proj, ” “CODECOMBO desc”, xal.accounting_date, gjh.je_source, gjh.je_category CATEGORY, gjb.NAME batch, gjh.NAME “JOURNAL name”, ” “JE SEQ…
Read MoreReport Builder Components 1. Data Model 2. Layout Model 3. Object Navigator 4. Report Triggers 5. Parameter Form 6. Program Units 7. Attached Libraries Data Model The Report Editor’s Data…
Read MoreAIM Document Specifications: 1. Business Process Architecture (BP) 2. Business Requirements Definition (RD) 3. Business Requirements Mapping 4. Application and Technical Architecture (TA) BP.010 Define Business and Process Strategy BP.020…
Read MoreFinding error messages while doing workflow activities from backend. Approach: Find a workflow internal name Query the workflow table with…
Read MoreRequirement: Timeout period should be 48 hours for a notification. Approach: 1. Go to particular Notification Label 2. Select the properties 3. Select the Node tab 4. Change the Timeout …
Read MoreFor Example Display the sub total values based on Account code and show grand total end of the report. The report has only one group (G_ACCT) and group columns like …
Read MoreRequirement : Enable ‘Execure-Query’ using an LOV field (non-database items) . Approach: When user clicks on CTRL+F11 we need set dynamic where clause. Normally for database fields Oracle standard feature…
Read MoreIn some cases, we get a comma separated string as output (say from another select statement or block) that we would need to pass to the IN clause of a…
Read More