Run Posting (GLPPOS), or other concurrent programs from the Command line

Run Posting (GLPPOS), or other concurrent programs from the Command line?

How to Run Posting (GLPPOS), or other concurrent programs from the Command line?

You can run any GL program from the command line. Follow these steps:

1) Verify that you run this at a time when there are no incompatible Programs running. To find the incompatible programs:

Responsibility = System Administrator

GUI Navigation = Concurrent/Program/Define

Query on GLPPOS in the Short Name field.

Click on the Incompatibilities button.

2) Change the profile “Concurrent Hold Request” to Yes.

Responsibility = System Administrator

GUI Navigation = Profile/System

Query on the profile option ‘Concurrent Hold Requests’.

Set it to Yes at the User level and Save.

3) Select a journal batch for posting. The request will be put on hold.

Responsibility = General Ledger Super User

GUI Navigation = Journals/Post

4) Go to the Concurrent Requests form and get the parameters for the Posting concurrent process.

The parameters for posting are:

set of books id

chart of accounts id

posting_run_id

5) Run posting from the command line.

$GL_TOP/bin/GLPPOS <username/pwd> 0 Y <parameters> X 2> <File name>

Where:   <username/pwd> : apps username and password

<parameters>   : The parameters for the program, separated by spaces. For NULL parameters you need to specify closed double quotes (“”).

X              : Indicates that you want to run the program in debug mode. This can be any character and is optional.

2> <File name> : Use this to redirect standard errors and output to a file. File name is the output file name it will create. It will be created in your current directory, if a full path is not specified. This is optional

but recommended.

Example:

If you go to the concurrent requests form and see in the Parameters field: 1,101,2546, you would enter the following command at the Unix prompt:

$GL_TOP/bin/GLPPOS <username/pwd> 0 Y 1 101 2546 X 2> <myfile.txt>

6) Change the profile option ‘Concurrent Hold Requests’ back to its original setting. Be sure to run the program from a directory for which you have write Privileges. That is where the log and out files will be created.

Also make sure that you are in the proper application environment.

Here is an example of the command and the output you will see.

$>$GL_TOP/bin/GLPPOS apps/apps 0 Y 8 50128 84 2 2> njpost2.out

DEBUG: started in debug_mode……

$> ls

L54536.log   L54540.log   O54536.out   O54540.out   njpost.out   post.out

L54538.logL54542.log   O54538.out   O54542.out   njpost2.out  test

$> more njpost2.out

Log filename    : L54542.log

Report filename : O54542.out

glpmai() fnd_user_id is -1

glpmai() fnd_user_name is ANONYMOUS

glpmai() req_id is 0

glpmai() sob_id is 8

etc.

selected General Ledger programs can be run in debug

mode by setting the profile option ‘GL: Debug Mode’ to Yes at the

appropriate level.

These programs are:

– GLCRVL – Revaluation

– GLPPOS – Posting

– GLTTRN – Translation

– GLCCON – Consolidation Transfer

– GLAMAS – Run MassAllocations

Oracle General Ledger and Budgeting

What is planning budget ?

The plan for the future expenses is planning budget. It is a paper work. There is no funds requirement. It does not require journals. There are no restrictions for estimating of funds. It is a budget through which you cannot exercise budgetary control. But u can compare your actual with budgets through inquiry window.

What is Consolidation in GL?

It Consolidates the Subsidiaries & Parent financial information. At a point of time we can check the Performance of the Companies overall Performance. When we have multiple setup and combine primary and secondary books getting the financial reports is called consolidation We will use consolidation reports at the time of period end closing Consolidation is the Process of combining the Financial results of different companies typically combining subsidiary accounting information into a parent company.The main purpose of consolidation is for reporting purpose. Consolidation is the period-end process of combing the financials of separate subsidiary with the pay rent company to from single ,combine statement of final result consolidation is one of the reporting tool.consolidation may map the subsidiary set of books to parent set of books, even if the set of books values are different using segment rule,accounting rule It is the process of combining the financial results of multiple companies into one financial statement the company may have different sobs in different countries,so we will collect all the financialtransactions(sob) in to one set of book ,that is parent sob then the company easely findout all the finacial year endingresullts in their functional curency,that purpose multiple companies are using consolidation I think consolidation can be done with two ways that is FSG, GCSÂ for FSG it can be done when both parent SOB and Subsidary SOB have Currency, Calender, COA, same then we go for FSG.In Global consolidation System currency, coa, calender are different in parent sob and subsidary sob we have to go for GCS.I am Saikrishna actaully I am pursuing my oracle financials in hyd i just completed one of my module GL institute.

