Entries by Oracle ERP Apps Guide

, , , , , ,

Query for Link Between SLA and Opm Accounting preprocessor Tables in R12

SELECT GEH.REFERENCE_NO,  GEH.TRANSACTION_ID,  GEH.TRANSACTION_DATE,  gel.line_number,  gel.journal_line_type,  gel.entered_amount,  gel.accounted_amount,  FND_FLEX_EXT.GET_SEGS(‘SQLGL’, ‘GL#’,gcc.chart_of_accounts_id,gcc.code_combination_id) account,  GL_FLEXFIELDS_PKG.get_concat_description( gcc.chart_of_accounts_id, gcc.code_combination_id) acc_descriptionFROM gl_code_combinations gcc,  xla_ae_lines al,  xla_distribution_links dl,  gmf_xla_extract_headers geh,  gmf_xla_extract_lines gelWHERE gcc.code_combination_id       = al.code_combination_idAND al.ae_header_id                 = dl.ae_header_idAND al.ae_line_num                  = dl.ae_line_numAND dl.event_id   […]

/by
, , ,

R12 – Basics of XSLT for BI Publisher

What is XSLT? Today, I’ll cover the basic of the XSLT. Basic development of BI Publisher RTF Template doesn’t require the XSLT coding. However, when you start developing advanced reports having a good understanding of the XSLT will help you to develop the RTF Template efficiently and provide richer functionality. I’ll cover the benefit of using […]

/by
, , ,

Solved: Workflow Error When Clicking View Status Diagram on Status Monitor

When you want to view the status diagram of workflow process on status monitor page from the workflow administrator responsibility, maybe you get the error page like below: The solution for the above issue is set the Server Timezone profile option on the Site level. After that you can able to see the status diagram in workflow […]

/by
, , , ,

Solved: You cannot run a page which is not Self Secured when the MAC fails

Sometimes we will face below issues in R12. Issue 1: You have insufficient privileges for the current operation. Please contact your System Administrator. You cannot run a page which is not Self Secured when the MAC fails. Resolution:   Set the below 3 profiles to None 1) FND Function Validation Level 2) FND Validation Level […]

/by