-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Home |
Technical Articles |
Training Articles |
Receive Email for New Articles |
Contributors |
Apps Book |
Oracle Account Generator Workflow Example | | Print | |
Written by Anil Passi | |
Sunday, 17 September 2006 | |
This article illustrates the steps one needs to implement to build an Account Generator Oracle Workflow for eBusiness Suite.
For this exercise I am using iProcurement & core Purchasing Account generation workflows. However, the concepts remain the same for all the account generator workflows, regardless of the module. Assuming that you have implemented Oracle Projects Accounting, the Requisition or a Purchase Order can either be Project based or can be Non Project based. For this exercise, for simplicity, lets restrict ourselves to Project Based Requisition. Step 1 By doing the above step, we have just created a workflow Function that is capable of assigning a desired value to GL Flexfield Segment. Now we need to configure this Function further, so that it knows the Segment upon which it operates, and also the default value that is assigned to the segment. In the Part-a of this step, we will assign the Cost Centre to an Attribute Named “TEMP_CC_VALUE”. This function calls PL/SQL XX_account_generator_pkg.set_cost_centre_attribute Step 3 ( Part b). Step 4. Check to see if the Code Combination is Complete A final note, for debugging the Account Generator workflow. Account Generator workflows are designed to run efficiently and quickly, hence they always in synchronous mode. This means that no inserts are made into the Oracle Workflow tables when generating the accounting. Comments
(8)
![]() ![]() written by Manish , April 25, 2007 ![]() written by Anil Passi , April 26, 2007
Hi Manish
This is because your access level is higher than that of the object. go to help menu in WF Builder, and set your access level to be a lower than that for the process. For example, set the access level to 0, then you will be able to modify the process. Thanks Anil ![]() written by Prativa , May 10, 2007
Hi Anil, Thanks for the wonderful document. it really helped me.
I have one question. I am trying to create step 3, part a, I can not able to type an internal name. I can not see the internal name- GET_COST_CENTER_FROM_ORG either. Please let me know. Thanks and regards, Prativa.
Hi Anil,
I have a problem related to po requisition workflow customization. i am describing my requirement through an example. 1. Log on as SACHORN create and submit requisition for approval. $300,000 2. Review approval list: BBAKER,DMcIlvin, JSWIFT, JBARRYHAMILTON 3. Log on as BBAKER, approve 4. Log on as DMcIlvin, approve 5. Log on as JSWIFT, change the account number a. open the requisition via wf notification, select edit requisition b. select approver checkout c. continue until you reach Review Charge Accounts, select the account number d. change the natural account number to 670203 e. continue and approve requisition 6. Log in as SACHORN and review status requisition a. it is now at BBAKER waiting for approval. >>> This is where we don't want it going back to the approver for approval. It should have continued to JBARRYHAMILTON There is a validation somewhere during the approver checkout process that determines that the req needs to get reapproved. How i can customize this workflow REQAPPRV.wft. which package i have to customize and how? please describe in detail. Thanks & Regards Kamal
Hi Anil,
Thank u very much for the info in detail .
Hi Anil,
Is it possible for the user to initiate the invoice approval process(kicking of Invoice Approval workflow)even if the invoices are on hold ? Thanks for your help
Accounting flexfield structure - Division
![]() ![]() Currently the retirement accounts picks up the value for member and region from the default Book Controls in our current business scenario. Business needs to modify this, as there is a commitment of this asset to a particular member and region. So at the time of retirement the associated accounts for proceeds of sale on Gain or Loss account should have the values relevent to where the asset was assigned just prior to retirement. The Account generator needs to be modified so as to pick up the values of both Member and Region from the Asset Assignments. I have customized FA Account Generator workflow as below. FA Account Generator Workflow -> Generate Default Account Process. 1. Modified the "Generate Book Level Account" process to fetch the Member and Region Segments from Distribution CCID for the corresponding account types. 2. Modified the "Generate Category Level Account" process to fetch the Member and Region Segments from Distribution CCID for the corresponding account types. Tested the scenario after implementing the custom workflow, But there was some mismatch with the expected results. - Select and Retire one Asset - Executed depreciatin without closing the period - Ran "Create Journal Entries" Process. Queried the journal transfered from Assets using the period and source. The Account Code combination for the retired assets is not correct. Still it shows account code combination for the retired asset as old logic. Infacg FA Account Generator Workflow processed and generated new code combination, But it does not reflect in the journal transfer. Could you please help me to resolve this issue or am i missing some steps in the workflow customization. I highly appreciate your help. Thanks, Venkanna
I have customized the FA Account Generator workflow as per my requirement.Thank you for all your help.
Thanks, Venkanna You must be logged in to a comment. Please register if you do not have an account yet.
|
This really helped me.. Thanks a lot.
I just had one question. In a isupplier seeded workflow , the processes are locked for update. (see a red lock sign on the process). How do I unlock the process?