How to import data to General Ledger by Feeder System ?

There are three ways:

1- You can upload Journal Entries using ADI (Application Desktop Integrator) functionality. ADI is used to interface spreadsheet uploads with Oracle applications data. ADI allows users take advantage of many of the data-entry shortcuts of a spreadsheet, such as copying and pasting cells, dragging and dropping ranges of cells and using formulas to calculate journal line amounts. ADI validates the data entered against the accounts, security rules and reference information that are defined in the General Ledger (GL).

2- Using Journal Import, we can bring the data from the feeder system; to import the Transactions from External Feeder Systems following are the steps-1. Populate the data from External system to GL_Interface table (GL_INTERFACE table acts like a bridge between the external system and the Oracle General Ledger Base tables where journals are stored). 2. Run the Journal Import process to import the date to base tables (Errors in Journal Import are listed in Execution Report)

3. From any sub module run individual module transfer to GL program Ex: Payables transfer to General Ledger

After creating Journal Source how do we approve to the specific Set of Books ?

To approve journals from specific source, while creating the source ‘Require Journal Approval’ check box should be enabled. To approve all the journals that come from different sources In the Set Of Books window under ‘Journaling’ tab ‘journal approval’ should be enabled.

While creating combination of accounts what is the use of PRESERVED check box ?

If we check preserve for a account code combination then even if you disable this account segment value, the inherited (parent. child) segment values will not be disabled. If it is unchecked all the related segment values will be disabled. Preserved check box will help you to retain the original character of the General Ledger code combination, even after u change the nature of the segments during maintenance of the GLCC.

What is the MD form 50 ?

MD50 is a Functional design document, designed by the functional consultant. After interacting with the client, functional consultant will prepare this document. In this we will compare the present business process and client requirement. It is mainly used for Application Extensions and Interface functional design.

What are the journal entries in Procure to Pay Cycle ?

When the Material Received at the Gate-

Receiving Accrual A/C — DrMaterial AP Accrual A/C — Cr

When the Material delivered to The Inv Org Material

A/c Dr Purchase Price Variance A/c Dr Receiving A/c Cr

When the Invoice Is enterd into the Payable with Matching Of PO Material

Ap Accrual A/c Dr Invoice Price Variance A/c Dr AP Liability A/c Cr

Material Receipt

Receiving Accural Dr AP Accural Cr

On completion on inspection and accepting of goods

Inventory Dr Receiving Accural Cr The Above given 2 entries are in PO module

On entering Invoice in AP

AP Accural Dr Accounts Payable Cr

On Making payment

Accounts Payable Dr   Cash/Bank Cr 1. On Entry of PO ________ No accounting impact On Material

On Payment

Accounts Payable Dr’ Cash/Bank Cr

When we raise the Purchase Order entry

Material in transit a/c Dr To AP Accrual A/c

Thanks – Shivmohan

Oracle Applications / Financials – Functional Question on General Ledger – Budgeting

Oracle Applications / Financials – Functional Question on General Ledger – Budgeting. Quite useful as FAQ and Interview Questions for General Ledger.

11. What is Set of Books? What are the four conditions when you change your SOBs?SOB is of 2 types – Primary and Reporting.Primary SOB - All transactions are with functional Currency

12. What is an Invoice?

AR invoice is a document sent to the customer with details like, Bill-to customer code, product code, qty sent, price, currency, credit terms, tax details, etc. Based on this invoice, customer will make payment to the company and the same is applied against the invoice. AP invoice is the document received from the supplier and contains information such supplier details, product code, qty, price and tax details. This invoice is entered in the AP module and payment is made to the supplier against this invoice.

There are 2 types of invoices-

1. Periodic 2. Milestone

Also, Invoice is an information sheet which a company sends to the buyer along with the good. It explains the details of the goods in the shipment and also the prices. Invoices can contain all sorts of data regarding the shipment and goods depending on the company and product.

13. Can you disable budgetary control for a set of books?

You can, however existing encumbrances are not cleared from the feeder systems. Therefore it is not recommended. If you do change the budgetary control options for an existing set of books, you must do two things for the change to be reflected.

–Run the Period Map Maintenance concurrent request, it must complete successfully.

–Exit Oracle Applications and restart. You must completely exit the application…it is not sufficient to select Sign on again from the Oracle Applications Special menu.

