Enterprise Resource Planning and Integrations BlogSpot

Skip to content

Day: January 23, 2017

GL Drilldown to FA, FA Drilldown to AP, AP Drillup to GL for Asset Clearing Account

  • by Yogesh Pachpute
  • Posted on January 23, 2017August 23, 2017
  • Fixed Asset

Requirement: Requirement is to identify Fixed Asset and Payables transaction related Asset Clearing Account coming into GL. This is to make the reconciliation of asset clearing account easy. Solution: Build BI Publisher report using following script […]

Read More

BI Publisher Desktop Installation for EBS R12.1.3 and Microsoft Office 2010

  • by Yogesh Pachpute
  • Posted on January 23, 2017
  • BI Publisher

As per Oracle BI Publisher and EBS R12.1.3 certification matrix following are the compatibility of BI Publisher with EBS, Windows and Microsoft office. a) BI Publisher Desktop: The EBS 12.1.3 has the embedded BIP version […]

Read More

Query To Check GL Period Begining Balances with Previous Period Ending Balance(Compare period1_end_balance with period2_begin_balance)

  • by Yogesh Pachpute
  • Posted on January 23, 2017August 10, 2017
  • General Ledger

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 SELECT code.concatenated_segments, period1.begin_balance_dr […]

Read More

Query To Check GL Balances with JE Lines Balances (Compare period_balance with line_bal)

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 […]

Read More

Categories

  • AGIS – Advanced Global Intercompany (1)
  • AR Reconciliation (8)
  • BI Publisher (3)
  • Cash Management (4)
  • Cloud Enterprise Structure (2)
  • Concurrent Processing in R12 (4)
  • Conversion (3)
  • Cost Management (3)
  • ERP Accounting (7)
  • ERP Integrations (1)
  • Fixed Asset (22)
  • General Ledger (34)
  • GRC (8)
  • iExpense (21)
  • Intercompany Integrations (1)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Cutover Tasks (1)
  • Oracle Cloud Fusion Financial (14)
  • Oracle Cloud Requirement – Design (5)
  • Oracle Cloud Security (2)
  • Oracle Database (2)
  • Oracle Fusion HCM (10)
  • Oracle Fusion HCM Technical (5)
  • Oracle Fusion Technical (11)
  • Oracle Installations (3)
  • Oracle Inventory (2)
  • Oracle SQL (4)
  • Order Management (4)
  • Payables (48)
  • 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 (23)
  • SubLedger Accounting (26)
  • Subscription Management (1)
  • Supplier Modeling (1)
  • Supply Chain Managment (1)
  • TCA – DQM (1)
  • Uncategorized (3)
  • Useful SQL Scripts (4)
  • Workday (7)

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

Join 41 other subscribers

Calendar

Calendar

January 2017
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
    Feb »
Blog at WordPress.com.
  • Subscribe Subscribed
    • Enterprise Resource Planning and Integrations BlogSpot
    • Join 41 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Enterprise Resource Planning and Integrations BlogSpot
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar