Enterprise Resource Planning and Integrations BlogSpot

Skip to content

Month: February 2017

BI Publisher Delivery Manager: How to Implement Support For FTP/SFTP Download

  • by Yogesh Pachpute
  • Posted on February 28, 2017
  • BI Publisher

APPLIES TO: BI Publisher (formerly XML Publisher) – Version 12.0 to 12.1 [Release 12.0 to 12.1] GOAL The goal of this document is to indicate the patch that needs to be applied to support FTP/SFTP […]

Read More

R12: Iexpense Expense Reports Join To Ap Invoices

  • by Yogesh Pachpute
  • Posted on February 23, 2017September 14, 2017
  • iExpense

Following joins will helps to understand exact relation between iExpenses and AP invoices. 1 2 3 4 5 6 SELECT aerh.vouchno, aerh.report_header_id FROM ap_expense_report_headers_all aerh, ap_invoices_all ap WHERE aerh.expense_status_code = 'INVOICED' AND ap.invoice_id= aerh.vouchno; then […]

Read More

AR Autoinvoice vs AR Invoice API vs AR Credit Memo API R12

  • by Yogesh Pachpute
  • Posted on February 23, 2017February 23, 2017
  • Receivables

A) AutoInvoice requires a batch of type Imported. Batch sources define default information such as transaction type and automatic numbering. There are two types available: Manual and Imported. AutoInvoice requires a batch of type Imported. Autoinvoice […]

Read More

How To Find AR Transaction Sequence or AR Transaction Sequence By Source

  • by Yogesh Pachpute
  • Posted on February 23, 2017February 23, 2017
  • Receivables

Use the following query to find AR Transaction Sequence By Source. SELECT * FROM all_sequences WHERE sequence_name LIKE ‘RA_TRX_NUMBER%’; Some Tips Example 1) Sequence RA_TRX_NUMBER_N1_81_S is a standard and manual source, this means N1 represents manual source. Example […]

Read More

How to Alter Database Sequence or How to increment or decrements sequence.

  • by Yogesh Pachpute
  • Posted on February 23, 2017
  • Oracle Database

How to Alter Database Sequence or How to increment or decrements sequence. select * from all_sequences where sequence_name like ‘RA_TRX_NUMBER%’; SELECT last_number FROM all_sequences WHERE sequence_name = ‘RA_TRX_NUMBER_N1_81_S’; SELECT last_number FROM all_sequences WHERE sequence_name = […]

Read More

How to find SubLedger accounting package being used for custom or standard subledger accounting engine

  • by Yogesh Pachpute
  • Posted on February 23, 2017August 11, 2017
  • General Ledger

Use following query to find the accounting package is being used 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 […]

Read More

Categories

  • AR Reconciliation (8)
  • BI Publisher (3)
  • Cash Management (4)
  • Cloud Enterprise Structure (2)
  • Concurrent Processing in R12 (4)
  • Conversion (2)
  • Cost Management (1)
  • Fixed Asset (23)
  • General Ledger (25)
  • GRC (6)
  • iExpense (21)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Cutover Tasks (1)
  • Oracle Cloud Fusion Financial (12)
  • Oracle Cloud Security (2)
  • Oracle Database (2)
  • Oracle Fusion HCM (10)
  • Oracle Fusion HCM Technical (5)
  • Oracle Fusion Technical (10)
  • Oracle Installations (3)
  • Oracle Inventory (2)
  • Oracle SQL (4)
  • Order Management (2)
  • Payables (47)
  • Payables Period Close (10)
  • Payables Reconciliation (10)
  • Payments (29)
  • Payroll (1)
  • Perl and Unix Scripting (1)
  • Purchasing (4)
  • Receivables (17)
  • Receivables Period Close (15)
  • Receiving Subledger (3)
  • RMCS (1)
  • SubLedger Accounting (26)
  • Supply Chain Managment (1)
  • TCA – DQM (1)
  • Uncategorized (2)
  • Useful SQL Scripts (4)
  • Workday (7)

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Calendar

Calendar

February 2017
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728  
« Jan   Mar »
Blog at WordPress.com.
  • Follow Following
    • Enterprise Resource Planning and Integrations BlogSpot
    • Join 35 other followers
    • Already have a WordPress.com account? Log in now.
    • Enterprise Resource Planning and Integrations BlogSpot
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar