You are browsing the archive for Oracle Accounts Receivables.

by oracleguru

D&B Flat File Upload Table Creation

ORACLE APPS COMMUNITY > Tutorial > Financials > Oracle Accounts Receivables

 

NAME: D&B Flat File Upload Table Creation
SHORT CODE: ARHLDDNB3
MODULE: Oracle Accounts Receivables

Description: Create external Table for D&B Batch Flat file Upload
Navigation: Oracle AR Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_dirobj : The file location directory object name
  • p_datafilename : The D&B Batch file name
  • p_logfilename : Log file name
  • p_badfilename : File name to store all bad records
  • p_dscfilename : File name to store all discarded records

 

Tags: No Comments »

by oracleguru

Generate Time Zone for Phone Numbers

ORACLE APPS COMMUNITY > Tutorial > Financials > Oracle Accounts Receivables

 

NAME: Generate Time Zone for Phone Numbers
SHORT CODE: ARHTZCPT
MODULE: Oracle Accounts Receivables

Description: Generate Time Zone Associated with the Phone Number
Navigation: Oracle AR Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_overwrite_flag : Overwrite Existing Time Zone

 

Tags: No Comments »

by oracleguru

Publish Actual Receipt

ORACLE APPS COMMUNITY > Tutorial > Financials > Oracle Accounts Receivables

 

NAME: Publish Actual Receipt
SHORT CODE: ARRXACRC
MODULE: Oracle Accounts Receivables

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

Report Parameters:

  • Request Type : Request Type
  • Application Name : Application Name
  • Concurrent Program Name : Concurrent Program Name
  • Report ID : Report ID
  • Attribute Set : Attribute Set
  • Output Format : Output Format
  • Reporting Level : Indicates Reporting Level
  • Reporting Context : Indicates Reporting Context
  • Set of Books Currency : Ledger Currency
  • Chart of Accounts : Chart of Accounts
  • Batch Name Low : Batch Name Low
  • Batch Name High : Batch Name High
  • Customer Name Low : Customer Name Low
  • Customer Name High : Customer Name High
  • Deposit Date Low : Deposit Date Low
  • Deposit Date High : Deposit Date High
  • Receipt Status Low : Receipt Status Low
  • Receipt Status High : Receipt Status High
  • Receipt Number Low : Receipt Number Low
  • Receipt Number High : Receipt Number High
  • Receipt Date Low : Receipt Date Low
  • Receipt Date High : Recei

 

Tags: No Comments »