Thursday 29 December 2016

How to set up Tracing for Web ADI Error

We can configure tracing for Web ADI activity by using below Profile options.
  • BNE Server Log Level : Set it to Trace
  • BNE Server Log Path : Enter directory path 
  • BNE Server Log Filename : Enter Log file name 
Navigation : Login to Oracle application 
Go to System Administrator Responsibility -> Profile -> System
Eneter User Name and in Profile field enter "BNE%Log%" Then click on Find.



Set all 3 profile options as shown in below mention screenshot at user level.

Once above mentioned setup done . Now you can recreate webadi error, which will create trace file on path mentioned in "BNE Server Log Path" profile option.

Monday 19 December 2016

How to Reconcile Account Payable with GL trial balance


  •  Kindly run the Accounts Payable Trial Balance for a particular period which you have already closed (or) intend to close in both AP and GL.

  • Now Run General Ledger Trial Balance Report for same period.

  • Then compare both trial balance report APTB & GLTB for all accounts. 
  • Submit Create Accounting program from Payable responsibility with proper end date and Final and Post Mode parameter value as 'Yes'.

  • After completing create accounting report again compare APTB and GLTB report.
  • If there is still any difference then submit the GL Account Analysis Report (180 char)" report, which will help to find whether any other source journals are posted to these liability accounts 

  • List out all other source journal amounts (credit less debit) and determine the net value (other than Payables source amounts) to compare with APTB.
  • If there is still a difference between APTB and GLTB after deducting other source journals, then submit the "Account Analysis Report" in Payables for the particular period and liability account code combination. This will help to get detailed transaction level data.
  • Export the output into excel with column sorting options and proceed to reconcile at transaction level to find out the difference between GL trial Balance and AP Trial Balance.
  • Then analyze the transaction accounting entries. If any corruption or partial accounting exist.

How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>

 How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>  Sometime these xml data tags automatically chang...