You are browsing the archive for Oracle Subledger Accounting.

Trading Partner Summary Report

 

NAME: Trading Partner Summary Report
SHORT CODE: XLATPSUMRPT
MODULE: Oracle Subledger Accounting

Description: Trading Partner Summary Report
Navigation: Oracle Subledger Accounting Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Application ID : Application ID
  • Ledger Name : Ledger Name
  • Ledger Dummy : Ledger Dummy
  • Chart Of Accounts Id : Chart Of Accounts Id
  • Journal Entry Source Name : Journal Entry Source Name
  • Accounting Flexfield From : Accounting Flexfield From
  • Accounting Flexfield To : Accounting Flexfield To
  • Period From : Period From
  • Period To : Period To
  • Trading Partner Type : Trading Partner Type
  • Trading Partner Type Dummy : Trading Partner Type Dummy
  • Third Party Type : Third Party Type
  • Third Party Type Dummy : Third Party Type Dummy
  • Accounting Date From : Accounting Date From
  • Accounting Date To : Accounting Date To
  • Trading Partner Name From : Trading Partner Name From
  • Trading Partner Name To : Trading Partner Name To
  • Include Subsidiary Trading : Include Subsidiary Trading
  • Include Subsidiary Dummy : Include Subsidiary Dummy

 

Third Party Balances Report

 

NAME: Third Party Balances Report
SHORT CODE: XLATPRPT
MODULE: Oracle Subledger Accounting

Description: Standard Third Party Balances Report
Navigation: Oracle Subledger Accounting Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_RESP_APPLICATION_ID : Application id attached to the responsibility
  • P_LEDGER_ID : Internal identifier for the ledger or ledger set
  • P_LEDGER : Ledger Name
  • P_COA_ID : Internal identifier for Chart of Accounts
  • P_JE_SOURCE_NAME : Journal Entry Source Name
  • P_JE_SOURCE : Journal Entry Source
  • P_LEGAL_ENTITY_ID : Internal identifier for the legal entity
  • P_LEGAL_ENTITY : Legal Entity Name
  • P_PERIOD_FROM : Start period from the calendar attached to the ledger or ledger set
  • P_PERIOD_TO : End period from the calendar attached to the ledger or ledger set
  • P_GL_DATE_FROM : Start Date
  • P_GL_DATE_TO : End Date
  • P_INCLUDE_DRAFT_ACTIVITY_FLAG : Include Draft Activity Flag
  • P_INCLUDE_DRAFT_ACTIVITY : Include Draft Activity
  • P_BALANCE_SIDE_CODE : Balance Side Code
  • P_BALANCE_SIDE : Balance Side
  • P_BALANCE_AMOUNT_FROM : Balance amount from
  • P_BALANCE_AMOUNT_TO : Ba

 

Open Account Balances Listing

 

NAME: Open Account Balances Listing
SHORT CODE: XLATBRPT
MODULE: Oracle Subledger Accounting

Description:
Navigation: Oracle Subledger Accounting Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_APPLICATION : Application Dummy
  • P_DEFINITION_CODE : Report Definition
  • P_JOURNAL_SOURCE : Journal Source
  • P_START_DATE : Start Date
  • P_AS_OF_DATE : As of Date
  • P_THIRD_PARTY_ID : Third Party Name
  • P_SHOW_TRX_DETAIL_FLAG : Show Transaction Detail
  • P_INCL_WRITE_OFF_FLAG : Include Write Offs
  • P_COA_ID : Chart of Accounts
  • P_ACCOUNT_FROM : Account From
  • P_ACCOUNT_TO : Account To
  • P_ACCT_BALANCE : Account Balance
  • P_SECURITY_FLAG : Security
  • P_VALUATION_METHOD : Valuation Method
  • P_SECURITY_ID_INT_1 : Security Identifier (Number)
  • P_SECURITY_ID_CHAR_1 : Security Identifier (Character)
  • P_CUSTOM_PARAM_1 : Custom Parameter 1
  • P_CUSTOM_PARAM_2 : Custom Parameter 2
  • P_CUSTOM_PARAM_3 : Custom Parameter 3