Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Retail Training Forum
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

0
Hi Since I'm new to this I'm posing this question so i can move forward.
Imagine we have an EBS concurrent program that does some custom validations before a standard Oracle seeded program is run and that it sends out an email with validation results before the standard program is run. These kind of custom validations are extremely common in EBS.
In the old EBS days , when custom validations were needed we would create the following.
1: A custom staging table
2;SQL Loader to load the data into the staging table
3: A concurrent program with logic to validate that data or call apis to validate that data
4: Write a report and email it to specific email groups.

In Fusion HCM.
we have a specific requirement
1: load an inbound file into some staging table in the cloud
2: this file will have valid code combinations given by a 3rd party
3: before payroll costing or some other program is run as part of processing , we need to check the code combinations against the ones we loaded in the custom table( from the inbound file)

Question is how would be go about solutioning this?
The question is how to simulate the old concurrent program logic in the new Fusion HCM system.
Can we create custom tables ,load data and create a PLSQL process to validate and write reports in Fusion?
What technologies are used to do that?
Thanks so Much
-D
Responses (1)
  • Accepted Answer

    Saturday, January 20 2018, 02:45 AM - #Permalink
    0
    Hi,

    If I understand correctly in this specific scenario you will have a list of Code Combinations values coming from a third party which you need to verify against the list of code combinations values which have been setup in system.

    This can be achieved in various ways:

    1. Pass the GL Code Combination Value as a parameter to existing Web Service Call (I hope there is one)which will return success or failure depending on whether the value exists in application base tables. But, this I hope will not meet your requirement.
    2. Load the values into a Custom Lookup / UDT and then using SQLs try to fetch all combinations of records which are not-matching. Collate all such entries , prepare a report and then send the report (inline / attachment) using email to concerned stakeholders. This might suit you with the only challenge being each time you get a new file ( from 3rd party) you would need to update the Lookup /UDT.
    3. This one by far would be the best approach (not sure whether feasible though). Create a custom BI Report using this Excel (I presume the Cost Center Values from 3rd party is in a spreadsheet) as one Data Set and SQL query from application base tables (which would fetch all code combination values another Data Set as and then find all values from Data Set1 which does not exist in Data Set 2.

    Kind Regards
    Ashish
    Like
    • PalsM
      more than a month ago
      Hi Ashish
      Thanks a lot for your reply, It really helps.
      I like both 2 and 3 options.
      The user defined tables seem like a good solution,
      We're actually gonna have 2 use cases.
      1: The external file , csv or excel will come in from a 3rd party ....for which I like the idea that I'll use the FTP adapter with ICS to bring it in , use Payroll batch loader to load it and then create an OTBI report which compares the gl combinations base table in HCM Cloud with the UDT table ...
      2: In this case I have to create a code combinations extract from an existing EBS R12 on premise system ,
      then use ICS to oad this into another UDT and do the comparison.

      Let me know if you have any ideas about this solution, again ,, i really appreciate your input.

      Also, do you know what technology would ppl use to replace custom pl/sql validations that a heavily customized EBS R12 implementation cannot do without ...I mean how and what technology would be used to replace that customization

      Thanks
      D
    The reply is currently minimized Show
Your Reply

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  May 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
    1  2  3  4  5
  6  7  8  9101112
13141516171819
20212223242526
2728293031  

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner