All modules Interface Tables

GL INTERFACE TABLESTNAME TABTYPE------------------------------ ------- ----------------------GL_BUDGET_INTERFACE TABLEGL_DAILY_RATES_INTERFACE TABLEGL_IEA_INTERFACE TABLEGL_INTERFACE TABLEGL_INTERFACE_CONTROL TABLEGL_INTERFACE_HISTORY...

Read More

PO Interface

PO_HEADERS_INTERFACEis the interface table that imports header information from e– Commerce Gateway for blanket purchase orders and catalog quotations.INTERFACE_HEADER_IDBATCH_IDINTERFACE_SOURCE_CODEPO_LINES_INTERFACEis the interface table that imports lines information from e– commerce Gateway for blanket purchase orders and catalog quotations.INTERFACE_LINE_IDINTERFACE_HEADER_IDACTION...

Read More

PO Queries

1. You need to list out all Internal Requisitions that do not have an associated Internal Sales order. Internal Requisitions without Sales order Select RQH.SEGMENT1 REQ_NUM, RQL.LINE_NUM, RQL.REQUISITION_HEADER_ID , RQL.REQUISITION_LINE_ID, RQL.ITEM_ID...

Read More

AOL Quiries.

1 ) To get list of responsibilities SELECT (SELECT application_short_name FROM fnd_application fa WHERE fa.application_id = frt.application_id) application, frt.responsibility_id, frt.responsibility_name FROM apps.fnd_responsibility_tl frt;2) To get Menus Associated with responsibilitySELECT DISTINCT a.responsibility_name,...

Read More

Purchasing Quiries

1) CANCEL REQUISITIONSSELECT ,prh.REQUISITION_HEADER_ID ,prh.PREPARER_ID ,prh.SEGMENT1 "REQ NUM" ,trunc(prh.CREATION_DATE) ,prh.DESCRIPTION ,prh.NOTE_TO_AUTHORIZERFROM,apps.Po_Requisition_headers_all prh,apps.po_action_history pahWHEREaction_code='CANCEL' andpah.object_type_code='REQUISITION' andpah.object_id=prh.REQUISITION_HEADER_ID2)INTERNAL REQUISITIONS...

Read More

Chart of Accounts Structure Overview

GL : Chart of Accounts Structure Overview:---------------------------------------------------CHART OF ACCOUNTS STRUCTUREGives an overview of the chart of accounts definitions and also status.This is used when implementing multiple charts of accounts to ensure consistent setup across countries and between environments.Where clause can be added or commented...

Read More

Chart of Account Segment Hierarchy Ranges

GL : Chart of Account Segment Hierarchy Ranges:-----------------------------------------------------------Chart of account segment hierarchy ranges and attributes for parent accountsI have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.I have commented the SOB condition. Check your Instances SOB short-name and provide accordingly...

Read More

Operating Unit and Legal Entity Configuration

GL : Operating Unit and Legal Entity Configuration:--------------------------------------------------------------LEGAL ENTITIERS & ORGANIZATIONSGives an overview of the legal entity and operating unit configuration across multiple OUThis is used when implementing multiple offices to ensure consistent setup across countries and between environments.Where...

Read More

Summary Account Template definition review script

GL : Summary Account Template definition review script:---------------------------------------------------------------------GL SUMMARY TEMPLATE DEFINITIONSSmall script showing summary template configuration across multiple books,I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.I have commented the SOB condition. Check your...

Read More

Set of Books Configuration Overview

GL : Set of Books Configuration Overview:-------------------------------------------------SET OF BOOKS CONFIGURATION OVERVIEWThis SQL gives an overview of the set of book definitions and can be used when implementing multiple sets of booksto ensure consistent setup across countries and between environments.Where clause can be added or commented out...

Read More

Segment Value Listing

GL : Segment Value Listing:---------------------------------SEGMENT VALUE SET LISTINGSLists single or multiple segment value sets. This is used to perform a QA on chart of accounts values.Examples of optional where clauses have also been provided below.SELECT FFVS1.FLEX_VALUE_SET_NAME--, FFVS1.FLEX_VALUE_SET_ID, FFVAL1.FLEX_VALUE"VALUE",...

Read More

Mass Allocation Formula review script

GL : Mass Allocation Formula review script:----------------------------------------------------Will show the definition of mass allocation batches and lines across multiple books in an easy to read format for review in excelIt has been written for a 10 segment CoA but can be modified to suit different structures.I have tested in 11.5.10.2 Instance....

Read More