14. Is there a limit to the number of periods in a budget year or how many years a budget can span?

There is no limit for the budget. One can define budgetary control for n number of years however, one year can have maximum of 60 fiscal periods.

15. Why don’t my Detail budgets roll up to my Master budget?

Detail budgets do not automatically roll up to the master budget. The GL uses summary accounts to maintain master/detail budget relationships between them.

16. I was able to post a budget journal to a closed period, why?

Yes, a budget journal can be posted to any period that is in an open budget year for that budget. This is regardless of the status of that period. The budget journal is not linked with your accounting period. Once you have open the budget period then you can book budget journal for that whole period.

17. How many ‘Current’ budgets can you have?

For each set of books, you can have only one current budget at any point in time. The only distinction between a ‘current’ and an ‘open’ budget is that the current budget defaults into the budget field on several budget-related forms. It can be replaced however by any ‘open’ budget in the field.

18. What is a funding budget?

Funding budget is a budget against which accounting transactions are checked for available funds when budgetary control is enabled for your set of books. Funding Budgets are approved budgets.Two types of budgets are there in Oracle Apps: 1- Fund 2- Plan.

Fund budget create the Budget Journal but plan budget used only for planning. Fund budget requires journal entries, and is assigned to a summary template or account range in the budget org, where the funds check level is set at Absolute or Advisory. It is the assignment that makes it a ‘funding budget’; it is not done at the budget definition level.

19. Why is my budget requiring budget journals?

At the set of books level that option is not enabled? This would happen when the budget itself is defined to require budget journals. This is done at the budget definition level.

20. Why can’t I inquire on my budget amounts from INQUIRE/BUDGETS navigation path?

The Budget Inquiry form (GLXIQBUD) is used to perform inquiries about master and detail budgets. GL compares summary balances between your master and detail budgets, and checks for budget variances and violations. This form only looks at summary accounts. To inquire on detail accounts you must use the navigation INQUIRE/ACCOUNTS, and choose the ‘budget’ amount type.

21. If I delete my budget org, will the budget amounts be deleted?

No, the amounts will be same. Deleting the budget organization does not remove the budget amounts from the GL_BALANCES table.

22. Can I update/adjust an existing account range in my budget organization?

Yes you can update an existing account range in Budget Organization.

23 How many times can a budget be purged?

Budget can be purged only one time.

24. Why is there no value in the REQUEST_ID column of GL_BUDGET_INTERFACE for rows with data that failed to be uploaded by the Budget Spreadsheet Upload program?

You are trying to open the next budget year. After navigating to the form and querying the budget, you notice the [Open Next Year] button is grayed out. You find that Account code combinations are not being added to the Budget Organization.

25. Why don’t my Detail budgets roll up to my Master budget?

Detail budgets do not automatically roll up to the master budget. The GL uses summary accounts to maintain master/detail budget relationships between hierarchy levels. Summary templates are defined so that accounts in your lower level detail budgets roll up into the same summary accounts as the detail accounts in your controlling master budget. A common misconception is that the detail budgets somehow roll up to the master budget by definition, this is not true. You must actually budget to a detail account in the master budget; this then serves as the controlling amount for the detail budgets. Master/Detail budgets are used in the budgeting process to control Authority and identify budgets that exceed control limits. They are not intended for reporting purposes.

26. I was able to post a budget journal to a closed period, why?

A budget journal can be posted to any period that is in an open budget year for that budget. This is regardless of the status of that period (closed, opened, or future enterable).

27. Why don’t my budget amounts appear on my FSG?

To include budgets (encumbrances or currencies) in a FSG report, your report definition must specify a row set of column set that has control values specified in the Balance Control options. In the report definition itself, you associate budget names with the control values that are assigned to the row or column set.

Shivmohan Purohit

Reporting SOB - All transactions are with foreign Currency

You have to assign your SOB to your responsibility. Set of book means linking between the 3cs i.e. chart of accounts, calendar, currency and maintain 5 mandatory accounts. Set of books are created keeping in mind the ‘Accounting Structure”. This is a combination of 3 ‘Cs’ – Chart of Accounts, Currency and Calendar. Chart of Accounts is made up of segments- Max of 30 Segments are allowed. Two Segments are mandatory – Balancing and Natural segment, Calendar –This can have a max of 365 periods (daily calendar) and a min of 1 period (Yearly calendar). Periods can be monthly, fortnightly, weekly, daily.